Microsoft Excel – Excel Course For Beginners


Learn The Excel Essentials Only For Beginners

What you will learn

Excel only for beginners

How to properly use Excel

Make your work faster, better and more efficient

Creating Charts from your data

Most Frequently Used Excel Functions With Examples

How to land your first job as an Excel Expert

PivotTable Made Easy

Improve your Microsoft Excel Skills

Description

Microsoft Excel Version 2021

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.

Here attached some Resource file for your practice. 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:

Started Fast

  • How to get Started with Excel
  • Create and open Workbook
  • Create New Worksheets
  • Tabs and Ribbon

Save Data

  • Save Workbook in your PC

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

LOOKUP Functions


Get Instant Notification of New Courses on our Telegram channel.

Noteβž› Make sure your π”ππžπ¦π² cart has only this course you're going to enroll it now, Remove all other courses from the π”ππžπ¦π² cart before Enrolling!


  • INDEX Function
  • MATCH Function
  • EXACT Function
  • VLOOKUP APPROXIMATE MATCH Function
  • VLOOKUP Function
  • HLOOKUP Function
  • XLOOKUP Function

GOOGLE Spread Sheet Function

  • Use DETECTLANGUAGE formula in google spread sheets

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

Sorting and Filtering

  • Sort Function
  • Filter Function

Flash Fill

  • Merge and Separate data using flash fill

Panes

  • Freeze panes
  • Split panes

Multiple worksheets and workbooks

  • Rename and Color Worksheets
  • Add and Delete 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 Size

  • Headers and footers
  • 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.

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

English
language

Content

Introduction

Course Outline
Introduction
What Is Excel
Where You Used Excel

Started Fast

How to get Started with Excel
Create and open Workbook
Create New Worksheets
Tabs and Ribbon

Save Data

Save Workbook in your PC

Error Functions

Error Functions Part 01
Error Functions Part 02

Logical Functions

AND() Function
OR() Function
NOT() Function
XOR() Function
SWITCH() Function
CELL() Function
ROW() Function

Conditional Functions

IF() Function
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 Functions

DATE() Function
DATEIF() Function
EDATE Function
EOMONTH Function
TODAY and NOW Function

Mathematical Functions

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 Functions

LEN Function
MID
REPT Function
SPLIT Function
TRIM Function
Show gridlines Function

LOOKUP Functions

INDEX Function
MATCH Function
EXACT Funtion
VLOOKUP Function
VLOOKUP APPROXIMATE MATCH Function
HLOOKUP Function
XLOOKUP Function

Web Data & Hyperlink

Hyperlink
Import HTML Table in Excel

GOOGLE Spread Sheet Function

How To use DETECTLANGUAGE formula in google spread sheets

Convert Function

How to convert number to word

Drop Down Lists

Dynamic dropdown List
Dependent dropdown List

Charts & Graphs

Charts & Graphs

Pivot Tables

How to Use Pivot Tables

Sorting and Filtering

Sort Function
Filter Function

Flash Fill

Merge and Separate data using flash fill

Panes

Freeze panes
Split panes

Multiple wordsheets and workbooks

Multiple wordsheets and workbooks

Share and Collaborate

Proetect Worksheet
Protect Workbook
Sharing Excel Workbook with Multiple Users

Page Size

Headers and Footers
Page settings
Page break view

Print selection & Print Area

Print selection & Print Area