1) Excel Shortcuts

1. Shortcuts
2. Creating and Editing Workbooks
3. Formatting Content
4. Printing and viewing workbooks

2) Conditional Formatting

1. Formatting Cells Containing Values
2. Top & Bottom Ten Items
3. Working with Data Bars
4. Working with Icon Sets
5. Clearing Conditional Formatting

3) Creating Charts

1. Creating Column, Line & Pie Charts
2. Resizing A Chart
3. Changing The Chart Type
4. Adding Chart Title

4) PivotTable

1. Creating PivotTable
2. Dropping Fields Into PivotTable
3. Filtering PivotTable Report
4. Clearing Report Filter
5. Formatting PivotTable Report
6. Creating Slicers (Interactive Filter)

5) Mastering VLOOKUP

1. Learn all functions related to V look up

6) Formulas / Functions

1. Basic Formulas
2. Using IF To Calculate Values

Word

1. Introduction to Word
2. Type, edit, and create text
3. Detailed formatting, saving, and print files
4. Add-ons on documents (images, charts, tables, bullets)
5. Smart Art and other objects
6. Header & Footer
7. Proofreading & grammar check
8. Merging, sharing, and emailing documents

PowerPoint

1. Introduction to PowerPoint
2. Slides & Themes
3. Smart arts and other Objects
4. Hyperlinks & Graphic representations
5. Tables, slide show, and animation
6. Proofread, saving, sharing, and printing