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 | Apr 18, 2014 | For your information, How to, Tips and Tricks
Formula Errors in Excel? Don’t fix them, Ignore them. Microsoft Excel has millions of cells that allow any value to be entered: Numbers, Text, Formulas. In fact the default setting in the Data Validation dialog box is set to “Allow Any Value”. This...
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...