Excel Essentials – Online

Nyhet

Excel Essentials English is an online course in Microsoft Excel, perfect for anyone who is self-taught or a beginner in Excel and wishes to master the software.

Pris 1 995 kr
Typ Onlinekurs
Platser kvar Ja
Fler kurstillfällen

Course description

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 pedagogy is based on short video lessons, averaging 2 minutes and 38 seconds per lesson, with exercise files and quizzes. You can access the online course from computer, tablet and mobile.

Information about the course

  • Full access for 12 months
  • 86 lessons
  • Total video time: 4 hours
  • Average length per lesson: 2 minutes 38 seconds

The course begins with learning the basics of Excel, how to line up data and how to make it look professional. We then gradually move forward to more advanced use of Excel. In the second part of the course you will learn how to work with PivotTables, how to use functions such as "VLOOKUP" and "IFerror".

Expenditure of time

The online course consists of 86 short lessons and in total 4 hours in video time. You will have access to the course for 12 months so you can repeat the course whenever needed.

The purpose of the online course is to quickly become a comfortable and efficient user of Excel and make Excel a natural tool in your work. You will learn functionalities and commands that help you save time and get a higher quality in your work.

After the course, Excel will be a natural tool in your work. Among other things, you will have learned how to manage a database, how to create and use functions, how to set up and work with a pivot table and understand how to work with macros. See the course chapters for further information.

The online course is a collaboration between FAR and Learnesy.

Chapters

  1. Get to know excel
  2. Basic functionality
  3. Working with formulas
  4. Formatting
  5. Worksheet basics
  6. Printing
  7. Charts
  8. Worksheet overview
  9. Manage multiple workbooks
  10. Functions
  11. Security and sharing
  12. Working with databases
  13. PivotTables
  14. Goal Seek and Macros

Video example

Requirements

No prior knowledge required.