Assessment: Word Basic, 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
- View, layout, and print documents
- Format Text and Paragraphs
- Header, Footers, and Page numbering
- Tables and Lists
- 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





