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 help learn Excel for beginners.
Here are some Resource files for your practice. please share your work with me so we can 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. Aitionallydd, 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 on your PC
Errors Functions
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 the IF function to calculate letter grades in Excel
Use the 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
INDEX Function
MATCH Function
EXACT Function
VLOOKUP APPROXIMATE MATCH Function
VLOOKUP Function
HLOOKUP Function
LOOKUP Function
GOOGLE Spread Sheet Function
Use the DETECTLANGUAGE formula in Google spreadsheets
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, please Enroll in this course now!
Comments