Microsoft Word
Introduction
Understanding the Word interface, creating and saving documents, typing and editing text, basic text formatting, paragraph alignment and spacing, page Layout, setting margins and paper size, page orientation, basic formatting tools, bulleted and numbered lists, applying styles and themes, inserting images into documents, and basic image formatting.
Intermediate
Advanced formatting, applying page borders and shading, creating and modifying headers and footers, using and customizing built-in styles, creating and applying custom styles, creating tables for data organization, formatting tables and adjusting column widths, adding section breaks for different formatting, using page breaks, creating document templates, and performing a basic mail merge.
Advanced
Advanced page layout, using columns for complex document layouts, using text boxes and shapes effectively, creating master documents for large projects, managing subdocuments within a master document, creating and modifying multi-level lists, generating table of contents and indexes, using captions and cross-references with images, wrapping text around images, and recording and running macros.
Microsoft Excel
Introduction
Understanding the Excel interface, workbook vs. worksheet, data entry and formatting, entering data into cells, basic text formatting (font, size, bold, italic), cell alignment and wrapping, basic formulas and functions, simple arithmetic formulas and functions, using references in formulas, basic data manipulation, sorting data, and filtering data.
Intermediate
Advanced Formatting, conditional formatting, cell styles and themes, data bars and color scales, data Validation, setting up dropdown lists, input message and error alerts, advanced formulas and functions, charts and graphs, creating column, bar, and pie charts, customizing chart elements, and creating PivotTables and PivotCharts.
Advanced
Advanced data analysis, advanced filtering techniques, understanding array formulas, using array functions for complex calculations, consolidating data from multiple sheets or workbooks, using 3D references, recording and running macros, writing simple code, importing and transforming data using Power Query, and creating relationships and calculations in Power Pivot.
Microsoft PowerPoint
Introduction
Understanding the PowerPoint interface, creating and saving presentations, adding new slides, slide layouts, typing and editing text on slides, basic text formatting, inserting images and clipart, adding basic shapes, and applying slide transitions for animations.
Intermediate
Slide layout and design, customizing slide layouts, applying design themes and colors, text and paragraph formatting. adjusting line spacing and indentation, using bullet points and numbering effectively, modifying the Slide Master, creating and editing slide layouts, inserting videos and audio clips, adjusting media playback settings, applying entrance and exit animations, and setting slide transition timings.
Advanced
Advanced design tools, customizing background graphics, creating custom color schemes, creating SmartArt diagrams, inserting and customizing charts, using comments for collaboration, packaging a presentation for CD or online sharing, adding hyperlinks to slides and web content, creating interactive navigation using action buttons, creating motion paths for custom animations, and using triggers to control animations.