by tomvorves | Apr 18, 2015 | Collaboration, For your information, Microsoft, Productivity, Tips and Tricks
Don’t let your file names reflect your mood Have you ever looked at a huge list of files, scrolling, scrolling, trying to find the file you saved the day before. You know where you saved it (you’re pretty sure) but you can’t seem to remember the...
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 | Jan 13, 2015 | Excel, How to, Microsoft, Productivity, Tips and Tricks
Clean it up. In 3 minutes I will teach you the best way to clean your data for improved sorting, filtering, better Pivot Tables and data analysis. Watch the video. Share it with others. Improve your life. Make new friends. All in 3 minutes. Enjoy...
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...