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
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
Buy Premium To Support Me & Get Resumable Support & Max Speed: