Advanced Microsoft Excel
EduCamp Australia
6 modules
English
Lifetime access
"Unlock the full potential of Microsoft Excel with advanced techniques and master the art of data analysis like a pro!"
Overview
In the "Advanced Microsoft Excel" course, you will delve deep into the various advanced features and functionalities of Microsoft Excel to enhance your skills and proficiency in spreadsheet tasks. This course is designed for individuals who already have a solid understanding of the basics of Excel and are looking to take their knowledge to the next level. Throughout the course, you will explore advanced formula writing, data analysis techniques, and data visualization methods using Excel's more complex tools. You will learn how to work with large datasets more efficiently, create dynamic and interactive reports, and automate repetitive tasks through macros and VBA programming. Furthermore, the course will cover advanced functions such as VLOOKUP, INDEX-MATCH, SUMIFS, and more, allowing you to manipulate and analyze data with ease. You will also discover how to use PivotTables and PivotCharts to summarize and present data effectively, as well as create interactive dashboards to showcase key insights. By the end of the "Advanced Microsoft Excel" course, you will have the skills and confidence to tackle complex data analysis projects, optimize your workflow, and become a more proficient Excel user. Whether you are a business professional, analyst, accountant, or student, this course will empower you to harness the full potential of Excel for various applications.
Key Highlights
Master advanced functions and formulas in Excel
Create complex spreadsheets and data models
Automate tasks with VBA programming
Perform advanced data analysis and visualization
Work with PivotTables and Power Pivot for in-depth analysis
Collaborate and share data effectively with others
Optimize workflow and increase productivity
Troubleshoot and debug complex Excel issues
What you will learn
Advanced Functions
Master advanced Excel functions such as INDEX-MATCH, VLOOKUP, and SUMIF.
Data Analysis Techniques
Learn how to analyze data using PivotTables, Power Query, and complex formulas.
Automation with Macros
Automate tasks and processes by creating and running macros in Excel.
Advanced Charting
Create advanced charts and graphs to visually represent data effectively.
Data Visualization
Explore advanced data visualization techniques in Excel for better insights.
Modules
Introduction
5 attachments
Program Details
Program Structure
Student Handbook
89 pages
Student Dashboard
Steps for adding Course Calendar - Google Docs
9 pages
FOUNDATIONAL LEVEL COURSE
19 attachments
Maths
Mathematics for Data Science I
Math Week 1 Solution for Practice Assignment
16 pages
Math Week 1 FAQ
4 pages
Mathematics for Data Science II
Essential Math for Data Science
452 pages
Maths Week 1-4
32 pages
Statistics
Statistics for Data Science I
Introductory Statistics
855 pages
Statistics Intro
818 pages
Statistics for Data Science II
Computational Thinking
Computational Thinking
English
English I
English II
Programming
Programming in Python
Diploma in Programming
Diploma in Data Science
BSc in Programming and Data Science
BS in Data Science and Applications
A$ 49.00
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!

Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
