Excel Genius
Ready to gain a deeper understanding of the world’s most popular spreadsheet application?
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