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. Read more
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.
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. Read more
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. Read more
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.
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
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. Read more
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.
If you are having a few hassles when filtering here are some reasons your Excel filter may not be working.
Excel has an expectation that you have prepared your data to meet some basic layout standards before you use filter.
Get these right and you will minimize filtering hassles. Read more
Learning 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