How to Create a Pivot Table in Excel
What is a Pivot Table? A Pivot Table is defined by Microsoft as “a powerful …
Tutorial
Basic Cell Formatting in Excel
Summary Never again present a spreadsheet to your boss that is purely black and white. …
The Excel Interface Explained (3min video)
This short series of videos is designed for the absolute Excel newbie, but if you’ve been …
Basic Formatting (video)
In the first installment of the “ABC’s of Excel” mini-course, we briefly explained the different elements on …
14 Excel Keyboard Shortcuts to Boost Your Productivity
I wish I could make a list called “150 mind-blowingly awesome Excel keyboard shortcuts” but …
AutoFilter – Stop Digging and Find Stuff Fast
AutoFilter is a real life saver. Hardly a day goes by where I don’t use it. …
Inserting Subtotals in a Range of Data
Subtotals could either refer to the =SUBTOTAL function that is typed into a cell or …
How to Freeze the Headings in Excel – Freeze Panes
The Excel Freeze Panes tool allows you to freeze the headings of your dataset, which means you can scroll …
How to Format Numbers as Currency in Excel (includes bonus tips and tricks!)
Quickly format a cell as “Currency” Cells are normally formatted as “General”, which means there …
How to Skip the Start Screen When You Open Excel (3 easy steps)
If you are using Excel 2013 you would have encountered a pretty neat feature every …
