Deepen and develop your Excel Functions skills
Learn to efficiently manage databases, clear text in cells and retrieve values from other tables. The course also goes through how to combine functions, which is required to be able to perform more advanced steps in Excel. With this knowledge, you will be able to simplify time-consuming parts of your work. With over 100 lessons spread over 12 chapters, you will learn a lot in the subject of Excel functions.
- Complete the course at your own pace
- Repeat as much as you want
- Practical exercises and quizzes
- Personal and digitally shareable diploma
- Save lessons as favorites
- The course takes about 4 hours to complete
- Access to the course material for 12 months
- 90+ lessons of functions and formulas
- Get yourself a library of Excel functions
Some of the things you will learn in this course:
A library of 100+ functions
After completing the entire course, it can be used as a library of functions. Save your favorite functions and return to them for a refresh whenever you need it.
The most useful functions
Functions that show you how to summarize, count, how to manage absolute and relative references, financial functions, statistical functions, and more.
VLOOKUP and reference functions
VLOOKUP, perhaps Excel’s most famous function, is not always easily understood. Learn this useful function along with 10 other practical functions used to search for and collect values.
Handle dates and text
Something that even experienced Excel users know is complicated are dates and texts in tables or databases. Use functions such as WEEKDAY, WORKINGDAYS, MID, and many other smart tips and tricks to get your data in order and manage it correctly.
More about the course
The Excel Functions Guide is a continuation course for those who want to expand their competence within the program’s many functions. Prior knowledge of Excel is required. If you’re lacking said knowledge, we can recommend our course Excel Essentials. In addition to the more basic functions, you will also learn dynamic array functions and how to handle error messages. When you handle multiple functions, you can save time in your work because you can often replace multiple elements with a single formula. Last but not least – to become an advanced Excel user, you must be able to master functions.
- Approximately 90 lessons divided into 12 chapters.
- Total video time: 1 hour 40 minutes.
- Estimated time to take the course including quizzes: 3 hours.
- Average length per lesson: 1 minute.
- Personal shareable certificate after completing the course.
Who should enroll this course?
This course is for those who have previously taken the course Excel Essentials or who have basic Excel skills, as this is one of Learnesy’s intermediate courses in Excel.
Is there exercises in this course?
This course includes many and short exercises. If you want to follow along with the lessons, you can do so by downloading the files that are attached to each lesson.
All chapters end with a quiz. With some questions there’s a downloadable resource which is needed to solve said exercise.
I HAVE PREVIOUSLY LEARNED EXCEL FUNCTIONS IN the Excel Essentials COURSE – IS THIS COURSE FOR ME?
Yes, if you have previously taken the Excel Essentials course, this course will give you a much deeper understanding and practical knowledge of Excel functions.
I HAVE USED EXCEL BEFORE. IS THIS COURSE FOR ME?
Yes. This comprehensive course contains lots of useful features and tips. However, this course requires some prior knowledge in the area of Excel functions. If you feel that you need to repeat the basics instead, you can take our course Excel Essentials.
HOW LONG DOES IT TAKE TO COMPLETE THE COURSE?
This course takes about 3 hours to complete. To pass the course and receive your diploma, you must complete all the lessons and quizzes that make up each chapter. If, on the other hand, you want to download the lesson materials and follow along practically in each lesson yourself, this course will take a little longer.
WHERE CAN I GO IF I NEED HELP WITH THE CONTENT OF THE COURSE?
If you need help, you can visit our forum or contact us at [email protected].
We are an enterprise, a team or a school needing a intermediate Excel course. How do we proceed?
Do you want to learn Excel functions, acquire a library of these and are looking for a business solution for your group? Then get in touch at [email protected].
If you are an educational institution that wants to offer its students supplementary Excel training, you can contact [email protected].
A lesson from the course
In this lesson from The Excel Functions Guide, you’ll learn the VLOOKUP function from the chapter “Lookup and reference”. The function looks for a given value in the leftmost column, and returns a value in another column on the same row. VLOOKUP is used to search and retrieve values, and is mainly used in spreadsheets with a lot of data. VLOOKUP can be compared to a phone book. You start with the information you know to find out what you don’t know.
The Excel Functions Guide is one of Learnesy’s intermediate courses in Excel. In this course, you’ll learn even more so-called reference functions. This course actually includes an entire chapter of such features. The remaining twelve chapters cover many other Excel functions with completely different purposes, such as matrix functions, statistics functions and text functions to name a few. In fact, the course contains about 90 lessons with functions, formulas and other tips and tricks for formula management.
Meet your teachers
Henrik is one of Learnesy’s course creators. Since 2015, he has developed and produced many of Learnesy’s courses. He has studied software development but also sound, which is why you can so often hear his voice in many of Learnesy’s courses.
Henrik has extensive experience in e-learning and possesses very good knowledge in the majority of data-related areas and the tools used.
Emil is an important part of our team of course creators. He has been creating courses on Learnesy since 2017 and has previous multi-year education in computer science. Many of the popular courses that can be found in Learnesy’s course range have been developed by Emil and he has a broad competence in Excel, data analysis and programming.
Choose what suits you best:
The Excel Functions Guide
- Access to all material 24/7 for 12 months
- Complete the course when it suits you
- Repeat freely during access
- Course maintained and updated continuously
- Personal and digitally shareable diploma by course
Take this course
- 24/7 access to all of Learnesys courses for 12 months
- Take full courses or see only the lessons you need
- Save your favorite lessons with the favorite feature
- Get ongoing updates in the courses
- Personal and digitally shareable diploma by course
Take all courses
- Personal Account Manager
- Personal account for all users
- Choose the courses that suits your needs
- Multi-user discounts
- Optional Kickoff at startup
- Statistics via Data Insight
- Technical support
- Unique login domain
Prices excluding VAT
Get a better understanding of the Excel workflow
Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is a course that both beginners and advanced users can find...
Become an expert in Excel's most fundamental data analysis tool
With this course, you’ll quickly and efficiently learn how to set up and analyse databases. Once you’re able to analyse data at a deeper level, you will then be able...