Excel Essentials

– A comprehensive introductory course for anyone who wants to become confident and efficient in Excel.

Excel Essentials is an extensive online course for beginners and self-taught users who want to build a solid foundation in Microsoft Excel. Starting with the fundamentals, you will progressively develop the skills needed to work with formulas, functions, tables, charts, data management and PivotTables. You will also be introduced to how AI tools can support and streamline your work in Excel.

Course description

Excel Essentials provides you with the knowledge and practical skills needed to work independently and efficiently in Microsoft Excel. The course begins with the Excel interface and fundamental functionality before progressing to formulas, functions, formatting, charts and structured data management.

You will also learn how to sort, filter and structure data, create PivotTables and use Excel for analysis and visualization. In addition, the course introduces AI tools and demonstrates how they can support you when working with Excel.

The course combines short video lessons with quizzes and practical exercises. You study at your own pace and get the opportunity to apply your new knowledge directly through realistic Excel tasks.

Information about the course

  • Online course with access to the learning platform for 12 months
  • Suitable for beginners and self-taught Excel users
  • Estimated completion time: approximately 10–12 hours including quizzes
  • Short and concise video lessons
  • Practical exercises and quizzes
  • Self-paced learning
  • Certificate upon completion
  • 10 Continuing Professional Education hours

Introduction video

Var vänlig tillåt kakor för statistik och marknadsföring för att visa detta innehåll.

The goal of the course is to provide you with a solid foundation in Excel and help you become more confident using the program in a professional environment. You will learn not only where to find different tools and features, but also how to use them to solve common tasks in a structured and efficient way.

After completing the course, you will be able to work independently with spreadsheets, formulas and functions, structure and analyze data, and create tables and clear visualizations. You will also have gained practical knowledge of PivotTables and an understanding of how AI can support your work in Excel.

The online course is a collaboration between FAR and Learnesy.

Chapters

Introduction: Welcome to Excel Essentials

  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. AI in Excel

Information

The course requires no prior knowledge of Excel and is suitable both for complete beginners and self-taught users who want to fill knowledge gaps and build a stronger foundation. The content starts at an introductory level and gradually progresses to more advanced Excel functionality.

The training is delivered entirely online, allowing you to study at your own pace throughout the access period. Short video lessons are combined with quizzes and practical Excel exercises, giving you the opportunity to reinforce your knowledge and apply what you learn.

The course covers a broad range of practical Excel skills, including formulas and functions, data management, charts, PivotTables and AI tools. The AI chapter introduces tools such as Microsoft Copilot and ChatGPT and demonstrates how AI can be used to support and streamline Excel-related tasks. The course is continuously maintained and updated by Learnesy's course developers.

This course is also available in Swedish: Excel Bas.

Version of Excel
The course is recorded in a Windows environment using a modern version of Microsoft Excel. If you use Excel 2019 or an older version, some functions and features may be unavailable or work differently.

Course scope
10 Continuing Professional Education hours.

Example lesson

Var vänlig tillåt kakor för statistik och marknadsföring för att visa detta innehåll.

English Excel

Excelkurser online