Thank You - you’re now enrolled in our free VLOOKUP mini-course
Are you looking to improve your knowledge of Excel functions this year?
If so, we have a one-time offer on our Your Excel Functions Toolkit course, which covers the 50 most useful functions in Excel
Introducing: Your Excel Functions Toolkit
1 hour on-demand video | 10 articles | 20 downloadable resources | Full lifetime access | Certificate of Completion
$27 SAVE $30 (was $57)
Learn to use Formulas, Functions and More for Excel 2010, Excel 2013, Excel 2016
Welcome to Your Excel Functions Toolkit, a powerful mini course to fast track your knowledge of Excel functions.
I'm guessing you're perhaps a beginner or intermediate Excel user, looking to improve your Excel skills, to further your career, to become better & faster at Excel, or to impress your boss.
Excel functions can seem intimidating and technical, and there's so many of them - over 400 at the last count! The good news is, you don't need to know them all to become great at Excel. I've been consulting & teaching data analytics in the UK financial services industry for over 15 years, and have curated a list of just 40 functions that will enable you to answer 99% of any data problem that you're ever likely to come across in your career.
At the end of this course, you'll be confident and proficient about solving business problems in Excel using functions.
This course works through that list of functions, one by one. Each lesson has a practical, real life examplethat we work through, and that you can download afterwards.
There are downloadable challenges that you can work through in your own time, and there's a quiz at the end of the course to test your knowledge.
The course comes with a downloadable cheat sheet, containing all the key Excel functions, which you can print and have by your desk for reference.
You also get access to my private facebook community, where you can ask me any Excel question and get a personal answer (worth far in excess of the price of this course!)
There's several free preview lessons below, so that you can get started, and I look forward to seeing you on the course!
TRY YOUR FUNCTIONS TOOLKIT FOR A FULL 30-DAYS, 100% RISK-FREE
We've packed a lot into this course, and I want to make sure that you not only get all that content before you fully commit to this — I want to give you 30 days to let it digest, use the skills at work, and make sure this is really working for you.
Try the entire course. 30 days is enough time to take the course twice and then decide. If you don't LOVE it, I insist that you get 100% of your money back.
It's simple: Join the course and try it for yourself. If the lessons and resources help improve your Excel skills in 30 days, I want you to email me. Show me you did the exercises, and I'll give you all your money back.
About Your Instructor
Hi, I'm Martyn. I created my courses to help you to get better at Excel and to get your next promotion, job or raise. My courses are a little different to most - you'll learn the most powerful functionality in Excel through in depth online courses, ongoing learning through case studies and exercises, as well as a fantastic online student community to share your experiences of breaking through the career ladder with better skills..
If you want to stop drifting and start learning Excel, you are in the right place. Welcome!
SUM, AVERAGE, MAX, MIN
SUM, AVERAGE, MAX, MIN (2:36)
Challenge: Find COUNT, SUM and AVERAGE Sales Value
Absolute vs Relative cell references (5:21)
SUMIF, COUNTIF, AVERAGEIF (7:17)
Challenge: Finding duplicate rows using COUNTIF
Referencing Tables & Named Ranges Correctly (3:35)
Nesting Functions (3:11)
Basics of VLOOKUP & HLOOKUP
VLOOKUP & HLOOKUP (7:48)
Challenge: Add data from another table using VLOOKUP
INDEX & MATCH (4:43)
Challenge: Perform a lookup using INDEX & MATCH
Create Conditional Formulas with IF (4:16)
IFERROR & ISERROR (6:50)
Challenge: Create a VLOOKUP with a custom error message
LEFT, RIGHT, MID & LEN (6:17)
FIND, SEARCH & SUBSTITUTE (5:23)
Text and date functions
TODAY & NOW (2:27)
Challenge: Turn a text date into an Excel date
Quiz: Can you use functions in Excel?
Functions Cheat Sheet
Frequently Asked Questions
What is DataMinded?
DataMinded is an online Excel training provider for individuals and businesses that helps students become expert Excel users as quickly as possible. We are based in Edinburgh but you can take a course from the comfort of your home or office.
What versions of Excel can I use on this DataMinded course?
The course is recorded in Excel 2016 for Windows, also known as Excel 365. Any Windows version of Excel from 2007 onwards is suitable for the course, although buttons and menus may look slightly different. Excel for Mac 2013 onwards is suitable for the course, although the interface does look different, we note where specific functionality is not available. The course is not suitable for Excel for Mac 2011 or Excel for iOS, due to its limited functionality. The course does not cover other spreadsheet packages such as OpenOffice, or Numbers for Mac.
What difficulty level is this course?
This is a beginner to intermediate Excel course. You should have a good working knowledge of the basics of Excel before you get started.
How long is the course?
The course contains an hour of HD video, downloadable Excel fact sheets, online quizzes, and practice exercises. You can also download the examples used in each lesson to try it out for yourself.
When does the Excel course start?
Thisis a self paced learning course. Start whenever you are ready, you'll never lose access to the content.
Is the Excel training course mobile friendly?
Yes, you can take any of the lessons on a smartphone, although to do the challenges, you'll want to be on a laptop or desktop.
What if Microsoft bring out a new version of Excel?
As Excel geeks ourselves, we're always on the lookout for new Excel functionality. When Microsoft release a new version we will update the course with any relevant new material.
Can I expense this course, or have my employer pay for it?
Yes, most of our students have their course paid for by their employer, and there are significant discounts available for purchasing courses for a team.
What if I don't like the content?
We're confident you'll see a massive improvement in your Excel skills by taking the course, but if you're not happy you can get a full refund within 30 days of purchase. Just get in touch if you're experiencing any problems with the content.
How long will I have access to content?
The course includes unlimited access, and free updates.
Is this the best way to learn Excel?
Excel is one of the widest taught topics online - so we know there are countless other places you could go to study. Learning for free using tutorial websites, reading books or YouTube is fine, but it requires patience to learn by trial and error. We also know scores of colleagues and friends who have taken classroom based one day courses, and come away with a nice booklet, but no lasting ability to use Excel.
Email us at firstname.lastname@example.org