Free Online Excel Course: From Basic to Advanced

Excel here, Excel there. We’ve all heard about this program at some point, whether at school or in the workplace.

This spreadsheet tool offers a wide range of functions that are used in a variety of fields. From the corner store that uses it to track purchases and sales to scientists who use it extensively for analyzing large volumes of data.

Learning to use Excel can tip the scales in your favor when it comes to job hunting, as it’s a highly regarded skill by companies, almost on par with English proficiency.

Do you want to learn Excel up to an advanced level but don’t know where to start? Don’t worry, my young grasshopper. Today, I’m going to share information about a course I’ve found online.

But it’s not just any course; this course promises to start from the beginner level and teach you the tricks and skills of an advanced level.

Excel Course: From Basic to Advanced

It’s designed for people of all levels, from beginners to those with intermediate knowledge who want to enhance their essential work skills. Here is a structured outline of what you will learn:

Module 1: Introduction

• Opening Excel for the first time
• Exploring the interface
• General aspects

Module 2: Fundamentals

• Basic table
• Printing to PDF
• Changing the size of rows and columns
• Saving Excel workbooks as PDF
• Printing area
• Adding headers and footers

Module 3: Excel Functions

• The SUM function
• Cell formatting
• Date formatting
• Copying sheets, cell styles, and custom formatting
• Excel functions
• Using relative and absolute references
• Structure of functions in Excel
• Average, maximum, and minimum functions

Module 4: Data Handling

• Inserting charts in Excel
• Bar charts
• Freezing rows and columns
• Hiding rows and columns
• Conditional formatting
• Find and replace
• Applying filters to your table
• Removing duplicate data
• Sorting data in a table

Module 5: Data Slicing and Pivot Tables

• Data slicing and total row
• Pivot tables

Module 6: Introduction to Macros

• Inserting a button
• The MsgBox pop-up window

No prior knowledge of the subject is required, just a computer with a stable internet connection and a version of Excel installed.

The course is an opportunity to enhance your skills and increase your efficiency in the workplace wherever Excel is used.

Finally, upon completing the course, you will have acquired a set of skills that will greatly benefit your professional life.