Testimonials

Leicestershire Police

"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"

Supply Chain Academy

"I would like to say a big thank you for Simon for all of his help. His training has helped to bring back some of my lost knowledge and also have expanded my knowledge too! Will definitely be recommending to others. Thank you so much once again."

Doppelmayr Cable Car

"This course shows me how to use Excel in a very good and understandable presentation"

Ground Control Ltd

"Very clear and easy to follow, brought the training to life with specific examples and tried to tailor the training to our needs and our needs of the business."

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