Your Excel Functions Toolkit

Your Excel Functions Toolkit, available at $19.99, has an average rating of 4.45, with 23 lectures, 1 quizzes, based on 41 reviews, and has 2891 subscribers.

You will learn about Use the most popular and useful functions in Excel to solve problems effectively Familiarise yourself with how functions work Differences between different functions and when to use them Perform complex analysis and data transformation Prepare & structure your data correctly so that it can be easily enriched & analysed Make your workflow simpler and more efficient with Excel Put your knowledge on test with quiz and challenges This course is ideal for individuals who are Your Excel Functions Toolkit is course for basic to intermediate level Excel users who are familiar with the basics of Excel features. It is particularly useful for Your Excel Functions Toolkit is course for basic to intermediate level Excel users who are familiar with the basics of Excel features.

Enroll now: Your Excel Functions Toolkit

Summary

Title: Your Excel Functions Toolkit

Price: $19.99

Average Rating: 4.45

Number of Lectures: 23

Number of Quizzes: 1

Number of Published Lectures: 23

Number of Published Quizzes: 1

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Use the most popular and useful functions in Excel to solve problems effectively
Familiarise yourself with how functions work
Differences between different functions and when to use them
Perform complex analysis and data transformation
Prepare & structure your data correctly so that it can be easily enriched & analysed
Make your workflow simpler and more efficient with Excel
Put your knowledge on test with quiz and challenges

Who Should Attend

Your Excel Functions Toolkit is course for basic to intermediate level Excel users who are familiar with the basics of Excel features.

Target Audiences

Your Excel Functions Toolkit is course for basic to intermediate level Excel users who are familiar with the basics of Excel features.

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 example that we work through, and that you can download afterwards.

There are downloadable challengesthat you can work through in your own time, and there’s a quizat 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 previewlessons below, so that you can get started, and I look forward to seeing you on the course!

Course Curriculum

Chapter 1: Introduction to Your Excel Functions Toolkit

Lecture 1: Enriching Data with Functions

Chapter 2: SUM, AVERAGE, MAX, MIN

Lecture 1: Functions SUM, AVERAGE, MAX, MIN

Lecture 2: Challenge: Find COUNT, SUM and AVERAGE Sales Value

Lecture 3: Absolute vs Relative cell references

Lecture 4: SUMIF, COUNTIF, AVERAGEIF

Lecture 5: Challenge: Finding duplicate rows using COUNTIF

Lecture 6: Referencing Tables & Named Ranges Correctly

Lecture 7: Nesting Functions

Chapter 3: Basics of VLOOKUP & HLOOKUP

Lecture 1: VLOOKUP & HLOOKUP

Lecture 2: Challenge: Add data from another table using VLOOKUP

Lecture 3: INDEX & MATCH

Lecture 4: Challenge: Perform a lookup using INDEX & MATCH

Lecture 5: Create Conditional Formulas with IF

Lecture 6: IFERROR & ISERROR

Lecture 7: Challenge: Create a VLOOKUP with a custom error message

Lecture 8: LEFT, RIGHT, MID & LEN

Lecture 9: FIND, SEARCH & SUBSTITUTE

Chapter 4: DATE & TIME FUNCTIONS

Lecture 1: TODAY & NOW

Lecture 2: DATE

Lecture 3: Challenge: Turn a text date into an Excel date

Chapter 5: Extra Cheat Sheet and 10 Tips for Structuring Data

Lecture 1: Functions Cheat Sheet

Lecture 2: The 10 immutable laws of structuring data

Chapter 6: Wrapping up

Lecture 1: Bonus Lecture: More from Martyn Blythin & DataMinded Training

Instructors

Martyn Blythin
Data Analytics Consultant

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 6 votes
4 stars: 20 votes
5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu