Imagine Training

Excel Secrets Level 1

Our Excel Secrets course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!) You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting super-fast and how to format your charts so they are stunning representation of your figures. At the end of this training course you’ll feel like an Excel Wizard!

Description

Getting started

Moving nimbly around the spreadsheet with lots of navigation shortcuts thrown in!

Entering and editing data

How to enter text, numbers, formula and pictures and how to work with them.

Modifying a worksheet

As your spreadsheet develops, you need to make changes and if you don’t know these few simple steps it can all go horribly wrong! We cover the basics of how to insert or delete rows and columns and copy formula without getting a nasty error message.

Using functions

Learn the simple ways to create formulas and the 5 basic formulas everyone should know!

Formatting

Getting to grips with that tricky formatting of text and numbers so your spreadsheets are easy to read and look amazing in just seconds.

Printing

Don’t get tied up in knots with printing – a few simple rules will help you print your spreadsheet right first time.

Charts

Starting with chart basics we’ll take you through how to format your charts so they are stunning representations of your figures.

 

Managing large workbooks

Working with large or multiple worksheets? You need to know how to traverse them in seconds and how to move and copy data within them.

Graphics and screenshots

Work with the beautiful new graphics features and see how you can simply take a screenshot. 

Prerequisites

One Day Classroom based course - can be one of our public courses or on your own business premises for groups. 

Attendees should be familiar with using keyboard and mouse and have some experience of using Excel. Even experienced users will find this course useful for keyboard shortcuts and navigation keys which will save (on average) up to 30 minutes a day doing routine spreadsheet work. This is a solid foundation for anyone who needs to use Excel.