Advanced Microsoft Excel
Course
In Eastleigh
Price on request
Description
-
Type
Course
-
Location
Eastleigh
You will then be qualified to progress to the VBA course for Excel. Candidates can be directed toward the European Computer Driving License Course.
Facilities
Location
Start date
Eastleigh
(Hampshire)
See map
Chestnut Avenue, SO50 5FS
Start date
On request
Reviews
Have you taken this course?
Subjects
- IT
- Excel
- MS Excel
- Microsoft Excel
- Microsoft excel training
Course programme
Course Syllabus:
Working with Advanced Formulas
- Using Names
- Using decision-making functions
- Creating nested functions
- Using financial functions
Lookups and Data Tables
- Working with lookup functions
- Creating data tables
Advanced List Management
- Creating subtotals
- Validating cell entries
- Exploring database functions
Working with PivotTables and Pivot Charts
- Working with PivotTables
- Rearranging PivotTables
- Formatting PivotTables
Exporting and importing text files
- Querying external databases
Using Analytical Options
- Working with Goal Seek and Solver
- Working with scenarios
- Working with views
Working with Macros
- Running and recording a macro
- Viewing VBA code
- Function procedures All one-day IT courses are bespoke and not qualification-based. Training formats available:
- 1 day instructor-led at the College
- Onsite at your company office UK wide
- Bespoke one-to-one basis
- Tailored training courses to your requirements At the end of this course, you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and advanced analysis, record macros and integrate with other office applications.Training formats available
- 1 day instructor-led at the College
- On-site at your company office UK wide
- Bespoke one-to-one basis
- Tailored training courses to your requirements
Advanced Microsoft Excel
Price on request