Overview
This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more.
We'll start with a deep dive into some of Excel's core capabilities, including formulas, charts & graphs, and PivotTables. You'll learn how to explore and analyze raw data, build custom visuals and interactive reports, and quickly expose patterns and insights with user-friendly pivots.
From there we'll dive into more advanced tools like Power Query, Power Pivot & DAX, introduce advanced dashboard design principles, and explore tips and techniques to help you maximize your productivity.
Finally, we'll wrap up with an exam prep course to help you earn your official MO-201 Excel Expert certification from Microsoft.
This path is designed to help you learn job-ready skills, solve real business problems, and build a project portfolio to showcase your skills to peers and employers.
WHO SHOULD TAKE THIS PATH?
- Excel users who want to work more efficiently and develop expert-level analytics and data visualization skills
- Analysts or business intelligence professionals looking to develop a deep and well-rounded Excel skill set
- Excel users looking to ace the MO-201 exam and become a Microsoft Certified Expert
- Students looking for a hands-on, project-based learning experience
WHAT ARE THE PATH REQUIREMENTS?
- Microsoft Excel, ideally Excel 2019 or Office 365 for Windows/PC (some features and charts are unavailable in older versions)
- Familiarity with basic Excel functionality is strongly recommended
Curriculum
Course
Excel Formulas & FunctionsMaster 75+ formulas & functions, and transform Excel into a dynamic and powerful analytics tool
Course
Excel Charts & GraphsDesign clear and effective charts and graphs, create advanced custom visuals, and master 20+ chart types in Excel
Guided Project
HR Survey AnalysisVisualize survey response data from ~1,500 city employees in Washington state
Course
Excel Pivot Tables & ChartsLearn how to explore and analyze your data using Pivot Tables & Pivot Charts, with 10 real-world case studies
Guided Project
Coffee Shop DashboardBuild an interactive dashboard to explore and analyze coffee shop sales
Course
Power Query, Power Pivot & DAXBuild and analyze data models using Excel’s trio of self-service BI tools: Power Query, Power Pivot & DAX
Guided Project
Global Electronics RetailerBuild a data model and interactive revenue report for a global retail company
Course
Advanced Excel Dashboard DesignBring your data to life with dynamic, interactive Excel dashboards, and build 3 real-world projects from scratch
Guided Project
Manufacturing Downtime AnalysisIdentify productivity improvement opportunities in a production line
Course
Excel MO-201 Exam PrepMaster the skills you need to ace the MO-201 Exam and become a certified Microsoft Excel ExpertInstructors
Chris Dutton
Chris DuttonChris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Enrique Ruiz
Enrique RuizEnrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.
Overview
This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more.
We'll start with a deep dive into some of Excel's core capabilities, including formulas, charts & graphs, and PivotTables. You'll learn how to explore and analyze raw data, build custom visuals and interactive reports, and quickly expose patterns and insights with user-friendly pivots.
From there we'll dive into more advanced tools like Power Query, Power Pivot & DAX, introduce advanced dashboard design principles, and explore tips and techniques to help you maximize your productivity.
Finally, we'll wrap up with an exam prep course to help you earn your official MO-201 Excel Expert certification from Microsoft.
This path is designed to help you learn job-ready skills, solve real business problems, and build a project portfolio to showcase your skills to peers and employers.
WHO SHOULD TAKE THIS PATH?
- Excel users who want to work more efficiently and develop expert-level analytics and data visualization skills
- Analysts or business intelligence professionals looking to develop a deep and well-rounded Excel skill set
- Excel users looking to ace the MO-201 exam and become a Microsoft Certified Expert
- Students looking for a hands-on, project-based learning experience
WHAT ARE THE PATH REQUIREMENTS?
- Microsoft Excel, ideally Excel 2019 or Office 365 for Windows/PC (some features and charts are unavailable in older versions)
- Familiarity with basic Excel functionality is strongly recommended
Instructors
Chris Dutton
Chris DuttonChris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Enrique Ruiz
Enrique RuizEnrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.
Curriculum
Course
Excel Formulas & FunctionsMaster 75+ formulas & functions, and transform Excel into a dynamic and powerful analytics toolCourse
Excel Charts & GraphsDesign clear and effective charts and graphs, create advanced custom visuals, and master 20+ chart types in ExcelGuided Project
HR Survey AnalysisVisualize survey response data from ~1,500 city employees in Washington stateCourse
Excel Pivot Tables & ChartsLearn how to explore and analyze your data using Pivot Tables & Pivot Charts, with 10 real-world case studiesGuided Project
Coffee Shop DashboardBuild an interactive dashboard to explore and analyze coffee shop salesCourse
Power Query, Power Pivot & DAXBuild and analyze data models using Excel’s trio of self-service BI tools: Power Query, Power Pivot & DAXGuided Project
Global Electronics RetailerBuild a data model and interactive revenue report for a global retail companyCourse
Advanced Excel Dashboard DesignBring your data to life with dynamic, interactive Excel dashboards, and build 3 real-world projects from scratchGuided Project
Manufacturing Downtime AnalysisIdentify productivity improvement opportunities in a production lineCourse
Excel MO-201 Exam PrepMaster the skills you need to ace the MO-201 Exam and become a certified Microsoft Excel ExpertTestimonials
Real. Happy. Students.
We've helped thousands of students land dream jobs, launch new careers, and build powerful data skills. Start writing your own success story today!
"Thinking like an analyst" course is a very complete compact course if you have to go through the process of getting to know your customers business till building an insightful dashboard for them. I did a lot of courses the past year but this one is totally different. Key is satisfying your customer by giving them strong insights. I really enjoyed the course and put it on pause many times to check or use it directly in my own ongoing project. I can recommend this course to anybody working as a consultant in the data area.
Marjolein Opsteegh
Marjolein Opsteegh
Maven's Pivot Table & Charts class was a great intro to dashboard design but Advanced Excel Dashboard Design will take your approach to a whole new level. You'll learn the importance of formula-based dashboard design and how to manipulate colors, charts, and KPI metric cards to tell your story. By far one of my favorite Maven classes!
Nate Dunn
Nate Dunn
Thinking like an Analyst course has helped me to clearly understand what it takes to have a successful career in data analytics. I have learnt that my focus should be on the skills I acquire while learning and not the tools. I have also learnt a data analysis workflow for high quality analysis that drives actionable outcomes. I had fun while learning during this course. It is self pacing and elaborate.
Eniola Dada
Eniola Dada
For all aspiring or converted analyst out there, stop looking around, this is the way to get the role you are looking for. I am truly impressed with the quality of the information and the completeness of the package Maven Analytics put together. In this well rounded package you have everything you need, from finding your own path, writing or re-writing your resume, marketing on LinkedIn, to building the so needed project portfolio, and even interview skills and approaches.
Radu Tecuceanu
Radu Tecuceanu
Love the Maven courses! The instructors always have great slide content to help solidify the concepts and drive home the key aspects. The examples and very relatable making it so much easier to understand how to apply my own projects.
Joseph Collins
Joseph Collins
Maven Analytics changed my life, I found a better job position taking the Excel and Power BI paths, nowadays I can apply my skills in my company innovating everyday. Thankful forever.
Rodrigo Chavez
Rodrigo Chavez
An excellent course with top-notch data sets to work around with. As usual, Chris Dutton did a fabulous job of covering each element with a simplistic but analytical approach. Although I've been using pivot tables for 5+ years, the new learnings will open a whole array of opportunities for extracting actionable insights. Thank you!
Faizan Qadri
Faizan Qadri
Before deciding to join this learning platform, I struggled to understand and figure out what direction I needed to take for my skill development to be a Data Analyst. This first course helped ease some of my fears and confusion. I am more passionate about my decision to become a data analyst. THANK YOU Chris, John, Aaron, and Enrique , and I look forward to learning more through Maven.
Angie
Angie
The Maven Analytics Courses are packed full of practical lessons and useful pro tips that can be immediately applied to data in the workplace. One of the best trainings I've ever taken!
Randy McCauley
Randy McCauley
Once again Maven blows it out of the water. In this fantastic, well structures course about the way to "Think Like an Analyst". It has so many good points and actions to take when putting together a project. I found it very useful and was able to put it into practice at work straight away. Thank Guys!
Catherine Taylor
Catherine Taylor
Maven really makes it possible to get into data analytics without taking (and paying for) a traditional education program. The courses I took left me with a better understanding and deeper knowledge of what I like most: analyzing data.
Erik van’t Ende
Erik van’t Ende
The course is fantastic and highly recommended. It gave me the confidence to perform the logical analysis in any given data source and of course build kickass visuals business dashboards for my clients :). Loved the course from the first second to the last.
Tonmoy Hashmi
Tonmoy Hashmi
Trusted by top companies to upskill their teams
For IndividualsLaunch Your Data CareerStart learning for free, no credit card required
For TeamsRequest A Free DemoRequest a demo and access a free trial for your team