Overview

This free online Excel course will equip you with the essential skills to manage and analyze your data effectively. You’ll master key Excel functions, including cell referencing, table creation, basic formulas, and sorting and filtering techniques, giving you the ability to handle data tasks more efficiently.You’ll also learn to work with date and time functions, as well as if-else conditions, to manipulate and analyze data. With step-by-step guidance and practical examples, you'll gain confidence in applying these skills in real-world scenarios, boosting productivity in your everyday work tasks. By the end of the course, you’ll have a strong foundation in Excel and know precisely how to apply these skills to improve your work efficiency.

Syllabus

Introduction to Excel

Discover what Excel is and when it came into existence. Learn how you can use Excel for data processing. This is an introductory module where you will be provided with the basic knowledge of Excel.

Cell Referencing in Excel

This module will be focused on cell referencing, a concept of Data Wrangling. With the help of illustrations covered in this module, you will understand the importance and types of cell referencing.

Tables and Borders in Excel

Learn how to create and use tables and borders in Excel that help in organizing and viewing the data. Tables are useful for sorting and filtering the data in an Excel sheet.

Basic Functions and Formula in Excel

In this module, you will come across the basic mathematical functions in Excel like Addition, Subtraction, Multiplication, Division, and Power. Learn the methods to perform these functions with the help of examples shown over the screen.

Sorting in Excel

Know how Sorting in Excel works. This is one of the most important features of Excel where you can sort all sorts of data in the Excel sheet on the basis of color or values. Experience how sorting works by going through the example shared by the instructor in the module.

Filtering in Excel

Experience how Filtering works in Excel in this module. Learn why we need filtering and the differences between Sorting and Filtering. Learn to apply filtering to a given data set and explore its uses, in this module.

Date and Time in Excel

Learn about various variables used in Excel. Become familiar with the date and time functions, which are stored in Excel as a number representing the number of days. Learn different ways to use the function in Excel.

If-Else condition in Excel

If Else condition in Excel is used to test a condition and then take one action if the condition is TRUE, and another action if the condition is FALSE. Get to know If Else condition and its use in Excel with the help of different use cases.

General Functions in Descriptive Analysis in Excel

Become familiar with different functions in Excel that are used in Descriptive Analytics. These functions are AVERAGE, MAX, MIN, MEDIAN, etc. that you will get to know in this module. Descriptive analytics is the process of analyzing data to find meaningful patterns that can be used to make better decisions.

ChatGPT for Excel

In this module, we will explore using ChatGPT to understand the basics of Excel, learn different types of functions, and generate Excel formulas to simplify data tasks and boost productivity.