Become an Excel Power User

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

Our Excel courses are focused on data analysis. During this course, we cover the most critical Excel skills that business professionals require 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

  • Data Analysis

    Use numerous built-in Excel functions to interpret and manipulate data

    Use Excel’s filters in conjunction with specific arithmetic functions to summarize large volumes of data

    Learn to use many features of the Advanced Filter, one of the most helpful and least utilized tools in Excel

    Incorporate widely used financial and arithmetic functions

  • Lookup Functions

    Use a variety of intermediate and advanced Lookup functions to efficiently extract specific information

    Learn multiple uses of the Vlookup and Offset functions, including ways to automate these functions

    Create nested formulas to expand the flexibility of various functions

  • Managing Text and Pivot Tables

    Use powerful Text functions to manipulate non-numeric variables

    Convert non-recognizable values into useable numbers with the use of Text functions

    Become proficient with Pivot Tables, one of the most powerful tools in Excel, to quickly analyze large quantities of data

    Learn to use the most effective and lesser known Pivot Table features

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

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

  • 9+ Hours of Interactive Content

  • Practice questions with solution videos and a full answer key

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

  • Dedicated course support

Access Excel 1: Core 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

    • 1a - Introduction

      FREE PREVIEW
    • 1b - Navigation

    • 1c - Filter (formerly the Auto Filter)

    • 1d - Advanced Filter

    • 1e - VLOOKUP

    • 1f - Absolute vs Relative Referencing

    • 1g - Dates in Excel

    • Part 1 - Intermediate Questions (1 to 14)

    • Part 1 - Advanced Questions (15 to 25)

  • 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

    • Part 1 - Solution to Question 24

    • Part 1 - Solution to Question 25

  • 4

    Part 2 - Lessons

    • 2a - Text Functions

    • 2b - Subtotal Tool

    • 2c - Offset and Match

    • Part 2 - Intermediate Questions (1 to 10)

    • Part 2 - Advanced Questions (11 to 22)

  • 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

    • Part 2 - Solution to Question 22

  • 6

    Part 3 - Lessons

    • 3a - Pivot Tables Introduction

    • 3b - Pivot Tables Features

    • 3c - Pivot Table Grouping Example

    • 3d - Pivot Table Slicer

    • Part 3 - Intermediate Questions (1 to 13)

    • Part 3 - Advanced Questions (14 to 19)

  • 7

    Part 3 - Solutions

    • Part 3 - Solution to Question 1

    • Part 3 - Solution to Question 2

    • Part 3 - Solution to Question 3

    • Part 3 - Solution to Question 4

    • Part 3 - Solution to Question 5

    • Part 3 - Solution to Question 6

    • Part 3 - Solution to Question 7

    • Part 3 - Solution to Question 8

    • Part 3 - Solution to Question 9

    • Part 3 - Solution to Question 10

    • Part 3 - Solution to Question 11

    • Part 3 - Solution to Question 12

    • Part 3 - Solution to Question 13

    • Part 3 - Solution to Question 14

    • Part 3 - Solution to Question 15

    • Part 3 - Solution to Question 16

    • Part 3 - Solution to Question 17

    • Part 3 - Solution to Question 18

    • Part 3 - Solution to Question 19

Also Available

In-Person and Webinar-Based Marquee Courses