Course description
Impress your current or future employers with expert skills in Microsoft Excel. This course will help you stand out from other candidates or get you the promotion you need! For those who use Excel regularly but want a more in depth, expert knowledge in Excel, our MOS Excel 2019 Expert course is perfect to help you understand a more skilled approach to using the programme. Become fully skilled in using Microsoft Excel and choose to sit an exam to receive the full qualification. Study for this course online and study whenever, wherever you want.
Course Content
Unit 1 Manage workbook options and settings
- Introduction
- Managing workbooks
- Preparing workbooks for collaboration
- Using and configuring language options
- Lesson review and quiz
- Assignment 1 – workbook options & settings exercises
Unit 2 Managing and formatting data
- Introduction
- Fill cells based on existing data
- Formatting and validating data
- Advanced conditional formatting and filtering
- Lesson review and quiz
- Assignment 2 – custom data formatting exercises
Unit 3 Creating advanced formulas and macros
- Introduction
- Performing logical operations in formulas
- Lookup data using functions
- Using advanced date and time functions
- Performing data analysis
- Troubleshooting formulas
- Creating and modifying macros
- Lesson review and quiz
- Assignment 3 – advanced formula exercises
Unit 4 Managing advanced charts and tables
- Introduction
- Creating and modifying advanced charts
- Creating and modifying pivot tables
- Managing pivot tables
- Create and modifying pivot charts
- Lesson review and quiz
- Assignment 4 – advanced table and chart exercises
- The MOS examination
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Why choose Open Study College
Trusted by over 110,000 students
Study from home, at your own pace
Discounts on selected courses
Expenses
Pay Now: GBP 229.00
OR 6 Monthly Instalments of GBP 49.35 with a deposit of GBP
32.90 totalling 329