Testimonials

Balfour Beatty

"Great course, trainer was very interactive and enthusiastic."

GKN Aerospace

"Very informative and fun energy. I really enjoyed it and will be able to use what I leaned."

Prominate

"Excellent, informative, fun and engaging. Learnt a lot!"

"It was excellent. Easy to follow, engaging, structured and delivered with humour and patience."

Industrial Inkjet LTD

"Very good Excel for beginners training learnt a lot thankyou. very friendly and easy to understand tutor. would definitely recommend and do another course"

Locations outside Guildford

Microsoft Excel 2010 Training Course Beginners Guildford

Guildford Beginners Microsoft Excel 2010 Course Overview

Microsoft Excel 2010 Training Course Beginners training course Guildford Surrey

Located in Surrey, Guildford is known for its cobbled high street and stunning countryside.

The town of Guildford in Surrey is known for a fantastic shopping experience. Of course with the Guildford business park and easy access to two popular airports in Heathrow and Gatwick. Your Beginners Microsoft Excel 2010 Training Course training course in Guildford Surrey can be conducted at your premises, where we can bring laptops with the Microsoft Excel 2010 Training Course already loaded. We can even bring a projector along with power extension leads, leaving you to concentrate on learning.

Conducting Microsoft Excel 2010 Training Course training courses in Surrey is a relatively new venture for us so please try us out and remember to tell us and others what you think.

Course Duration: 1 Day

Complete 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

Have a look at our range of Excel Training Courses

Other Excel training courses you may be interested in:

Excel 2019 Beginners Training Course

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel Pivot Tables training course beginners

Microsoft Excel PowerPivot training course intermediate

Intermediate Microsoft Excel 2010 Training Course

Advanced Microsoft Excel 2010 Training Course

Microsoft Excel 2013 Training Course - Beginners

Microsoft Excel 2016 Training Course - Beginners