Microsoft Word

Ribbons, tabs, creating and saving documents, Alignments, borders and shading, Insert pictures, word art, shapes, Insert page, page break, blank page, Bullets and numbering, Tables, Table of content, citation, Header and footer, hyperlink, Page layout, print, Mail merge, Comment, track changes, Types of views, multiple windows

Microsoft Excel

Introduction to Excel, spreadsheet basics, Cell formats, format painter, Basic functions (SUM, AVERAGE, COUNT), Conditional formatting, Data validation, Filter, subtotal, What if analysis (goal seek, data table), Date, text, IF, VLOOKUP functions, Protect sheet, page layout, print, Header footer, autofill, flash fill, Custom lists, sparklines, Charts, Pivot table, Track change, comments, Insert and delete rows and columns, Hyperlink, Macros, Trace precedent, trace dependants, watch window

Microsoft PowerPoint

Introduction to PowerPoint, Types of slide layouts, Creation of presentation, Background colour, design template, Animation, Photo albums, Slide sorter, Slide master, Header and footer, Page layout, print, Slide show