Excel Essentials - Online

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.

Auktoriserad lönekonsult Auktoriserad redovisningskonsult Auktoriserad/godkänd revisor Controller Ekonomiassistent Ekonomichef/CFO Företagsekonom Lönekonsult Redovisningsansvarig/chef Redovisningskonsult Revisorsassistent Skatterådgivare/konsult

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
  • Around 80 lessons
  • Estimated time to complete course: 10 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 around 80 short lessons with a total of 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 workflow. You will learn functions 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

Information

No prior knowledge is required to take this course.

The lessons are based on the latest version of Excel and will work well with all versions except for Excel for Mac 2013 and older versions. 

This course is also available in Swedish: Excel Bas

Video Example

English Excel

  • Excel Essentials - Online 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.
  • The Excel PivotTables Guide - online This online course in Excel PivotTables will take you step by step through the powerful tool which is the PivotTable. The course will teach you how to arrange, group, filter and sort your PivotTables in new, more effective ways.
  • The Excel Functions Guide - online This online course will both guide you through the logic behind functions and also serve as an online library where you'll be able to rehears and look up useful functions.
  • Power BI Essentials - online This online course in Power BI is meant for anyone who wants to familiarize themselves with Power BI, Microsoft’s program that visualizes large amounts of data and provides tools for quickly making well-informed decisions. For this course, no previous knowledge is required!
  • Power Query Essentials - online This online course in Power Query is for anyone who wants to further increase their knowledge and skills within Excel. If you want to learn how to handle large databases like a professional, then this is the course for you! Save time by learning how to organize and analyse data at a rapid pace. 

Excelkurser online

  • Excel Bas Excel Bas är en excelkurs som riktar sig till dig som är nybörjare eller självlärd i Excel, och som snabbt vill utvecklas till en mästare i programmet.
  • Excelfunktioner fördjupning - online Den här onlinekursen kommer lära dig logiken bakom Excels funktioner och samtidigt vara ditt onlinebibliotek med funktioner att se och repetera när du behöver.
  • Excel pivottabeller – online Excelkurs – fördjupning pivottabeller är en Excelkurs som riktar sig till dig som är nybörjare eller självlärd kring Pivottabeller, och som snabbt vill utvecklas till en mästare med verktyget.
  • Power BI - Grundkurs Power BI är Microsofts tjänst i business intelligence. Business intelligence handlar om att analysera och sammanfatta data för att skapa en bättre uppfattning om en verksamhet. I kursen lär du dig Power BI:s grundfunktioner samt hur tjänsten fungerar i sin helhet. Du lär dig bland annat att hämta, visualisera, transformera och dela data.
  • Power Query för Excel - online Excelkursen Power Query för Excel är för den som vill fördjupa sina kunskaper inom Excel och hantera stora databaser som ett proffs. 
  • Power Pivot & DAX I kursen lär du dig grunderna i Power Pivot samt DAX-formler. DAX är en samling av formler som effektiviserar utförandet av uträkningar
  • PowerPoint Bas Kursen riktar sig till dig som är nybörjare eller självlärd i PowerPoint och snabbt vill utvecklas till att effektivt hantera programmet och utnyttja dess fulla potential.