by Linda | Aug 18, 2020 | post, Tutorial
AutoFilter is a real life saver. Hardly a day goes by where I don’t use it. It is super quick and easy to use and can help you to make sense of big data, quickly. What is AutoFilter? Excel cleverly adds little drop-down arrows to the headings (top row) of your...
by Linda | Aug 18, 2020 | post, Tutorial
Subtotals could either refer to the =SUBTOTAL function that is typed into a cell or the Subtotal tool found in the DATA tab. This post addresses the latter, namely the Subtotal tool, that automatically groups rows based on changes in one column, and adds, counts, etc....
by Linda | Aug 18, 2020 | post, Tutorial
The Excel Freeze Panes tool allows you to freeze the headings of your dataset, which means you can scroll down or to the right and still see the headings. The first step is to position your headings the way you would like to see them, before we lock them in place. Row...
by Linda | Aug 18, 2020 | post, Tutorial
Quickly format a cell as “Currency” Cells are normally formatted as “General”, which means there is no special formatting applied to the numbers typed into cells. If you type 123.45 then 123.45 is what you’ll see. Look at this simple table below: You can quickly...
by Linda | Aug 17, 2020 | post, Tutorial
If you are using Excel 2013 you would have encountered a pretty neat feature every time you start it up. You are given the option to select either a blank worksheet or select from a wide assortment of colourful templates. I really liked it… for the first week or so,...