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 9, 2015 | Excel, Functions, How to, Microsoft, Productivity, Tips and Tricks
Have you wasted time playing the “Higher/Lower” game in Excel? Let’s say you have a formula that is not producing the answer you’re looking for. So you may try changing another cell’s value until you get what you want from the formula....
by tomvorves | Jan 16, 2015 | Excel, For your information, Functions, How to, Microsoft, Productivity, Tips and Tricks
Use Excel to calculate when it’s time to go home. Most computers read dates and time the same way we read numbers. For instance today, January 16, 2015 is day number 42020 counting from the “beginning of time” which was January 1, 1900 (from a computer’s...
by tomvorves | Dec 8, 2014 | Excel, For your information, Functions, How to, Microsoft, Tips and Tricks
Make the Excel Filter Feature Better than Ever with Subtotals Do you use filtered lists in Excel? If you have tried to Sum a range while the list is filtered, well you have found that it just doesn’t work. This video will teach you how to harness the power of a...