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

  • A Certificate will be provided upon course completion

  • 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

Course curriculum

    1. Welcome and Course Objectives

      FREE PREVIEW

    2. PC versus Mac

      FREE PREVIEW

    3. FAQs: Maximizing Your Success in this Course

      FREE PREVIEW

    4. Course Materials and Technology Requirements

    1. 1a - Introduction

      FREE PREVIEW

    2. 1b - Navigation

    3. 1c - Filter (formerly the Auto Filter)

    4. 1d - Advanced Filter

    5. 1e - VLOOKUP

    6. 1f - Absolute vs Relative Referencing

    7. 1g - Dates in Excel

    8. Part 1 - Intermediate Questions (1 to 14)

    9. Part 1 - Advanced Questions (15 to 25)

    1. Part 1 - Solution to Question 1

    2. Part 1 - Solution to Question 2

    3. Part 1 - Solution to Question 3

    4. Part 1 - Solution to Question 4

    5. Part 1 - Solution to Question 5

    6. Part 1 - Solution to Question 6

    7. Part 1 - Solution to Question 7

    8. Part 1 - Solution to Question 8

    9. Part 1 - Solution to Question 9

    10. Part 1 - Solution to Question 10

    11. Part 1 - Solution to Question 11

    12. Part 1 - Solution to Question 12

    13. Part 1 - Solution to Question 13

    14. Part 1 - Solution to Question 14

    15. Part 1 - Solution to Question 15

    16. Part 1 - Solution to Question 16

    17. Part 1 - Solution to Question 17

    18. Part 1 - Solution to Question 18

    19. Part 1 - Solution to Question 19

    20. Part 1 - Solution to Question 20

    21. Part 1 - Solution to Question 21

    22. Part 1 - Solution to Question 22

    23. Part 1 - Solution to Question 23

    24. Part 1 - Solution to Question 24

    25. Part 1 - Solution to Question 25

    1. 2a - Text Functions

    2. 2b - Subtotal Tool

    3. 2c - Offset and Match

    4. Part 2 - Intermediate Questions (1 to 10)

    5. Part 2 - Advanced Questions (11 to 22)

    1. Part 2 - Solution to Question 1

    2. Part 2 - Solution to Question 2

    3. Part 2 - Solution to Question 3

    4. Part 2 - Solution to Question 4

    5. Part 2 - Solution to Question 5

    6. Part 2 - Solution to Question 6

    7. Part 2 - Solution to Question 7

    8. Part 2 - Solution to Question 8

    9. Part 2 - Solution to Question 9

    10. Part 2 - Solution to Question 10

    11. Part 2 - Solution to Question 11

    12. Part 2 - Solution to Question 12

    13. Part 2 - Solution to Question 13

    14. Part 2 - Solution to Question 14

    15. Part 2 - Solution to Question 15

    16. Part 2 - Solution to Question 16

    17. Part 2 - Solution to Question 17

    18. Part 2 - Solution to Question 18

    19. Part 2 - Solution to Question 19

    20. Part 2 - Solution to Question 20

    21. Part 2 - Solution to Question 21

    22. Part 2 - Solution to Question 22

    1. 3a - Pivot Tables Introduction

    2. 3b - Pivot Tables Features

    3. 3c - Pivot Table Grouping Example

    4. 3d - Pivot Table Slicer

    5. Part 3 - Intermediate Questions (1 to 13)

    6. Part 3 - Advanced Questions (14 to 19)

About this course

  • $125.00
  • 90 lessons
  • 8.5 hours of video content

Also Available

In-Person and Webinar-Based Marquee Courses

Explore