Upgrade to Continue Learning

Access all 60+ Lessons! Learn VLOOKUP, Pivot Tables, XLOOKUP, IF, SUMIF, INDEX MATCH, and more!
Number Formatting ShortcutsCell Selection ShortcutsCOUNT FunctionTrue & FalseIF FunctionSUM FunctionArrow KeysWildcard CharactersSUMIF FunctionSUMIFS FunctionSUM Functions Skill SummarySUMIF PracticeSUMIFS PracticeCOUNTIF FunctionCOUNTIFS FunctionCOUNT PracticeCOUNT Skill SummaryAND, OR, XOR FunctionsIS FunctionsIFS FunctionSWITCH FunctionLarger Cell SelectionsRow and Column Selections Number Formatting ShortcutsCell Selection ShortcutsCOUNT FunctionTrue & FalseIF FunctionSUM FunctionArrow KeysWildcard CharactersSUMIF FunctionSUMIFS FunctionSUM Functions Skill SummarySUMIF PracticeSUMIFS PracticeCOUNTIF FunctionCOUNTIFS FunctionCOUNT PracticeCOUNT Skill SummaryAND, OR, XOR FunctionsIS FunctionsIFS FunctionSWITCH FunctionLarger Cell SelectionsRow and Column Selections
Cell Selection Shortcuts 2Larger Cell Selections 2Cell Selection Skill SummaryVLOOKUP FunctionVLOOKUP Function 2VLOOKUP PracticeHLOOKUP FunctionHLOOKUP Function 2XLOOKUP FunctionXLOOKUP Function 2MATCH FunctionINDEX FunctionINDEX MATCH LookupINDEX MATCH PracticeIndex Match Skill SummaryLEN, LEFT, and RIGHT FunctionsMID FunctionLEN, LEFT, RIGHT, MID PracticeFIND FunctionSEARCH FunctionIntro to ShortcutsText Formatting ShortcutsCut, Copy, Paste Cell Selection Shortcuts 2Larger Cell Selections 2Cell Selection Skill SummaryVLOOKUP FunctionVLOOKUP Function 2VLOOKUP PracticeHLOOKUP FunctionHLOOKUP Function 2XLOOKUP FunctionXLOOKUP Function 2MATCH FunctionINDEX FunctionINDEX MATCH LookupINDEX MATCH PracticeIndex Match Skill SummaryLEN, LEFT, and RIGHT FunctionsMID FunctionLEN, LEFT, RIGHT, MID PracticeFIND FunctionSEARCH FunctionIntro to ShortcutsText Formatting ShortcutsCut, Copy, Paste
Data ShortcutsAVERAGE FunctionMIN, MAX, LARGE, SMALL FunctionsMIN, MAX, LARGE, SMALL PracticeFLOOR & CEILING FunctionsDATE FunctionTODAY FunctionDATEDIF FunctionDAYS FunctionDATE Functions Skill SummaryCONCAT FunctionTEXTJOIN FunctionUPPER, LOWER, and PROPER FunctionsSUBSTITUTE FunctionPivot Tables 1Pivot Tables 2Table FiltersTables Skill SummaryODD and EVEN FunctionsWorksheetsConditional FormattingMEDIAN FunctionMODE Function Data ShortcutsAVERAGE FunctionMIN, MAX, LARGE, SMALL FunctionsMIN, MAX, LARGE, SMALL PracticeFLOOR & CEILING FunctionsDATE FunctionTODAY FunctionDATEDIF FunctionDAYS FunctionDATE Functions Skill SummaryCONCAT FunctionTEXTJOIN FunctionUPPER, LOWER, and PROPER FunctionsSUBSTITUTE FunctionPivot Tables 1Pivot Tables 2Table FiltersTables Skill SummaryODD and EVEN FunctionsWorksheetsConditional FormattingMEDIAN FunctionMODE Function

Access all downloadable Excel project files with step-by-step instructions to build dashboards and practice job interview assessments.
Trout Dashboard
UFO Dashboard
Wine Dashboard
Earn a certificate of completion to add to your LinkedIn profile.
UFO Dashboard
Trout Dashboard

We have over 5,000 happy customers. Here's what they say:
"I just want to thank you for your website. I hated using excel and was preparing for an excel exam that I was sure I would fail. But because of your website I have gained more confidence in excel and enjoy using it now. Today I also passed my excel exam with flying colours!"
Deb R.
"The program is really great, it helped me crack an interview and land amazing job."
Parth S.
"Hey Jake love the website! It's super fun, easy to use and great explanations without giving away too much of the answer."
Zac S.
"I love it! Never been a computer person and found I could use these tips for excel and you have the best hands on program I have found. Thank you again!"
Holly M.
"Thank you, Jake! It's fun so far and I'm surprised at the simple shortcuts I don't already know."
Theresa P.
"After doing a couple of the exercises, I quickly learned some new things about Excel. The website is super easy to use and the exercises are straight to the point. Keep up the good work!"
Trevor T.
"I Love your website!! You helped me get my dream job working in commercial real estate, your the GOAT!"
Cam O.
"Love your website! It is interactive and very helpful, exactly what I've been looking for. I was getting confused at first with all the youtube tutorials and various resources out there, I didn't know where to start. Then I found ExcelExercises.com. I tried it out and loved it! I'm currently pursuing a career in business analytics and AI strategy. Your website is a great place to get me to my goal and it's exactly what I needed. I wish I had discovered it sooner! Thank you so much for reaching out. I will continue to use your website and enhance my excel skills for the future."
Aqsa M.

You can cancel any time you'd like. You can do this by viewing your profile and clicking the "Manage Subscription" button. You can set your subscription to expire at the end of the paid period so that it will not renew. You can also email jake@excelexercises.com for assistance.

Upgrade to ExcelExercises Premium to access all of our content. Upon completion of all lessons, you earn an ExcelExercises LinkedIn certficiation. You can repeat lessons as many times as you'd like.

Premium includes the following lessons, and we regularly add more:
  1. • Number Formatting Shortcuts
  2. • Cell Selection Shortcuts
  3. • COUNT Function
  4. • True & False
  5. • IF Function
  6. • SUM Function
  7. • Arrow Keys
  8. • Wildcard Characters
  9. • SUMIF Function
  10. • SUMIFS Function
  11. • SUM Functions Skill Summary
  12. • SUMIF Practice
  13. • SUMIFS Practice
  14. • COUNTIF Function
  15. • COUNTIFS Function
  16. • COUNT Practice
  17. • COUNT Skill Summary
  18. • AND, OR, XOR Functions
  19. • IS Functions
  20. • IFS Function
  21. • SWITCH Function
  22. • Larger Cell Selections
  23. • Row and Column Selections
  24. • Cell Selection Shortcuts 2
  25. • Larger Cell Selections 2
  26. • Cell Selection Skill Summary
  27. • VLOOKUP Function
  28. • VLOOKUP Function 2
  29. • VLOOKUP Practice
  30. • HLOOKUP Function
  31. • HLOOKUP Function 2
  32. • XLOOKUP Function
  33. • XLOOKUP Function 2
  34. • MATCH Function
  35. • INDEX Function
  36. • INDEX MATCH Lookup
  37. • INDEX MATCH Practice
  38. • Index Match Skill Summary
  39. • LEN, LEFT, and RIGHT Functions
  40. • MID Function
  41. • LEN, LEFT, RIGHT, MID Practice
  42. • FIND Function
  43. • SEARCH Function
  44. • Intro to Shortcuts
  45. • Text Formatting Shortcuts
  46. • Cut, Copy, Paste
  47. • Data Shortcuts
  48. • AVERAGE Function
  49. • MIN, MAX, LARGE, SMALL Functions
  50. • MIN, MAX, LARGE, SMALL Practice
  51. • FLOOR & CEILING Functions
  52. • DATE Function
  53. • TODAY Function
  54. • DATEDIF Function
  55. • DAYS Function
    56. • DATE Functions Skill Summary
  56. • CONCAT Function
  57. • TEXTJOIN Function
  58. • UPPER, LOWER, and PROPER Functions
  59. • SUBSTITUTE Function
  60. • Pivot Tables 1
  61. • Pivot Tables 2
  62. • Table Filters
  63. • Tables Skill Summary
  64. • ODD and EVEN Functions
  65. • Worksheets
  66. • Conditional Formatting
  67. • MEDIAN Function
  68. • MODE Function

If you are a teacher or educator, you can get free access for your students. Email jake@excelexercises.com for details. Please note we are unable to work with individual students - if you are a student, please ask your teacher to reach out for free access.

We offer a 100% refund if you're not happy for any reason. Email jake@excelexercises.com for details.

If you have a discount code to use, simply press the green "Upgrade" button above, and there will be an option to add a promotion code.
  • $9.99
  • USD/month
Save 50%
  • $59.99
  • USD/year
Cancel any time 100% refund if you're unhappy for any reason