Microsoft Office Specialist: Microsoft Excel Advanced Expert
Microsoft Office Excel Formulas and Functions, Excel in Data Analysis and Data Science, Data Visualization, Automation
4.39 (113 reviews)
7 617
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
25/01/2025
course created date
27/01/2025
course indexed date
Bot
course submited by