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

Motorplus

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

Julian Support

"Thought the training from Alan at Computer Tutoring was excellent. The pace of the training was perfect and very relaxed and the content just right. We covered a lot of information during the Introduction Training Course on Microsoft Excel during the day but I didn't feel overloaded at anytime. I already use excel on a regular basis but have never had any formal training and picked up a lot of tips on how to do tasks in a much more efficient way as well as learning some things I didn't know at all! Thanks very much!"

Seven Telematics

"Informative, clear, precise, good instruction. It was broken down in to easy bite sized chunks."

Frutarom UK Ltd

"Excellent training, very patient and informative. A structured approach and easy to follow manual."

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