1.      Introduction to Excel Advance.

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

3.      Paste Special

4.      Advanced Paste Special

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

6.      Outlining and subtotals

•       Creating subtotals.

•       Outlining.

7.     Data Validation

•       Using the Data Validation feature.

•       Finding Invalid Data.

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

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

10.  Date & Time Function.

11.  Logical Function.

•       IF.

•       SUMIF.

•       SUMIFS.

•       IF NUMBER

•       IFERROR.

•       AND / OR.

•       COUNT.

•       COUNTIF.

•      COUNTIFS.

12.  Sorting

13.  Lookup& Reference Function.

•       VLOOKUP.

•       Match.

•       Index.

•       XLOOPUP

14.  Cell References

15.  Trace Precedents / Dependents.

16.  Evaluate Formula.

17.  Protecting Worksheet / Worksheet Content / Cells.

18.  Consolidate data.

19.  Conditional Formatting

20.  Left /Right/ Mid Functions.

21.  Go to / Special.

22.  Evaluation Formula.

23.  PivotTable.