Microsoft Office Specialist: Microsoft Excel Advanced Expert
Microsoft Office Excel Formulas and Functions, Excel in Data Analysis and Data Science, Data Visualization, Automation
4.43 (89 reviews)
5,464
students
1.5 hours
content
Jan 2025
last update
$49.99
regular price
What you will learn
Module 1: Advanced Formulas and Functions
Exercise 1: Logical Functions
Exercise 2: Lookup and Reference Functions
Exercise 3: Text Functions
Module 2: Data Analysis and Visualisation
Exercise 4: Pivot Tables
Exercise 5: Advanced Charting
Exercise 6: Conditional Formatting
Exercise 7: Data Tables
Module 3: Data Management and Cleaning
Exercise 8: Data Validation
Exercise 9: Text to Columns
Exercise 10: Removing Duplicates
Module 4: Automation with Macros and VBA
Module 5: Advanced Data Import and Export
Exercise 15: Using Downloaded JSON Data for Data Connections
Exercise 16: Importing data
Exercise 17: Data Integration with SQLite and Excel
Exercise 18: Advanced Filtering and Sorting with Dynamic Arrays
6422925
udemy ID
1/25/2025
course created date
1/27/2025
course indexed date
Bot
course submited by