Excel 2010 Introduction Training Course

Our Excel 2010 Introduction course is designed for new users of Excel 2010, or those whom have been self taught. The course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.

Our Excel 2010 Introduction or Basic course is run by qualified MOS trainers. We can also run your Excel 2010 basic course onsite, or at our London based training centre.

If you are not sure that the Excel 2010 introduction course is the right level for you, please contact us. As part of our service, we offer free Excel 2010 training needs analysis. This will help you get the most of your investment to ensure you get trained on area's of Excel 2010 that is most suited to your needs.

If you are upgrading from a previous version of Excel and only require upgrade training, please see our Excel 2010 Upgrade Training Course

We also offer a free course tailoring service. If you need to know specific functionality of Excel, please let us know. We will be more than happy to create a tailored or bespoke Excel 2010 introduction course for you.

Excel 2010 Introduction Training Course Info

Audience: This course is designed for new users of Excel, or those whom have been self taught. We cover all aspects of creation a spreadsheet including writing formulae.

Course Duration: This is a 1 day Excel 2010 Introduction Course. Course starts at 09:30 and runs until 16:30

Excel 2010 Introduction Course Objectives: After the course, you will be able to:

Create and maintain spreadsheets
Create and edit formulae
Format and print worksheets
Perform basic list management tasks

Requirements: You do not need any previous knowledge of Excel, but should have basic windows, keyboard and mouse skills

Course Locations / Schedule: This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel 2010 Introduction / Beginners Training Course Contents

Excel Basics

An overview of the screen, navigation and basic spreadsheet concepts
Understand Excel terminology workbooks, worksheets, rows, columns, cells
Various selection techniques
Understanding the various mouse cursors
Working with Ribbon Tabs, Groups and Dialog Boxes
Standard and Contextual ribbons
Use the task pane
Understand and use the File Tab
Saving, File types, File compatibility (earlier versions)
Useful keyboard commands
Quick Access toolbar & Mini Toolbar
Get Help!

Entering Data

Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
Use Auto List feature
Date and Time are storage in Excel
Enter Dates and Times
Date/time formatting
Methods to Move and Copy data
Use the Fill Handle to copy data and create simple lists
Create series of information
Insert, Delete and Hiding Rows & Columns
Insert, Delete and Move Cells
Insert, Delete, Move and Copy Sheets
Various navigation techniques

Creating & Editing Formulae & Functions

Define Formulae
Create & Edit Formulae
BoDMAS : Mathematical Order
Copy & Move Formulae
Use Basic Functions - Sum, Average, Max, Min, Count, Counta
Use Autosum tool
Introduction to the Function Library
Reference a cell in other sheets
Understand Relative Referencing
Apply Absolute (Fixed) Referencing

Formatting and Proofing

Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
Quick formats and themes
Sheet tab formatting and Renaming
Copy and Clear Formats
Merging cells
Spell Check, Find & Replace and AutoCorrect

Printing and Page Setup

Page Orientation
Add Headers and Footers
Print a selection
Set a print area
Clear a print area
Shrink to Fit
Adjust page breaks within Page Break Preview
Repeat columns and rows
Print Gridlines
Save print settings

Multiple File & Large Workbook Tools

Split screen tool
Freeze panes
Arrange workbook windows
Zooming tools
GoTo tool
Name box navigation

**All our Excel 2010 training courses can be tailored to suit your needs**