FreeTutorials Us excel-for-analysts

1. 01-before-we-dive-in/001-course-structure-outline.mp412.31MB
2. 01-before-we-dive-in/002-bonus-extra-homework-exercises.mp46.92MB
3. 02-excel-formulas-101/003-introduction.mp42.3MB
4. 02-excel-formulas-101/004-the-formula-library-auditing-tools.mp412.3MB
5. 02-excel-formulas-101/005-demo-using-the-evaluate-formula-tool.mp45.64MB
6. 02-excel-formulas-101/006-basic-formula-syntax.mp47.84MB
7. 02-excel-formulas-101/007-fixed-relative-mixed-references.mp414.75MB
8. 02-excel-formulas-101/008-common-errors-the-iferror-statement.mp419.07MB
9. 02-excel-formulas-101/009-function-ctrl-alt-shortcuts.mp419.04MB
10. 02-excel-formulas-101/010-bonus-shortcuts-for-mac-users.mp47.86MB
11. 02-excel-formulas-101/011-creating-custom-data-validation-rules.mp49.17MB
12. 02-excel-formulas-101/012-fixed-vs.-volatile-functions.mp47.51MB
13. 02-excel-formulas-101/013-homework-formulas-101.mp42.01MB
14. 03-conditional-statements-logical-operators/014-introduction.mp42.48MB
15. 03-conditional-statements-logical-operators/015-anatomy-of-the-if-statement.mp416.86MB
16. 03-conditional-statements-logical-operators/016-nested-if-statements.mp416.03MB
17. 03-conditional-statements-logical-operators/017-andor-operators.mp428.21MB
18. 03-conditional-statements-logical-operators/018-not-vs..mp411.36MB
19. 03-conditional-statements-logical-operators/019-fixing-errors-with-iferror.mp420.08MB
20. 03-conditional-statements-logical-operators/020-common-is-statements.mp420.92MB
21. 03-conditional-statements-logical-operators/021-homework-logical-operators.mp41.84MB
22. 04-statistical-functions/022-introduction.mp41.82MB
23. 04-statistical-functions/023-basic-statistical-functions.mp414.75MB
24. 04-statistical-functions/024-smalllarge-rankpercentrank.mp421.05MB
25. 04-statistical-functions/025-rand-randbetween.mp46.31MB
26. 04-statistical-functions/026-the-sumproduct-function.mp410.59MB
27. 04-statistical-functions/027-countifssumifsaverageifs.mp414.14MB
28. 04-statistical-functions/028-project-showcase-building-a-basic-dashboard-with-countifs-sumifs.mp423.59MB
29. 04-statistical-functions/029-homework-statistical-functions.mp41.82MB
30. 05-lookupreference-functions/030-introduction.mp42.13MB
31. 05-lookupreference-functions/031-working-with-named-arrays.mp411.31MB
32. 05-lookupreference-functions/032-rowrows-columncolumns.mp49.55MB
33. 05-lookupreference-functions/033-vlookuphlookup.mp421.21MB
34. 05-lookupreference-functions/034-joining-data-with-vlookup.mp437.77MB
35. 05-lookupreference-functions/035-fixing-errors-with-iferror-vlookup.mp415.19MB
36. 05-lookupreference-functions/036-vlookup-reference-array-options.mp440.16MB
37. 05-lookupreference-functions/037-the-index-function.mp46.15MB
38. 05-lookupreference-functions/038-the-match-function.mp49.22MB
39. 05-lookupreference-functions/039-using-index-match-together.mp423.72MB
40. 05-lookupreference-functions/040-combining-match-with-vlookup.mp426.64MB
41. 05-lookupreference-functions/041-update-vlookup-correction.mp418.5MB
42. 05-lookupreference-functions/042-the-offset-function.mp46.91MB
43. 05-lookupreference-functions/043-combining-offset-with-counta-to-return-a-variable-list.mp47.77MB
44. 05-lookupreference-functions/044-project-showcase-using-offset-to-create-a-dynamic-scrolling-chart.mp430.3MB
45. 05-lookupreference-functions/045-homework-lookupreference-functions.mp42.83MB
46. 06-text-functions/046-introduction.mp41.18MB
47. 06-text-functions/047-upperlowerproper-trim.mp421.17MB
48. 06-text-functions/048-the-concatenate-function.mp423.63MB
49. 06-text-functions/049-leftmidright-len.mp416.94MB
50. 06-text-functions/050-textvalue.mp432.09MB
51. 06-text-functions/051-searchfind.mp431.06MB
52. 06-text-functions/052-categorizing-data-with-ifisnumbersearch.mp433.61MB
53. 06-text-functions/053-combining-right-len-and-search.mp441.87MB
54. 06-text-functions/054-bonus-the-substitute-function.mp49.79MB
55. 06-text-functions/055-homework-text-functions.mp42.55MB
56. 07-date-time-functions/056-introduction.mp43.26MB
57. 07-date-time-functions/057-datevalue-your-new-bff.mp413.96MB
58. 07-date-time-functions/058-date-formatting-fill-series.mp48.64MB
59. 07-date-time-functions/059-todaynow.mp45.4MB
60. 07-date-time-functions/060-yearmonthday-hourminutesecond.mp47.88MB
61. 07-date-time-functions/061-the-eomonth-function.mp413.07MB
62. 07-date-time-functions/062-the-yearfrac-function.mp45.76MB
63. 07-date-time-functions/063-weekday-workday-networkdays.mp419.09MB
64. 07-date-time-functions/064-the-datedif-function.mp410.11MB
65. 07-date-time-functions/065-project-showcase-designing-a-sample-budget-pacing-tool.mp426.1MB
66. 07-date-time-functions/066-homework-date-time-functions.mp41.36MB
67. 08-formulabased-formatting/067-introduction.mp42.79MB
68. 08-formulabased-formatting/068-creating-editing-managing-formulabased-rules.mp412.06MB
69. 08-formulabased-formatting/069-highlighting-every-other-row-using-the-mod-function.mp414.95MB
70. 08-formulabased-formatting/070-formatting-cells-based-on-the-value-of-another-cell.mp410.06MB
71. 08-formulabased-formatting/071-formatting-cells-using-statistical-functions.mp424.27MB
72. 08-formulabased-formatting/072-formatting-cells-using-text-functions-logical-operators.mp420.57MB
73. 08-formulabased-formatting/073-homework-formulabased-formatting.mp41.73MB
74. 09-array-formulas/074-introduction.mp42.03MB
75. 09-array-formulas/075-rules-of-array-functions.mp48.79MB
76. 09-array-formulas/076-pros-cons-of-array-functions.mp45.2MB
77. 09-array-formulas/077-vertical-horizontal-and-2dimensional-array-constants.mp412.71MB
78. 09-array-formulas/078-using-array-constants-in-formulas.mp47.1MB
79. 09-array-formulas/079-named-array-constants.mp49.96MB
80. 09-array-formulas/080-the-transpose-function.mp413.56MB
81. 09-array-formulas/081-linking-data-between-sheets-array-vs.-nonarray-comparison.mp49.05MB
82. 09-array-formulas/082-returning-the-x-largest-values-in-a-range.mp410.78MB
83. 09-array-formulas/083-counting-characters-across-cells.mp45.5MB
84. 09-array-formulas/084-creating-a-max-if-array-formula.mp49.22MB
85. 09-array-formulas/085-bonus-max-if-with-multiple-criteria.mp420.13MB
86. 09-array-formulas/086-bonus-using-the-double-unary-operator.mp412.26MB
87. 09-array-formulas/087-homework-array-functions.mp47.08MB
88. 10-badass-bonus-functions/088-introduction.mp42.6MB
89. 10-badass-bonus-functions/089-the-indirect-function.mp430.16MB
90. 10-badass-bonus-functions/090-hyperlink-as-awesome-as-it-sounds.mp414.17MB
91. 10-badass-bonus-functions/091-tapping-into-realtime-data-with-webservice-filterxml.mp423.42MB
92. 11-wrapping-up/092-conclusion-next-steps.mp4678.25KB