Microsoft Excel - Advanced Formulas And Functions
- Offered byUDEMY
Microsoft Excel - Advanced Formulas And Functions at UDEMY Overview
Duration | 6 hours |
Total fee | ₹449 |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Excel - Advanced Formulas And Functions at UDEMY Highlights
- Certificate of completion
- Full lifetime access
- Access on mobile and TV
- 30-Day Money-Back Guarantee
Microsoft Excel - Advanced Formulas And Functions at UDEMY Course details
- Intermediate To Advanced Users
- Take Your Excel Skills To The Next Level
- This course will teach Infinite Skills beyond the basics of Excel, and how to use the advanced formulas and functions in this spreadsheet program by Microsoft
- This course is designed for users that already have a basic working knowledge of Excel
- In this course students will explore extended formula usage with 3D referencing, naming cells and absolute referencing
Microsoft Excel - Advanced Formulas And Functions at UDEMY Curriculum
Welcome
Important Excel Working Files
How Advance is Advanced
Getting the Basics Right
Referencing Entire Rows/Columns
Excel - Function Processing Order
Extend Your Formulae Usage
Naming Cells To Improve Formula Appearance
Excel - 3D Referencing
If And If Type Functions
Using The And, Or, And Not Functions Within If
Count If, Sum If, And Average If
Look Up And Reference Type Functins
Nearest Match With VLookup
Nested Lookup Functions
Mathematical Functions
Generating Random Numbers And Values In Excel
Password Generating Workbooks
Statistics
The Middle Value With Median
Ranking Data Without Sorting
Text Functions
Locating Data With Find, Search, Exact
Use Trim And Clean To Remove Unwanted Gaps
Date And Time Functions
Locating Data With Find, Search, Exact
Use Trim And Clean To Remove Unwanted Gaps
Information And Referencing functions
Extracting Information With Cell And Info Functions
Using IsBlank, IsOdd, IsEven, IsText, And IsNumber
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?