• Length:
    6 Weeks
  • Effort:
    2–4 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $149 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English
  • Course Type:
    Self-paced on your time

Associated Programs:

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.

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.

Meet your instructors

Ricardo R. Trujeque
Instructor
University of British Columbia

Pursue a Verified Certificate to highlight the knowledge and skills you gain
$149 USD

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    edX, a non-profit, relies on verified certificates to help fund free education for everyone globally