Advanced Excel Course Details
Advanced Excel Course is designed to enhance data analysis, reporting, and automation skills using Excel. It covers advanced formulas, functions (VLOOKUP, HLOOKUP, INDEX-MATCH), pivot tables, data validation, macros, Power Query, Power Pivot, dashboards
Advanced Excel Course Syllabus
1. Introduction to Advanced Excel
- Overview of Advanced Features
- Understanding Excel Interface and Shortcuts
- Customizing Excel for Efficiency
2. Advanced Formulas and Functions
- Logical Functions: IF, AND, OR, IFERROR
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP
- Text Functions: LEFT, RIGHT, MID, CONCATENATE, TEXTM, LEN, TRI
- Date and Time Functions: TODAY, NOW, DATEDIF, EOMONTH
- Math and Statistical Functions: SUMIFS, COUNTIFS, AVERAGEIFS, RANK, ROUND
3. Data Validation and Conditional Formatting
- Setting Data Entry Rules
- Dropdown Lists and Custom Validation
- Applying Conditional Formatting with Formulas
4. Data Analysis Using Pivot Tables and Pivot Charts
- Creating and Customizing Pivot Tables
- Grouping, Filtering and Slicers
- Calculated Fields and Custom Reports
5. Power Pivot and Data Modeling
- Creating Data Models and Relationships
- DAX (Data Analysis Expressions) Basics
- Advanced Data Visualization
6. Financial Analysis and Business Intelligence
- Forecasting and Trend Analysis
- Goal Seek and What-If Analysis
- Scenario Manager and Solver