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

  • A Certificate will be provided upon course completion

  • 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

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 - Advanced Computation Skills

    3. 1c - SUMPRODUCT

    4. 1d - Database Functions

    5. 1e - Index Functions

    6. Part 1 - Questions

    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

    1. 2a - Naming

    2. 2b - Dynamic Naming

    3. 2c - Table Tool

    4. Part 2 - Questions

    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

About this course

  • $95.00
  • 58 lessons
  • 6.5 hours of video content

Also Available

In-Person and Webinar-Based Marquee Courses

Explore