[ WebToolTip.com ] Udemy - Microsoft Excel - Master Formulas, Functions, and Data Tools

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/1 - Understanding the Excel Interface and Formula Bar.mp4

52 MB

~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/2 - Basic Arithmetic Operations (+, -, , ).mp4

39 MB

~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/3 - Using Cell References (Relative, Absolute, Mixed References).mp4

43 MB

~Get Your Files Here !/1 - Introduction to Excel Formulas and Functions/4 - Order of Operations in Excel Formulas.mp4

53 MB

~Get Your Files Here !/2 - Essential Functions for Everyday Use/1 - SUM, AVERAGE, COUNT, MIN, MAX Functions.mp4

45 MB

~Get Your Files Here !/2 - Essential Functions for Everyday Use/2 - Date and Time Functions (TODAY, NOW, DATEDIF, YEAR, MONTH, DAY).mp4

45 MB

~Get Your Files Here !/2 - Essential Functions for Everyday Use/3 - Logical Functions (IF, AND, OR, NOT).mp4

63 MB

~Get Your Files Here !/3 - Lookup and Reference Functions/1 - Combining INDEX and MATCH for Flexible Lookups.mp4

34 MB

~Get Your Files Here !/3 - Lookup and Reference Functions/2 - Handling Errors with ISERROR and IFERROR.mp4

31 MB

~Get Your Files Here !/4 - Data Analysis with Statistical Functions/1 - COUNTIF, SUMIF, AVERAGEIF, and Their Plural Counterparts (COUNTIFS, SUMIFS, AVER.mp4

61 MB

~Get Your Files Here !/4 - Data Analysis with Statistical Functions/2 - RANK, LARGE, SMALL, and PERCENTILE Functions.mp4

32 MB

~Get Your Files Here !/4 - Data Analysis with Statistical Functions/3 - Analyzing Trends with TREND and FORECAST Tunctions.mp4

46 MB

~Get Your Files Here !/5 - Working with Arrays and Dynamic Arrays/1 - Introduction to Array Formulas.mp4

29 MB

~Get Your Files Here !/5 - Working with Arrays and Dynamic Arrays/2 - Dynamic Arrays and Spill Behavior (New Feature in Excel 3652021).mp4

58 MB

~Get Your Files Here !/5 - Working with Arrays and Dynamic Arrays/3 - Functions Like FILTER, SORT, UNIQUE, SEQUENCE, and RANDARRAY.mp4

58 MB

~Get Your Files Here !/5 - Working with Arrays and Dynamic Arrays/4 - Practical Use Cases for Dynamic Arrays.mp4

62 MB

~Get Your Files Here !/6 - Advanced Techniques and Nested Functions/1 - Nesting Multiple Functions Within One Formula.mp4

54 MB

~Get Your Files Here !/6 - Advanced Techniques and Nested Functions/2 - Using Conditional Formatting With Formulas.mp4

51 MB

~Get Your Files Here !/6 - Advanced Techniques and Nested Functions/3 - Advanced Logical Functions (IFS, SWITCH).mp4

71 MB

~Get Your Files Here !/6 - Advanced Techniques and Nested Functions/4 - Error Handling with ISNUMBER, ISBLANK, and CHOOSE.mp4

39 MB

~Get Your Files Here !/7 - Financial and Engineering Functions/1 - PMT, IPMT, PPMT For Loan Calculations.mp4

36 MB

~Get Your Files Here !/7 - Financial and Engineering Functions/2 - NPV, IRR, and XIRR for Investment Analysis.mp4

33 MB

~Get Your Files Here !/7 - Financial and Engineering Functions/3 - CONVERT Function for Unit Conversions.mp4

40 MB

~Get Your Files Here !/7 - Financial and Engineering Functions/4 - Goal Seek and Solver Add-ins for Optimization Problems.mp4

45 MB

~Get Your Files Here !/Bonus Resources.txt

70 B