Instant access

19 Lessons

3 Hours

Certified Course
Course never expires
Complete on multiple devices
Courses receive accredited certificate

Top 25 Excel Advanced Formulas

Top 25 Excel Advanced Formulas - Online Course

Course Overview

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.
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

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 skillset.
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 2007 and 2010 versions of Microsoft Excel as well.
So, enroll now and take your skills to the next level.
logo-1-1024x1024This Course has been approved by the International eLearning Standards


 


Course Overview

Module 1 - Course Introduction


Lesson 1: Introduction and About the Instructor - FREE!
Free Introduction and Learn about the Instructor
Lesson 2: What Will I Learn? FREE!
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.

Module 2 - Logical Functions


Lesson 1: AND and IF Functions
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
Lesson 2: IFERROR and XOR Functions
In this lesson we will look at IFERROR and XOR formulas

Module 3 - Financial Functions


Lesson 1: PV and FV Functions
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.
Lesson 2: PMT-PPMT-PRICE-YIELD Functions
In this lesson we will look at PMT, PPMT, PRICE and YIELD functions
Lesson 3: PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions
In this lesson we will look at PRICE, COUPONDAYS, ACCRINT and ACCRINTM functions
Lesson 4: Depreciation Lecture
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.
Lesson 5: SLN-SYD-DB-DDB-VDB Functions
In this lesson we will look at SLN, SYD, DB, DDB and VDB functions

Module 4 - Text Functions


Lesson 1: TEXT and CONCATENATE Functions
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.
Lesson 2: PROPER-UPPER-LOWER-SUBSTITUE Functions
In this lesson we will look at PROPER, UPPER, LOWER and SUBSTITUTE functions

Module 5 - Lookup and Reference Function


Lesson 1: LOOKUP Function Lecture
This is a lecture on the LOOKUP function
Lesson 2: Working with Advanced VLOOKUP
In this lesson we will look at Advanced VLOOKUP
Lesson 3: HLOOKUP-INDEX-MATCH Functions
In this lesson we will look at HLOOKUP, INDEX and MATCH Functions

Module 6 - Bonus Section


Lesson 1: Modifying Existing Templates
In this lesson we will look at modifying existing templates
Lesson 2: Copying Macros Between Workbooks
In this lesson we will look at copying Macros between Workbooks
Lesson 3: Working with External Data Sources
In this lesson we will look at working with external data sources
Lesson 4: Exploring Tracking Changes Feature
In this lesson we will explore the tracking changes feature

Module 7 - Course Conclusion


Lesson 1: Course Conclusion
Course conclusion

What are the requirements?
- Brush up on simple formulas before taking this course

What am I going to get from this course?
- Over 19 lectures and 3 hours of content
- Master top 25 advanced formulas in Excel
- Confidently work within the Excel environment
- Increase operational efficiency
- Learn using real world examples
- Become proficient in building Excel formulas using 19 tutorials with over 3 hours of hands-on tutorials

What is the target audience?
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


Instructor

412299_e4df_12Syed Raza
- BBA in Finance University of Wisconsin
- MBA Concordia University
- LLB, DBL degree University Law College
- PhD Management Sciences
- MCSE (Microsoft Certified Systems Engineer)
- MCP+I (Microsoft Certified Professional + Internet)
- MCT (Microsoft Certified Trainer)

 

About Syed
Syed graduated from University of Wisconsin in 1995 with a BBA in Finance. Subsequently, he obtained an MBA from Concordia University, LLB and DBL degrees from University Law College, and PhD in Management Sciences.
Having obtained MCSE (Microsoft Certified Systems Engineer), MCP+I (Microsoft Certified Professional + Internet), and MCT (Microsoft Certified Trainer), Syed has provided training to thousands of students.
Read More

Great Course

5 5 1
Great formulas Great Course

Good All Round Course

4 5 1
Good All Round Course

Highly Recommend

5 5 1
This is a great course to learn about the key advanced formulas and very well explained by Dr. Syed. Very personal approach to teaching this tutorial with some great real world examples. Would definitely recommend this course.

Thumbs Up!

5 5 1
Thumbs up for this course. The instructor's teaching methodology was great, especially for this expert level course. A practical course and highly recommended. The course content is perfectly aligned with learning real world skills. This is a 'must take' course. Thanks.

Easy to follow, Great formulas

5 5 1
I just love the step-by-step instruction. This makes it very easy for me to understand and follow. I can see myself applying the concepts within my current projects. The pace of the course is perfect, and the instructor delivered the course in a professional manner.

Useful Course

5 5 1
I find it useful, Thanx!
Name
Review Title
Rating
Review Content
Top 25 Excel Advanced Formulas Overall rating: ★★★★★ 4.8 based on 6 reviews
5 1

Single payment of $199