Course details
This course designed to help Microsoft Office Specialist Certification candidates prepare for the Microsoft Office Excel 2007 Expert certification exam.
COURSE OUTLINE
- Module 1. Using Conditional and Custom Formats
- Module 2. Using Range Names
- Module 3. Working with Data Validation
- Module 4. Working with Advanced Filters
- Module 5. Consolidating Worksheets
- Module 6. Using Advanced Functions
- Module 7. Using Auditing Tools
- Module 8. Creating PivotTables and PivotChart
- Module 9. Inserting Visual Elements to a Chart
- Module 10. Using What-if Analysis
- Module 11. Exporting and Importing Data
- Module 12. Using Worksheet Protection
- Module 13. Using Macros
- Module 14. Recording Macros
- Module 15. Editing Macros
- Module 16. Using Forms Control
Course Location
About ITBM
Instructional & Courseware Design
- Customized CD Learning, e-Learning and Courseware for companies. Find out more now.
Office Workflow Automation
- When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- 50 Microsoft Excel Formulas Academy for Health & FitnessSGD 17
SGD 884Duration: Upto 2 Hours - Microsoft Excel 2016 PowerPivot Adams AcademySGD 53
SGD 557Duration: Upto 13 Hours