Home » Archives for Sharyn Baines

Author: Sharyn Baines

Insert page breaks and scale an Excel worksheet for printing

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

pen om paper

How to total a range of cells in Excel

pen om paper

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

turned on black and grey laptop computer

Excel Tables

turned on black and grey laptop computer

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