Previous Lecture
Complete and continue
Microsoft Advance Excel
Introduction to Advanced Excel
Overview of Advanced Excel Features
Importance of Advanced Excel in Data Analysis
Setting up Advanced Excel Environment
Organizing and Manipulating Data
Sorting and Filtering Data
Text Functions and Data Validation
Conditional Formatting
Removing Duplicates
Using Advanced Lookup Functions
Advanced Formula Techniques
Data Visualization and Summarization
Creating and Formatting Charts and Graphs
Pivot Tables and Pivot Charts
Power Pivot and Power View
Data Analysis Expressions (DAX)
Using Advanced Data Analysis Tools
Creating Interactive Dashboards
Loading Data from Various Sources using Power Query
Introduction to Power Query
Importing Data from External Sources
Transforming Data with Power Query Editor
Merging and Appending Data
Loading Data into Excel Workbook
Analyzing Complex Data
Introduction to What-If Analysis
Scenario Manager and Goal Seek
Solver Add-In
Statistical Analysis with Excel
Advanced Data Analysis Techniques
Dashboard and Automation
Creating Dynamic Dashboards with Excel
Advanced Charting Techniques
Excel Automation with Macros and VBA
Using Excel for Data Mining and Predictive Analytics
Excel Integration with Other Tools
Excel Automation with Macros and VBA
Lecture content locked
If you're already enrolled,
you'll need to login.
Enroll in Course to Unlock
Log In
×
E-Mail Address
Password
Remember Me
Login
Forgot Your Password?