Adult Learners > Digital Skills Centre > Microsoft Office Specialist – Excel

Microsoft Office Specialist – Excel

Print this page

Woman working on a spreadsheet on computer

Courses Code

QD2DHMOSE

Study method

Part Time

Cost from

£75

Location(s)

Off Site

View courses

Print this page

Is this course for you?

Boost your CV with Microsoft Excel skills that are Industry recognised, while exploring your use of Excel to improve your productivity. This course provides you with all of the necessary learning materials required to study from home, expanding on your foundation understanding of Excel to that of more advanced spreadsheet automation’s such as master graph your data, and in ultimately preparing you to undertake the Microsoft Office Specialist Excel Examination.

Microsoft Office Specialist certification proves to prospective employers that you have the necessary skills to perform key aspects of a given role, helping you stand out from the crowd.

Associate Level

Reveal trends and gain insights with powerful analysis tools

Excel Associate Certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

A learner earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.

Expert Level

Expand your Excel proficiency by unlocking Excel’s full power

The Microsoft Office Specialist: Excel Expert Certification demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations.

The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.

A learner earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry expert-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel at an expert-level and can complete tasks independently.
Required qualifications

No formal qualifications are required, but you will have to have Microsoft Excel 2019 to complete this course. The course covers the use of either Microsoft Excel 2019 or 365 the pc cloud version of the software.
What skills will I develop?

You will develop in-depth knowledge of Microsoft Excel functions and tools such as the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.

The course materials consist of online materials, but with an allocated online tutor who will provide guidance on start-up and then accessible via email throughout the duration of your enrolment for troubleshooting queries.

Associate Level
- Import, customise and navigate workbooks
- Manipulate cells, ranges and data in a workbooks
- Filter and sort table data
- Calculate and transform data
- Create, modify and manage charts
Expert Level
- Manage configure share workbooks
- Apply advanced conditional formatting and filtering
- Perform logical operations in formulas
- Troubleshoot formulas
- Create and manage PivotTables
- Create and manage PivotCharts
Careers

You can study other MOS qualifications such as in Word, Access, PowerPoint and Outlook and/or progress to that of a Microsoft Expert, but one thing that is clear is that Microsoft Office products are the most widely-used business productivity software worldwide, and that knowing Microsoft Office products will give you a leg up in the job hunt, as well as helping you be a better employee and co-worker with your new found knowledge.
Other important information

On successful completion of this unit, practice exam and certification exam, certification will then be awarded by Microsoft directly. You will be a certified Microsoft Office Specialist in EXCEL application. If students complete three of the four associated certifications, they become Microsoft Office Specialist, earning additional certification.

Course Structure:
- Introduction: 2 hours face to face
- Virtual / Online teaching hours: 80 Approx – self study
- Teams catch-up: 2 hours
- Exam
Please note that the above structure is for just one of the levels – Associate or Expert. If you progress onto the higher level, the structure will be the same again for that level.

Is this course for you?

Boost your CV with Microsoft Excel skills that are Industry recognised, while exploring your use of Excel to improve your productivity. This course provides you with all of the necessary learning materials required to study from home, expanding on your foundation understanding of Excel to that of more advanced spreadsheet automation’s such as master graph your data, and in ultimately preparing you to undertake the Microsoft Office Specialist Excel Examination.

Microsoft Office Specialist certification proves to prospective employers that you have the necessary skills to perform key aspects of a given role, helping you stand out from the crowd.

Associate Level

Reveal trends and gain insights with powerful analysis tools

Excel Associate Certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

A learner earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.

Expert Level

Expand your Excel proficiency by unlocking Excel’s full power

The Microsoft Office Specialist: Excel Expert Certification demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations.

The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.

A learner earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry expert-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel at an expert-level and can complete tasks independently.
Required qualifications

No formal qualifications are required, but you will have to have Microsoft Excel 2019 to complete this course. The course covers the use of either Microsoft Excel 2019 or 365 the pc cloud version of the software.
What skills will I develop?
You will develop in-depth knowledge of Microsoft Excel functions and tools such as the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.

The course materials consist of online materials, but with an allocated online tutor who will provide guidance on start-up and then accessible via email throughout the duration of your enrolment for troubleshooting queries.

Associate Level
- Import, customise and navigate workbooks
- Manipulate cells, ranges and data in a workbooks
- Filter and sort table data
- Calculate and transform data
- Create, modify and manage charts
Expert Level
- Manage configure share workbooks
- Apply advanced conditional formatting and filtering
- Perform logical operations in formulas
- Troubleshoot formulas
- Create and manage PivotTables
- Create and manage PivotCharts
Careers

You can study other MOS qualifications such as in Word, Access, PowerPoint and Outlook and/or progress to that of a Microsoft Expert, but one thing that is clear is that Microsoft Office products are the most widely-used business productivity software worldwide, and that knowing Microsoft Office products will give you a leg up in the job hunt, as well as helping you be a better employee and co-worker with your new found knowledge.
Other important information
On successful completion of this unit, practice exam and certification exam, certification will then be awarded by Microsoft directly. You will be a certified Microsoft Office Specialist in EXCEL application. If students complete three of the four associated certifications, they become Microsoft Office Specialist, earning additional certification.

Course Structure:
- Introduction: 2 hours face to face
- Virtual / Online teaching hours: 80 Approx – self study
- Teams catch-up: 2 hours
- Exam
Please note that the above structure is for just one of the levels – Associate or Expert. If you progress onto the higher level, the structure will be the same again for that level.

Testimonials

“Microsoft Office Specialist certification is the only Microsoft-recognised certification for Office applications worldwide, and provides a stamp of proficiency that more and more employers are looking for to ensure new staff have the requisite skills they need, and in being able to perform such applications in a professional and efficient manner.”

Chris Hopkins

Director of Faculty at South Staffordshire College

Apply for a course

Microsoft Office Specialist – Excel

Off Site

Start Date: Start Any Time

Code: QXD2DHMOSE

Cost: £75

Part Time: 14 Weeks

Apply

Microsoft Office Specialist – Excel

Is this course for you?

Required qualifications

What skills will I develop?

Careers

Other important information

Testimonials

Apply for a course

Microsoft Office Specialist – Excel