Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial

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.

7 of 7 students recommendSee All

Syed speaks slowly and clearly. He covers a lot of good material in this course. Not all of it was applicable to my work, I don't work in Finance/Accounting, but I definitely learned some new tricks! Thanks, Syed!
Super course! Very focused course and to the point. Only now I understand the difference between VLOOKUP and HLOOKUP function. Thanks Syed.

158

Students

--

Projects

Syed Raza

Web Developer | Entrepreneur-CEO www.claydesk.com

Why are 85,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! ?

_____________________________________...

See full profile