Excel Essentials - Online

Excel Essentials is a popular online course aimed at beginners or self-taught individuals in Excel who want to quickly become proficient in the program.

Course description

The pedagogy is based on short video lessons, averaging three minutes each, with accompanying practice files and concluding knowledge tests. After completing this course, you will have a fundamental understanding of Excel's various functionalities. You will be able to use functions to solve complex problems and calculations, quickly generate reports and visualizations using various tools, and easily manage large datasets in Excel. The course also includes educational practice and exercise files where you can apply what you have learned in practical scenarios.

Information about the course

  • Full access for 12 months
  • Approximately 75 lessons
  • Estimated completion time: 14 hours

Introduction video

The goal of the course is to quickly make you a comfortable and efficient user of Excel, and to make Excel a natural tool in your work. You will learn functionalities and commands that help you save time and achieve 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 databases, create and use functions, and set up and work with a pivot table. See the course chapter names for more 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. Manage content and appearance
  6. General functionalities
  7. Functions
  8. Charts
  9. Data management
  10. PivotTables
  11. 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

Sample lesson

English Excel

  • Excel Essentials - Online Excel Essentials is a popular online course aimed at beginners or self-taught individuals in Excel who want to quickly become proficient in the program.
  • 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 In this online course, you will learn to master 100 of Excel's most commonly used functions. Additionally, the course serves as an online library of functions, allowing you to come back and review them at any time.
  • Power BI Essentials - online Power BI Essentials, designed for beginners, is an online training program focused on creating dynamic reports and visualizations using Power BI, a business intelligence tool from Microsoft.
  • Power Query Essentials - online Power Query Essentials is an online course designed to teach the fundamentals of Power Query, a powerful data preparation tool in Excel. It is ideal for both beginners and self-taught individuals and requires no prior experience with Power Query.

Excelkurser online

  • Excel Bas Excel Bas är en populär onlinekurs 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 I den här onlinekursen lär du dig bemästra 100 av Excels mest använda funktioner. Samtidigt fungerar kurser som ett onlinebibliotek av funktioner, så du kan komma tillbaka och repetera när som helst.
  • 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 En onlinekurs som fokuserar på att skapa dynamiska rapporter och visualiseringar med Power BI, ett verktyg för affärsintelligens från Microsoft.
  • 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.