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 ExcelCreate and open WorkbookCreate New WorksheetsTabs and Ribbon
Save Data
Save Workbook in your PC
Errors Functions
#VALUE!, #DIV/0!, #NAME?, #N/A#REF!, ###, #NULL!, #NUM!
Logical Function
AND() FunctionsOR() FunctionsNOT() FunctionsXOR() FunctionsSWITCH() FunctionsCELL() FunctionsROW() Functions
Conditional Functions
IF() FunctionsIFS() FunctionsNesting IF() FunctionsUse IF function to calculate letter grades in ExcelUse IFS function to calculate letter grades in Excel
Filter Function
How to use Filter Function in Excel
DATE Function
DATE() FunctionDATEIF() FunctionEDATE FunctionEOMONTH FunctionTODAY and NOW Function
Mathematical Function
Count FunctionRound FunctionSum FunctionAverage FunctionSubtotal FunctionHow to generate Subtotal With GrandtotalPower FunctionMod FunctionINT & TRUNC FunctionMIN() and MAX() Function
Text Function
Find, Search and ReplaceLEN FunctionMID FunctionREPT FunctionSPLIT FunctionTRIM FunctionShow gridlines
LOOKUP Functions
INDEX FunctionMATCH FunctionEXACT FunctionVLOOKUP APPROXIMATE MATCH FunctionVLOOKUP FunctionHLOOKUP FunctionXLOOKUP 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 ListDependent dropdown List
Charts & Graphs
How to Create Charts & Graphs
Pivot Tables
How to Use Pivot Tables
Sorting and Filtering
Sort FunctionFilter Function
Flash Fill
Merge and Separate data using flash fill
Panes
Freeze panesSplit panes
Multiple worksheets and workbooks
Rename and Color WorksheetsAdd and Delete WorksheetsHide and Unhide WorksheetsMove and Copy WorksheetsWorksheet Groups
Share and Collaborate
Protect WorksheetProtect WorkbookSharing Excel Workbook with Multiple Users
Page Size
Headers and footersPage settingsPage break view
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!
