- Getting Started:  

-    Data in Excel.

-    Data entry in Excel.

-    Auto File in Excel with data type.

-    Auto Number with data type.

-    Tips and tricks in data type.

-    Work with Multiple Worksheets.

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

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

-       Conditional Formatting :

-    Introduction to Conditional Formatting.

-    Highlight Rules.

-    Top/Bottoms Rules.

-    Data Bar.

-    Color Scale .

-    Icon Sets.

-    Manage Rules.

- Data Validation.:

-    Introduction to Data Validation.

-    Number Validation.

-    Text Validation.

-    Date/Time .

-    List Validation and manage List .

- Data tools:

-    Remove Duplicates.

-    Text to Columns.

- Manipulating Data:

-    Paste Special.

-    Transposing data.

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

-  Functions:

-    COUNT , COUNTA , SUM , SUMIF, VLOOKUP , IF, AND , OR.

- Sort & Filter:

-    Sorting Data (By Values, By Cell Color, By Font Color, By Cell Icons) .

-    Multi Column Sort .

-    Filter (By Values, By Cell Color, By Font Color, By Cell Icons) .

-    Multi Column Filter .

-    Advanced Filter .

 -  Charts :

-    Introduction to chart.

-    Creating chart.

-    Edit, resize, move and delete chart.

-    Change Chart type.

-    Working with Chart Label.

-    Working with Chart Axes.

-    Manage Chart elements.

-    Using Sparkline (Line, Column, Win/Loss) .