skip to Main Content

Excel Formulas Training Kit – Full Package

4.68 (22 reviews)

Excel Test worksheet for training Excel skills. Stop watching videos. Learn VLOOKUP, IF and many more excel formulas by doing.


(One-time Payment | Instant Download)

Learn more about License Types


Payments are processed by our partner company
You will receive a download link immediately after purchase.


You should be using Excel for business and personal purposes, aren’t you? Actually, the question should be “Do you benefit from all Excel features?”

The major feature that Excel provides us is Excel Formulas & Functions. Do not ever forget that if you start repeating the same action in Excel, there should be an Excel formula designed to solve your specific issue.

Say goodbye to all the tedious and countless hours spent watching online Excel Courses. You can still feel uncomfortable when you use Excel on projects, reports etc. This is because Excel requires highly hands-on experience to master on it. Our training kit will provide you with this hands-on experience with real-world examples. You can both learn and practice most used Excel Formulas in Excel!

We’ve prepared Excel Formulas Full Training Kit for the ones who want to practice Excel test equip themselves fully with Excel Formulas and Functions.

Full training kit consists of both Beginner Level, Medium Level and Advanced Level Kits. 30 sections and around 100 questions involved within the kit:

Full Module – Covered Excel Functions

1. Basic Math Operators 11. VLOOKUP Function 21. Advanced VLOOKUP Function
2. SUM Function 12. IF Function 22. IF – AND Combinations
3. COUNT Function 13. COUNTIF Function 23. IF – OR Combinations
4. AVERAGE Function 14. SUMIF Function 24. Nested IFs
5. MAX and MIN Functions 15. IS Functions 25. MATCH Function
6. Date Functions 16. CONCATENATE Function 26. INDEX Function
7. LEN Function 17. HLOOKUP Function 27. MID and SEARCH Function
8. COUNTA Function 18. RIGHT and LEFT Functions 28. OFFSET Function
9 ROUND Function 19. RAND Function 29. INDIRECT Function
10. SUMPRODUCT Function 20. IFERROR Function 30. ARRAY Formulas

Get the training kit that makes you master all of these functions with real-life examples. It is a unique workbook that contains Excel formulas problems which is design to teach you the most common actions of Excel.


When you working on these functions, sometimes you need help. We also provide you help to understand concept of formula and best-practices to use it. The video is prepared by country winner of the Microsoft Excel Championship!


  1. Clear instructions and web links are included so that the user is able to learn the functions by himself/herself which he/she doesn’t know already.
  1. Questions are to the point and quite well prepared in terms of functionality. Tested so many times with professional users.
  1. Multi-language formulas supported.

Excel Formulas Training Template Features:

  • Unique product for training purposes 30 sections with 100 questions
  • Practice Excel Test Modules
  • Nice design and easy to use navigation
  • Nice dashboard with progress meters
  • Multi-language formulas supported
  • Clear on sheet instructions (with turn on/off function)
  • Full Print Ready
  • Includes web links for detailed explanation for all functions
  • Works on both Windows and Mac
  • Compatible with Excel 2010 and later
  • No installation needed. Ready to use.

This Excel Formulas Training Template is prepared with VBA macros. Don’t forget to enable macros after you get it. If you need customization on your charts or in need of more complex schemes, just contact us via [email protected]

For individual packages, check:

Beginner Level Module – Excel Formulas Trainer

Medium Level Module – Excel Formulas Trainer

Advanced Level Module – Excel Formulas Trainer


22 reviews for Excel Formulas Training Kit – Full Package

  1. Victoria

    As a clerk I always build up the databases of the clients and I should rapidly deliver graphs and rotate tables to help the composed reports. Using this training spreadsheet it will be simpler to learn the functions in a more sophisticated way. Keep up the great job guys!

  2. jakelee

    as a teacher it allows me to learn functions. thx for taking the time to put together an amazing set. Is there any package you offer for all of my students? I just want them to get it too.

    • Someka

      Hi Jakelee,
      Thanks for your feedback! If you want to get this template for your students please get in contact with us via [email protected] so we can talk about the multiple purchasing options and possible discount opportunities.

  3. lucrecia

    Very practical tool.

  4. Peter J

    This is better than an online course. I’ve taken many online courses and practicing is better. You can practice right away and go back to spreadsheet. Noticed that I was really using the formulas blindly! You’ll learn how to use formulas in a more complex and efficient way.

    • Someka

      Hi Peter, that’s true: there’s definitely more than one way to approach those formulas. Thanks!

  5. S Harris

    What I love most about this spreadsheet is it incredibly encourages you to do a lot of calculation.

  6. Liammitchell

    It is very clear and understandable. Every step has been constructed in detail.

    • Someka

      Hi Liammitchell,
      We are glad that you like! Thanks! We also have a playlist with a detailed explanation about this training. You can have a look at from here: Excel Formulas Training Series

  7. LydiaS

    Very good.
    Two suggestions:
    1. The earlier modules is too basic to solve.
    2. An error in my solution would be more specific.

    • Someka

      All ideas are welcomed! Those are great suggestions, Lydia! Thank you!

  8. Stewart W

    The guy on the video shows everything in such a easy way. I’ve checked their website and their founder is a national Excel championship winner! Now that explains why I really liked it.

  9. Donna Graham

    For me, the basic part of the sheet was too basic and at the same time there were some fine tips to lear. then it focused on important functions

  10. Fiona

    A very long steps

  11. madeleine

    I had no idea all that Excel could do. All functions training was good. I also learned a lot of workarounds in Excel that I didn’t know.

  12. Sebastian

    This is a very well organized detailed course. the guy on the video explains the concepts so well.

    • Someka

      Hi Sebastian,
      Thank you for your feedback! Appreciated! If you have any questions you can get contact with us via customer chat or from [email protected].

  13. justin kimland

    I am learning more than I ever knew about Excel. In advanced sections you need a bit out of box thinking guys

  14. Lucy-smith

    I have found this very first class. Also their support team has very generous to response my with work related spreadsheet issues I have had. I would recommend to anyone looking to upgrade their spreadsheet skills

    • Someka

      Thank you so much Lucy, we’re happy to hear about your experience 🙂 Keep it up!

  15. 1kevin

    Really nice tool which covers almost all important functions in Excel

  16. D_Davies

    I must work with Excel to generate the calculation sheets with the full staff that will attend each day, plus the notes when they are evaluated are downloaded in excel sheet

  17. Stanlevines2

    Just finished second level and It was great! Very practical which enables quick learning.

  18. Kate

    I cannot give less than 5 stars. The sections are smartly designed and gives very useful problems that will improve your thinking. You can put into practice what you’ve learned about Excel.

    • Someka

      Hi Kate, happy to help. And best of luck with your learning journey!

  19. Brandon

    Too basic

  20. david bastow

    This excel traing is a useful recruitment assesment tool for us. It provide great challenges for candidates but also give opportunity us to test them on process.

  21. Vicki

    Great training program that is user-friendly and easy to follow. Learn in your own time. Thanks Someka!

  22. Bhaarath

    Its a great learning experience. I first started with the basics and medium and with a little help from the tutorial, I was able to successfully complete the advanced level also. Since successful completion is immediately seen, it is also very motivating. The tutorial is also very user friendly. I would definitely recommend it strongly to any person who wants to improve his or her Excel skills. Its really great. Trust me!

    • Someka

      Thanks a lot for nice review and I am really glad it was useful to train your skills. And congrats on completing it 100% 😉

Leave a customer review

Your email address will not be published. Required fields are marked *