by tomvorves | Jan 26, 2017 | Collaboration, For your information, How to, Productivity, Tips and Tricks
What are you doing with your business D D K? Documents We have been storing our documents in network shared drives for a very long time. The system of a shared drive works well enough, but is lacking in dramatic ways that ultimately cost you and your business a whole...
by tomvorves | Oct 27, 2016 | Excel, For your information, Functions, How to, Microsoft, Power BI, Productivity, SharePoint, Tips and Tricks
Power BI Watch the webinar here: https://youtu.be/nOaeJ9D_9D4 We just conducted the first Power BI webinar at Learn iT! with a full house of on-line attendees. We all had an awesome session of discovery! Power BI is a great platform of programs designed to put...
by tomvorves | Apr 7, 2016 | Excel, Functions, How to, Microsoft, Tips and Tricks, Uncategorized
VLookup. V stands for ‘Victory’. Well, not this time. It actually stands for ‘Vertical’. But, once you learn to use this popular function of Microsoft Excel, you WILL feel victorious. Use VLookup when you have two sets of data that you would...
by tomvorves | Feb 3, 2014 | Productivity, Tips and Tricks
Microsoft Excel 2013 comes with PowerPivot built in. To access PowerPivot tools, open Excel 2013 then open the ‘FILE’ tab, select ‘Options’ then ‘Add-Ins’. Look to the bottom of the ‘Add-Ins’ dialog and locate the...
by tomvorves | Jan 5, 2014 | For your information, How to, Productivity, Tips and Tricks
Excel Reports: Data Preparation My newest course on Udemy.com will teach you how to organize your data in the best way to create quick and easy reports using Pivot Tables and summary functions. A well-formed data set can not only make reporting easier and faster, but...