Advance Excel Course
Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the huge amount of data, performing data analysis, better representation of data, etc.In this course we will cover different types of Formulas & Functions, Pivot Table, Conditional Formatting, Graphs & Charts.
Formulas & Functions
Working With Data
- Sum, Count & Average
- Date & Time
- Logical (If, Match, Index etc.)
- Look Up
- Off Set
- Iferror
- Pivot Table
- Sub Total
- Conditional Formatting
- Goal Seek
- Data Validation
- Remove Duplicates
Advanced Concepts
Graphs
- Paste Special
- Data Tools
- Formula Audits
- Security & Protection
- Different Type of Charts
- Combination of Column & Line Charts
- Dynamic Charts
- Charts Formatting