Excel Tips, Tricks & Time Savers training is now here!

We are excited to announce the addition of some important new Excel courses to our training catalog Excel Tips, Tricks & Time Savers training is now here! We’ve noticed that our clients love it when we teach them various tips, tricks and time savers so we’ve developed two new courses that focus on those handy […]

Categories: Excel Newsletters Training

When to Take Excel VBA Programming or Hire a Consultant

You probably use Excel in your day-to-day business operations, but how much of its potential are you putting to good use? If you’re managing a relatively successful business, then you already understand the importance of making sure that your internal processes are running as smoothly and efficiently as possible. Whether it’s streamlining accounting procedures, calculating […]

Categories: Excel Newsletters Training

The Top 5 Underused Features in Excel

1. VLookups The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a […]

Categories: Excel

Time Saving Tools for Excel Formulas

If you work in the type of office where you can’t install your own favourite productivity software due to strict IT policies, then it’s likely that Microsoft Office is already installed on your system. Microsoft Office is packed with features that can help you stay on top of things and get the job done. Here […]

Categories: Excel MS Office

Add Ribbon Items to the Quick Access Toolbar

If you work in the type of office where you can’t install your own favourite productivity software due to strict IT policies, then it’s likely that Microsoft Office is already installed on your system. Microsoft Office is packed with features that can help you stay on top of things and get the job done. Here […]

Categories: Excel MS Office Newsletters PowerPoint Word

Make Full Use of the Format Painter

If you work in the type of office where you can’t install your own favourite productivity software due to strict IT policies, then it’s likely that Microsoft Office is already installed on your system. Microsoft Office is packed with features that can help you stay on top of things and get the job done. Here […]

Categories: Excel MS Office Newsletters PowerPoint Word

Tips on Working with Microsoft’s Ribbon

Below are three ways to use Microsoft’s Ribbon: 1. Ribbons keyboard shortcut To navigate the ribbon with the keyboard (instead of the mouse), press the ALT key on the keyboard.  Numbers and/or letters will appear next to the ribbon tabs allowing you to navigate the ribbon. 2. Let’s hide my ribbon To collapse or minimize the […]

Categories: Excel MS Office PowerPoint Word