Microsoft Office Excel Formulas and Functions, Excel in Data Analysis and Data Science, Data Visualization, Automation
What you will learn
Get Instant Notification of New Courses on our Telegram channel.
Noteβ Make sure your ππππ¦π² cart has only this course you're going to enroll it now, Remove all other courses from the ππππ¦π² cart before Enrolling!
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
English
language