Set as Homepage|Bookmark
 

Thank you Download
Need helps Supports me

 
» » STONE RIVER ELEARNING Top 25 Excel Formulas-OXBRiDGE
Advertise

STONE RIVER ELEARNING Top 25 Excel Formulas-OXBRiDGE

STONE RIVER ELEARNING Top 25 Excel Formulas-OXBRiDGE

STONE RIVER ELEARNING Top 25 Excel Formulas-OXBRiDGE
English | Size: 1.05 GB
Category: Tutorial

The old 80/20 rule for software-that 80% of a program's users use only 20% of a program's features-doesn't apply to Microsoft Excel. Instead, this program probably operates under what could be called the 95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program's power!
On the other hand, most people know that they could be getting more out of Excel if they could only get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated, shrouded as it is in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

This practical course is designed to give you the ability to master the Top 25 Microsoft Excel formulas with real world examples, by demystifying the building of worksheet formulas, and presenting the most useful Excel functions in an accessible and jargon-free manner. In this tutorial, you will be able to learn important functions such as:

Financial
Logical
Text
Lookup & Reference, and many more

Class Curriculum

Course Introduction
Introduction and About the Instructor 00:02:14
What will I Learn? 00:02:07
Logical Functions
AND and IF Functions 00:09:41
IFERROR and XOR Functions 00:12:24
Financial Functions
PV and FV Functions 00:14:59
PMT-PPMT-PRICE-YIELD Functions 00:11:40
PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions 00:10:29
Depreciation 00:07:44
SLN-SYD-DB-DDB-VDB Functions 00:13:46
Text Functions
TEXT and CONCATENATE Functions 00:11:10
PROPER-UPPER-LOWER-SUBSTITUTE Functions 00:10:13
Lookup & Reference Function
LOOKUP Function Lecture 00:04:58
Working with Advanced VLOOKUP 00:12:17
HLOOKUP-INDEX-MATCH Functions 00:17:45
Bonus Selection
Modifying Existing Templates 00:11:07
Copying Macros Between Workbooks 00:04:24
Working with External Data Sources 00:10:16
Exploring Tracking Changes Feature 00:11:51
Course Conclusion
Course Conclusion 00:02:37
Download link:

Buy Premium To Support Me & Get Resumable Support & Max Speed:





Links are Interchangeable - Single Extraction - Premium Download To Resumable:
Dear visitor, you are browsing our website as Guest.
We strongly recommend you to register and login to view hidden contents.

Comments:

Add Comment