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





