Author: Sharyn Baines

15/06/2018

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

14/06/2018

Insert, delete and hide rows or columns in Excel

Learn how to insert, delete and hide rows or columns in Excel.

Once the basic worksheet is completed and tested, it may be expanded by inserting additional columns and rows. Additionally you can easily remove information from view simply by hiding it.

13/06/2018

Save an Excel workbook, including save a copy and save as PDF

Being confident in how to save an Excel workbook, including save a copy and save as PDF, is a fundamental skill in Excel.

Once you have created a workbook (file), you will need to save the file in order to store it for later use. Saving a file means that you are storing the file into a storage area. Continue Reading

13/06/2018

How to total a range of cells in Excel

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

13/06/2018

How to create basic calculations in Excel

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

11/06/2018

How to enter data into an Excel worksheet

Once you know how to enter data into an Excel worksheet you will be setting up tables of data in no time.

When you haven’t been shown how to enter data it can be a little tricky, so follow the steps below to learn the tips and hacks to entering your data easily into your worksheet. Continue Reading

07/06/2018

Understanding the Excel screen components

When you first start using Excel the screen can be a little overwhelming.

Once you have an understanding of each of the components you can quickly locate and use them with confidence.

07/06/2018

Selecting cells and moving around an Excel worksheet

If you are new to Excel, before you start entering data it’s a good idea to become familiar with how to select cells using the keyboard and the mouse. Read more

03/06/2018

Excel Tables

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

03/06/2018

Sum only visible rows when Filtering data in Excel

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.