This course is also available in: Suomi Suomi Norsk Norsk Svenska Svenska
Excel Essentials

The ultimate guide to mastering Excel

Our most comprehensive Excel course where you will discover and master the fundamental features of Excel. The course is aimed at beginners and self-taught individuals who want to deepen their knowledge in Excel. From basic functions and formulas to data analysis tools and charts, this course covers everything you need to become efficient and confident in your work with Excel.

  • Access to the course for 12 months
  • Personal and digitally shareable diploma
  • The course takes about 10–12 hours to complete
  • Repeat as much as you want
  • Quizzes and practical exercises in Excel
Learnesy
4.9
Based on 140 reviews
powered by Google
js_loader

Course participants about Excel Essentials

Some of the things you will learn in this course:

The basics

The key to becoming proficient in Excel is to get the basics right from the beginning. Once you have a solid foundation to stand on, you will feel comfortable with the software’s functions and workflows, which will allow you to solve tasks independently.

Data visualization

Bring your data to life by creating compelling charts and visualizations. By customizing visualizations, you learn to effectively highlight trends, make comparisons, and identify patterns in your datasets.

Functions – how do they work?

Learn to use various functions to analyze and manage data. After this chapter, you will be able to perform more complex calculations and fully take advantage of Excel’s features.

Pivottables

Organize and analyze data dynamically and create clear reports with the help of PivotTables. In this chapter, you will learn to analyze large datasets efficiently and make well-informed decisions.

A lesson from the course

Absolute and Relative Cell References

In Excel, understanding absolute and relative cell references is fundamental to creating efficient and dynamic spreadsheets. A relative cell reference in Excel automatically adjusts when you copy a formula from one cell to another. This means that the reference changes relative to the position to which the formula has been moved.

On the other hand, an absolute cell reference retains its original reference regardless of where in the spreadsheet the formula is copied. In some situations, it may be beneficial to use a mixed cell reference, which combines the properties of both absolute and relative references. This type of reference is especially useful in complex spreadsheets where you need to maintain the reference to a specific row or column while allowing the other part of the reference to adjust relatively.

Shortcut key: F4

Course Content

Expand All
Chapter Content
0% Complete 0/1 Steps
Introduction
Chapter Content
0% Complete 0/4 Steps
Chapter Content
0% Complete 0/6 Steps
Chapter Content
0% Complete 0/7 Steps
Create formulas
Create a function
Copy formulas
Complicated formulas
Absolute and Relative Cell References
Dynamic and static values
Insert Function
Chapter Content
0% Complete 0/5 Steps
Chapter Content
0% Complete 0/6 Steps
Chapter Content
0% Complete 0/5 Steps
Chapter Content
0% Complete 0/12 Steps
Chapter Content
0% Complete 0/8 Steps
Create a chart
Format Chart
Adjust the database in a chart
Chart Types
Chart Elements
Slicers
Create a basic dashboard
Visualize trends and dynamic sections
Chapter Content
0% Complete 0/10 Steps
Structure and visual design of workbooks
Create a Database
Advanced conditional formatting
Sort
Subtotals
Filter
Flash Fill
Duplicates
Data validation
Get data from a web page (Power Query)
Chapter Content
0% Complete 0/9 Steps
Create a PivotTable
Working with a PivotTable
Filter and slicer
Insert a PivotChart
Grouping by time
Grouping rows and columns
Refresh the PivotTable
Change data source
Create PivotTables with multiple data sources (Power Pivot)
Chapter Content
0% Complete 0/4 Steps

More about the course

In this comprehensive introductory course, you will learn the most important and critical functions of Excel. The course starts with the basics and gradually moves towards more advanced topics. Our pedagogy is based on short lessons, which facilitates both learning and review. Throughout the course, you will also gain practical experience by solving interesting exercise tasks that simulate real-life scenarios.

Since its launch, Excel Essentials has had tens of thousands of users, and the course is updated annually based on new features in Excel. In line with our aim to constantly offer the most current and relevant course content, we continuously adapt our courses to reflect the latest developments and features in the software.

  • Approximately 80 lessons divided into 14 chapters.
  • Total video time: About 3.5 hours.
  • Estimated time to take the course including quizzes: 10–12 hours.
  • Average duration per lesson: 2–3 minutes.
  • Personal course certificate after you have completed 100% of the course.
certificate of course completion Excel Essentials Sarah Anderson It is hereby certified that Sarah Anderson has with diligence and commendable efforts completed Learnesy's online course Excel Essentials

Course manager

Emil

Course creator, Learnesy

Emil har jobbat på Learnesy som produktutvecklare i flera år och ligger bakom flera av Learnesys kurser. Han har en utbildning inom datavetenskap med ett stort intresse för det analytiska och teoretiska.

Choose what suits you best:

Excel Essentials

  • Choose the course that suits your needs
  • Access to all material 24/7 for 12 months
  • Complete the course at your convenience
  • Repeat freely throughout the access period
  • The course is maintained and updated
  • Personal and digitally shareable diploma
  • Save your favorite lessons
  • Contact us and we will help you choose the right one!
249 kr / month 2988 kr billed yearly. VAT will be applied.
Take this course

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

All courses

  • Access to the entire course catalog
  • Access 24/7 for 12 months
  • Complete the courses at your convenience
  • Repeat freely throughout the access period
  • Courses that are maintained and updated
  • Personal and digitally shareable diploma by course
  • Save your favorite lessons
  • Take full courses or see only the lessons you need
  • Contact us and we will help you get started today!
599 kr / month
7188 kr billed yearly. VAT will be applied.
Take all courses

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

For teams

  • 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
Offer

Prices excluding VAT

FAQ

Who should take this course?

This course covers a wide range of knowledge in Excel, and targets beginners or those who are self-taught in the subject.

Does the course include exercises?

This course uses many and short exercises. If you want to follow along with the lessons, you can do so by downloading the documents that are attached to each lesson. For each lesson there is an associated quiz, where many of the questions also contain an attached file.

I have previously used Excel. Is this course for me?

Yes, there is useful knowledge for almost everyone in this comprehensive course. If you feel that you still master the areas covered in the course, you can instead choose to take one of Learnesy’s more advanced courses in Excel.

How long does it take to complete the course?

This course takes an estimated 10-12 hours. If, on the other hand, you download all the available lesson materials in order to perform the same actions as in the lessons yourself, this course will take an estimated few hours longer.

Where can I turn if I need help with the content of the course?

You’ll find our forum helpful, where you can turn if you have questions regarding the course content or questions about Excel in general.

Are there enterprise solutions for this course?

If you want to easily and uncomplicatedly give your employees new or a refresher of their Excel skills, you can contact [email protected].

I am looking for an Excel course for a group of students as working life requires good Excel skills. Can you help me?

If you are an educational institution that wants to offer its students supplementary Excel training, you can contact [email protected].

For other questions?

For other questions, you should first read our FAQ.

Can’t find your answer? Contact [email protected].

Deloitte Deloitte Deloitte