Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial Premium class

Syed Raza, Web Developer | Entrepreneur-CEO www.claydesk.com

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
19 Videos (3h 2m)
    • Abouttheinstructor HB

      2:17
    • Whatwillilearn final HB

      2:07
    • Logical AND and IF formula HB

      9:43
    • Logical IFERROR and XOR formula FULL AND FINAL6 HB

      12:23
    • PV and FV formula HB

      14:59
    • PMT PPMT PRICE YIELD formulas HB

      11:40
    • PRICE ACCRINT ACCRINTM COUPONDAYS REAL WORLD BOND EVALUATION HB

      10:28
    • DEPRECIATION Lecture HB

      7:43
    • SLN SYD DB DDB VDB Depreciation formulas HB

      13:46
    • TEXT and CONCATENATION formula HB

      11:09
    • PROPER UPPER LOWER case and SUBSTITUTE formula final HB

      10:13
    • LOOKUP VLOOKUP HLOOKUP MATCH INDEX Formulas Lecture slides HB

      4:58
    • LOOKUP VLOOKUP HLOOKUP MATCH INDEX Formulas Tutorial HB

      12:17
    • HLOOKUP MATCH INDEX Formulas Tutorial HB

      17:45
    • Modifying templates HB

      11:06
    • Copying macros between workbooks HB

      4:24
    • External data HB

      10:15
    • Tracking changesnew HB

      11:50
    • Conclusion final final HB

      2:33

About This Class

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!

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.

5 of 5 students recommendSee All

Super course! Very focused course and to the point. Only now I understand the difference between VLOOKUP and HLOOKUP function. Thanks Syed.
Excellent course!! Syed does a great job in demonstrating Excel formulas using real world examples.
Sami Shah

Avid Learner!

135

Students

--

Projects

Syed Raza

Web Developer | Entrepreneur-CEO www.claydesk.com

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

1) 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?

Or maybe acquire new skills.

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. Highly motivated and goal oriented professional, with over 20 years of combined experience in the fields Law, Management, and IT, Syed also focuses on e-discovery issues in complex civil litigation. As a trial attorney with significant experience in matters relating to patent infringement, defense and prosecution in the pharmaceutical industry, contracts disputes, real estate, criminal matters, and international human rights law. Syed provides guidance and counsel to attorneys and clients on all aspects of discovery, including information management, data preservation and collection, early case assessment, comprehensive managed review and production.

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