Excel 1 Day Introduction – Mastering the Essentials – face to face
October 27 @ 9:30 am - 4:00 pm
MASTERING THE ESSENTIALS
Duration 1 day
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.
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
At the end of the training you will be able to successfully:
• Understand basic features and use of Excel and essential principles of
• 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.
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
Printing Worksheets Save your sticky tape! This module will show you how to print
out your spreadsheets clearly and logically with all the
information you need.
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 YOUR OWN LAPTOP with an APPROPRIATE MICROSOFT SOFTWARE on it!