Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial (Udemy.com)
Learn Excel 2013 advanced formulas in this hands-on tutorial. Become an expert and show your skills
Created by: Syed Raza
Last updated August 2015
What you will 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
- VLookup, HLookup, Date & Time and much more
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating3.8 out of 5among the lower-rated ones
- Reviews190#306 of 356 by number of reviews
- Length3 hoursshorter than 74% of them
- Last updatedAugust 2015earlier than 97% of them
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:
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
Instructor Details
- 3.8 Rating
190 Reviews
Syed Raza
"You’re big on Udemy. Top 10% most engaging instructors BIG. Which means students can’t get enough of your courses. That kind of impact means you’re the reason students start new careers, get promotions, or try something new that brightens their day. Your success is well deserved" Frank Visciano - VP, Marketplace Content, The Udemy Team
Hello, my name is Syed Raza and I am passionate about teaching valuable skills to students who are motivated to learn! My goal is to help you easily achieve your goals and objectives, whether that means enhancing your existing skill set, gain productivity at workplace, differentiate yourself, learning the new technological skills that are required to improve your career.
Over the last 20 years, I have acquired valuable skill sand experience that allow me to provide you with great learning experience. I have numerous technical IT and developer certifications (AWS, MCSE+I, MCT, CCNA—including a PhD which enable me to teach a variety of powerful courses, from IT to Project Management.
Providing technical and training solutions using AWS, Azure, Google Cloud, Red Hat OpenShift, Python, Java, JavaScript, React JS, GCP, Kubernetes, Jenkins, Ansible, and Docker
More courses by Syed Raza
NEW AWS Certified Solutions Architect - Associate (2024)
4.2 (3,038 Reviews)
Provider: Udemy
Time: 13.3h
$94.99
Microsoft PowerApps & Flow: Build Business Apps Without Code (2020)
4.1 (1,888 Reviews)
Provider: Udemy
Time: 4.1h
$15.99
DevOps Fundamentals: Gain Solid Understanding (2021)
4.0 (896 Reviews)
Provider: Udemy
Time: 2.7h
$11.99
The Complete DevOps Engineer Course 2.0 - Java & Kubernetes (2023)
4.1 (380 Reviews)
Provider: Udemy
Time: 14.6h
$89.99
Red Hat OpenShift With Jenkins: DevOps For Beginners (2020)
3.9 (335 Reviews)
Provider: Udemy
Time: 5.7h
$49.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Jose Castro on 1/26/2022
ejemplos demasiado absurdos
By Shardul on 5/29/2021
the content was not up to the mark expected a lot more! The content was titled advance excel but hardly any new formulae were discussed!
By Joseph A Bergeron on 1/5/2018
The amount of formulas covered is great for the price i paid. The bonus is a yahoo! Thanks all at Udemy. Joe B.
By Apparao Neeli on 11/28/2017
It is good class and I learn short cuts are learn from these videos
By Jonatan on 11/26/2017
The experience was good, I KNEW BIT OF EXCEL BUT THE VIDEOS AND TEACHING GAVE PRECISED AND IN DEPTH KNOWLEDGE. Thanks to UDEMY
By Ashwin Gour on 11/26/2017
It was a great learning experience, it helped me to gain more knowledge and i came across many new options and tools, thanks to Udemi
By Syed Huq on 11/26/2017
The IFERROR was not a good example, since it was already showing an error to being with (!DIV/0). You need to find an example where you don't know IF there could be an ERROR then let the formula find it for you.
By Jennifer Lötje on 6/26/2017
Eine Formel (Match) hat bei mir nicht funktioniert, sonst war der Kurs super. Sehr gut verständlich und hilfreich
By Anja Zemlin on 6/26/2017
This is not for advanced users. Just a very long overview of the excel functions.
By Melissa on 6/11/2016
Excellent course! And to the point instruction. Practical aspects of using Excel formulas were shown. I learned some great tips and techniques especially with the VLOOKUP and HLOOKUP functions. Thanks.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 76 / 100












