Microsoft Excel Basic Course

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

courses Content

Expand All

1. Getting to know Excel 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Working with the Excel environment

Workbooks in Excel

Getting to know Excel – Quiz

2. Working with Cells 3 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/3 Steps

Understanding cells

Cell Content – Part 1

Cell Content – Part 2

Working With Cells – Quiz

3. Modifying Columns, Rows, and Cells 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

Working With Columns, Rows, and Cells

Wrapping Text and Merging Cells

Modifying Columns, Rows, and Cells – Quiz

4. Formatting Cell 5 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/5 Steps

Changing the Font Size

Changing the Font Face

Changing the Font Color

Using Bold, Italic, and Underline commands:

Excel Cell Styles

Formatting Cell – Quiz

5. Understanding Number format in Excel 5 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/5 Steps

Excel Custom Number Formats

Where can you use custom number formats?

What is a number format?

Where can you find number formats?

General is “Default” Settings

Number Format – Quiz

6. Using Find & Replace 2 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/2 Steps

How to Find Content

To Replace Cell Content

Using Find and Replace – Quiz

7. Formulas and Functions 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

Understanding Formulas in Excel

Entering a Formula

Operator Precedence

Copy/Paste a Formula

Insert Function

Formulas and Functions – Quiz

8. Most Used Functions 10 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/10 Steps

Function 1 – COUNT

Function 2 – SUM

Function 3 – IF

Function 4 – AVERAGE

Function 5 – COUNTIF

Function 6 – SUMIF

Function 7 – VLOOKUP

Function 8 – INDEX and MATCH

Function 9 – MIN and MAX

Function 10 – SUMPRODUCT

Most used Functions – Quiz