Excel Training- Focus on business and Data Analytics
In this course you will learn 1. Excel Data Manipulation and Cleaning 2. Excel Data Exploration and Visualization 3. Excel Analytical Functions
Data Sort
Filtering
Tables
Text to Columns
Flash Fill
Data Validation
Group and Outline
Freeze Panes
Relative and Absolute Referencing
VLOOKUP
Index Match
IF
Nested If
Count if
SUM IF
IFERROR
Chart Basics
Chart Series and Column Charts
Bar Charts
Pie Charts
Composite Charts
Power Query
Pivot Tables
Dashboards