Basic Formatting (video)
In the first installment of the “ABC’s of Excel” mini-course, we briefly explained the different elements on …
post
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 …
Working with text using the functions LEFT, RIGHT and MID
The LEFT, RIGHT and MID functions are extremely powerful and can save you hours of …
Fixing “blank” cells in Excel that have something in them (i.e. clearing zero-length strings)
I was recently asked about an issue where a cell would appear empty, but for …
How to create an interactive invoice in Excel using Data Validation and VLOOKUP
Goal? To automatically populate information in a document, e.g. an address field in an invoice …
