-     Introduction and Data Handling Basics:

-       Introduction to Excel.

-       Naming Cells and Ranges:

-       Setting up range names.

-       Scoping a range name.

-       Using the range name manager.

-       Using names in formulas.

-       Rules for naming cells and ranges.

-       Creating named ranges automatically based on cell values.

-       Deleting named cells/ranges.

-       Paste Special.

-       Advanced Paste Special.

-       Text to Columns.

-     Data Organization and Formatting:

-       Working with Tables:

-       Creating a table from existing data.

-       Changing the table name, style, and style options.

-       Creating a total row.

-       Inserting/deleting table rows/columns.

-       Selecting parts of a table and moving a table.

-       Outlining and Subtotals:

-       Creating subtotals.

-       Outlining.

-       Data Validation.

-       Formatting & Display Techniques:

-       Creating custom number formats.

-       Freezing panes (top row, first column, or both).

-       Using the Split feature.

-       Hiding and un-hiding rows, columns, and worksheets.

-     Logical and Conditional Functions:

-       Date & Time Functions.

-       Logical Functions:

-       IF, SUMIFS, SUMIF.

-       IFNUMBER.

-       IFERROR.

-       AND / OR.

-       Counting Functions:

-       COUNT, COUNTIF, COUNTIFS.

-       Conditional Formatting.

-       Text Functions:

-       Left, Right, Mid functions.

-     Lookup Functions and Formula Analysis:

-       Sorting and Filtering.

-       Lookup & Reference Functions:

-       VLOOKUP, HLOOKUP, XLOOKUP, Match, Index.

-       Cell References.

-       Tracing and Evaluating Formulas:

-       Trace precedents / dependents.

-       Evaluate formula.

-       Remove Duplicates.

-       Consolidate Data.

-     PivotTables and Advanced Features:

-       Pivot Tables.

-       Protecting Worksheets / Worksheet Content / Cells.

-       Go To / Special.

-       Mail Merge in MSWord

-       Final Project: A comprehensive project utilizing PivotTables and other advanced analysis skills.