Basic Formatting (video)
In the first installment of the “ABC’s of Excel” mini-course, we briefly explained the different elements on …
In the first installment of the “ABC’s of Excel” mini-course, we briefly explained the different elements on …
I wish I could make a list called “150 mind-blowingly awesome Excel keyboard shortcuts” but …
AutoFilter is a real life saver. Hardly a day goes by where I don’t use it. …
Subtotals could either refer to the =SUBTOTAL function that is typed into a cell or …
The Excel Freeze Panes tool allows you to freeze the headings of your dataset, which means you can scroll …
Quickly format a cell as “Currency” Cells are normally formatted as “General”, which means there …
If you are using Excel 2013 you would have encountered a pretty neat feature every …
The LEFT, RIGHT and MID functions are extremely powerful and can save you hours of …
I was recently asked about an issue where a cell would appear empty, but for …
Goal? To automatically populate information in a document, e.g. an address field in an invoice …