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

Spreadsheet Principles

What is a spreadsheet?

Screen Layout and Excel Basics

Ribbon
Understanding Workbooks, Worksheets, Rows, Columns, cells
Various selection techniques
Understanding various Mouse shapes
Tabs
Groups
Dialog Box Launchers
Quick Access Toolbar (QAT)
Customizing QAT
Formula Bar Customization
Live Preview
Contexualized tabs
File Tab (Backstage View)
Zoom Feature
Page Layout View
Full Screen View
Access Keys (Shortcut keys)
Saving, File types, File Compatibility (with earlier Versions)
Getting Help
Various selection techniques
Pinning Recent Files

Entering, Selecting and Editing Data

Entering , Editing and Deleting information in cells (Text, Date, and numbers)
Entering Auto Lists
Using Fill handle to create simple lists
Creating custom lists
Deleting Rows, Columns and Cells
Inserting Rows, Columns and Cells
Inserting , Deleting, Moving, Copying and Renaming Sheets
Various Navigation Techniques using Scroll bar, Keyboards and Go To command
Using the Paste Preview

Creating Formulae and Functions

Concept
Creating Formulae
Editing Existing Formulae
BODMAS: Mathematical Order
Copying Formulae
Understanding Relative Referencing
Understanding Absolute Referencing
Using the Autosum Feature
Common Basic Functions : SUM, MIN, MAX, AVERAGE, COUNT, COUNTA
Using the Formulas Tab

Formatting Cells, Rows, Columns and Sheets

Formatting Cells
Number Formatting
Date Formatting
Text Formatting
Cell Alignment And Orientation
Wrap text
Applying borders and shading
Border drawing
Clearing Formats
Changing Column Widths
Changing Row Heights
Changing sheet Tab Colours
Using Format Painter

Data Sort and Filter

Sorting Data
Auto Filter

Charts/Graphs

Creating Simple Charts
Editing Charts
Formatting Charts

Printing

Print Preview
Page Orientation
Adding Headers and Footers
Printing A Selection
Setting A Print Area
Scaling
Adjusting page breaks using Page Break Preview
Repeating columns and rows
Changing Margins
Center On Page

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