Testimonials

Aldi

"Excellent! I normally shy away from Excel as I am not a numbers person, however Denise really made it an enjoyable session and showed us some amazing aspects that will save so much time for us. Thank you."

Blaby District Council

"The trainer.. had the ability to explain in a clear and concise manner and had a deep knowledge of excel but kept his training very relevant to the group. The course did not feel rushed or pressured and there was no feeling of embarrassment if more help or explanation was needed. The trainer offered assistance at every stage and was able to explain in a way that was relevant. His diction and pace were perfect."

Buster + Punch

"Simon makes the training an easier task by approaching his public first, in order to know their level of knowledge, and then he presents the BI functions in an understandable and patient way. Excellent introduction for beginners and an overview of the amazing tools Power BI provides for creating reports, data analysis and decision making."

Cambridge Flow Solutions

"The training was brilliant. Went at my own pace. Simon answered all my questions and concentrated on teaching me the things I use the most at my work (or possibly may need in future). A very happy customer! Thank you!"

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 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