Excel Genius

Ready to gain a deeper understanding of the world’s most popular spreadsheet application?

Find a Class

Description

Excel Genius is a set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application. Each class will cover a topic in depth and then give students exercises that apply that knowledge to real world situations.

Video Tutorials

Want to start learning Excel now? Check out our tutorial videos, available on our YouTube page!

Curriculum

Class 1:
Logic Functions

This class covers how to use conditional logic in formulas and functions, allowing you to create formulas that act differently in different circumstances. Topics covered include: IF statements, nested IF statements, AND & OR logic functions.

Skills Required:

Be able to write a basic formula and function
Be able to write Relative and Absolute cell references

Class 2:
Conditional Stat Functions

This class covers how to take the basic logic from Class 1 and use it to create functions that process data based on conditions. Topics include SUMIF/AVERAGEIF/COUNTIF and SUMIFS/AVERAGEIFS/
COUNTIFS.

Skills Required:

Be able to write a basic formula and function
Be able to write Relative and Absolute cell references
Have taken Class 1 or understand the material covered in it

Class 3:
Charts and Sparklines

This class will cover how to customize charts to better visualize information, as well as the pros and cons of various chart types. Topics include: Formatting charts, adding and customizing chart elements, creating mixed charts, chart analysis tools, and sparklines.

Skills Required:

How to insert a chart
How to navigate menu options in Excel

Class 4:
Array Formulas, Tables, and Data Validation

This class will cover how to create Array Formulas, how to build and edit Tables, and how to write Structured References that make function writing easier and more flexible. We will also cover Data Validation and build drop-down lists in your spreadsheets.

Skills Required:

Be able to Write functions
Understand Absolute vs Relative Cell References
Know how to navigate menu options in Excel

Class 5:
Pivot Tables

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data. We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements.

Skills Required:

Know how to navigate menu options in Excel
Understand formatting and conditional formatting

Class 6:
Creating a Dashboard

This class will cover creating multiple Pivot Tables, Pivot Charts, and Slicers, and combining them into one interactive worksheet that we call a Dashboard.

Skills Required:

Know how to navigate menu options in Excel
Understand Pivot Tables and Pivot Charts
Know how to customize charts

Class 7:
VLOOKUP

This class will cover the most popular lookup method in Excel, VLOOKUP, which used to search for and retrieve information in datasets and work with the results.

Skills Required:

Be able to write functions
Understand Absolute vs Relative Cell References
Know how to write structured references a plus

Class 8:
LOOKUP and INDEX MATCH

This class will cover alternative lookup methods in Excel - LOOKUP and INDEX MATCH - and discuss the pros and cons of each.

Skills Required:

Be able to write functions
Understand Absolute vs Relative Cell References
Understand nesting functions

Class 9:
String Functions and Goal Seek

This class will cover how to use functions to modify strings, a useful tool when scrubbing data, and how to use goal seek to solve common problems.

Skills Required:

Be able to write functions
Understand nesting functions

Page updated

Report abuse