Microsoft Excel

Do you want to learn how to use Excel, the most popular spreadsheet software in the world? Whether you need to organize data, perform calculations, create charts, or automate tasks, Microsoft Excel can help you do it faster and easier. In this course, you will learn the basics of Excel, such as how to enter and format data, use formulas and functions, create charts and tables, and manage worksheets and workbooks. You will also learn some tips and tricks to make your work more efficient and professional. By the end of this course, you will be able to use Excel confidently for your personal or professional needs.

This course is suitable for anyone who wants to learn Excel from scratch or refresh their skills. No prior knowledge of Excel is required. You will need a computer with Microsoft Excel installed.

The course consists of 10 modules, each with a video lecture, a quiz, and a practice exercise. You can complete the course at your own pace and access it anytime and anywhere. You will also get a certificate of completion upon finishing the course.

Enroll now and start your Excel journey today!

Course Syllabus

Basic Instructions

Instructions
Name Check

Introduction

Module 1

Create a workbook

00:45
Autofill & Manual Data Entry

00:42
OneDrive

00:23
Pro Tip

00:35
Automatically fill a column with Flash Fill
Quickly calculate with AutoSum
Create a chart
Use conditional formatting
Freeze the top row of headings
Freeze rows or columns
Unfreeze rows or columns
Insert or delete a worksheet
Move or copy worksheets or worksheet data
Use Excel as your calculator
Subtraction

00:26
Multiplication

00:23
Division

00:24
Use AutoSum

00:42
Avoid rewriting the same formula

00:00
What can I use in a formula to mimic calculator keys?

00:54
Select one or more cells
Filter for unique values or remove duplicate values

00:42
Create a list of sequential dates
Find or replace text and numbers on a worksheet
Replace
Merge and unmerge cells

01:01

Module 2

Module 3

Formulas & functions

01:22
Create a formula that refers to values in other cells
Making a reference to a cell or a range of cells on another worksheet in the same workbook
XLOOKUP function

00:40
Syntax
Examples
VLOOKUP

00:43
SUM function

00:25
Best Practices with SUM
Frequently Asked Questions
COUNTIF function

01:08
IF function

00:37
Simple IF examples
Apply the IFS formula to the column
Use the ROW function to number rows
Use the ROW function to number rows
Dates
Define and use names in formulas

01:40
Combine data with the Ampersand symbol (&)