Become the Excel Master of Your Office
Total Lesson Progress
0%
SUM Functions
SUM Function, SUMIF Function, SUMIFS Function
0
Lessons Completed
COUNT Functions
COUNT Function, COUNTIF Function, COUNTIFS Function
0
Lessons Completed
Logical Functions
True and False, And/Or Functions, IF Function
0
Lessons Completed
Lookup Functions
VLOOKUP Function, HLOOKUP Function, XLOOKUP Function
0
Lessons Completed
Text Search Functions
LEN, LEFT, RIGHT, MID Functions, FIND Function
0
Lessons Completed
Intro to Shortcuts
Intro Shortcuts, Text Formatting Shortcuts, Data Shortcuts
0
Lessons Completed
Cell Selection Shortcuts
Cell Selection, Larger Selections, Rows and Columns
0
Lessons Completed
Text Manipulation Functions
CONCAT Function, TEXTJOIN Function, UPPER, LOWER, PROPER Functions, SUBSTITUTE Function
0
Lessons Completed
Date Functions
DATE Function, TODAY Function, DATEDIF Function
0
Lessons Completed
Index Match Lookup
INDEX Function, MATCH Function, INDEX/MATCH
0
Lessons Completed
Statistical Functions
AVERAGE Function, MIN, MAX, LARGE, SMALL Functions, FLOOR & CEILING Functions
0
Lessons Completed
Tables
Filters, Pivot Tables 1, Pivot Tables 2
0
Lessons Completed
Other Excel Skills
Conditional Formatting, Worksheet Tabs
0
Lessons Completed
Project 1: Wine Dashboard
Create a dashboard from data with graphs and drop-down menus. Utilize CONCAT, VLOOKUP, Absolute References, and more!
Project 2: UFO Dashboard
Create a dashboard from data with graphs and drop-down menus. Utilize COUNTIFS, IF, Absolute References, and more!
Today's High Scores
| My Points Today: | 0 |