Udemy - Microsoft Excel - Master Formulas, Functions, and Data To...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Excel Formulas and Functions
• 1 - Understanding the Excel Interface and Formula Bar.mp4 (52.3 MB)
• 2 - Basic Arithmetic Operations (+, -, , ).mp4 (38.6 MB)
• 3 - Using Cell References (Relative, Absolute, Mixed References).mp4 (42.9 MB)
• 4 - Order of Operations in Excel Formulas.mp4 (52.7 MB)
2 - Essential Functions for Everyday Use
• 1 - SUM, AVERAGE, COUNT, MIN, MAX Functions.mp4 (44.7 MB)
• 2 - Date and Time Functions (TODAY, NOW, DATEDIF, YEAR, MONTH, DAY).mp4 (44.6 MB)
• 3 - Logical Functions (IF, AND, OR, NOT).mp4 (63.0 MB)
3 - Lookup and Reference Functions
• 1 - Combining INDEX and MATCH for Flexible Lookups.mp4 (34.2 MB)
• 2 - Handling Errors with ISERROR and IFERROR.mp4 (30.7 MB)
4 - Data Analysis with Statistical Functions
• 1 - COUNTIF, SUMIF, AVERAGEIF, and Their Plural Counterparts (COUNTIFS, SUMIFS, AVER.mp4 (61.2 MB)
• 2 - RANK, LARGE, SMALL, and PERCENTILE Functions.mp4 (32.2 MB)
• 3 - Analyzing Trends with TREND and FORECAST Tunctions.mp4 (45.8 MB)
5 - Working with Arrays and Dynamic Arrays
• 1 - Introduction to Array Formulas.mp4 (28.6 MB)
• 2 - Dynamic Arrays and Spill Behavior (New Feature in Excel 3652021).mp4 (58.4 MB)
• 3 - Functions Like FILTER, SORT, UNIQUE, SEQUENCE, and RANDARRAY.mp4 (57.8 MB)
• 4 - Practical Use Cases for Dynamic Arrays.mp4 (62.5 MB)
6 - Advanced Techniques and Nested Functions
• 1 - Nesting Multiple Functions Within One Formula.mp4 (53.9 MB)
• 2 - Using Conditional Formatting With Formulas.mp4 (51.2 MB)
• 3 - Advanced Logical Functions (IFS, SWITCH).mp4 (71.2 MB)
• 4 - Error Handling with ISNUMBER, ISBLANK, and CHOOSE.mp4 (38.7 MB)
7 - Financial and Engineering Functions
• 1 - PMT, IPMT, PPMT For Loan Calculations.mp4 (35.6 MB)
• 2 - NPV, IRR, and XIRR for Investment Analysis.mp4 (32.9 MB)
• 3 - CONVERT Function for Unit Conversions.mp4 (39.7 MB)
• 4 - Goal Seek and Solver Add-ins for Optimization Problems.mp4 (44.9 MB)
• Bonus Resources.txt (0.1 KB)