OUTLINE
Module 1. Designing Your Worksheets
-Formatting Cells: Borders, Fill Colors, etc.
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets

Module 2. Essential Excel Functions
-Basic Arithmetic Formulas: SUM, AVERAGE, etc.
-Text Functions: UPPER, LOWER, CONCATENATE, etc.
-Math Functions: SUM, COUNTIF, SUMIF, etc.
-Absolute vs Relative Reference
-Basic Logical Functions: IF

Module 3. Data Tab and Formatting Tools
-Using Text- to- Columns to Separate Texts
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists

Module 4. Introduction to PivotTables
-Creating PivotTables
-Formatting Fields
-Using Slicers to Filter Data

Outline

OUTLINE
Module 1. Designing Your Worksheets
-Formatting Cells: Borders, Fill Colors, etc.
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets

Module 3. Data Tab and Formatting Tools
-Using Text- to- Columns to Separate Texts
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists

Module 4. Introduction to PivotTables
-Creating PivotTables
-Formatting Fields
-Using Slicers to Filter Data