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 10, 2016 | How to, Productivity, Tips and Tricks, Uncategorized
Microsoft Office Web Apps Keyboard Shortcuts Here are the official links to Microsoft Office Web Apps Accessibility Features, including helpful keyboard shortcuts, tips and tricks. Enjoy. Keyboard shortcuts in Outlook Online Keyboard shortcuts in Word Online Keyboard...
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 | Jul 8, 2014 | For your information, Productivity, Tips and Tricks
Quickly Zoom In and Zoom Out using your keyboard and mouse While using a Microsoft Office program, you may need to zoom in to get a closer look, or zoom out to see your work from a birds-eye view. Although using the zoom bar on the lower right corner of any Microsoft...
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...