xREL.v3

University of OXford & University of camBRiDGE

...is a collective term for characteristics that the two institutions share.

Top 25 Excel Formulas

by Syed Raza
Publisher: Stone River eLearning
Release Date: May 2019
ISBN: 10000SRESR06

Lecture Size: 23x50
Lecture Date: 05.2019

Lecture Link: www.oreilly.com | www.stoneriverelearning.com

| 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

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