Microsoft Excel

Certified Course on

Microsoft Excel

Excel is more than just a tool. It’s a skill that can boost your productivity and career. Learn how to use it with this course.

About Course

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, 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 Content

Introduction

Overview

01:00

Module 1

Create a workbook

00:44
Autofill & Manual Data Entry

00:42
OneDrive

00:22
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 (&)

Module 4

Module 5

Charts
Add or remove titles in a chart
Show or hide a chart legend or data table
Add or remove a secondary axis in a chart in Excel

00:31
Add or remove a secondary axis in a chart in Office 2010
Add a trend or moving average line to a chart
Add a moving average line
Instant charts using Quick Analysis

Module 6

Pro-Tip

Trusted by 10K+ Students

Students are our biggest asset. Their stories will speak for itself! We imagine a world were education is redefined in such a way that it’s accessible, affordable and easy to learn from anywhere across the world.

Frequently Asked Questions (FAQ)

Are there any hidden fees or additional charges?

No, there is no additional charges

Can we access it on mobile?

Yes, all our courses and internships are mobile friendly. It will always be ♥️.

Why are your course fees very low?

We are focused on providing affordable and accessible education to anyone, anywhere across the globe. It is the motto of our company. Education shouldn't be an exclusive privilege to only the ones who can afford it. Please refer to the {Our Story} section to know more.

Find your desired course

Select Your Favourite Category And Start Learning.

Freedom

Internship

Workshop

Microsoft Excel

About Course

Course Content

Introduction

Overview

Module 1

Create a workbook

Autofill & Manual Data Entry

OneDrive

Pro Tip

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

Multiplication

Division

Use AutoSum

Avoid rewriting the same formula

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

Select one or more cells

Filter for unique values or remove duplicate values

Create a list of sequential dates

Find or replace text and numbers on a worksheet

Replace

Merge and unmerge cells

Module 2

Formatting

Number formats

Add a watermark in Excel

Display or hide zero values

Module 3

Formulas & functions

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

Syntax

Examples

VLOOKUP

SUM function

Best Practices with SUM

Frequently Asked Questions

COUNTIF function

IF function

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

Combine data with the Ampersand symbol (&)

Module 4

Tables

Filter data in a range or table

Filter data in a table

Use slicers to filter data

Module 5

Charts

Add or remove titles in a chart

Show or hide a chart legend or data table

Add or remove a secondary axis in a chart in Excel

Add or remove a secondary axis in a chart in Office 2010

Add a trend or moving average line to a chart

Add a moving average line

Instant charts using Quick Analysis

Module 6

Pivot Tables

Use the Field List to arrange fields in a PivotTable

Group or ungroup data in a PivotTable

Select Your Favourite
Category And Start Learning.