Price: SGD 589
- Duration: 2 Days
Course details
In this course, the participant will be introduced to the more advanced features of Microsoft Excel 2013. 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 2013.
COURSE OUTLINE
- Module 1. Using Conditional and Custom Formats
- Module 2. Using Templates
- Module 3. Working with Databases
- Module 4. Working with Advanced Filters
- Module 5. Revising Charting Features
- Module 6. Creating/Revising PivotTables
- Module 7. Using Auditing Tools and Range Names
- Module 8. Exporting and Importing Data
- Module 9. Using Advanced Functions
- Module 10. Using Scenarios
- Module 11. Using Worksheet Protection
- Module 12. Tracking and Merging Workbooks
- Module 13. Recording Macros
- Module 14. Comments
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.
Are you from ITBM ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SGD 272Duration: Upto 155 Hours
- SGD 18
SGD 354Duration: Upto 5 Hours
