Excel Exercises Practice

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

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
You won't appear on the leaderboard until you log in or create an account



How Do You Like Excel Exercises?

Would you mind giving us some feedback to improve the site?

Give Feedback