Assessment: Word Expert, PowerPoint basic, Excel Advanced
Finding ways to improve productivity is one of the most important goals to achieve in today’s businesses. Taking advantage of the special tools offered by Microsoft Office to improve productivity, requires in-depth knowledge of its operation.
The assessment syllabus covers the following topics in Word, Excel, and PowerPoint:
- Word
- Formatting
(Styles, paragraph settings, wrapping style, picture layout) - Referencing and Columns
(Columns, table of contents, captions) - Enhancing Productivity
(Text to table, sections)
- Formatting
- Excel
- Headers and Footers
- Pivot Tables
- Conditional Formatting
- Slicers
- Remove Duplicate Data
- Formulas and Functions
(SUM, AVERAGE, COUNT, MIN, MAX, AVERAGEIF, OFFSET, SUMIF, AVERAGEIFS, COUNTIFS, VLOOKUP, INDEX, MATCH, DAY, MONTH, DATE)
- PowerPoint
- Using Slide Masters
- Formatting and Themes
- Charts, Graphical Objects, and Multimedia
- Animations and Transitions
The assessment uses Microsoft Office 2019
The assessment syllabus covers formulas and functionality common in the following versions of Microsoft Office:
Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 2021, Microsoft 365
Also, the interface of Microsoft Office remains mostly similar for all the above versions of Microsoft Office.