Testimonials

Control Risks

"Simon was a great teacher and was very enthusiastic about the course which was brilliant. He used good examples during our Excel course and showed so many useful tips and tricks along the way. Now it's just time for me to put it into practice! But thank you Simon, it's much appreciated"

Affinity Fragrances

"The training was fabulous. Thoroughly enjoyed being shown and putting in to practice 'all things learnt' during the training session. The trainer had a huge amount of knowledge and the hints and tips were great.

Micro Scooters

"Well presented, interesting and lively."

Dirks

"A fun learning experience coupled with excellent course delivery and content"

Print & Desktop Publishing

Locations

Microsoft Excel 2010 Training Course Beginners

Microsoft Excel 2010 Overview

In this training course you will learn the basics of the latest version of Microsoft Office Excel. The 2010 version has an updated interface that you will learn your way around, how to enter information, manage files, learn about formulas and formatting as well as how to print your work.

Other Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

Course Outline

Orientation in Excel 2010

The Ribbon
Quick Access Toolbar
Galleries
Older Dialog Boxes (The Older way of doing it)
Using Help
Rows & Columns & Cells
The Formula Bar
Button Drop Down Lists
The Cell Reference Box
Context Tabs & Menus (Mini Toolbar)

File Management in Excel 2010

Creating a New File
Using Built-in Templates
Opening & Closing a Workbook
Saving a Workbook
Recent Workbooks & Places

Entering Information

Entering Data
Selecting Data
Adjusting Column Width & Row Height
Using Auto fill
Copy and Pasting Data
Moving Quickly around a Work Sheet (Using Keyboard)
Inserting & Deleting Rows & Columns
Find & Replace
Spell Checker

Formulas

Simple Formula
Using Cell References
Operator Preference
Functions
Linking Between Worksheets
Linking Between Workbooks
Basic Error Checking
Change Calculation Options

Formatting - Changing the look

Formatting Numbers
Font Size & Colour
Fill Colour
Borders
Cell Alignment
Text Wrapping
Cell Styles
The Decimal Point
Format Painter

Printing

Choosing what to print
Margins
Selecting the print area - so you don't print those pesky blank pages
Printing a large spread sheet

Working with Different Views

Zooming In & Out
Split View
Freeze Panes
View Side by Side with synchronous scrolling so you can compare 2 sheets at once
Page Layout View
Page Break Preview
Gridlines, Headings & Formula Bar
Adding Custom Views to save you time when you have to open up a lot of sheets together