Course details
The exam requires the candidate to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The candidate shall be able to operate effectively at more than a basic level of competence and be able to edit and enhance numeric, text and graphical data and to sort, query and link data.
The candidate shall be able to carry out advanced formatting and presentation operations on charts and graphs. The candidate shall be able to use functions such as those associated with logical, statistical or mathematical operations. The candidate shall be able to use available analysis and audit tools and to run and record simple macros.
This course prepares the participants for the Microsoft Office Specialist exams.
COURSE OUTLINE
- Module 1. Apply Custom Conditional Formatting
- Module 2. Using Advanced Functions
- Module 3. Using Scenarios And Goal Seeking
- Module 4. Using Worksheet Protection
- Module 5. Revising Charting Features
- Module 6. Creating/Revising PivotTable
- Module 7. Sharing Workbooks
- Module 8. Recording Macros
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
- Excel Data Analysis Advanced Diploma Course LineSGD 33Duration: Upto 1 Hour
- Financial Modelling in Excel Course DriveSGD 32
SGD 164Duration: Upto 2 Hours