Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial

ClayDesk

Reed Courses Certificate of Completion

Digital certificate - Included

• Course Introduction 03:59

  • 1: Introduction and about the instructor Preview 01:52
  • 2: What Will I Learn? Preview 02:07

• Logical Functions 22:04

  • 3: AND and IF Functions 09:41
  • 4: IFERROR and XOR Functions 12:23

• Financial Functions 58:35

  • 5: PV and FV Functions 14:59
  • 6: PMT-PPMT-PRICE-YIELD Functions 11:40
  • 7: PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions Preview 10:28
  • 8: Depreciation Lecture 07:43
  • 9: SLN-SYD-DB-DDB-VDB Functions 13:45

• Text Functions 21:22

  • 10: TEXT and CONCATENATE Functions 11:09
  • 11: PROPER-UPPER-LOWER-SUBSTITUTE Functions 10:13

• Lookup & Reference Functions 35:00

  • 12: LOOKUP Function Lecture 04:58
  • 13: Working with Advanced VLOOKUP 12:17
  • 14: HLOOKUP-INDEX-MATCH Functions 17:45

• Additional Learning Resources 37:35

  • 15: Modifying Existing Templates 11:06
  • 16: Copying Macros Between Workbooks 04:24
  • 17: Working with External Data Sources 10:15
  • 18: Exploring Tracking Changes Feature 11:50

• Conclusion 02:37

  • 19: Course Conclusion 02:37

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.

Here's the good news

I have designed this practical course 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

I have included few bonus tutorials at the end of the course as well:

1. Modifying templates and styles

2. Copying macros between workbooks

3. Working with external data

4. Tracking changes in Excel 2013

The entire objective of this course is to dive deep into the Excel 2013 environment with regards to formulas in in order to make you more productive, efficient, and achieve a greater skill set

To top it off: If you would like me to explain a particular formula of your choice, I would be delighted to create a hands-on tutorial just for you

With that said, this course will enhance your comfort level working with advanced formulas in Excel 2013. The concepts learned in this course apply to Excel 2010, and 2016 versions of Microsoft Excel as well. So, enroll now and take your skills to the next level.

Join thousands of happy students!

See you in class

Syed and Team ClayDesk

• This tutorial is designed for Excel power users, and for those who are up to the challenge! It is not for students who are beginning to learn Microsoft Excel

• Brush up on simple formulas before taking this course

Currently there are no Q&As for this course. Be the first to ask a question.