Advanced Microsoft Excel 2010 Training Courses
Short course
In Twickenham
Description
-
Type
Short course
-
Location
Twickenham
-
Duration
1 Day
-
Start date
Different dates available
This course aims to give delegates an in-depth knowledge of Excel 2010 features.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates will have advanced skills in using Microsoft Excel 2010. They will be able to:
Link multiple workbooks
Print workbooks
Use one and two-way data tables
Audit a worksheet
Create and use PivotTables and reports
Use Solver, Scenario Manager and Goal Seek tools
Use Excel workgroup features
Create and use macros
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- MS Excel
- Excel
- Microsoft excel training
- Microsoft Excel
- Data Analysis Tools
- Goal seek
- <br /> Solver
- Scenario manager
- SmartArt graphics
- PivotTables
- Tracing errors
Course programme
Using a workspace
Printing workbooks
Printing and previewing multiple worksheets
Custom views
Display
Using one-input or two-input data tables
Protection
Protecting and unprotecting a worksheet with a password
Protecting and unprotecting designated cells in a worksheet with a password
Security
Adding password protection to a workbook
Removing password protection from a workbook
Creating a shared workbook
Tracking changes
Highlighting
Accepting
Rejecting
Sorting
Sorting data by multiple columns
Performing custom sorts
Querying/filtering
Creating a single or multiple criteria query using available options
Using advanced query/filter options
Templates
Using a template
Editing a template
Auditing a worksheet
Tracing errors
Tracing dependents
Tracing precedents
Adding, removing and editing worksheet comments
PivotTables and Reports
Creating a PivotTable report
Creating a PivotChart report
Resetting a summary function in a PivotTable report
Creating a PivotTable report for the World Wide Web
Data Analysis Tools
Goal Seek
Solver
Scenario manager
SmartArt graphics
Creating a SmartArt graphic
Formatting SmartArt
Changing SmartArt graphic layout
Changing SmartArt graphic colours
Macros
Recording macros
Running macros
Editing macros
Additional information
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT
Advanced Microsoft Excel 2010 Training Courses