Archived
files |
01.01-use_the_most_powerful_formulas_and_functions_in_excel.mkv
[b645bb2da1624fba]
|
4,725,065 |
11E0999A |
02.01-display_and_highlight_formulas.mkv
[41f56376774241a3]
|
14,344,450 |
AD5C8707 |
02.02-use_the_auditing_tools.mkv
[9e82e58accf6cf8e]
|
18,511,152 |
9C3222E4 |
02.03-use_entire_rowcolumn_references.mkv
[121d4b5d4c77c828]
|
8,235,056 |
638F1D53 |
02.04-change_formulas_to_values_and_update_values_without_formulas.mkv
[ac0ba548c116ac44]
|
15,939,477 |
5207D80B |
02.05-simplify_debugging_formulas_with_the_f9_key.mkv
[ad4eb5b7628d2e2c]
|
10,618,563 |
F0045AFF |
02.06-enhance_readability_with_range_names.mkv
[e7728bd5ac245c0b]
|
15,158,072 |
EE54262D |
02.07-create_3d_formulas_to_tabulate_data_from_multiple_sheets.mkv
[c28aa824eeaa16f4]
|
11,273,197 |
443CC2D2 |
03.01-explore_if_logical_tests_and_use_relational_operators.mkv
[b06f44a8ba9c789a]
|
12,107,706 |
EE4A0074 |
03.02-create_and_expand_the_use_of_nested_if_statements.mkv
[810b5c01e6723388]
|
12,303,431 |
8F93C058 |
03.03-create_compound_logical_tests_with_and_or_not_and_if.mkv
[d21bf48c52bef6ce]
|
14,127,463 |
83BFC2DE |
03.04-use_ifs_for_multiple_conditions.mkv
[55901daf6cdc99d]
|
6,036,314 |
B1842C01 |
04.01-explore_the_vlookup_and_hlookup_functions.mkv
[3aacc864f58ade00]
|
11,678,119 |
15FF83D5 |
04.02-find_approximate_matches_with_vlookup_and_hlookup.mkv
[954ed45d7b73fb6a]
|
13,873,210 |
11F80EF5 |
04.03-use_vlookup_to_find_exact_matches_and_search_large_tables.mkv
[4fbc905262f015d1]
|
14,297,198 |
F6E805B7 |
04.04-find_table-like_data_within_a_function_using_choose.mkv
[671c1f04318c4757]
|
8,993,749 |
00C70660 |
04.05-use_the_switch_function_for_formula-embedded_selection.mkv
[8496daef33c44fe2]
|
11,992,549 |
E4945A54 |
04.06-locate_data_with_the_match_function.mkv
[4982f41d5fc564b6]
|
7,632,806 |
C7D6E8A3 |
04.07-retrieve_information_by_location_with_the_index_function.mkv
[5e1b19cde8f466e]
|
7,134,992 |
BB92D519 |
04.08-use_the_match_and_index_functions_together.mkv
[37cc71661aa58237]
|
11,239,205 |
2F4C3166 |
04.09-document_formulas_with_the_formulatext_function.mkv
[65b23f5135256cea]
|
6,450,246 |
8118BDD9 |
04.10-extract_and_count_unique_entries_from_a_list_with_unique.mkv
[8e591b8c680f86a9]
|
15,546,683 |
230B18B6 |
04.11-use_the_xlookup_function.mkv
[227608c96ca65ccc]
|
14,399,683 |
C26C7BBE |
05.01-tabulate_data_using_a_single_criterion_with_countif_sumif_and_averageif.mkv
[89ed2afa67d81254]
|
11,287,956 |
5CF6C896 |
05.02-tabulate_data_using_multiple_criteria_with_countifs_sumifs_and_averageifs.mkv
[5609e0a9da4ef13c]
|
11,094,606 |
26D21C8E |
05.03-use_maxifs_and_minifs.mkv
[5dfc108f5583dff3]
|
7,186,730 |
EB915C7A |
05.04-use_the_subtotal_function_to_prevent_double_counting.mkv
[bae244ddd474877e]
|
15,215,274 |
CE8E5323 |
06.01-find_middle_and_most_common_values_with_median_and_mode.mkv
[87ca27ff64796e41]
|
8,204,253 |
AEB21237 |
06.02-rank_data_without_sorting_using_rank_and_rank.eq.mkv
[25b4c98ace9dc50]
|
10,908,175 |
FA09E74D |
06.03-find_the_largest_and_smallest_values_with_large_and_small.mkv
[91ace71adab1f448]
|
4,820,919 |
081FD9B2 |
06.04-tabulate_blank_cells_with_the_countblank_function.mkv
[298ed123bb604549]
|
15,918,497 |
8BB33847 |
06.05-use_count_counta_and_the_status_bar.mkv
[83652201cd6c208f]
|
9,117,672 |
F5001F51 |
07.01-work_with_the_round_roundup_and_rounddown_functions.mkv
[85d6de44246da98d]
|
14,309,632 |
168598E6 |
07.02-use_mround_ceiling_and_floor_for_specialized_rounding.mkv
[27cf96ee1bcf3839]
|
7,385,574 |
30083E36 |
07.03-use_int_trunc_odd_and_even_for_specialized_rounding.mkv
[fa872c11c7f7d423]
|
7,905,214 |
C9E2D66C |
07.04-use_mod_to_find_remainders_and_apply_conditional_formatting.mkv
[52fb26715e11b80e]
|
12,128,913 |
5A37C088 |
07.05-explore_practical_uses_for_rand_randarray_and_randbetween.mkv
[ebde5b26988dae9e]
|
13,887,179 |
27AAB70B |
07.06-convert_a_value_between_measurement_systems_with_convert.mkv
[eb43f9aa7f4fed1d]
|
8,069,043 |
43CF24D5 |
07.07-use_the_aggregate_function_to_bypass_errors_and_hidden_data.mkv
[f31183546b471fde]
|
13,759,049 |
6D5CA2CD |
07.08-use_roman_and_arabic_to_display_different_number_systems.mkv
[e40bff05f72eb550]
|
8,435,403 |
2A29E1E5 |
08.01-understand_excel_date_and_time_capabilities_in_formulas.mkv
[ce87721c1b3082ba]
|
10,029,553 |
6CC905AB |
08.02-use_various_date_and_time_functions.mkv
[1707d15c7f8a3841]
|
11,963,958 |
A48A5594 |
08.03-use_the_today_and_now_functions_for_date_and_time_entry.mkv
[dd1205f633a11dd7]
|
12,147,651 |
CDB1D05F |
08.04-identify_weekdays_with_the_weekday_function.mkv
[a3efac2f5f5764a0]
|
9,082,857 |
107F4389 |
08.05-count_working_days_and_completion_dates_(networkdays_and_workday).mkv
[c44d548ff924e1b3]
|
9,598,389 |
1403A827 |
08.06-tabulate_date_differences_with_the_datedif_function.mkv
[c4d6a266f67cd246]
|
14,129,071 |
50556FB5 |
08.07-calculate_dates_with_edate_and_eomonth.mkv
[e8a813f8905b263c]
|
13,638,058 |
A54AC43E |
09.01-get_data_from_remote_cells_with_the_offset_function.mkv
[4f18ba73b6e8761f]
|
8,777,155 |
3E1F999C |
09.02-return_references_with_the_indirect_function.mkv
[44d12600aa4e291a]
|
8,609,715 |
8BC8B9D1 |
09.03-use_indirect_with_data_validation_for_multitiered_pick_lists.mkv
[4def6619627842e9]
|
13,437,745 |
6B3C118A |
10.01-locate_and_extract_data_with_find_search_and_mid.mkv
[bd1be06702b695bb]
|
12,397,094 |
2FEA4481 |
10.02-extract_data_with_the_left_and_right_functions.mkv
[190d3697993d28c1]
|
9,080,475 |
54D2FB79 |
10.03-use_the_trim_function_to_remove_unwanted_spaces_in_a_cell.mkv
[9954fc66d9cefc6b]
|
10,050,582 |
E510B4F7 |
10.04-combine_data_with_symbols_(and)_and_concatenate.mkv
[7c1623d99c96b823]
|
8,352,859 |
3A3D57BE |
10.05-use_concat_and_textjoin_to_combine_data_from_different_cells.mkv
[460e29104044ff11]
|
11,119,227 |
44140C9C |
10.06-adjust_alphabetic_case_with_upper_lower_and_proper.mkv
[ac1ab84e2ed27d15]
|
11,609,288 |
0B95D640 |
10.07-adjust_character_content_with_replace_and_substitute.mkv
[6f377b6e0540a8f2]
|
13,079,100 |
9D698346 |
10.08-use_utility_text_functions_text_rept_value_and_len.mkv
[b1b6a29414f6eaae]
|
12,605,808 |
EBC4C37D |
10.09-use_the_new_let_function.mkv
[9a67a638bc54eb10]
|
17,721,523 |
E5CDDAFF |
10.10-new_create_custom_functions_with_lambda.mkv
[30831cecef0da7af]
|
17,478,254 |
D0A2660E |
11.01-extract_information_with_the_cell_and_info_functions.mkv
[5228ef74ab863c60]
|
10,699,501 |
F947EA75 |
11.02-explore_various_information_functions.mkv
[3724be3cbdbed342]
|
9,789,519 |
6A82169A |
11.03-use_several_error-checking_functions.mkv
[e9df9ff609f33c93]
|
15,272,388 |
AAB6ACED |
11.04-track_and_highlight_formula_cells_with_isformula.mkv
[e9729a39abd83e71]
|
9,674,646 |
C8F6D72F |
12.01-next_steps.mkv
[f8a7de18c9349e5d]
|
1,737,860 |
EB9D2CC3 |
Ex_Files_Excel_Advanced_Formulas_Functions_2021.zip |
2,624,777 |
84C10679 |
Ex_Files_Excel_Advanced_Formulas_Functions.zip |
2,619,768 |
262CF777 |
Glossary_Excel_Advanced_Formulas_Functions.zip |
91,496 |
386CC6C1 |
|
Total size: |
733,670,792 |
|
|