Home Courses Enquiries Online Training Testimonials Locations Prices

Total Price:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Testimonials

Huxley Bertram

"Very good, Alan made it fun and interesting. I now want to apply some of what he showed us today. It should be extremely useful".

Fontus Health Limited

"An enjoyable day and Simon was very professional and approachable."

Middlesbrough Council

"Excellent. Learnt lots of new knowledge on Excel."

Motorplus

"Good fun easy to learn and great trainer very friendly and approachable"

Print & Desktop Publishing

Apple

Presentation

Online Videos

Locations

Microsoft Excel 2010 Training Course Beginners

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 Excel training courses

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