Become an Excel Power User

Master the key skills that will save you hours when analyzing data in Excel

More than ever, people are overwhelmed and inundated with the amount of data available. Our Excel courses are focused on data analysis. During this course, we cover advanced Excel skills that business professionals should know in order to analyze, manage and automate their data.

There are hundreds of Excel videos on the internet, but it’s hard to learn from watching.  In this course, the learning happens from doing. We have included dozens of real-world problems to help you master the concepts.

 

Learning Topics Include

  • Computational Skills

    Use numerous functions to compute complex calculations

    Use Excel’s Database functions so that Excel can be used instead of Microsoft Access

    Learn common uses for the Database functions, some of the most underutilized tools in Excel

    Learn Excel’s dreaded SUMPRODUCT function and how to use it to perform complex calculations

  • Lookup Functions
    &
    Conditional Formating

    Use some of Excel’s more advanced Lookup functions, including the INDEX function, and learn helpful applications for their use

    Review some little-known advanced features of the INDEX function

    Use advanced conditional formatting tools to enhance the caliber of analytical output

  • Static and Dynamic Naming
    &
    Table Tool

    Discuss the rationale for using Static Names when building formulas

    Learn to create Dynamic Named Ranges, one of the most powerful concepts in Excel which allows users to automatically update graphs, Lookup functions and Pivot Tables

    Learn to create a Table to manage and analyze data

    Use Structured Reference functions to perform powerful calculations on a datasetfeatures

The Gold Standard of Excel Training

Includes all content from our live sessions and incorporates Marquee’s teaching approach honed by 20 years in the classroom

  • 52 expert videos. Pause, fast forward, and rewind to suit your individual pace

  • 6+ Hours of Interactive Content

  • Practice questions with solution videos and a full answer key

  • Presentation book of key concepts (60 pages of tips and resources)

  • Dedicated course support

Access Excel 2: Advanced Data Analysis

Get Started Today

Are you a current, full-time student?

Follow these steps to claim your 40% off code:

Email a photo of your student ID to marqueepedia@marqueegroup.ca and include the course(s)* you want to enroll in. *Excludes Python Fundamentals, Applied Machine Learning, and the Python Bundle

Course curriculum

  • 2

    Part 1 - Lessons

  • 3

    Part 1 - Solutions

    • Part 1 - Solution to Question 1

    • Part 1 - Solution to Question 2

    • Part 1 - Solution to Question 3

    • Part 1 - Solution to Question 4

    • Part 1 - Solution to Question 5

    • Part 1 - Solution to Question 6

    • Part 1 - Solution to Question 7

    • Part 1 - Solution to Question 8

    • Part 1 - Solution to Question 9

    • Part 1 - Solution to Question 10

    • Part 1 - Solution to Question 11

    • Part 1 - Solution to Question 12

    • Part 1 - Solution to Question 13

    • Part 1 - Solution to Question 14

    • Part 1 - Solution to Question 15

    • Part 1 - Solution to Question 16

    • Part 1 - Solution to Question 17

    • Part 1 - Solution to Question 18

    • Part 1 - Solution to Question 19

    • Part 1 - Solution to Question 20

    • Part 1 - Solution to Question 21

    • Part 1 - Solution to Question 22

    • Part 1 - Solution to Question 23

  • 4

    Part 2 - Lessons

    • 2a - Naming

    • 2b - Dynamic Naming

    • 2c - Table Tool

    • Part 2 - Questions

  • 5

    Part 2 - Solutions

    • Part 2 - Solution to Question 1

    • Part 2 - Solution to Question 2

    • Part 2 - Solution to Question 3

    • Part 2 - Solution to Question 4

    • Part 2 - Solution to Question 5

    • Part 2 - Solution to Question 6

    • Part 2 - Solution to Question 7

    • Part 2 - Solution to Question 8

    • Part 2 - Solution to Question 9

    • Part 2 - Solution to Question 10

    • Part 2 - Solution to Question 11

    • Part 2 - Solution to Question 12

    • Part 2 - Solution to Question 13

    • Part 2 - Solution to Question 14

    • Part 2 - Solution to Question 15

    • Part 2 - Solution to Question 16

    • Part 2 - Solution to Question 17

    • Part 2 - Solution to Question 18

    • Part 2 - Solution to Question 19

    • Part 2 - Solution to Question 20

    • Part 2 - Solution to Question 21

Also Available

In-Person and Webinar-Based Marquee Courses