[FreeCourseWorld.Com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions

1. 05 Lookup Reference Functions/050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4 172.49 MB
2. 02 Excel Formulas 101/006 Excel Formula Syntax.mp4 114.41 MB
3. 02 Excel Formulas 101/012 Saving Time with Function Shortcuts.mp4 103.67 MB
4. 04 Common Excel Statistical Functions/034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp4 95.30 MB
5. 10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp4 92.27 MB
6. 02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 89.35 MB
7. 05 Lookup Reference Functions/040 Joining Data with VLOOKUP.mp4 81.83 MB
8. 02 Excel Formulas 101/009 Formula Auditing Trace Precedents Dependents.mp4 80.39 MB
9. 05 Lookup Reference Functions/051 Selecting List Items with CHOOSE.mp4 80.25 MB
10. 04 Common Excel Statistical Functions/033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp4 73.13 MB
11. 10 Extra Bonus Functions/102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp4 71.78 MB
12. 06 Text Functions/060 Converting Text to Values with TEXT VALUE.mp4 55.38 MB
13. 07 Date Time Functions/073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp4 55.27 MB
14. 04 Common Excel Statistical Functions/027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp4 54.26 MB
15. 02 Excel Formulas 101/008 Common Excel Error Types.mp4 53.41 MB
16. 02 Excel Formulas 101/010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp4 53.12 MB
17. 05 Lookup Reference Functions/039 Introduction to VLOOKUPHLOOKUP.mp4 51.78 MB
18. 02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed Relative References.mp4 50.69 MB
19. 02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.mp4 49.14 MB
20. 05 Lookup Reference Functions/043 Approximate Match Lookups.mp4 46.41 MB
21. 02 Excel Formulas 101/014 PRO TIP Creating Drop-Down Menus with Data Validation.mp4 44.03 MB
22. 06 Text Functions/063 Combining RIGHT LEN and SEARCH.mp4 41.87 MB
23. 05 Lookup Reference Functions/042 VLOOKUP Reference Array Options.mp4 40.16 MB
24. 02 Excel Formulas 101/015 Congrats Youre a Developer.mp4 33.88 MB
25. 06 Text Functions/062 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 33.61 MB
26. 04 Common Excel Statistical Functions/030 DEMO Calculating Shipping Costs with SUMPRODUCT.mp4 31.27 MB
27. 06 Text Functions/061 Searching Text String with SEARCH FIND.mp4 31.06 MB
28. 05 Lookup Reference Functions/054 PRO TIP Using OFFSET to Create Interactive Charts.mp4 30.30 MB
29. 10 Extra Bonus Functions/100 Creating Custom References with INDIRECT.mp4 30.16 MB
30. 01 Getting Started/001 Course Structure Outline.mp4 28.61 MB
31. 03 Conditional Statements Logical Operators/020 Adding Conditional ANDOR Operators.mp4 28.21 MB
32. 05 Lookup Reference Functions/047 Combining MATCH VLOOKUP for More Flexible Lookups.mp4 26.64 MB
33. 07 Date Time Functions/075 DEMO Building a Simple Budget Pacing Tool.mp4 26.10 MB
34. 01 Getting Started/004 Setting Expectations.mp4 24.50 MB
35. 08 Formula-Based Formatting/081 Formatting Cells Using Stats Functions.mp4 24.27 MB
36. 05 Lookup Reference Functions/046 Combining INDEX MATCH to Dynamically Search Ranges.mp4 23.72 MB
37. 06 Text Functions/058 Combining Text with CONCATENATE ().mp4 23.63 MB
38. 04 Common Excel Statistical Functions/032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.mp4 23.59 MB
39. 06 Text Functions/057 Capitalization with UPPER LOWER PROPER TRIM.mp4 21.17 MB
40. 03 Conditional Statements Logical Operators/023 Common IS Statements.mp4 20.92 MB
41. 08 Formula-Based Formatting/082 Formatting Cells Using Text Functions Logical Operators.mp4 20.57 MB
42. 09 Array Formulas/096 Creating a MAX IF Array Formula with Multiple Criteria.mp4 20.13 MB
43. 03 Conditional Statements Logical Operators/022 Fixing Errors with IFERROR.mp4 20.08 MB
44. 05 Lookup Reference Functions/049 SNEAK PEEK XLOOKUP (Office 365 Only).mp4 19.87 MB
45. 05 Lookup Reference Functions/048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp4 18.50 MB
46. 06 Text Functions/059 Extracting Strings with LEFT MID RIGHT LEN.mp4 16.94 MB
47. 03 Conditional Statements Logical Operators/018 Anatomy of the IF Statement.mp4 16.86 MB
48. 03 Conditional Statements Logical Operators/019 Nesting Multiple IF Statements.mp4 16.03 MB
49. 05 Lookup Reference Functions/041 Fixing Errors with IFERROR VLOOKUP.mp4 15.19 MB
50. 08 Formula-Based Formatting/079 Highlighting Rows Using the MOD Function.mp4 14.95 MB