Course details
In this course, the participant will be introduced to the more advanced features of Microsoft Excel 2010. The participant will learn how to manage, filter and generate reports from Excel data. The course also shows the participant how to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek. Additionally, participants will learn how to create macros to automate some repetitive tasks, as well as how to protect worksheets and workbooks. At the end of the course, the participant will be able to demonstrate the ability to manage and analyze data efficiently with Microsoft Excel 2010.
This course prepares the participants for the Microsoft Office Specialist exams.
COURSE OUTLINE
- Module 1. Applying Workbook Settings
- Module 2. Sharing Workbooks
- Module 3. Using Conditional and Custom Formats
- Module 4. Using Templates
- Module 5. Working with Advanced Filters
- Module 6. Creating/revising Pivottables
- Module 7. Using Range Names
- Module 8. Consolidating Worksheets
- Module 9. Using Advanced Functions
- Module 10. Using Other Functions
- Module 11. Using Auditing Tools
- Module 12. Using Scenarios and Goal Seeking
- Module 13. Using Worksheet Protection
- Module 14. Creating Charts
- Module 15. Formatting Charts
- Module 16. Using Advanced Charting Features
- Module 17. Recording Macros
- Module 18. Creating Macro Buttons
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
- Microsoft Excel Bundle Study 365SGD 127
SGD 919Duration: Upto 18 Hours - Microsoft Excel - Complete Diploma Knowledge DoorSGD 34
SGD 382Duration: Upto 11 Hours
