Skip to main contentSkip to Xpert Chatbot

UBCx: Excel for Everyone: Data Analysis Fundamentals

4.6 stars
22 ratings

Perform advanced data wrangling, analysis and dashboard visualization to help drive strategic decision-making.

Excel for Everyone: Data Analysis Fundamentals
6 weeks
2–4 hours per week
Self-paced
Progress at your own speed
Free
Optional upgrade available

There is one session available:

40,705 already enrolled! After a course session ends, it will be archivedOpens in a new tab.
Starts Dec 3
Ends Dec 31

About this course

Skip About this course

This advanced Excel course builds on the teachings of Course 1: Core Foundations and Course 2: Data Management. Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data.

Whether you need to process numbers for personal projects or for organizational purposes like sales, inventory, human resources, or IT, knowing how to make sense of data is critical. You will develop in-demand skills to gain a competitive edge and value to your organization, including how to extract actionable organizational intelligence from raw data, and present it in a visual format to help drive organizational decision-making Learn how to get Excel to do the hard work for you with sophisticated automation, spreadsheet design and powerful dashboards.

At a glance

  • Language: English
  • Video Transcript: English
  • Associated programs:
  • Associated skills:Data Analysis, Sales, Data Management, Automation, Organizational Intelligence, Decision Making, Data Wrangling

What you'll learn

Skip What you'll learn
  • How to apply advanced formulas and conditional logic.
  • How to analyze and report on data frequently.
  • Automating complex or repetitive tasks.
  • How to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
  • Protecting your workbooks.
  • Performing Formula Audits and Data Validation.
  • Creating Macros and usingVisual Basic.
  • How to use Advanced Charting Techniques to build professional dashboards.

This course is part of Excel for Everyone Professional Certificate Program

Learn more 
Expert instruction
3 skill-building courses
Self-paced
Progress at your own speed
5 months
3 - 5 hours per week

Interested in this course for your business or team?

Train your employees in the most in-demand topics, with edX For Business.