Home » Our Blog

How to total a range of cells in Excel

sharyn bainesThe quickest way to total a range of cells in Excel is to use the SUM function.

The Sum function is one of the most commonly used functions in Excel. The function requires the first and last cells within a list, it then includes them and every cell between them into the total. For example =SUM(C4:C10) replaces the need to enter =C4+C5+C6+C7+C8+C9+C10.

Maybe you could just create a formula to add each of the cells when there only 7 of them…but imagine if there were 7000! Yikes! That’s when the SUM function becomes an amazing tool to have in your toolbox.
Read more

How to create basic calculations in Excel

sharyn bainesBeing able to create basic calculations in Excel is fundamental to being able to use Excel well.

Writing Excel formulas is much the same as writing an equation. With just a little bit of instruction you will be creating basic calculations in no time! And of course, you will be able to confidently read other people’s calculations which is awesome when you want to work out what the calculation is actually doing. Read more

Excel Tables

sharyn bainesManaging, analysing and referencing lists of data becomes easier when you know how to use Excel Tables.

There are so many advantages to using Tables which I will cover within this post. Once you see how helpful they are I’m pretty sure you will be using Tables a lot.

When you insert a Table over a list of data Excel automatically takes over and applies many features for you. You will also have many tools for working in lists made available to you on a contextual tab, making working with lists so much easier. Read more

Sum only visible rows when Filtering data in Excel

sharyn bainesA common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible rows when filtering data in Excel”?

It’s very common for people to try creating a SUM total at the bottom of a list and then filter the data hoping that the total will change to reflect the SUM of the data displayed. However, the total doesn’t update. It still shows the SUM of the entire list.

You can definitely use the AutoSum button to instantly create a total that will update as you filter your data. Here’s how you do it.

Read more

Filter data in Excel

sharyn bainesLearning how to filter data in Excel enables you to find and work with just a subset of a larger list or database.

Filtering displays only the rows that contain a certain value or that meet a set criteria, while hiding other rows that don’t. Once you have filtered your data you can then work with just the visible set of data.

For example you might like to filter a list to find all sales made to one customer and then print only that data. Filter will allow you to do this in just a few clicks. Read more