1 ) Advanced Microsoft Excel Formulas & Functions - 2021
What you'll learn
What Are the Different Among RELATIVE, ABSOLUTE AND MIXED REFERENCE?
How To Use RELATIVE, ABSOLUTE AND MIXED REFERENCES?
How To Create The MULTIPLICATION TABLE By Using Mixed Reference?
How To Add The Zeros In Microsoft Excel?
How To Generate AUTOMATIC SERIAL NUMBERS In Microsoft Excel?
How To Use The CONVERT Function?
How To Use WORKDAY AND WORKDAYINTL Functions?
How To Use RAND Function?
How To Use RANDBETWEEN Function?
How To Use AUTOSUM Function?
How To Use VLOOKUP Function?
How To Use HLOOKUP Function?
How To Manage Stocks & Stores By Using Hlookup Function?
How To Use CHOOSE Function?
How To Use TRANSPOSE Function?
How To Use RANK Function?
How To Use COUNTBLANK Function?
How To Use INDEX AND MATCH Functions?
How To Convert Numbers To Words?
How To Create Data Entry Form In Excel?
Requirements
Microsoft Office Software Installed
No prior Excel knowledge is needed.
Who this course is for:
Excel users both inexperienced and experienced who don't feel confident about Microsoft Excel Advanced formulas and Functions
Anyone who uses Excel for work or personal needs such as Sales Manager, Students, Individual, Accountants ,Auditor, Financial Analyst, Information Clerk
Anyone who work with Excel for Entering data,Extract data, lists, formulas and functions
2 ) Excel Microsoft Excel - 5 Levels Mastery Course 19+ hours
What you'll learn
Master Excel From Scratch From Beginner To Advanced Levels Having 5 Levels Of Proficiency
Impress Your Boss And Peers By Unleashing The True Power Of Excel
Be Proficient In Working With Formulas And Functions In Excel
Create Mind Blowing Charts, Visualization Features & Integrate Them Into Your Worksheet
Efficiently Analyze And Manage Excel Data : Implement Conditional Analysis, Pivot tables , Data Validation Techniques Seamlessly
Tap Into In Depth Features Of Power Query , Power Pivot : Generate Robust Reporting Solutions
Have Full Access To An Excel Trainer with over 15 years of experience
Requirements
Just a zeal to learn.
However If You Don't Have Excel Also You Can Get Started, I Will Tell You How To Use Latest Excel Version For Free Online So That You Don't Have To Pay A Single Penny. Check The Preview First And You Shall Know Of It !!
Who this course is for:
This Course Has 5 Levels Of Excel Proficiency.
If You Want To Transform Your Excel Skills From Beginner To Advanced And Even Beyond, Then This Course Is Just Right For You
Excel Users Who Have Basic Skills And Want To Develop Their Skills Further
Students Looking Out For Extraordinary Interactive Hands On Approach For Advanced Excel Skills Training
Professionals Looking To Pursue Career In Business Intelligence, Data Science, Financial Modelling & Advisory , Investment Banking
No Prior Knowledge Is Required !!..
Post a Comment