Home » Archives for Sharyn Baines » Page 3

Author: Sharyn Baines

Sharyn Baines

Insert page breaks and scale an Excel worksheet for printing

Sharyn Baines

Learn how to insert page breaks and scale an Excel worksheet for printing.

Once you have your worksheet created and formatted you may want to print it. Printing can be extremely challenging if you don’t know how to control where page breaks occur and how to fit your worksheet to print on a page so that you avoid having one row or one column printing on a following page.

The Page Setup commands allow you to set the appearance of the printed worksheet.  Many Page Setup options apply to every page of the active worksheet. Continue Reading

How to total a range of cells in Excel

Sharyn Baines

The 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.
Continue Reading

How to create basic calculations in Excel

Sharyn Baines

Being 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. Continue Reading

Excel Tables

Sharyn Baines

Managing, 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. Continue Reading

Sum only visible rows when Filtering data in Excel

Sharyn Baines

A 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.

Continue Reading