Here you are the second part of basic Excel tools that are to be deeply analysed during our Excel online training. Make sure your basic knowledge of Excel is sufficient and please do remember we are ready to help you to be your guide as to this MS powerful tool.

Rounding numbers in Excel – SPartners’ Excel online training offer

It’s very important to understand how rounding works in Excel. A common example is rounding prices to two decimal places in a sales spreadsheet. If your formulas don’t round price calculations to the correct number of decimal places, then you can end up with sales figures that are incorrect – and hunting down the differences can be a nightmare. And rounding errors can cause havoc with your spreadsheets without you even realising it. A common mistake occurs when you change the display format of a number to show fewer digits after the decimal point and assume that the number has been rounded for use in other calculations.

Our online class of basic skills will explain how rounding in Excel works, and shows you how to avoid common rounding errors in Excel.

Scale your spreadsheet to fit on one page when printing from Excel –

SPartners’ Excel online training offer

Every Excel user has stories to tell about printing their spreadsheet and finding that what should have been a simple one-page spreadsheet has somehow spilled over onto 2 or more pages when they print it out. The likelihood of this happening is usually related directly to how important the document is, and how soon you need it.

During our webinar, you’ll learn how to scale your spreadsheet so that it fits on just one page. You’ll also learn the failsafe trick for printing your spreadsheet so that it is only one page wide, but is as many pages long as it needs to be.

Print an Excel spreadsheet with page numbers –

SPartners’ Excel online training offer

There are no two ways about it – page numbers on spreadsheets are important. You’ll know what I mean if you’ve ever sat in a meeting where someone handed out a 20 page spreadsheet without page numbers and then proceeded to spend the meeting making you flip back and forth between pages. Which page are we on now?

During this online lesson, you will learn several ways to print your Excel spreadsheets with page numbers on each page, so you never have to be that person in meetings. You’ll learn how to print the page number in the same place on every page. You’ll also learn advanced tricks such as printing your page numbers in different places on odd- and even-numbered pages, and printing page numbers differently (or not at all) on the first page of your documents.

Freeze or lock rows and columns in an Excel worksheet –

SPartners’ Excel online training offer

When you are working on a big spreadsheet it’s easy to get lost as you scroll through your data. For that reason, it can be handy to keep one or more rows and/or columns locked so they don’t disappear when you scroll down or across in the spreadsheet.

We will teach you how to use Excel’s Freeze Panes feature to lock rows and columns in place in your spreadsheet.

If you want to learn Excel, if you are going to use Excel effectively, even if you’ve been using Excel for a while, check out our offer of Excel classes to make sure you have the basic Excel utilities covered – and maybe learn something new with SPartners. If you have any questions referring our trainings, you can always contact us and ask additional questions.