Save for later

Excel for Everyone

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

  • 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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of edX and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating Not enough ratings
Length 6 weeks
Effort 2 - 4 hours per week
Starts On Demand (Start anytime)
Cost $149
From University of British Columbia via edX
Instructor Ricardo R. Trujeque
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science
Tags Data Analysis & Statistics

Get a Reminder

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Advanced Facilitator $45k

Accountant Advanced $57k

Advanced operator $66k

Excel Reporting Developer $68k

Advanced Academics $71k

Biologist-Advanced $77k

Excel/Access DTS Developers $78k

Advanced Planner - Advanced Operations $79k

Excel VBA Developer $82k

Excel/Access DTS Developer $83k

Tutor - Accounting/ Excel /ESL $87k

Advanced Scientist $118k

Write a review

Your opinion matters. Tell us what you think.

Rating Not enough ratings
Length 6 weeks
Effort 2 - 4 hours per week
Starts On Demand (Start anytime)
Cost $149
From University of British Columbia via edX
Instructor Ricardo R. Trujeque
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science
Tags Data Analysis & Statistics

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now