Master the basics of Microsoft Excel the easy way with our Excel Essentials training course.
Learn all of the core skills that you need to use Excel day-to-day. This course is designed for beginners and you only need basic computer skills to take part.
We know that learning Excel for the first time can be a bit daunting.
Our approachable, experienced Excel trainers will quickly get you using Excel confidently. They will also share lots of tips and tricks.
This is a hands-on course. It includes lots of time to practice what you are being taught and try things out for yourself.
By the time you finish, you’ll be comfortable using a wide range of Excel’s core features.
✔ A complete beginner’s course that covers all of the basics.
✔ Plenty of one to one attention and time to ask questions
✔ Friendly expert trainers, small groups and a comfortable place to learn
✔ All the materials and extras that you’ll ever need
✔ Ongoing support and help with issues you have after the course
WHAT WILL I LEARN?
This course aims to get you comfortable with Excel as quickly as possible.
With plenty of practice to consolidate what you learn, you’ll be up to speed in no time.
You’ll learn about:
If you’d like to know more about any of these areas we’ve outlined the full syllabus below (see COURSE DETAIL) or take a quick look at the video.
Once you have completed this course you will be ready for our Excel Intermediate course.
If you book both these courses at the same time we offer a discount – contact us for more details.
AM I READY FOR THIS COURSE?
Don’t worry, you don’t need any previous experience of using Microsoft Excel.
You only need a basic understanding of working with computers and Windows.
If you can work with multiple windows, navigate the desktop and know a bit about storing files in folders you’ll be absolutely fine.
YOUR TRAINING DAY
Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for a tasty, freshly prepared lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practice more in your own time.
✔ A snazzy Certificate of Attendance to show that you trained with the best.
COURSE VIDEO
Looking for more details? Have a look at our quick video, or see “COURSE DETAIL” below.
|
The first session in this course focuses on showing you how to find your way round Excel. It explains how you navigate around the screen and how you access the many functions and tools that Excel contains.
The key topics covered are:
This session gets you using spreadsheets for the first time, and shows you how to create, input data into and save a workbook. It also shows you how to format the data that you have put into Excel and spell check it for typos.
The key topics covered are:
This session focuses on explaining how to work with the cells in a spreadsheet. It shows you how to select specific areas of a spreadsheet (including areas that aren’t continuous) or to select whole rows or columns.
The key topics covered are:
Now that you are comfortable working with the basics in spreadsheets the course shows you how to work with the data in your spreadsheet. It leads you through editing your data, deleting your cells or whole spreadsheet and finally the undo function that Excel contains.
The key topics covered are:
Excel allows you to share your workbook with other users on the same network and on OneDrive and edit have multiple people editing it. Changes are saved when you close your document and you will be able to see other users changes when you re-open. With just one working file it disposes of the need to email a spreadsheet between team members and then try and merge the changes and see changes that others have made.
The key topics covered are:
Excel contains a very useful function called “Fill”. It allows you to very quickly create a series of entries in a series ( e.g. 1,2,3,4,5 ….. 45,46 ….) just by entering the initial members of the series.
The key topics covered are:
The ability of Excel to manipulate data by using formulas is one of it’s key properties. This session is a gentle introduction to formulas explaining how they work and introducing some of the simpler, standard formulas that Excel contains.
The key topics covered are:
Another key part of working with and understanding formulas in Excel is referencing. Formulas must draw the information that they use from somewhere. Usually this is a cell in the spreadsheet. Ensuring that the formulas always work with the correct pieces of information even when they are cut and paste is key. This session explains how referencing works and how to ensure that your formulas work with the correct information.
The key topics covered include:
As you can in other Microsoft Office programs, Excel allows you to format the font, background and other text effects of your text very flexibly. This session will show you all of the different possibilities that Excel has to offer.
The key topics covered include:
When you are working with a spreadsheet it is very likely that you will work with other types of data than just text. Most likely your spreadsheet will contain numbers, dates, fractions, currency and possibly other items. Excel will allow you to format each of these types of data appropriately so that it is easy to read and obvious to the user what type of data they are looking at.
The key topics covered include:
This session focuses on how to apply, remove and format options on cell borders. Borders are a very useful way to help users navigate the information held in a spreadsheet. This session will show you how to use Excel’s functionality to apply them quickly.
The key topics covered include:
Each spreadsheet is held within a worksheet. Just as there are a number of options to manipulate and customise the appearance of a cell, there are a number of ways that the appearance of a whole worksheet can be manipulated. We will show you how to make sure that your worksheets are formatted and structured exactly how you would like them to be.
The key topics covered include:
Once you have created your spreadsheet and used it to store and manipulate your data you will want to print it out at some point. This session introduces the basics of printing from Excel.
The key topics covered include:
This final session of the course goes into more detail on printing in Excel. It shows you how to control things like margins, the orientation of your page and the background of your printed area.
The key topics covered include:
Copyright © 2018 Acuity Training. All Rights Reserved.
