# 2023 Excel for Beginners: Microsoft Excel Course

COURSE AUTHOR –
Web Oral

Last Updated on November 20, 2023 by GeeksGod

# Course : Microsoft Excel – Excel Only For Beginners 2023

## Microsoft Excel Version 2021

### The Basics of Microsoft Excel

In this course, you will learn the basics of Microsoft Excel. This course is designed for people who are interested in Microsoft Excel and can do any calculation using Excel. This course will be helpful for learning Excel for beginners.

### Free Udemy Coupon, Microsoft Excel Course

#### Share your work with me so we can be able to discuss it and review it together.

First, you should watch promotional videos and watch the free preview lessons. I think they’re going to give you a good idea of the quality of the course content, pace, and what to expect from taking the course. Apart from that, Udemy offers a 30-day money-back guarantee with no questions asked!

### This Course includes:

#### Get Started Fast

How to get Started with Excel

Create and open Workbook

Create New Worksheets

Tabs and Ribbon

#### Errors Functions

#VALUE!, #DIV/0!, #NAME?, #N/A#REF!, ###, #NULL!, #NUM!

#### Logical Function

AND() Functions

OR() Functions

NOT() Functions

XOR() Functions

SWITCH() Functions

CELL() Functions

ROW() Functions

#### Conditional Functions

IF() Functions

IFS() Functions

Nesting IF() Functions

Use IF function to calculate letter grades in Excel

Use IFS function to calculate letter grades in Excel

#### Filter Function

How to use Filter Function in Excel

#### DATE Function

DATE() Function

DATEIF() Function

EDATE Function

EOMONTH Function

TODAY and NOW Function

#### Mathematical Function

Count Function

Round Function

Sum Function

Average Function

Subtotal Function

How to generate Subtotal With Grandtotal

Power Function

Mod Function

INT & TRUNC Function

MIN() and MAX() Function

#### Text Function

Find, Search and Replace

LEN Function

MID Function

REPT Function

SPLIT Function

TRIM Function

Show gridlines

### Free Udemy Coupon, Microsoft Excel Course

#### LOOKUP Functions

INDEX Function

MATCH Function

EXACT Function

VLOOKUP APPROXIMATE MATCH Function

VLOOKUP Function

HLOOKUP Function

XLOOKUP Function

#### Convert Function

How to convert number to word

#### Drop Down List

Dynamic dropdown List

Dependent dropdown List

#### Charts & Graphs

How to Create Charts & Graphs

#### Pivot Tables

How to Use Pivot Tables

Sort Function

Filter Function

#### Flash Fill

Merge and Separate data using flash fill

Freeze panes

Split panes

#### Multiple worksheets and workbooks

Rename and Color Worksheets

Hide and Unhide Worksheets

Move and Copy Worksheets

Worksheet Groups

#### Share and Collaborate

Protect Worksheet

Protect Workbook

Sharing Excel Workbook with Multiple Users

Page settings

Page break view

#### Print

Print selection

I am sure you can do it! all you have to do is follow the lessons step-by-step!

Feel free to share any problem you are facing, and I will be here to review it.

### Free Udemy Coupon, Microsoft Excel Course

To achieve everything mentioned in this piece of advice, Enroll in this course now!

## Udemy Coupon :

SUBHANALLAH_112023

## What you will learn :

1. Excel only for beginners
2. How to properly use Excel
3. Make your work faster, better and more efficient
4. Creating Charts from your data
5. Most Frequently Used Excel Functions With Examples
6. How to land your first job as an Excel Expert
8. Improve your Microsoft Excel Skills