-    Introduction to Excel Advance.

-    Naming Cells and Range:

-    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.

-    Working with Tables:

-    Use Tables.

-    Create a Table from Existing Data.

-    Change the Table Name.

-    Change the Table Style.

-    Change Table Style Options.

-    Create a Total Row.

-    Insert/Delete Table Rows/Columns.

-    Select Parts of a Table, Move a Table.

-    Outlining and subtotals:

-    Creating subtotals.

-    Outlining.

-    Data Validation:

-    Using the Data Validation feature.

-    Finding Invalid Data.

-    Filtering:

-    Filtering Data.

-    Using AutoFilter and Removing AutoFilter.

-    Using AutoFilter with Top 10.

-    Creating a Custom AutoFilter.

-    Filtering with a Single Comparison Criterion.

-    Filtering with Two Comparison Criteria.

-    FORMATTING & DISPLAY TECHNIQUES:

-    Creating custom number formats.

-    Freezing the top row.

-    Freezing the first column.

-    Freezing the top row and the first column at the same time.

-    Using Split.

-    Hiding and un-hiding rows.

-    Hiding and un-hiding columns.

-    Hiding and un-hiding worksheets.

-    Remove Duplicates.

-    Text to Columns.

-    Date & Time Function.

-    Logical Function.

-    IF.

-    SUMIF.

-    SUMIFS.

-    IF NUMBER

-    IFERROR.

-    AND / OR.

-    COUNT.

-    COUNTIF.

-    COUNTIFS.

-    Sorting.

-    Lookup& Reference Function:

-    VLOOKUP.

-    Match.

-    Index.

-    XLOOPUP

-    Cell References.

-    Trace Precedents / Dependents.

-    Evaluate Formula.

-    Protecting Worksheet / Worksheet Content / Cells.

-    Consolidate data.

-    Conditional Formatting

-    Left /Right/ Mid Functions.

-    Go to / Special.

-    Evaluation Formula.

-    PivotTable.