Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial
4.0 (38 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,531 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial to your Wishlist.

Add to Wishlist

Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial

Learn Excel advanced formulas in this hands-on tutorial. Become an expert and show your skills!
4.0 (38 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,531 students enrolled
Last updated 8/2015
English
English
Current price: $10 Original price: $45 Discount: 78% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Brush up on simple formulas before taking this course
Description

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 skillset!

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 2007 and 2010 versions of Microsoft Excel as well. So, enroll now and take your skills to the next level.


Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
03:01:34
+
Course Introduction
2 Lectures 04:24

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.

Preview 02:07
+
Logical Functions
2 Lectures 22:04

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

AND and IF Functions
09:41

IFERROR and XOR Functions
12:23
+
Financial Functions
5 Lectures 58:36

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.

PV and FV Functions
14:59

PMT-PPMT-PRICE-YIELD Functions
11:40


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.

Depreciation Lecture
07:43

SLN-SYD-DB-DDB-VDB Functions
13:46
+
Text Functions
2 Lectures 21:22

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.

TEXT and CONCATENATE Functions
11:09

PROPER-UPPER-LOWER-SUBSTITUTE Functions
10:13
+
Lookup & Reference Function
3 Lectures 35:00
LOOKUP Function Lecture
04:58

Working with Advanced VLOOKUP
12:17

HLOOKUP-INDEX-MATCH Functions
17:45
+
Bonus Section
4 Lectures 37:35
Modifying Existing Templates
11:06

Copying Macros Between Workbooks
04:24

Working with External Data Sources
10:15

Exploring Tracking Changes Feature
11:50
+
Course Conclusion
1 Lecture 02:33
Course Conclusion
02:33
About the Instructor
Syed Raza
4.2 Average rating
1,938 Reviews
83,217 Students
25 Courses
Top Udemy Instructor! 80,000+ students

Why are 80,000+ students (and counting) enrolled in my courses?

1) As the CEO of ClayDesk, I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you gain real world skills and knowledge and change your life today!

3) My dedication to the teaching profession and teaching online. Udemy has named me one of its top instructors.

► Try enrolling in a course with me and see for yourself! ◄

_____________________________________________________________________

Want to learn how to become A Professional Web Developer?

Would you like to  Boost Your Career?

Then Enroll in my Courses Today! You too can be doing this - and so much more!

_____________________________________________________________________

About Syed Raza:

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. ClayDesk provides e-Discovery and cloud computing services including technical training to a wide range of clients globally. 

Business:

Syed Raza is an entrepreneur running his own e-learning site along with providing e-discovery and cloud computing consulting and services to a global client base. Syed is a Microsoft Certified Trainer and a Systems Engineer, and his solid finance and management background gives him a competitive edge. He has taught thousands of students in the United States and continues to inspire students of all ages.

Mission Statement- ClayDesk e-discovery and cloud computing is dedicated to provide superior e-learning and outsourcing services worldwide.

ClayDesk E-learning
4.2 Average rating
1,821 Reviews
81,402 Students
22 Courses
The Knowledge Factory

Welcome! to the Knowledge factory by ClayDesk. My name is Syed Raza, and as the CEO of ClayDesk, I am delighted to provide learning solution to my students. My fellow co-instructors play an important part in building these courses to ensure quality and latest trends in learning - I encourage you to browse through our courses and enroll.

1) We teach with passion and purpose! Every course is delivered with our students in mind. Teaching a combined student population of over 160,000.

2) Our courses will help you gain real world skills and knowledge and change your life today!

3) Our dedication to the teaching profession and teaching online. Udemy has named our instructors as one of its top instructors.

ClayDesk creates and distributes high quality technology training content. Our certified team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Mission Statement- ClayDesk e-learning is dedicated to provide superior e-learning and outsourcing services worldwide.