Tips & Tutorials
While I have briefly talked about the =SUM() function before (see my posts Formulas and Functions: How to Make Calculations in Excel and Auto-Sum and other Functions: How to Make Calculations in Excel), we will...
Ideally, you will use cell references in your formulas and functions (I will use the term formulas in this post to mean both formulas and functions). Cell references reduce the manual workload for you: whenever...
Excel provides a shortcut for the most commonly used functions. You can find this in the Home-Ribbon under the Section Editing, called Auto-sum. If you click on the name Auto-sum Excel will automatically add a...
Spreadsheets are an amazing tool for calculations. The possibilities are endless, ranging from basics, such as summing expenses, to sophisticated statistics. To get you started on this, you will need to understand how to build...
There are 3 main areas to each spreadsheet, which is something all spreadsheet applications have in common: Columns Columns go vertically across the screen from top to bottom. On the top you’ll see the column...
Designing Spreadsheets / Worksheet Management
by Nora · Published 2025-11-24 · Last modified 2025-11-23
In all Microsoft Office applications, there’s a colour palette with 10 different colours in different shades. Whenever you wish to change any colour in your document (for example for fonts or backgrounds) you can select...
Now that we have covered How To Add Worksheets and How to Hide Worksheets (and how to make them visible again), let’s talk about copying and moving worksheets. Both can be done within the same...
Hiding worksheets is another great way to keep your workbook organised. There can be plenty of reasons why you might wish to hide a worksheet. For example, if you have a worksheet that contains ‘helper...
If you would like to customise the worksheet tab bar further, you can assign a background colour to your worksheet tabs. This will change the background of the worksheet name, not the worksheet itself. Step...
In a new Excel file, one worksheet is created by default and named Sheet1. As mentioned in my previous post, it is good practise to rename worksheets to something more useful. While keeping the name...
Navigation
Welcome to my blog! My name is Nora and I'm here to help you develop your spreadsheet skills in Excel. Read more about me