Learning Excel through Football

December 22, 2017
Procurement, FOOTBALL, LEARNING, MICROSOFT, MODERN DAY
Blogs

Market Dojo have put together a learning spreadsheet to help procurement professionals gain a better understanding of excel. This spreadsheet uses premier league, international and club football data to provide engaging educational statistics.

Included in the spreadsheet is:

  • Basic Excel Formulas – SUM, Average, Min/Max, Count etc
  • Intermediate Excel Formulas – IF & IF(AND)
  • Text Excel Formulas – TRIM, Concatenate etc
  • Excel Lookups – Standard Lookups & VLookups
  • Conditional Formatting Rules
  • Pivot Tables – Layouts, filters etc
  • Graphs – Editing graphs, Trendlines, Combo Graphs etc
  • Macros – Turning on macros and creating macros

You can download the spreadsheet here on our resources page under miscellaneous.

In the modern age of data, being able to decipher large amounts of data can be invaluable in both saving you time and analysing data in new ways. Whether you trying to formulate data into an importable file or simply improve your employ-ability.

Image result for premier league

We believe that having a good understanding of Excel is essential for the modern day procurement professional. Without being able to use Vlookups or create conditional formatting rules you would struggle to organise and interpret large volumes of data that is crucial in modern roles.

This spreadsheet isn’t meant to be a thorough understanding of all the different aspects of Excel. However, if you have anything else that you believe should be included just get in contact and we will do our best to include in an amended version.
Market Dojo helps procurement professionals negotiate better with our on-demand eSourcing tools. If you’d like to find out more, get in touch or register for free and play around with our software for yourself!

no comments

  • You really make it appear so easy together with your presentation but I to find this topic to be really one thing that I believe I'd by no means understand. It sort of feels too complex and extremely huge for me. I'm looking ahead in your subsequent put up, I'll try to get the cling of it!

    christa, 14 August, 2018
  • I got this website from my buddy who told me about this web page and at the moment this time I am browsing this website and reading very informative articles or reviews at this place.

    kasper, 8 August, 2018

Leave a Reply

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

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Test