Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial | Syed Raza | Skillshare

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)

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

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.

170

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Syed Raza

Web Developer | Entrepreneur-CEO www.claydesk.com

Why are 135,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

Report class