Top 25 Microsoft Excel Advanced Formulas Hand On Tutorial
Learn Excel 2013 advanced formulas in this hands-on tutorial. Become an expert and show your skills
Last updated 2022-01-10 | 3.4
- Master top 25 advanced formulas in Excel- Confidently work within the Excel environment
- Increase operational efficiency
What you'll learn
* Requirements
* Brush up on simple formulas before taking this courseDescription
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:
Modifying templates and styles
Copying macros between workbooks
Working with external data
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
Who this course is for:
- 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
Course content
7 sections • 19 lectures
Introduction and About the Instructor Preview 02:17
In this lecture you will learn about the course structure and instructor
What will I Learn? Preview 02:07
This course is designed to provide hands-on experience in understanding the top 25 useful formulas in Microsoft Excel. Tutorials also contain real world examples and scenarios.
AND and IF Functions Preview 09:41
One common use for the AND function is to expand the usefulness of other functions that perform logical tests. Similarly, the IF function tests to see if a specified condition - the logic test - is true or false
IFERROR and XOR Functions Preview 12:23
PV and FV Functions Preview 14:59
The Present Value or PV function allows the user in determining the current value of a financial asset. For instance, analysts can value a stock by forecasting its future profits, or cash flows, and discounting them back to today to get a current, or present value, for the stock. Likewise, Future Value of FV simply returns the future value of an investment based on periodic, constant payments and a constant interest rate.
PMT-PPMT-PRICE-YIELD Functions Preview 11:40
PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions Preview 10:28
Depreciation Lecture Preview 07:43
Depreciation, in accounting terms, is a noncash expense that reduces the value of an asset as a result of wear and tear, age, or obsolescence. Most assets lose their value over time (in other words, they depreciate), and must be replaced once the end of their useful life is reached. This lecture explains the concept of depreciation as well various types of depreciation utilized for assets.
SLN-SYD-DB-DDB-VDB Functions Preview 13:46
TEXT and CONCATENATE Functions Preview 11:09
TEXT function is especially useful when you want to embed the numeric output of a formula or function and present it in a particular format inside other text. For example, "Sales last year increased by over $55,878", where the number 55878 has been formatted to reflect currency symbol and thousands separator. The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items.
PROPER-UPPER-LOWER-SUBSTITUTE Functions Preview 10:13
LOOKUP Function Lecture Preview 04:58
In this section you will learn Microsoft Excel advanced LOOKUP and REFERENCE functions
Working with Advanced VLOOKUP Preview 12:17
HLOOKUP-INDEX-MATCH Functions Preview 17:45
In this lecture you will learn additional functions such as HLOOKUP, INDEX, and MATCH
Modifying Existing Templates Preview 11:06
In this lecture you will learn how to modify exiting templates
Copying Macros Between Workbooks Preview 04:24
In this lecture you will learn how to copy macros in excel between workbooks
Working with External Data Sources Preview 10:15
In this lecture you will learn how to work with external data sources
Exploring Tracking Changes Feature Preview 11:50
In this lecture you will will how to explore and track changes feature in Excel
Course Conclusion Preview 02:33
This is the course recap