| Archived
files |
|
01.01-introduction.mkv
[a937a122341c99c6]
|
22,297,449 |
C6A65DD4 |
|
02.01-a_recap_of_basic_formulas.mkv
[30c12084f61a21c]
|
52,128,074 |
50BCE65C |
|
02.02-absolute_versus_relative_referencing.mkv
[7f5ac8631c6051d8]
|
33,974,766 |
A81C0871 |
|
02.03-exercise_01.mkv
[de00c3eed7e1deb5]
|
8,557,357 |
1071739C |
|
03.01-merging_data_from_different_sources.mkv
[d496a8e751d895f0]
|
11,570,150 |
09B8447D |
|
03.02-looking_up_information_with_vlookup_(exact).mkv
[12b1d51602545333]
|
44,913,037 |
01063C6F |
|
03.03-looking_up_information_with_vlookup_(approx.).mkv
[c244066f955695fb]
|
26,559,804 |
FCC84848 |
|
03.04-how_to_use_vlookup_with_data_that_expands.mkv
[5051245cd5898b23]
|
41,079,791 |
E3951504 |
|
03.05-using_hlookup.mkv
[4c186720584ad6de]
|
50,353,202 |
85977A7B |
|
03.06-combining_vlookup_and_match.mkv
[432d655b794caa58]
|
51,083,130 |
B184482C |
|
03.07-using_index_match_and_xlookup.mkv
[6ce982bddf3494ff]
|
71,500,511 |
77BE95F4 |
|
03.08-data_validation_lists_with_lookups.mkv
[44b521f68f8d804e]
|
34,938,785 |
7CCF9080 |
|
03.09-exercise_02.mkv
[fb28f4bcc124ced9]
|
26,277,137 |
239D7017 |
|
04.01-how_to_use_the_if_function.mkv
[1304069c6adfdca4]
|
22,658,199 |
F4A61153 |
|
04.02-more_examples_of_the_if_function.mkv
[38eadde8fc39aa71]
|
29,405,412 |
7938F466 |
|
04.03-working_with_nested_ifs.mkv
[48cd8eff8e3349ea]
|
27,110,008 |
5336AA1F |
|
04.04-the_ifs_function.mkv
[4a68fa93e5c3da4a]
|
35,840,990 |
C9EAF384 |
|
04.05-error_handling_with_iferror_and_ifna.mkv
[51a86994f4c8bf34]
|
38,560,810 |
3E7E5EDA |
|
04.06-using_max_and_min_instead_of_the_if_function.mkv
[a7ffff345ca6ee1d]
|
47,041,856 |
8B49D962 |
|
04.07-using_sumifs_and_countifs.mkv
[8c7419c6a58fc4c5]
|
48,960,448 |
8874EE4B |
|
04.08-exercise_03.mkv
[3847000cce7286b3]
|
6,344,329 |
033DC5C5 |
|
05.01-splitting_data_using_text_functions.mkv
[6c91f12728474b09]
|
66,254,122 |
851B606D |
|
05.02-using_the_flash_fill_command.mkv
[e23abb172d501028]
|
19,226,789 |
C7781E06 |
|
05.03-concatenating_data.mkv
[3afda69a7e32ba05]
|
37,269,902 |
37EA9F79 |
|
05.04-standardizing_data.mkv
[c8eee0d435433576]
|
37,113,687 |
B984E69A |
|
05.05-formatting_data_as_a_table.mkv
[991871d1c96c8e22]
|
40,025,000 |
AE880031 |
|
05.06-exercise_04.mkv
[6f3bc8e3c4876be9]
|
10,236,143 |
850A1D05 |
|
06.01-an_introduction_to_pivottables.mkv
[8f6013f8863df485]
|
13,522,642 |
B4724D21 |
|
06.02-creating_a_pivottable.mkv
[78eb60a709808445]
|
52,227,722 |
938351DC |
|
06.03-summarizing_data.mkv
[59a55ac8ec910d13]
|
56,346,678 |
1841C391 |
|
06.04-calculations_in_pivottables.mkv
[3046044da4722ff1]
|
62,478,903 |
753F2C1D |
|
06.05-using_slicers_to_filter_information.mkv
[fc4f4dac4550299c]
|
40,613,102 |
491CAE09 |
|
06.06-exercise_05.mkv
[5fef902b2487caa0]
|
7,720,892 |
8058EBB4 |
|
07.01-creating_a_pivot_chart.mkv
[ae18662075773305]
|
43,300,142 |
80233827 |
|
07.02-formatting_a_pivot_chart.mkv
[c90af1b2ed37cf85]
|
58,837,101 |
3E7976C5 |
|
07.03-using_sparklines.mkv
[eabe390811647fa5]
|
32,317,810 |
C2D968AE |
|
07.04-a_basic_interactive_dashboard.mkv
[f1c1155008c0e6a8]
|
60,572,813 |
22CCD5A9 |
|
07.05-exercise_06.mkv
[ecc1158756c27d7a]
|
11,736,559 |
91510B3C |
|
08.01-forecast_sheets.mkv
[2856d837902e30f4]
|
30,070,582 |
690AB544 |
|
08.02-the_forecast_function.mkv
[22fe7af402c593bd]
|
30,441,089 |
A6FC792B |
|
08.03-exercise_07.mkv
[784d6609bef88098]
|
6,556,474 |
7D13E639 |
|
09.01-conditional_formatting.mkv
[791cb63b70da9bf1]
|
46,980,838 |
A958E14B |
|
09.02-the_indirect_function.mkv
[f67d22933083080d]
|
55,287,461 |
35159F6B |
|
09.03-the_offset_function.mkv
[840f737870f5655e]
|
43,403,142 |
D312D115 |
|
09.04-using_histograms.mkv
[cf4f5a559213d4da]
|
20,299,261 |
429496F5 |
|
09.05-regression.mkv
[506ab61299c77e16]
|
27,761,662 |
9432FAC6 |
|
09.06-exercise_08.mkv
[25dc41ac00673312]
|
9,154,011 |
CC149212 |
|
10.01-goal_seek.mkv
[a640224900018d80]
|
31,692,307 |
272D132B |
|
10.02-scenario_manager.mkv
[f274f0c92bfcb910]
|
33,087,614 |
371EFE43 |
|
10.03-data_tables.mkv
[9370b3ee8ea97e1d]
|
29,755,731 |
EB0CDF11 |
|
10.04-solver.mkv
[e38ee754fda96ec6]
|
28,282,771 |
9B596CFB |
|
10.05-exercise_09.mkv
[24d5b3b3dbfe0fde]
|
7,071,453 |
C0B031C5 |
|
11.01-summary.mkv
[6a3b8568c8bb7c97]
|
2,988,159 |
D062D12D |
|
12.01-introduction_to_the_advanced_excel_2019.mkv
[8b3b8f1b66a5ccc1]
|
27,507,040 |
836875A5 |
|
12.02-advanced_excel_2019_learning_structure.mkv
[95b36bf9eba8df95]
|
17,964,498 |
515AEAE8 |
|
13.01-functions-part_1.mkv
[f6b9ec7d42ef927d]
|
58,748,150 |
B2B91A0F |
|
13.02-functions-part_2.mkv
[49302f8aa8373980]
|
34,702,723 |
EFFF283D |
|
13.03-autosum.mkv
[2130cdfa08a97ed9]
|
25,244,009 |
E5BFB0F0 |
|
14.01-how_date_and_time_works.mkv
[27a0c00f3965ff5f]
|
45,357,427 |
B4AC212C |
|
14.02-basic_date_and_time_functions.mkv
[ad88400936b74aa0]
|
39,865,673 |
C80D9143 |
|
14.03-complex_date_and_time_functions.mkv
[436616a4f8c13a59]
|
43,573,961 |
441860B5 |
|
15.01-using_text_functions-part_1.mkv
[71ade0cc2e64843b]
|
50,842,159 |
49BA7264 |
|
15.02-using_text_functions-part_2.mkv
[9b50e05d1c9c0b56]
|
50,263,578 |
697D36FA |
|
16.01-logical_functions.mkv
[5444ea092c671482]
|
40,334,462 |
EE262736 |
|
16.02-exercise_01.mkv
[524440b5264964b1]
|
9,247,301 |
AEE5B6B6 |
|
17.01-lookup_functions-part_1.mkv
[6a1541f89e5b7c0]
|
57,670,897 |
13E21B06 |
|
17.02-lookup_functions-part_2.mkv
[9df51b643173edb0]
|
32,701,021 |
5BB3D612 |
|
17.03-exercise_02.mkv
[3955daea73a9f39d]
|
23,094,408 |
8878BF42 |
|
18.01-financial_functions_and_terminology.mkv
[6c1f353a2faf527f]
|
37,963,769 |
6741D869 |
|
18.02-personal_financial_functions.mkv
[7bf5eb451fcc62f8]
|
38,336,607 |
31783632 |
|
18.03-principal_and_interest_payments.mkv
[99bf586c2a4e8c85]
|
30,949,942 |
476F0759 |
|
18.04-depreciation.mkv
[fea5e3063bfa3c8d]
|
21,029,665 |
FB229C9F |
|
18.05-exercise_03.mkv
[78f19770ed9d1bac]
|
6,826,965 |
DC2D0DAD |
|
19.01-statistical_functions_for_description-part_1.mkv
[44572cece9a764e1]
|
55,709,920 |
57616B26 |
|
19.02-statistical_functions_for_description-part_2.mkv
[3c74e3c91822e868]
|
56,501,509 |
FC8977AA |
|
19.03-statistical_functions_for_forecasting-part_1.mkv
[1c9735b7c9a33f3d]
|
49,122,189 |
77937BC8 |
|
19.04-statistical_functions_for_forecasting-part_2.mkv
[fcbabd95acf89610]
|
48,417,300 |
296E99CD |
|
19.05-exercise_04.mkv
[b3710209cbd9806]
|
7,668,700 |
4705DE38 |
|
19.06-one_click_forecasting.mkv
[79199d5251c27f26]
|
36,870,582 |
76619F7E |
|
19.07-statistical_functions_for_inference.mkv
[6f72a0e3b66fd995]
|
45,923,009 |
851CB75C |
|
20.01-connecting_to_other_workbooks.mkv
[fce3921de8a71013]
|
54,397,377 |
00CD5761 |
|
20.02-connecting_to_access_databases.mkv
[a8c60f592d832fe2]
|
52,784,710 |
4F3D7B4C |
|
20.03-connecting_web_data_sources.mkv
[7ea835ae3853f15c]
|
32,500,351 |
E9B73C35 |
|
20.04-get_and_transform.mkv
[46122d978535656d]
|
59,331,294 |
1B6DA984 |
|
20.05-exercise_05.mkv
[ecb688a8f3f55488]
|
21,198,451 |
05A4CC43 |
|
21.01-introduction_to_tables.mkv
[6c5d42d2ae21a159]
|
49,903,777 |
A574B2B6 |
|
21.02-working_with_tables.mkv
[4a7dae7e2c0e3727]
|
44,002,185 |
1A5AC4C1 |
|
21.03-table_references.mkv
[3d243284edb380c4]
|
35,342,151 |
2247B157 |
|
21.04-table_styles.mkv
[2975133181601ff6]
|
22,916,809 |
72F7EDBC |
|
21.05-exercise_6.mkv
[940502dbda396ee2]
|
6,135,019 |
2FE66B7C |
|
22.01-introduction_to_pivot_tables.mkv
[1f6796d875f10368]
|
41,073,546 |
E2B72FCB |
|
22.02-working_with_pivot_tables.mkv
[5c3b1599c5ad19e4]
|
52,729,113 |
B879FCA2 |
|
22.03-filters_and_slicers.mkv
[da53f05af97bfcec]
|
51,491,028 |
99068AF7 |
|
22.04-pivot_and_charts.mkv
[3a16444c7c382315]
|
35,519,697 |
FC5F4E2B |
|
22.05-exercise_07.mkv
[fe82e3a6274c9062]
|
10,284,381 |
D18871EC |
|
23.01-what_if_analysis.mkv
[96ed083e86801258]
|
42,437,831 |
C7E80AE5 |
|
23.02-scenario_manager.mkv
[a3f34850855d07e1]
|
47,036,119 |
1CD1508E |
|
23.03-goal_seek.mkv
[72c3f69c583e54a5]
|
31,917,054 |
6DEFB001 |
|
23.04-solver.mkv
[a645ef028c9902a3]
|
49,528,318 |
4B24E7C8 |
|
23.05-exercise_08.mkv
[e45508d40023b39a]
|
7,489,281 |
A9AF8A16 |
|
24.01-area_charts.mkv
[2616df5f2e5290fb]
|
27,833,004 |
E0B74984 |
|
24.02-surface_charts.mkv
[16131c3c05a2006c]
|
19,779,777 |
43D6F46E |
|
24.03-radar_charts.mkv
[1749151994e10fd6]
|
22,302,527 |
58083E72 |
|
24.04-bubble_charts.mkv
[5701a6e9254d953a]
|
32,233,017 |
7D331271 |
|
24.05-sparklines.mkv
[dbce6c8b3a0d62a]
|
39,357,865 |
A8878718 |
|
24.06-stock_charts.mkv
[37a2806a99bf1101]
|
37,489,628 |
B71F0CD6 |
|
24.07-exercise_9.mkv
[179fc104417fe987]
|
14,612,263 |
55EEA9B5 |
|
25.01-web_app-part_1.mkv
[6dff9204f9739033]
|
41,750,039 |
35DE1605 |
|
25.02-web_app-part_2.mkv
[81a62e0092f6689f]
|
41,086,277 |
958CAD40 |
|
26.01-summary.mkv
[e7037207833d742f]
|
3,489,335 |
E4C7ECDA |
|
27.01-introduction_to_advanced_pivottables.mkv
[d6a66f4be02c029c]
|
15,762,871 |
7F6398A2 |
|
27.02-pivottables_recap.mkv
[6386330d26acd0f8]
|
52,380,988 |
A845082E |
|
28.01-importing_data_from_a_text_file.mkv
[a8d83b2faa9515ed]
|
41,543,231 |
250F808D |
|
28.02-importing_data_from_access.mkv
[8155d91dcbd1e324]
|
34,359,189 |
4F7C0B9F |
|
28.03-exercise_01.mkv
[71e0684db9ad5c53]
|
19,237,684 |
6B9B974B |
|
29.01-cleaning_data.mkv
[51785b65bd5fc0a]
|
72,611,801 |
298EEFE9 |
|
29.02-tabular_data.mkv
[c457c342b68a33f9]
|
65,967,234 |
655FA983 |
|
29.03-exercise_02.mkv
[b360f21a26ddbaf4]
|
13,637,290 |
483C0412 |
|
30.01-creating_and_manipulating_a_pivottable.mkv
[50c4cf83cd822836]
|
51,446,558 |
FF25B401 |
|
30.02-combining_data_from_multiple_worksheets.mkv
[b6ee69752346aad6]
|
49,485,618 |
262EA2B8 |
|
30.03-grouping_and_ungrouping.mkv
[656d0e76dd82f582]
|
45,333,799 |
F52495BE |
|
30.04-report_layouts.mkv
[a7e3d16a99d051e3]
|
44,714,099 |
5D8697A3 |
|
30.05-formatting_error_values_and_empty_cells.mkv
[e90ef82305f7555b]
|
34,734,568 |
26B8AB64 |
|
30.06-exercise_03.mkv
[30796875a066a8f5]
|
6,603,072 |
6FC98976 |
|
31.01-pivottable_styles.mkv
[9b70bdd18bfe220a]
|
47,770,723 |
25BEF403 |
|
31.02-custom_number_formatting.mkv
[75ff9850c81c8bce]
|
67,327,705 |
121F32C0 |
|
31.03-exercise_04.mkv
[a332dc0db85eaa0b]
|
7,243,239 |
AEC3FD20 |
|
32.01-summarizing_values.mkv
[d5fd62bce50dc50f]
|
46,841,812 |
B2C37C79 |
|
32.02-show_values_as.mkv
[87864b863a956a2f]
|
37,514,367 |
AE2155BF |
|
32.03-exercise_05.mkv
[e491b76d2ae23891]
|
7,458,443 |
E698EB9E |
|
33.01-advanced_sorting.mkv
[de28e11763666b59]
|
35,656,913 |
CA246846 |
|
33.02-advanced_filtering.mkv
[733b5796d269785a]
|
57,843,668 |
C1207D27 |
|
33.03-exercise_06.mkv
[6a2ed50a007b7093]
|
9,576,300 |
C2F7475A |
|
34.01-inserting_and_formatting_slicers.mkv
[d266c60fd667b3cf]
|
56,851,606 |
54E094DE |
|
34.02-inserting_and_formatting_timelines.mkv
[4fd62e762e8e262d]
|
29,445,001 |
B7B3036E |
|
34.03-connecting_slicers_to_multiple_pivottables.mkv
[9cb16c3a86178696]
|
33,494,088 |
FC00EAB6 |
|
34.04-using_slicers_in_protected_workbooks.mkv
[e51a01df4f0bd7cb]
|
23,065,557 |
B97BAA09 |
|
34.05-exercise_07.mkv
[72433d5d8fc12cb2]
|
9,679,425 |
6B3B57DD |
|
35.01-creating_a_calculated_field.mkv
[e30affbdd55efa7f]
|
34,686,879 |
D4D41256 |
|
35.02-creating_a_calculated_item.mkv
[2dfc32c89adc15ae]
|
33,597,591 |
DF800066 |
|
35.03-solve_order_and_list_formulas.mkv
[895ce7798d52648b]
|
43,684,981 |
8869C2E6 |
|
35.04-getpivotdata.mkv
[8857812d41626f94]
|
38,757,504 |
F383E4FC |
|
35.05-exercise_08.mkv
[49619732e018af08]
|
27,587,274 |
D308F60D |
|
36.01-creating_a_pivot_chart.mkv
[626c5220d5d6631e]
|
47,250,392 |
EBDB335C |
|
36.02-formatting_a_pivot_chart-part_1.mkv
[1bda8557074cbc31]
|
64,557,144 |
377B79AD |
|
36.03-formatting_a_pivot_chart-part_2.mkv
[3e9b178ec38aeb58]
|
63,590,386 |
CC5D3313 |
|
36.04-creating_a_map_chart_using_pivot_data.mkv
[e4a751d5dbd5d7d1]
|
49,348,590 |
6E0D5032 |
|
36.05-dynamic_chart_titles.mkv
[15db2e7a1b4e82b7]
|
56,776,976 |
9ECC9030 |
|
36.06-include_a_sparkline_with_your_pivottable.mkv
[69ece2649a521a5f]
|
43,828,925 |
027F8D07 |
|
36.07-exercise_09.mkv
[ea1792cf8f83a06a]
|
31,887,470 |
DB534148 |
|
37.01-highlighting_cell_rules.mkv
[87e57052bb174965]
|
39,142,296 |
5A5D7648 |
|
37.02-graphical_conditional_formats.mkv
[e346a84162d981ea]
|
41,495,560 |
49DD1973 |
|
37.03-conditional_formatting_and_slicers.mkv
[26647efbc5eb3c5]
|
26,400,144 |
19FACA27 |
|
37.04-exercise_10.mkv
[fe2988ec2e57555c]
|
10,076,283 |
F059FA82 |
|
38.01-creating_an_interactive_dashboard-part_1.mkv
[e10a357cb94641ff]
|
95,158,689 |
1C37A54C |
|
38.02-creating_an_interactive_dashboard-part_2.mkv
[5345dc5c58ffdb23]
|
57,293,716 |
0CC1BC53 |
|
38.03-updating_pivot_charts_and_pivottables.mkv
[83ac9c2d9ac3825a]
|
18,233,062 |
89607DB7 |
|
38.04-exercise_11.mkv
[1621156a6845fd6a]
|
14,429,655 |
7D42FA20 |
|
39.01-summary.mkv
[dc7362ee36d99700]
|
2,601,490 |
C7C30F14 |
|
40.01-introduction.mkv
[d1eb7dabc48565e3]
|
29,946,865 |
4200E586 |
|
41.01-filter_a_dataset_using_a_formula.mkv
[ca4f9a3505cbee17]
|
31,328,001 |
792AA83A |
|
41.02-sort_a_dataset_using_a_formula_and_defined_variables.mkv
[4b210582b1691ff7]
|
53,432,768 |
013BAC45 |
|
41.03-multiple_dependent_dynamic_drop-down_lists.mkv
[cb55111fe269ebea]
|
42,325,896 |
20705C4F |
|
41.04-perform_a_2-way_lookup.mkv
[9903f19fec1e1770]
|
46,802,868 |
F7D8ACAD |
|
41.05-make_decisions_with_complex_logical_calculations.mkv
[8330a4cdc84fa4ed]
|
67,359,234 |
D8FE6E71 |
|
41.06-extracting_parts_of_a_text_string.mkv
[13278cc74e8ef3d3]
|
64,548,795 |
9E2AB27E |
|
41.07-creating_a_dynamic_chart_title.mkv
[63c223551280bb14]
|
54,619,320 |
1DB3559F |
|
41.08-finding_the_last_occurrence_of_a_value_in_a_list.mkv
[54da3ef43cb41a7]
|
55,582,685 |
F34F151B |
|
41.09-looking_up_information_with_xlookup.mkv
[e926e7a51bbfaa61]
|
44,331,950 |
57C9BDCE |
|
41.10-find_the_st_match_to_a_value.mkv
[cf4fd7d61aefd3eb]
|
32,091,800 |
47F7466A |
|
42.01-summary.mkv
[2add56648cdd6816]
|
5,531,440 |
3342D3A0 |
|
9781803239262_Code.zip |
61,594,358 |
CE0DD8BD |
|
| Total size: |
6,251,645,331 |
|
|
