Everything went smooth.

Something went wrong.

There are a total of 249 short lessons in 1 to 3 minutes that will give you great knowledge in Excel. Like all Learnesy’s courses, the lessons are short so it should be easy and fun for you to acquire the knowledge, and above all, easy to repeat. The courses also includes exercise assignments that you can practice on.

The Excel package gives you 12 months of access to Learnesy’s three Excel courses:

- Excel Essentials
- The Excel Functions Guide
- The Excel Pivottables Guide

*Excel Essentials* – With Excel you can easily turn data into insights. In Excel you can use functions to calculate, create diagrams and tables. Another great feature with the software is that you can work with your colleagues on the latest version for real-time collaboration.

*The Excel Functions Guide* – The course will teach you the logic behind functions at the same time as it’s your very own online-library filled to the brim with functions. All available to watch and repeat whenever you need.

*The Excel Pivottables Guide* – If you use Excel on a daily basis, you are probably spending a lot of time making analyzes that Excel can easily make for you. Learnesy’s Pivottable Guide goes through lesson by lesson Excel’s PivotTables, an incredibly useful and powerful tool to analyze data.

- Form of education: Educational online courses in Excel Essentials, The Excel Functions Guide and The Excel Pivottables Guide
- Target group: In Excel Essentials no prior knowledge is required. The Excel Functions Guide and the Excel Pivottables Guide requires basic knowledge in Excel.
- You will have access to the course in 12 months.
- Personal certificate after completing 100% of the course

Do you need Excel? Here you can buy Excel from Microsoft

1 Introduction to PivotTables

0 of 5 lessons completed

2 Creating a PivotTable

0 of 11 lessons completed

3 Grouping a PivotTable

0 of 4 lessons completed

4 Sorting a PivotTable

0 of 4 lessons completed

5 Filtering a PivotTable

0 of 5 lessons completed

6 Slicers
4 Lessons
1 Quiz

Expand

6 Slicers

0 of 4 lessons completed

7 Calculated Fields and Items

0 of 4 lessons completed

8 Formatting a PivotTable

0 of 3 lessons completed

9 PivotCharts

0 of 5 lessons completed

10 Tips and Tricks for PivotTables

0 of 4 lessons completed

1 Functions with Count And Sum

0 of 11 lessons completed

2 Logical
3 Lessons
1 Quiz

Expand

2 Logical

0 of 3 lessons completed

3 Cell references

0 of 4 lessons completed

4 Date and time

0 of 9 lessons completed

5 Text
11 Lessons
1 Quiz

Expand

5 Text

0 of 11 lessons completed

6 Lookup and reference

0 of 9 lessons completed

8 Statistical

0 of 11 lessons completed

9 Round
4 Lessons
1 Quiz

Expand

10 Formula errors

0 of 6 lessons completed

11 Array formulas
10 Lessons

Expand

11 Array formulas

0 of 10 lessons completed

1 Get to know Excel

0 of 8 lessons completed

2 Basic functionality

0 of 6 lessons completed

3 Working with formulas

0 of 7 lessons completed

4 Formatting

0 of 8 lessons completed

5 Worksheet basics

0 of 5 lessons completed

6 Printing

0 of 2 lessons completed

7 Charts
7 Lessons
7 Quizzes

Expand

7 Charts

0 of 7 lessons completed

8 Worksheet overview

0 of 3 lessons completed

9 Manage multiple workbooks

0 of 3 lessons completed

10 Functions

0 of 10 lessons completed

11 Security and sharing

0 of 3 lessons completed

12 Working with databases

0 of 6 lessons completed

13 PivotTables

0 of 8 lessons completed

14 Goal Seek and Macros

0 of 4 lessons completed