Microsoft Excel Advanced
Overview & Objectives:
This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2003 effectively.
Course Duration:
7 Hours (Part-time or Fulltime available)
Who should attend:
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.
Prerequisites:
This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions, and perform simple formatting of the data.
Course modules:
Chapter 1 Labels And Names
Chapter 2 Protecting Data
Chapter 3 Lookup Functions
Chapter 4 Nesting Functions Workshop
Chapter 5 Advanced Filters
Chapter 6 Validations
Chapter 7 Goal Seeking
Chapter 8 Data Tables
Chapter 9 Scenarios
Chapter 10 Pivot Tables
Chapter 11 Outlining
Chapter 12 Linking Workbooks
Chapter 13 Sharing Workbooks
Chapter 14 Consolidation
Chapter 15 Excel On The Web
Chapter 16 Recorded Macros
Chapter 17 Recorder Workshop
Chapter 18 Macro Virus Control
Certifications
- Cloud Computing Certifications
- Cisco Certifications
- Microsoft Certifications
- PHP Certifications
- CompTIA Certifications
- Linux Certifications
- MySQL Certifications
- Check Point Certification
- Sun Java Certifications
- VMware Certifications
- IPV6 Certifications
Applications Training
Project Management Training
Training Programmes
Follow Us
Follow Us
