Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Excel Level 1 Secrets

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.

Similar courses

Excel Level 2 Ninjas

To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula;

More Information
Excel Level 3 Gurus

This course is specifically designed for office staff/managers with some previous knowledge of Excel, and is designed to take you to the next level. Mistakes can be reduced if you use the tools that come with Excel and check your work. This course will cover essential time-saving features and will look in detail at:

More Information
Excel Business Intelligence

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel Business Intelligence course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use the tools – Get & Transform, Power Pivot, Power Maps and Desktop BI Visualisations.

More Information
Excel Dashboards

Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one. Let's make one for your business too.

More Information
Excel Power BI Desktop Visualisations

Create Visualisations using Microsoft Excel Power BI Desktop

More Information

Press enter to see more results