********Basic Excel***************

1. Introduction to Excel
- Start Up Screen
- Quick Access Toolbar
- Sheets
- Grid View
- Page View
- Page breaker view
- Zoom Slider

2. Create & Edit Data
- Create New database
- Clipboard actions
- Font Actions
- Page Layout Actions
- View tab Actions

********Intermediatory Excel***************

1. Conditional Formation

- Highlight Cell Rules
- Top/Bottom Rules
- Data bar
- Color Scale
- Icon Set

2. Formulas & Function
- SUM
- AVERAGE
- IF
- VLOOKUP
- TRIM
- LEFT
- RIGHT

3. Basic Pivots and Charts

Advance Pivot
- 1. Use slicers
- 2. Create a calculated field
- 3. Create multiple pivot tables from one
- 4. Hide or unhide subtotals
- 5. Look behind the scenes of your pivot table
- 6. Refresh your data

Charts

- 1. Use slicers
- 2. Column Chart with Percentage Change
- 3. Conditional Doughnut Progress Chart
- 4. Interactive Histogram with Details
- 5. Dynamic Histogram or Frequency Distribution Chart
- 6. Annual Trend with Monthly Details

Formulas for below Functions:
- Lookup Ref Functions
- String Text Functions
- Date Time Functions
- Statistical Functions
- Logical Functions

Power Query Training
===============================================

- Power Query Introduction

- Import Data into Power Query
- Import Data from Excel File
- Import data from other files / folder

- Loading and Refreshing
- Load data and refresh query when source data changes

- Data Transformation
- Column Transformation
- Row Transformation

- InBuilt Transformations in power query
- Text Transformation
- Numbers transformation
- Date transformation
- Conditional Column transformation

- Consolidate and Append Data
- Append data from Excel tables within same Excel file
- Append / Duplicate / Reference multiple Queries
- Import data from files in a folder
- Import data from multiple excel files in a folder
- Changing file path for source data

- Merge Quires/Multiple joins in power query
- Multiple JOINS in power query (Merge Queries)

- Building Blocks of M Language
- Introduction to building blocks in M
- Text functions in Power Query
- Date functions in Power Query
- Conditional Functions in Power Query