DesireCourse Net Udemy - Microsoft Excel - Advanced Excel Formulas & Functions

1. 01 Getting Started/001 Course Structure Outline.mp428.62MB
2. 01 Getting Started/004 Setting Expectations.mp424.5MB
3. 02 Excel Formulas 101/005 Introduction Excel Formulas 101.mp46.21MB
4. 02 Excel Formulas 101/006 Excel Formula Syntax.mp4114.41MB
5. 02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed Relative References.mp450.69MB
6. 02 Excel Formulas 101/008 Common Excel Error Types.mp453.41MB
7. 02 Excel Formulas 101/009 Formula Auditing Trace Precedents Dependents.mp480.39MB
8. 02 Excel Formulas 101/010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp453.12MB
9. 02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.mp489.35MB
10. 02 Excel Formulas 101/012 Saving Time with Function Shortcuts.mp4103.67MB
11. 02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.mp449.14MB
12. 02 Excel Formulas 101/014 PRO TIP Creating Drop-Down Menus with Data Validation.mp444.03MB
13. 02 Excel Formulas 101/015 Congrats Youre a Developer.mp433.88MB
14. 02 Excel Formulas 101/016 HOMEWORK Excel Formulas 101.mp44.68MB
15. 03 Conditional Statements Logical Operators/017 Introduction.mp46.24MB
16. 03 Conditional Statements Logical Operators/018 Anatomy of the IF Statement.mp416.86MB
17. 03 Conditional Statements Logical Operators/019 Nesting Multiple IF Statements.mp416.03MB
18. 03 Conditional Statements Logical Operators/020 Adding Conditional ANDOR Operators.mp428.21MB
19. 03 Conditional Statements Logical Operators/021 Using NOT Conditionals.mp411.36MB
20. 03 Conditional Statements Logical Operators/022 Fixing Errors with IFERROR.mp420.08MB
21. 03 Conditional Statements Logical Operators/023 Common IS Statements.mp420.92MB
22. 03 Conditional Statements Logical Operators/024 HOMEWORK Excel Logical Operators.mp41.84MB
23. 04 Common Excel Statistical Functions/025 Introduction.mp46.31MB
24. 04 Common Excel Statistical Functions/026 Basic Excel Statistical Functions.mp414.75MB
25. 04 Common Excel Statistical Functions/027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp454.26MB
26. 04 Common Excel Statistical Functions/028 Randomization with RAND() RANDBETWEEN.mp46.31MB
27. 04 Common Excel Statistical Functions/029 Row-Level Calculation with SUMPRODUCT.mp410.59MB
28. 04 Common Excel Statistical Functions/030 DEMO Calculating Shipping Costs with SUMPRODUCT.mp431.27MB
29. 04 Common Excel Statistical Functions/031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.mp414.14MB
30. 04 Common Excel Statistical Functions/032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.mp423.59MB
31. 04 Common Excel Statistical Functions/033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp473.13MB
32. 04 Common Excel Statistical Functions/034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp495.3MB
33. 04 Common Excel Statistical Functions/035 HOMEWORK Excel Stats Functions.mp41.82MB
34. 05 Lookup Reference Functions/036 Introduction.mp47.23MB
35. 05 Lookup Reference Functions/037 Working with Named Ranges.mp411.31MB
36. 05 Lookup Reference Functions/038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.mp49.55MB
37. 05 Lookup Reference Functions/039 Introduction to VLOOKUPHLOOKUP.mp451.78MB
38. 05 Lookup Reference Functions/040 Joining Data with VLOOKUP.mp481.83MB
39. 05 Lookup Reference Functions/041 Fixing Errors with IFERROR VLOOKUP.mp415.19MB
40. 05 Lookup Reference Functions/042 VLOOKUP Reference Array Options.mp440.16MB
41. 05 Lookup Reference Functions/043 Approximate Match Lookups.mp446.41MB
42. 05 Lookup Reference Functions/044 Navigating Cell Ranges with INDEX.mp46.15MB
43. 05 Lookup Reference Functions/045 Matching Text Values with MATCH.mp49.22MB
44. 05 Lookup Reference Functions/046 Combining INDEX MATCH to Dynamically Search Ranges.mp423.72MB
45. 05 Lookup Reference Functions/047 Combining MATCH VLOOKUP for More Flexible Lookups.mp426.64MB
46. 05 Lookup Reference Functions/048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp418.5MB
47. 05 Lookup Reference Functions/049 SNEAK PEEK XLOOKUP (Office 365 Only).mp419.87MB
48. 05 Lookup Reference Functions/050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4172.49MB
49. 05 Lookup Reference Functions/051 Selecting List Items with CHOOSE.mp480.25MB
50. 05 Lookup Reference Functions/052 Defining Ranges with OFFSET.mp46.91MB
51. 05 Lookup Reference Functions/053 Combining OFFSET with COUNTA to Create a Flexible Range.mp47.77MB
52. 05 Lookup Reference Functions/054 PRO TIP Using OFFSET to Create Interactive Charts.mp430.3MB
53. 05 Lookup Reference Functions/055 HOMEWORK Excel Lookup Reference Functions.mp42.83MB
54. 06 Text Functions/056 Introduction.mp44.04MB
55. 06 Text Functions/057 Capitalization with UPPER LOWER PROPER TRIM.mp421.17MB
56. 06 Text Functions/058 Combining Text with CONCATENATE ().mp423.63MB
57. 06 Text Functions/059 Extracting Strings with LEFT MID RIGHT LEN.mp416.94MB
58. 06 Text Functions/060 Converting Text to Values with TEXT VALUE.mp455.38MB
59. 06 Text Functions/061 Searching Text String with SEARCH FIND.mp431.06MB
60. 06 Text Functions/062 Categorizing Data with IF(ISNUMBER(SEARCH)).mp433.61MB
61. 06 Text Functions/063 Combining RIGHT LEN and SEARCH.mp441.87MB
62. 06 Text Functions/064 Replacing Text with SUBSTITUTE.mp49.79MB
63. 06 Text Functions/065 HOMEWORK Excel Text Functions.mp42.55MB
64. 07 Date Time Functions/066 Introduction.mp410.91MB
65. 07 Date Time Functions/067 Understanding Excel Date Syntax with DATEVALUE.mp413.96MB
66. 07 Date Time Functions/068 Formatting Dates Filling Date Series.mp48.64MB
67. 07 Date Time Functions/069 Creating Real-Time Functions with TODAY NOW.mp45.4MB
68. 07 Date Time Functions/070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.mp47.88MB
69. 07 Date Time Functions/071 Calculating the Month Start or End with EOMONTH.mp413.07MB
70. 07 Date Time Functions/072 Calculating of Year with YEARFRAC.mp45.76MB
71. 07 Date Time Functions/073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp455.27MB
72. 07 Date Time Functions/074 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp410.11MB
73. 07 Date Time Functions/075 DEMO Building a Simple Budget Pacing Tool.mp426.1MB
74. 07 Date Time Functions/076 HOMEWORK Excel Date Time Functions.mp41.36MB
75. 08 Formula-Based Formatting/077 Introduction.mp49.2MB
76. 08 Formula-Based Formatting/078 Creating Editing Managing Formula-Based Rules.mp412.06MB
77. 08 Formula-Based Formatting/079 Highlighting Rows Using the MOD Function.mp414.95MB
78. 08 Formula-Based Formatting/080 Formatting Based on the Value of Another Cell.mp410.06MB
79. 08 Formula-Based Formatting/081 Formatting Cells Using Stats Functions.mp424.27MB
80. 08 Formula-Based Formatting/082 Formatting Cells Using Text Functions Logical Operators.mp420.57MB
81. 08 Formula-Based Formatting/083 HOMEWORK Excel Formula-Based Formatting.mp41.73MB
82. 09 Array Formulas/084 Introduction.mp46.96MB
83. 09 Array Formulas/086 Rules of Excel Array Functions.mp48.79MB
84. 09 Array Formulas/087 Pros Cons of Array Functions.mp45.2MB
85. 09 Array Formulas/088 Defining Vertical Horizontal and 2-Dimensional Arrays.mp412.71MB
86. 09 Array Formulas/089 Using Array Constants in Formulas.mp47.1MB
87. 09 Array Formulas/090 Defining Referencing Named Array Constants.mp49.96MB
88. 09 Array Formulas/091 Restructuring Data with TRANSPOSE.mp413.56MB
89. 09 Array Formulas/092 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp49.05MB
90. 09 Array Formulas/093 Returning the Largest Values in a Range.mp410.78MB
91. 09 Array Formulas/094 Counting Characters Across Cells.mp45.5MB
92. 09 Array Formulas/095 Creating a MAX IF Array Formula.mp49.22MB
93. 09 Array Formulas/096 Creating a MAX IF Array Formula with Multiple Criteria.mp420.13MB
94. 09 Array Formulas/097 Converting Boolean Values Using the Double Unary (--).mp412.26MB
95. 09 Array Formulas/098 HOMEWORK Excel Array Functions.mp47.08MB
96. 10 Extra Bonus Functions/099 Introduction.mp48.67MB
97. 10 Extra Bonus Functions/100 Creating Custom References with INDIRECT.mp430.16MB
98. 10 Extra Bonus Functions/101 Linking to Worksheet Locations with HYPERLINK.mp414.17MB
99. 10 Extra Bonus Functions/102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp471.78MB
100. 10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp492.27MB
101. 11 Wrapping Up/104 Conclusion Next Steps.mp4678.25KB