What is a Pivot Table and How Can it Help Me?
Microsoft’s own definition of a Pivot Table is “a powerful tool to calculate, summarize, and …
Linda
How to Create a Pivot Table in Excel
What is a Pivot Table? A Pivot Table is defined by Microsoft as “a powerful …
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 …
