Excel 2010 - Level 1 - 1 Day
Course Aims
This course introduces users to Microsoft Excel. Users will learn how to create, modify and print spreadsheets. This 'hands on' course includes specially prepared exercises that give participants practical experience of using the features of Excel to create professional looking spreadsheets.
Course Outline
Getting Started with Excel
- • Starting Excel; Excel opening Screen
- • Basic Excel On–screen features
Getting Assistance with Excel
- • The Office Assistant
- • The Ask a Question Box
- • Other Ways to Get Help
Creating a Wordbook
- • Creating a New Wordbook and Entering Data
- • Moving Around The Sheet
- • Selecting and Editing data; Undoing Incorrect Edits
- • Autofill; Custom Lists
- • AutoRecover
- • Saving, Closing, Opening and Deleting a Wordbook
- • Creating a folder
Editing a Wordsheet
- • Moving and Copying Data
- • Using Go To/Find and Replace
Creating Formulae
- • Entering a Calculation
- • Using Basic Functions; Autosum; Insert Function
- • Using Relative and Absolute Cell Addresses
- • Common Error Messages
|
Formatting Cells
- • The Formatting Toolbar
- • Formatting Numbers and Text
- • Indenting and Aligning
- • Resizing Columns and Rows
- • Merge and Unmerge cells
- • Borders and Shading
- • AutoFormat and Format Printing
Working with Worksheets
- • Inserting, Deleting & Moving Rows and Columns
- • Inserting, Deleting, Moving & Naming Worksheets
- • Change the Colour of Worksheet Tabs
Printing Worksheets
- • Print Preview
- • Changing the Page Setup; Printing
Charts and Pictures
- • Creating Charts; Chart Wizard
- • Changing Chart Elements
- • Changing Chart Data
- • Printing Charts
- • Inserting Clip Art and Pictures
- • Drawing Objects
- • Manipulating Objects
|
Target Audience
New or intending users of Excel who want to gain a good understanding of the software in a short space of time.
Assumed Knowledge
A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance on a "Windows Fundamentals" course.
Excel 2010 - Level 2 - 1 Day
Course Aims
This course introduces users to more advanced features of Excel. This 'hands on' course includes specially prepared exercises that give participants practical experience of using the more advanced features of Excel.
Course Outline
Sorting and filtering data
- • Create a Data List
- • Single and Multi-Level Sorts/Applying Filters
More Advanced Formulae
- • Financial and Statistical Functions; ROUND Functions
- • Text Functions and Logical Functions
- • Nested Functions
Navigating Worksheets and Workbooks
- • Working with Multiple Workbooks
- • Working with Large Sheets
- • Using Panes & Zoom; Freezing Panes
- • Using 3D references
- • Worksheet Linking
Productivity Features
- • Protecting the Worksheet/Part of Worksheet
- • Hide/Unhide Data
- • AutoCorrect
- • The Spelling Checker
- • Working with Comments
|
Custom Number and Conditional Formatting
- • Apply Number Formats
- • Custom Number & Date Formats
- • Using Conditional Formats
Using Named Ranges
- • Add and Delete a Named Range
- • Using a Named Range in a Formula
Working with Multiple Workbooks
- • Creating Custom Views; Creating a Workspace File
- • Using Workspace Files; Linking Workbooks
- • Creating Formulae to Link Data
Charts and Pictures
- • Creating Charts; Chart Wizard
- • Changing Chart Elements
- • Changing Chart Data
- • Printing Charts
- • Inserting Clip Art and Picture
s
- • Drawing Objects
- • Manipulating Objects
|
Target Audience
Users with a basic understanding of Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.
Assumed Knowledge
Delegates should have a good working knowledge of Excel and must be able to create, format and print workbooks that incorporate basic mathematical, financial and logical functions and charts.
Excel 2010 - Level 3 - 1 Day
Course Aims
This course is designed to give users and understanding of some of the more advanced features of Excel. This 'hands on' course includes specially prepared exercises that gives participants practical experience of using the more advanced features of Excel.
Course Outline
Importing and Exporting Data
- • Using Paste Special
- • Sharing and Importing Data Using Other Applications
Templates and Add-Ins
- • Creating and Using Workbook Templates
- • Loading Add-In Programs
Lookup and Reference Functions
- • Using VLOOKUP, HLOOKUP Functions
- • Preventing LOOKUP Errors
Macros
- • Creating, Editing & Assigning Macros
- • Copying, Deleting and Renaming Macros
- • Macro Virus Protection
Customising Excel Charts
- • Repositioning Chart Elements
- • Formatting Chart Axes and Data Series
- • Combination Charts/Trendlines/Images
- • Storing a Custom Chart as a Template
Auditing a Worksheet
- • Data validation rules
- • The Auditing toolbar
- • Tracing errors, precedents and dependents
- • Formula Error Checker, Formula Evaluator & Watch Window
|
Working with Data Lists
- • Creating Sorting & Filtering Lists
Data Management
- • Searching for Data with Advanced Filters
- • Summarising Data with Outlines
- • Querying a Database
- • Data Sources
PivotTables
- • Analysing Data with PivotTables Overview
- • Creating PivotTables Lists for the Web
Sharing Workbooks
- • Applying Worksheet & Workbook Protection
- • Password Protecting a File
- • Changing Workbook Properties
- • Adding Comments to the Worksheet
- • Sharing Workbooks & Tracking Changes
- • Resolving Conflicts
- • Merging Workbooks
- • E-mailing Workbooks for Review
|
Target Audience
Users with a basic understanding of Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.
Assumed Knowledge
Delegates should have a good working knowledge of Excel and must be able to create, format and print workbooks that incorporate basic mathematical, financial and logical functions and charts.