Excel Level 1 - Mastering Essentials

Overview

This course gives you all the essentials you need to get started with Excel. You will learn how to use spreadsheet layout to best effect; how to enter and change data; tips and shortcuts; arithmetic formulas; functions and printing. If you have numbers to manipulate in your business, this is the course for you. 

Recommended for

Anyone who wishes to use or develop spreadsheets for business use. 

What do you need to know already?

We assume that you have used a computer before and know a bit about:

• Working within the Windows environment
• Electronic filing
• Using a keyboard
• Using a mouse

Objectives

At the end of the training you will be able to successfully:

• Understand basic features and use of Excel and essential principles of workbook design
• Enter, edit and format data in a simple Excel spreadsheet
• Use autofill to enter data efficiently
• Apply text and numerical formatting to a spreadsheet
• Use the clipboard and keyboard shortcuts to cut, copy and paste data
• Use arithmetic formulas and simple functions to analyse numerical data
• Print worksheets using the documentation and support provided.

Modules covered in this course

What can Excel do? - Before we get you started, we look at what Excel is capable of to give you something to aim for.

Getting Started - This module includes all the basics you will need to start putting together your own spreadsheets

Fill - Fill is a great way to help you enter data quickly. You will see how to create series and patterns in a couple of mouse-clicks.

Formulas - Excel is a powerful tool for analysing data. This module gets you started on this by showing you how to get Excel to do arithmetic for you.

Cut, copy and paste - Don’t type the same thing more than once! This module shows you all the ways of copying or moving data from one place to another.

Formatting - Make your spreadsheets easier to use and read by using a few simple formatting effects.

Introduction to Functions - Functions are the power-house of Excel. This module shows you how to insert functions and the specifics of the most commonly used functions to sum, average and count your data. Printing Worksheets Save your sticky tape!

We recommend that you bring real-life examples and problems from work with you
so that you can go back to work after training having made real progress.

Please bring in your own laptop with appropriate Excel software on it. If you do not have access to a laptop we can sometimes provide a spare laptop for the day, please let us know if this is the case.