Associated Courses

Course Outline

Duration

1 Day

Price

£150 per person

Pre-Requisites

Delegates should be familiar with working in Windows.
No knowledge of Microsoft Excel 2010 is assumed.

Course tailoring service

Our tailoring service is a luxury you can afford, allowing you to combine elements of related courses producing a bespoke
solution, designed specifically to fulfil your training needs. Is there any better way to meet all of your training objectives and maximise your training ROI?

Kit supply

Running a course at your facilities might sound like a good idea until you start thinking about the practicalities of equipment usage and the
impact this could have on day to day business, so why not let us bring the necessary
equipment with us?

Excel 2010 Core Skills

Learn how to

Understand the structure and layout of Spreadsheets
Create, modify and Save Spreadsheets
Enter information
Perform calculations using formulas
Format spreadsheets to make them look professional
Create a variety of different charts
Print Spreadsheets

Content

Excel Introduction
What is Microsoft Excel?
Starting Excel
The Excel Screen
The Tab-and-Ribbon Interface
The Quick Access Toolbar
Keyboard Shortcuts
Using Help

Workbooks and Worksheets
The Structure of Excel Files
XLS and XML
Opening an Existing Workbook
Saving a Workbook
Starting a New Workbook
Navigating a Workbook
Managing Worksheets

Entering Information
Spreadsheet Information
Formatting Cells for Specific Contents
Entering Labels
Using Numbers as Labels
Using Spellcheck
Using AutoComplete
Entering Numbers
Using Currency and other formats
Date and Time
Using Percentages
Using Fractions
Selecting a Range
Using Autofill

Entering Formulas
Basic Formulas
Order of Operations (BODMAS)
Basic Mathematical Functions
Using SUM
Using AVERAGE
Using COUNT
Using MAX
Using MIN
Using AutoSum
Referencing Other Cells in Formulas

Multiple Worksheets and WorkBooks
Referencing Cells in Other WorkSheets
Referencing Cells in Other Workbooks
Opening Workbooks with External References

Formatting Workbooks
Editing Cell Contents
Selecting Cells
Copying and Moving Cells
The Clipboard
Inserting and Deleting Cells, Rows and Columns
Using Undo and Redo Using Find and Replace Cell Comments Formatting Cell Content
Advanced Cell Formatting
AutoFormat
Using Format Painter
Row Height and Column Width
Cell Styles
Themes

Charts
Chart Types
Creating a Chart
Formatting and Editing Chart Objects
Changing the Source Data of a Chart
Charging a Charts Type
Annotating Charts

Printing a Worksheet
Using Print Preview
Printing a Large WorkSheet
Printing a Chart
Additional Print Options