Svenska
Deepen and develop your Excel Functions skills
Learn how to efficiently manage databases, clean text in cells, and retrieve values from other tables. The course also covers how to combine functions, which is essential for performing more advanced tasks in Excel. With these skills, you’ll be able to simplify time-consuming parts of your work. With over 100 lessons spread across 12 chapters, you will gain extensive knowledge of Excel functions.
- Master advanced functions for automated analysis
- Combine and optimize data with smart formulas
- Boost your CV with a diploma
- Practice directly in Excel
- Short lessons – flexible structure (approx. 4 hours)
- Learn at your own pace, for 12 months
- Used by companies and universities
Try some lessons in this course for free
Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.
Try some lessons in this course for free
Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.
Course manager
Emil
Hello! My name is Emil, and I have had the pleasure of being an Excel instructor at Learnesy for many years. In this course, we focus on the most useful functions in Excel, with the goal that you not only learn to handle these tools but also can apply them independently in your daily work.
My aim is to provide you with the tools to transform numbers into insights, and I am enthusiastic about supporting you on your journey to becoming an Excel master.
For more information or questions, contact me via email:
emil@learnesy.com
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.
Course Content
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.
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.
Invest in your knowledge
One course (The Excel Functions Guide)
2 995 kr
VAT will be applied.
Educate yourself further with an online course in Excel, Power BI, or PowerPoint – to name a few.
Course package
5 995 kr
VAT will be applied.
Take your career to the next level with our tailored course packages!
Educational scheme
- Access to all material 24/7 for 12 months
- Complete the course at your convenience
- Repeat freely during the access period
- Courses that are maintained and updated
- Personal and digitally shareable diploma per course
- Schedule and set goals for your learning
- Save your favorite lessons
- Ask your questions in our forum
- Tech Support
- Track and test your knowledge
- Admin features for your team
- LMS integration
- Discounts for multiple users
Business groups
With our platform, we focus on improving your company's skills through customized course content, flexible learning times, and tracking tools to track and test employee progress. We offer courses in several languages and for different skill levels, as well as the possibility of hybrid training and integration with your company's LMS system. When you feel ready - contact us for a quote.
- Personal Account manager
- Personal User Accounts
- Select courses
- Quantity discount
- Statistics
- Unique login domain
- Prior knowledge and follow-up test
- Compare progress with the group
Prices excluding VAT
How Your Learnesy Course Works
At Learnesy, we believe that education should be accessible and straightforward. That’s why we’ve created a platform with you, the user, at the center. Within the platform, you can easily navigate in and between your online courses.
• My Account – here you’ll find your dashboard, where you can access both ongoing and completed courses. Your dashboard is the starting point for your learning journey.
• Get a glimpse of a Learnesy course – from your dashboard, you can easily click through to an ongoing or completed course.
• Favorite and share lessons – found a particularly useful segment or something you want to review again? You can save these by marking them as favorites. You can also share lessons with others who might benefit from them.
• Quizzes and practice exercises – practice makes perfect. Here, you put your theoretical knowledge into action. All quizzes, as well as all course content, can be repeated.
• Congratulations on your course diploma – upon completing a course, you’ll receive a personal, shareable diploma as proof of your new skills.
Have a question? You might find your answer here. If not, don’t hesitate to contact us.
FAQ
What does this Excel Functions course teach?
You’ll learn how to master key Excel functions like IF, VLOOKUP, XLOOKUP, INDEX, MATCH, and more.
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.
Will I receive a certificate after completion?
Yes, upon successfully completing the course, you will receive a personal, digitally shareable diploma.
How long does it take to complete this course?
The estimated total time to complete the course is about 4 hours.
Who can I contact for further questions or support?
For any assistance with course content, technical access, licenses, or business inquiries, email support@learnesy.com.
Related courses
