All Posts
-
Inserting Subtotals in a Range of Data
Read More: Inserting Subtotals in a Range of DataSubtotals could either refer to the =SUBTOTAL function that is typed into a cell or…
-
How to Freeze the Headings in Excel – Freeze Panes
Read More: How to Freeze the Headings in Excel – Freeze PanesThe 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!)
Read More: 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)
Read More: 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
Read More: Working with text using the functions LEFT, RIGHT and MIDThe 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)
Read More: 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
Read More: How to create an interactive invoice in Excel using Data Validation and VLOOKUPGoal? To automatically populate information in a document, e.g. an address field in an invoice…
-
Different Functions for Rounding in Excel
Read More: Different Functions for Rounding in ExcelI couldn’t find a decent article outlining the differences between the various rounding functions in Excel… so I…
-
Unpacking our design and development process.
Read More: Unpacking our design and development process.Each stage of a project is dependent on the one prior. Mollis pretium lorem primis…
