|
|
001-Hide_and_unhide_worksheets_securely.mp4
|
MP4
|
17.01 MB
|
|
|
001-Hide_and_unhide_worksheets_securely.srt
|
SRT
|
12.48 KB
|
|
|
002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4
|
MP4
|
27.85 MB
|
|
|
002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt
|
SRT
|
19.02 KB
|
|
|
003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4
|
MP4
|
21.48 MB
|
|
|
003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt
|
SRT
|
14.51 KB
|
|
|
004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4
|
MP4
|
16.4 MB
|
|
|
004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt
|
SRT
|
10.7 KB
|
|
|
005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4
|
MP4
|
23.75 MB
|
|
|
005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt
|
SRT
|
14.7 KB
|
|
|
006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4
|
MP4
|
29.4 MB
|
|
|
006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt
|
SRT
|
17.99 KB
|
|
|
007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4
|
MP4
|
40.45 MB
|
|
|
007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt
|
SRT
|
22.81 KB
|
|
|
008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4
|
MP4
|
24.1 MB
|
|
|
008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt
|
SRT
|
16.33 KB
|
|
|
009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4
|
MP4
|
30.3 MB
|
|
|
009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt
|
SRT
|
16.85 KB
|
|
|
010-Applying_conditional_formatting_across_rows_of_data.mp4
|
MP4
|
20.45 MB
|
|
|
010-Applying_conditional_formatting_across_rows_of_data.srt
|
SRT
|
12.2 KB
|
|
|
011-Exploring_various_layouts_for_your_PivotTable.mp4
|
MP4
|
13.86 MB
|
|
|
011-Exploring_various_layouts_for_your_PivotTable.srt
|
SRT
|
8.42 KB
|
|
|
012-Splitting_and_consolidating_workbooks.mp4
|
MP4
|
20.53 MB
|
|
|
012-Splitting_and_consolidating_workbooks.srt
|
SRT
|
12.99 KB
|
|
|
013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4
|
MP4
|
23.2 MB
|
|
|
013-Using_date_and_time_as_metrics_in_a_PivotTable.srt
|
SRT
|
13.42 KB
|
|
|
014-Adding_illustrations_to_your_workbook.mp4
|
MP4
|
33.62 MB
|
|
|
014-Adding_illustrations_to_your_workbook.srt
|
SRT
|
22.95 KB
|
|
|
015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4
|
MP4
|
22.57 MB
|
|
|
015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt
|
SRT
|
16.1 KB
|
|
|
016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4
|
MP4
|
29.52 MB
|
|
|
016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt
|
SRT
|
22.49 KB
|
|
|
017-Dynamically_presenting_data_via_chart_slicers.mp4
|
MP4
|
20.42 MB
|
|
|
017-Dynamically_presenting_data_via_chart_slicers.srt
|
SRT
|
14.46 KB
|
|
|
018-Parsing_your_data_to_create_unique_lists.mp4
|
MP4
|
14.51 MB
|
|
|
018-Parsing_your_data_to_create_unique_lists.srt
|
SRT
|
6.56 KB
|
|
|
019-Using_the_REPT_function_to_represent_data_visually.mp4
|
MP4
|
8.82 MB
|
|
|
019-Using_the_REPT_function_to_represent_data_visually.srt
|
SRT
|
5.91 KB
|
|
|
020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4
|
MP4
|
24.96 MB
|
|
|
020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt
|
SRT
|
14.59 KB
|
|
|
021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4
|
MP4
|
23.25 MB
|
|
|
021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt
|
SRT
|
15.14 KB
|
|
|
022-Increasing_your_productivity_with_custom_lists.mp4
|
MP4
|
20.89 MB
|
|
|
022-Increasing_your_productivity_with_custom_lists.srt
|
SRT
|
9.44 KB
|
|
|
023-Highlighting_PivotTable_results_with_conditional_formatting.mp4
|
MP4
|
19.23 MB
|
|
|
023-Highlighting_PivotTable_results_with_conditional_formatting.srt
|
SRT
|
11.73 KB
|
|
|
024-Customizing_templates_to_fit_your_unique_needs.mp4
|
MP4
|
20.37 MB
|
|
|
024-Customizing_templates_to_fit_your_unique_needs.srt
|
SRT
|
12.29 KB
|
|
|
025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4
|
MP4
|
11.49 MB
|
|
|
025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt
|
SRT
|
6.44 KB
|
|
|
026-Enhancing_table_filtering_with_slicers.mp4
|
MP4
|
20.19 MB
|
|
|
026-Enhancing_table_filtering_with_slicers.srt
|
SRT
|
10.24 KB
|
|
|
027-Converting_charts_into_pictures.mp4
|
MP4
|
15.93 MB
|
|
|
027-Converting_charts_into_pictures.srt
|
SRT
|
8.97 KB
|
|
|
028-Custom_grouping_in_PivotTables.mp4
|
MP4
|
12.99 MB
|
|
|
028-Custom_grouping_in_PivotTables.srt
|
SRT
|
8.71 KB
|
|
|
029-Quick_formatting_tips.mp4
|
MP4
|
23.4 MB
|
|
|
029-Quick_formatting_tips.srt
|
SRT
|
14.94 KB
|
|
|
030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4
|
MP4
|
25.61 MB
|
|
|
030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt
|
SRT
|
11.77 KB
|
|
|
031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4
|
MP4
|
21.61 MB
|
|
|
031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt
|
SRT
|
10.09 KB
|
|
|
032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4
|
MP4
|
23.56 MB
|
|
|
032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt
|
SRT
|
18.7 KB
|
|
|
033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4
|
MP4
|
21.88 MB
|
|
|
033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt
|
SRT
|
12.1 KB
|
|
|
034-Calculating_with_hours_minutes_and_times_of_day.mp4
|
MP4
|
29.66 MB
|
|
|
034-Calculating_with_hours_minutes_and_times_of_day.srt
|
SRT
|
18.48 KB
|
|
|
035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4
|
MP4
|
21.74 MB
|
|
|
035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt
|
SRT
|
11.21 KB
|
|
|
036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4
|
MP4
|
40.04 MB
|
|
|
036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt
|
SRT
|
20.64 KB
|
|
|
037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4
|
MP4
|
19.26 MB
|
|
|
037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt
|
SRT
|
13.86 KB
|
|
|
038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4
|
MP4
|
18.99 MB
|
|
|
038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt
|
SRT
|
11.21 KB
|
|
|
039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4
|
MP4
|
25.08 MB
|
|
|
039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt
|
SRT
|
11.34 KB
|
|
|
040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4
|
MP4
|
21.15 MB
|
|
|
040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt
|
SRT
|
13.71 KB
|
|
|
041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4
|
MP4
|
24.18 MB
|
|
|
041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt
|
SRT
|
12.97 KB
|
|
|
042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4
|
MP4
|
19.93 MB
|
|
|
042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt
|
SRT
|
14.49 KB
|
|
|
043-Exploring_what_if_scenarios_using_Goal_Seek.mp4
|
MP4
|
28.04 MB
|
|
|
043-Exploring_what_if_scenarios_using_Goal_Seek.srt
|
SRT
|
16.22 KB
|
|
|
044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4
|
MP4
|
17.89 MB
|
|
|
044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt
|
SRT
|
12.4 KB
|
|
|
045-Creating_Variable_Conditional_Formatting_Rules.mp4
|
MP4
|
30.8 MB
|
|
|
045-Creating_Variable_Conditional_Formatting_Rules.srt
|
SRT
|
14.47 KB
|
|
|
046-Handling_Dates_with_unusual_formats.mp4
|
MP4
|
20.25 MB
|
|
|
046-Handling_Dates_with_unusual_formats.srt
|
SRT
|
10.98 KB
|
|
|
047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4
|
MP4
|
38.13 MB
|
|
|
047-Using_wildcards_(asterisk_tilde_and_question_mark).srt
|
SRT
|
17.52 KB
|
|
|
048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4
|
MP4
|
39.18 MB
|
|
|
048-Custom_formats_using_asterisk_semicolon_and_brackets.srt
|
SRT
|
22.45 KB
|
|
|
049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4
|
MP4
|
47.68 MB
|
|
|
049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt
|
SRT
|
22.23 KB
|
|
|
050-Create_an_Organization_Chart.mp4
|
MP4
|
23.64 MB
|
|
|
050-Create_an_Organization_Chart.srt
|
SRT
|
17.23 KB
|
|
|
051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4
|
MP4
|
50.68 MB
|
|
|
051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt
|
SRT
|
21.89 KB
|
|
|
052-Using_Excels_error_checking_functions.mp4
|
MP4
|
33.63 MB
|
|
|
052-Using_Excels_error_checking_functions.srt
|
SRT
|
20.44 KB
|
|
|
053-Custom_formats_relative_addressing_and_conditional_formatting.mp4
|
MP4
|
23.95 MB
|
|
|
053-Custom_formats_relative_addressing_and_conditional_formatting.srt
|
SRT
|
15.63 KB
|
|
|
054-Auditing.mp4
|
MP4
|
30.66 MB
|
|
|
054-Auditing.srt
|
SRT
|
18.06 KB
|
|
|
055-Adding_comments_and_shapes.mp4
|
MP4
|
25.43 MB
|
|
|
055-Adding_comments_and_shapes.srt
|
SRT
|
15.77 KB
|
|
|
056-Drawing_borders_and_border_grids.mp4
|
MP4
|
21.36 MB
|
|
|
056-Drawing_borders_and_border_grids.srt
|
SRT
|
12.55 KB
|
|
|
057-Building_a_flexible_monthly_table_using_functions.mp4
|
MP4
|
32.81 MB
|
|
|
057-Building_a_flexible_monthly_table_using_functions.srt
|
SRT
|
23.64 KB
|
|
|
058-Adding_pictures_as_worksheet_backgrounds.mp4
|
MP4
|
20.05 MB
|
|
|
058-Adding_pictures_as_worksheet_backgrounds.srt
|
SRT
|
10.33 KB
|
|
|
059-ADDRESS_ROW_and_COLUMN_functions.mp4
|
MP4
|
27.67 MB
|
|
|
059-ADDRESS_ROW_and_COLUMN_functions.srt
|
SRT
|
15.98 KB
|
|
|
060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4
|
MP4
|
17.57 MB
|
|
|
060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt
|
SRT
|
11.48 KB
|
|
|
061-Working_with_formulas_in_tables.mp4
|
MP4
|
48.15 MB
|
|
|
061-Working_with_formulas_in_tables.srt
|
SRT
|
27.97 KB
|
|
|
062-Locating_Data_Validation_rules_and_violations.mp4
|
MP4
|
28.54 MB
|
|
|
062-Locating_Data_Validation_rules_and_violations.srt
|
SRT
|
14.8 KB
|
|
|
063-Creating_an_Excel_template.mp4
|
MP4
|
23.18 MB
|
|
|
063-Creating_an_Excel_template.srt
|
SRT
|
16.2 KB
|
|
|
064-Restoring_missing_column_titles.mp4
|
MP4
|
26.37 MB
|
|
|
064-Restoring_missing_column_titles.srt
|
SRT
|
13.57 KB
|
|
|
065-Creating_a_pick_list_dependent_on_another_pick_list.mp4
|
MP4
|
18.84 MB
|
|
|
065-Creating_a_pick_list_dependent_on_another_pick_list.srt
|
SRT
|
13.61 KB
|
|
|
066-Pasting_picture_links.mp4
|
MP4
|
31.03 MB
|
|
|
066-Pasting_picture_links.srt
|
SRT
|
18.47 KB
|
|
|
067-Using_Command_Shortcuts_with_the_Alt_key.mp4
|
MP4
|
20.2 MB
|
|
|
067-Using_Command_Shortcuts_with_the_Alt_key.srt
|
SRT
|
10.95 KB
|
|
|
068-Set_up_a_macro_for_sorting_dynamic_data.mp4
|
MP4
|
28.18 MB
|
|
|
068-Set_up_a_macro_for_sorting_dynamic_data.srt
|
SRT
|
18.61 KB
|
|
|
069-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4
|
MP4
|
28.83 MB
|
|
|
069-Use_random_number_functions_for_sorting_and_creating_sample_data.srt
|
SRT
|
19.95 KB
|
|
|
070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4
|
MP4
|
26.32 MB
|
|
|
070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt
|
SRT
|
17.06 KB
|
|
|
071-Replace_characters_by_position_with_the_REPLACE_function.mp4
|
MP4
|
15.57 MB
|
|
|
071-Replace_characters_by_position_with_the_REPLACE_function.srt
|
SRT
|
10.11 KB
|
|
|
072-Work_with_formulas_in_tables.mp4
|
MP4
|
30.04 MB
|
|
|
072-Work_with_formulas_in_tables.srt
|
SRT
|
17.81 KB
|
|
|
073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4
|
MP4
|
55.03 MB
|
|
|
073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt
|
SRT
|
31.23 KB
|
|
|
074-Use_special_tricks_for_working_with_dates_in_Charts.mp4
|
MP4
|
33.2 MB
|
|
|
074-Use_special_tricks_for_working_with_dates_in_Charts.srt
|
SRT
|
21.02 KB
|
|
|
075-Use_a_data_form_for_data_entry_and_exploring_data.mp4
|
MP4
|
24.91 MB
|
|
|
075-Use_a_data_form_for_data_entry_and_exploring_data.srt
|
SRT
|
12.95 KB
|
|
|
076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4
|
MP4
|
19.66 MB
|
|
|
076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt
|
SRT
|
13.61 KB
|
|
|
077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4
|
MP4
|
22.16 MB
|
|
|
077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt
|
SRT
|
14.37 KB
|
|
|
078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4
|
MP4
|
19.17 MB
|
|
|
078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt
|
SRT
|
12.36 KB
|
|
|
079-How_to_use_locked_cells_and_sheet_protection.mp4
|
MP4
|
35.04 MB
|
|
|
079-How_to_use_locked_cells_and_sheet_protection.srt
|
SRT
|
19.44 KB
|
|
|
080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4
|
MP4
|
20.84 MB
|
|
|
080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt
|
SRT
|
13.31 KB
|
|
|
081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4
|
MP4
|
27.8 MB
|
|
|
081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt
|
SRT
|
14.85 KB
|
|
|
082-Use_slicers_and_charts_together_for_dynamic_presentations.mp4
|
MP4
|
29.07 MB
|
|
|
082-Use_slicers_and_charts_together_for_dynamic_presentations.srt
|
SRT
|
17.61 KB
|
|
|
083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4
|
MP4
|
18.4 MB
|
|
|
083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt
|
SRT
|
12.29 KB
|
|
|
084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4
|
MP4
|
22.7 MB
|
|
|
084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt
|
SRT
|
14.94 KB
|
|
|
085-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4
|
MP4
|
25.94 MB
|
|
|
085-Adjust_a_charts_source_data_and_adjust_its_series_order.srt
|
SRT
|
17.46 KB
|
|
|
086-Use_the_OFFSET_function_for_tabulating_moving_data.mp4
|
MP4
|
30.82 MB
|
|
|
086-Use_the_OFFSET_function_for_tabulating_moving_data.srt
|
SRT
|
19.72 KB
|
|
|
087-Alter_numeric_data_without_formulas.mp4
|
MP4
|
37.41 MB
|
|
|
087-Alter_numeric_data_without_formulas.srt
|
SRT
|
19.19 KB
|
|
|
088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4
|
MP4
|
34.31 MB
|
|
|
088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt
|
SRT
|
19.02 KB
|
|
|
089-Adjust_banded_row_formatting.mp4
|
MP4
|
57.78 MB
|
|
|
089-Adjust_banded_row_formatting.srt
|
SRT
|
28.13 KB
|
|
|
090-Change_the_shape_of_comment_boxes_and_other_objects.mp4
|
MP4
|
19.25 MB
|
|
|
090-Change_the_shape_of_comment_boxes_and_other_objects.srt
|
SRT
|
12.53 KB
|
|
|
091-How_and_when_to_use_Excels_10_rounding_functions.mp4
|
MP4
|
35.35 MB
|
|
|
091-How_and_when_to_use_Excels_10_rounding_functions.srt
|
SRT
|
24.22 KB
|
|
|
092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4
|
MP4
|
18.91 MB
|
|
|
092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt
|
SRT
|
13.33 KB
|
|
|
093-How_to_use_mixed_cell_references.mp4
|
MP4
|
23.41 MB
|
|
|
093-How_to_use_mixed_cell_references.srt
|
SRT
|
15.79 KB
|
|
|
094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4
|
MP4
|
17.84 MB
|
|
|
094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt
|
SRT
|
11.83 KB
|
|
|
095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4
|
MP4
|
14.71 MB
|
|
|
095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt
|
SRT
|
9.55 KB
|
|
|
096-Accelerate_data_entry_with_five_special_techniques.mp4
|
MP4
|
31.52 MB
|
|
|
096-Accelerate_data_entry_with_five_special_techniques.srt
|
SRT
|
23.29 KB
|
|
|
097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4
|
MP4
|
16.99 MB
|
|
|
097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt
|
SRT
|
12.22 KB
|
|
|
098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4
|
MP4
|
29.69 MB
|
|
|
098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt
|
SRT
|
15.54 KB
|
|
|
099-How_to_create_time_interval_entries.mp4
|
MP4
|
32.38 MB
|
|
|
099-How_to_create_time_interval_entries.srt
|
SRT
|
21.29 KB
|
|
|
100-How_to_create_frequency_tabulations_and_distributions.mp4
|
MP4
|
24.93 MB
|
|
|
100-How_to_create_frequency_tabulations_and_distributions.srt
|
SRT
|
13.99 KB
|
|
|
101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4
|
MP4
|
36.74 MB
|
|
|
101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt
|
SRT
|
13.27 KB
|
|
|
102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4
|
MP4
|
35.66 MB
|
|
|
102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt
|
SRT
|
18.36 KB
|
|
|
103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4
|
MP4
|
16.52 MB
|
|
|
103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt
|
SRT
|
13.89 KB
|
|
|
104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4
|
MP4
|
35.93 MB
|
|
|
104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt
|
SRT
|
17.65 KB
|
|
|
105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4
|
MP4
|
30.07 MB
|
|
|
105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt
|
SRT
|
18.38 KB
|
|
|
106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4
|
MP4
|
29.79 MB
|
|
|
106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt
|
SRT
|
19.24 KB
|
|
|
107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4
|
MP4
|
29.86 MB
|
|
|
107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt
|
SRT
|
21.38 KB
|
|
|
108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4
|
MP4
|
38.99 MB
|
|
|
108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt
|
SRT
|
25.09 KB
|
|
|
109-Keyboard_shortcuts_for_numeric_formats.mp4
|
MP4
|
25.85 MB
|
|
|
109-Keyboard_shortcuts_for_numeric_formats.srt
|
SRT
|
15.06 KB
|
|
|
11-Exploring_various_layouts_for_your_PivotTable.mp4
|
MP4
|
13.86 MB
|
|
|
11-Exploring_various_layouts_for_your_PivotTable.srt
|
SRT
|
8.42 KB
|
|
|
110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4
|
MP4
|
41.35 MB
|
|
|
110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt
|
SRT
|
16.77 KB
|
|
|
111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4
|
MP4
|
24.59 MB
|
|
|
111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt
|
SRT
|
16.08 KB
|
|
|
112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4
|
MP4
|
24.29 MB
|
|
|
112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt
|
SRT
|
16.76 KB
|
|
|
113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4
|
MP4
|
29.82 MB
|
|
|
113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt
|
SRT
|
19.06 KB
|
|
|
114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4
|
MP4
|
29.38 MB
|
|
|
114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt
|
SRT
|
14.74 KB
|
|
|
115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4
|
MP4
|
40.93 MB
|
|
|
115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt
|
SRT
|
22.07 KB
|
|
|
116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4
|
MP4
|
11.45 MB
|
|
|
116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt
|
SRT
|
8.74 KB
|
|
|
117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4
|
MP4
|
19.03 MB
|
|
|
117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt
|
SRT
|
13.03 KB
|
|
|
118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4
|
MP4
|
17.39 MB
|
|
|
118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt
|
SRT
|
10.36 KB
|
|
|
119-Displaying_multiple_worksheets_and_workbooks_together.mp4
|
MP4
|
32.4 MB
|
|
|
119-Displaying_multiple_worksheets_and_workbooks_together.srt
|
SRT
|
20.07 KB
|
|
|
12-Splitting_and_consolidating_workbooks.mp4
|
MP4
|
20.53 MB
|
|
|
12-Splitting_and_consolidating_workbooks.srt
|
SRT
|
12.99 KB
|
|
|
120-Tips_for_creating_and_updating_sample_data.mp4
|
MP4
|
31.62 MB
|
|
|
120-Tips_for_creating_and_updating_sample_data.srt
|
SRT
|
20.85 KB
|
|
|
121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4
|
MP4
|
24.14 MB
|
|
|
121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt
|
SRT
|
15.88 KB
|
|
|
122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4
|
MP4
|
29.89 MB
|
|
|
122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt
|
SRT
|
18.79 KB
|
|
|
123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4
|
MP4
|
23.43 MB
|
|
|
123-Summarize_data_from_different_worksheets_with_a_PivotTable.srt
|
SRT
|
13.35 KB
|
|
|
124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4
|
MP4
|
20.22 MB
|
|
|
124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt
|
SRT
|
12.88 KB
|
|
|
125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4
|
MP4
|
24.27 MB
|
|
|
125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt
|
SRT
|
15.4 KB
|
|
|
126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4
|
MP4
|
35.01 MB
|
|
|
126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt
|
SRT
|
22.53 KB
|
|
|
127-Dealing_with_circular_errors.mp4
|
MP4
|
22.37 MB
|
|
|
127-Dealing_with_circular_errors.srt
|
SRT
|
14.57 KB
|
|
|
128-Tips_for_creating_charts_quickly.mp4
|
MP4
|
19.24 MB
|
|
|
128-Tips_for_creating_charts_quickly.srt
|
SRT
|
12.95 KB
|
|
|
129-Creating_heat_maps_using_conditional_formatting.mp4
|
MP4
|
34.91 MB
|
|
|
129-Creating_heat_maps_using_conditional_formatting.srt
|
SRT
|
15.55 KB
|
|
|
13-Using_date_and_time_as_metrics_in_a_PivotTable.mp4
|
MP4
|
23.2 MB
|
|
|
13-Using_date_and_time_as_metrics_in_a_PivotTable.srt
|
SRT
|
13.42 KB
|
|
|
130-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4
|
MP4
|
28.38 MB
|
|
|
130-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt
|
SRT
|
20.02 KB
|
|
|
131-Displaying_tips_when_using_Excel_in_presentations.mp4
|
MP4
|
29.65 MB
|
|
|
131-Displaying_tips_when_using_Excel_in_presentations.srt
|
SRT
|
11.59 KB
|
|
|
132-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4
|
MP4
|
30.35 MB
|
|
|
132-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt
|
SRT
|
17.32 KB
|
|
|
133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4
|
MP4
|
17.05 MB
|
|
|
133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt
|
SRT
|
10.29 KB
|
|
|
134-Working_with_multiple_worksheets_simultaneously.mp4
|
MP4
|
25.99 MB
|
|
|
134-Working_with_multiple_worksheets_simultaneously.srt
|
SRT
|
17.96 KB
|
|
|
135-Exploring_font_choices_not_found_on_the_Home_tab.mp4
|
MP4
|
11.68 MB
|
|
|
135-Exploring_font_choices_not_found_on_the_Home_tab.srt
|
SRT
|
7.38 KB
|
|
|
136-Using_WordArt_for_special_titles_and_headings.mp4
|
MP4
|
14.54 MB
|
|
|
136-Using_WordArt_for_special_titles_and_headings.srt
|
SRT
|
8.78 KB
|
|
|
137-Differentiating_weekdays_and_weekends_in_Excel_data.mp4
|
MP4
|
31.82 MB
|
|
|
137-Differentiating_weekdays_and_weekends_in_Excel_data.srt
|
SRT
|
21.4 KB
|
|
|
138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4
|
MP4
|
22.8 MB
|
|
|
138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt
|
SRT
|
12.9 KB
|
|
|
139-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4
|
MP4
|
25.12 MB
|
|
|
139-Borders_and_gridlines_Exploring_variations_options_and_differences.srt
|
SRT
|
16.42 KB
|
|
|
140-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4
|
MP4
|
30.13 MB
|
|
|
140-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt
|
SRT
|
15.37 KB
|
|
|
141-Freezing_column_and_row_titles.mp4
|
MP4
|
41.85 MB
|
|
|
141-Freezing_column_and_row_titles.srt
|
SRT
|
14.54 KB
|
|
|
142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4
|
MP4
|
25.51 MB
|
|
|
142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt
|
SRT
|
20.02 KB
|
|
|
143-Avoiding_common_chart_distortions.mp4
|
MP4
|
32.73 MB
|
|
|
143-Avoiding_common_chart_distortions.srt
|
SRT
|
21.49 KB
|
|
|
144-Use_the_new_Funnel_chart_available_in_Excel_365.mp4
|
MP4
|
10.63 MB
|
|
|
144-Use_the_new_Funnel_chart_available_in_Excel_365.srt
|
SRT
|
8.49 KB
|
|
|
145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4
|
MP4
|
15.23 MB
|
|
|
145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt
|
SRT
|
11.54 KB
|
|
|
146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4
|
MP4
|
28.07 MB
|
|
|
146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt
|
SRT
|
18.09 KB
|
|
|
147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4
|
MP4
|
17.62 MB
|
|
|
147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt
|
SRT
|
10.33 KB
|
|
|
148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4
|
MP4
|
28.03 MB
|
|
|
148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt
|
SRT
|
18.34 KB
|
|
|
149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4
|
MP4
|
27.92 MB
|
|
|
149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt
|
SRT
|
17.69 KB
|
|
|
150-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4
|
MP4
|
18.54 MB
|
|
|
150-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt
|
SRT
|
12.98 KB
|
|
|
151-Sorting_tips_and_shortcuts.mp4
|
MP4
|
32.43 MB
|
|
|
151-Sorting_tips_and_shortcuts.srt
|
SRT
|
16.44 KB
|
|
|
152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4
|
MP4
|
17.99 MB
|
|
|
152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt
|
SRT
|
13.12 KB
|
|
|
153-Work_with_formulas_and_formats_Decimals_and_fractions.mp4
|
MP4
|
13.53 MB
|
|
|
153-Work_with_formulas_and_formats_Decimals_and_fractions.srt
|
SRT
|
10.65 KB
|
|
|
154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4
|
MP4
|
27.89 MB
|
|
|
154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt
|
SRT
|
13.92 KB
|
|
|
155-Control_gridlines_in_charts_and_on_worksheets.mp4
|
MP4
|
21.68 MB
|
|
|
155-Control_gridlines_in_charts_and_on_worksheets.srt
|
SRT
|
14.64 KB
|
|
|
156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4
|
MP4
|
20.16 MB
|
|
|
156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt
|
SRT
|
11.9 KB
|
|
|
157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4
|
MP4
|
21.95 MB
|
|
|
157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt
|
SRT
|
13.75 KB
|
|
|
158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4
|
MP4
|
18.7 MB
|
|
|
158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt
|
SRT
|
13.36 KB
|
|
|
159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4
|
MP4
|
19.14 MB
|
|
|
159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt
|
SRT
|
11.66 KB
|
|
|
160-Create_your_own_customized_date_and_time_formats.mp4
|
MP4
|
22.5 MB
|
|
|
160-Create_your_own_customized_date_and_time_formats.srt
|
SRT
|
14.66 KB
|
|
|
161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4
|
MP4
|
18.79 MB
|
|
|
161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt
|
SRT
|
11.61 KB
|
|
|
162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4
|
MP4
|
22.46 MB
|
|
|
162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt
|
SRT
|
10.96 KB
|
|
|
163-Create_numeric_formats_Display_in_thousands_or_millions.mp4
|
MP4
|
35.8 MB
|
|
|
163-Create_numeric_formats_Display_in_thousands_or_millions.srt
|
SRT
|
21.69 KB
|
|
|
164-Converting_dates_like_20102006_into_usable_date_entries.mp4
|
MP4
|
11.98 MB
|
|
|
164-Converting_dates_like_20102006_into_usable_date_entries.srt
|
SRT
|
7.99 KB
|
|
|
165-Create_custom_lists_for_letter_series_like_A_to_Z.mp4
|
MP4
|
28.74 MB
|
|
|
165-Create_custom_lists_for_letter_series_like_A_to_Z.srt
|
SRT
|
12.31 KB
|
|
|
166-Freeze_Panes_and_Split.mp4
|
MP4
|
30.26 MB
|
|
|
166-Freeze_Panes_and_Split.srt
|
SRT
|
11.51 KB
|
|
|
167-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4
|
MP4
|
14.74 MB
|
|
|
167-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt
|
SRT
|
10.52 KB
|
|
|
168-Calculate_%_of_change.mp4
|
MP4
|
14 MB
|
|
|
168-Calculate_%_of_change.srt
|
SRT
|
10.08 KB
|
|
|
169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4
|
MP4
|
16.56 MB
|
|
|
169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt
|
SRT
|
8.41 KB
|
|
|
170-Use_the_COUNT_and_COUNTA_functions.mp4
|
MP4
|
13.93 MB
|
|
|
170-Use_the_COUNT_and_COUNTA_functions.srt
|
SRT
|
7.83 KB
|
|
|
171-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4
|
MP4
|
18 MB
|
|
|
171-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt
|
SRT
|
11.15 KB
|
|
|
172-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4
|
MP4
|
16.11 MB
|
|
|
172-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt
|
SRT
|
10.98 KB
|
|
|
173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp4
|
MP4
|
18.83 MB
|
|
|
173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt
|
SRT
|
10.41 KB
|
|
|
174-Identify_or_extract_unique_entries_in_a_list.mp4
|
MP4
|
22.68 MB
|
|
|
174-Identify_or_extract_unique_entries_in_a_list.srt
|
SRT
|
10.54 KB
|
|
|
175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp4
|
MP4
|
27.06 MB
|
|
|
175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt
|
SRT
|
10.78 KB
|
|
|
176-Create_artistic_charts_with_random_numbers.mp4
|
MP4
|
22.72 MB
|
|
|
176-Create_artistic_charts_with_random_numbers.srt
|
SRT
|
14.57 KB
|
|
|
177-Extract_day_month_and_year_from_date_fields.mp4
|
MP4
|
13.15 MB
|
|
|
177-Extract_day_month_and_year_from_date_fields.srt
|
SRT
|
9.75 KB
|
|
|
178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4
|
MP4
|
13.17 MB
|
|
|
178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt
|
SRT
|
9.54 KB
|
|
|
179-How_to_covert_ROMAN_numberals.mp4
|
MP4
|
13.25 MB
|
|
|
179-How_to_covert_ROMAN_numberals.srt
|
SRT
|
7.88 KB
|
|
|
180-Use_range_names_for_more_readable_formulas.mp4
|
MP4
|
15.5 MB
|
|
|
180-Use_range_names_for_more_readable_formulas.srt
|
SRT
|
9.93 KB
|
|
|
181-Customize_your_Quick_Access_Toolbar.mp4
|
MP4
|
20.33 MB
|
|
|
181-Customize_your_Quick_Access_Toolbar.srt
|
SRT
|
11.12 KB
|
|
|
182-Conditional_formatting_based_on_date_proximity.mp4
|
MP4
|
13.75 MB
|
|
|
182-Conditional_formatting_based_on_date_proximity.srt
|
SRT
|
9.21 KB
|
|
|
183-How_to_adjust_names.mp4
|
MP4
|
16.21 MB
|
|
|
183-How_to_adjust_names.srt
|
SRT
|
9.82 KB
|
|
|
184-Differences_and_limitations_of_converting_data_to_a_table.mp4
|
MP4
|
18.78 MB
|
|
|
184-Differences_and_limitations_of_converting_data_to_a_table.srt
|
SRT
|
9.97 KB
|
|
|
185-Avoid_the_#DIV_0_error_message.mp4
|
MP4
|
13.76 MB
|
|
|
185-Avoid_the_#DIV_0_error_message.srt
|
SRT
|
9.47 KB
|
|
|
186-Explore_formatting_options_not_available_on_the_Home_tab.mp4
|
MP4
|
15.55 MB
|
|
|
186-Explore_formatting_options_not_available_on_the_Home_tab.srt
|
SRT
|
8 KB
|
|
|
187-Control_table_formatting_with_custom_formats.mp4
|
MP4
|
12.2 MB
|
|
|
187-Control_table_formatting_with_custom_formats.srt
|
SRT
|
6.23 KB
|
|
|
188-Use_date_functions_for_age_and_tenure_calculations.mp4
|
MP4
|
16.43 MB
|
|
|
188-Use_date_functions_for_age_and_tenure_calculations.srt
|
SRT
|
10.57 KB
|
|
|
189-Avoid_unintentional_entries_when_typing_code_numbers.mp4
|
MP4
|
9.52 MB
|
|
|
189-Avoid_unintentional_entries_when_typing_code_numbers.srt
|
SRT
|
8.01 KB
|
|
|
190-Sorting_by_moving_columns.mp4
|
MP4
|
15.31 MB
|
|
|
190-Sorting_by_moving_columns.srt
|
SRT
|
7.83 KB
|
|
|
191-Calculating_cumulative_totals.mp4
|
MP4
|
11.22 MB
|
|
|
191-Calculating_cumulative_totals.srt
|
SRT
|
7.63 KB
|
|
|
192-Using_the_CONVERT_function_for_different_numbering_systems.mp4
|
MP4
|
12.85 MB
|
|
|
192-Using_the_CONVERT_function_for_different_numbering_systems.srt
|
SRT
|
8.24 KB
|
|
|
193-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.mp4
|
MP4
|
11.3 MB
|
|
|
193-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.srt
|
SRT
|
7.97 KB
|
|
|
194-Keystroke_shortcuts_using_the_Alt_key.mp4
|
MP4
|
14.71 MB
|
|
|
194-Keystroke_shortcuts_using_the_Alt_key.srt
|
SRT
|
10.9 KB
|
|
|
195-Using_the_Solver_Add-in.mp4
|
MP4
|
11.75 MB
|
|
|
195-Using_the_Solver_Add-in.srt
|
SRT
|
7.73 KB
|
|
|
196-Column_widths_row_heights_merging_cells_and_related_formatting_issues.mp4
|
MP4
|
10.97 MB
|
|
|
196-Column_widths_row_heights_merging_cells_and_related_formatting_issues.srt
|
SRT
|
9.98 KB
|
|
|
197-Adjusting_default_layouts_and_date_grouping_in_PivotTables.mp4
|
MP4
|
11.42 MB
|
|
|
197-Adjusting_default_layouts_and_date_grouping_in_PivotTables.srt
|
SRT
|
7.82 KB
|
|
|
198-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.mp4
|
MP4
|
9.94 MB
|
|
|
198-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.srt
|
SRT
|
7.92 KB
|
|
|
199-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.mp4
|
MP4
|
10.58 MB
|
|
|
199-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.srt
|
SRT
|
10.3 KB
|
|
|
200-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.mp4
|
MP4
|
11.98 MB
|
|
|
200-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.srt
|
SRT
|
10.23 KB
|
|
|
201-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.mp4
|
MP4
|
12.71 MB
|
|
|
201-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.srt
|
SRT
|
9.79 KB
|
|
|
202-Helpful_keystroke_shortcuts.mp4
|
MP4
|
21.27 MB
|
|
|
202-Helpful_keystroke_shortcuts.srt
|
SRT
|
9.6 KB
|
|
|
203-Identify_weekdays_and_weekend_days_in_data.mp4
|
MP4
|
11.98 MB
|
|
|
203-Identify_weekdays_and_weekend_days_in_data.srt
|
SRT
|
6.92 KB
|
|
|
204-Use_chart_and_filter_for_presentations.mp4
|
MP4
|
9.52 MB
|
|
|
204-Use_chart_and_filter_for_presentations.srt
|
SRT
|
9.19 KB
|
|
|
205-Create_picture_links.mp4
|
MP4
|
19.23 MB
|
|
|
205-Create_picture_links.srt
|
SRT
|
8.41 KB
|
|
|
206-How_to_use_the_error_checking_rules_in_Excel.mp4
|
MP4
|
13.63 MB
|
|
|
206-How_to_use_the_error_checking_rules_in_Excel.srt
|
SRT
|
10.03 KB
|
|
|
207-Protect_worksheets_and_lock_cells.mp4
|
MP4
|
17.24 MB
|
|
|
207-Protect_worksheets_and_lock_cells.srt
|
SRT
|
7.77 KB
|
|
|
208-Use_mixed_addresses_in_Excel_formulas.mp4
|
MP4
|
12.68 MB
|
|
|
208-Use_mixed_addresses_in_Excel_formulas.srt
|
SRT
|
9.53 KB
|
|
|
209-Rapid_filtering_with_Filter_by_Selection.mp4
|
MP4
|
12.68 MB
|
|
|
209-Rapid_filtering_with_Filter_by_Selection.srt
|
SRT
|
9.87 KB
|
|
|
210-Display_large_values.mp4
|
MP4
|
17.27 MB
|
|
|
210-Display_large_values.srt
|
SRT
|
6.64 KB
|
|
|
211-Tracking_down_conditional_formatting_and_data_validation_rules.mp4
|
MP4
|
18.94 MB
|
|
|
211-Tracking_down_conditional_formatting_and_data_validation_rules.srt
|
SRT
|
10.22 KB
|
|
|
Exercise Files
|
![[LinkedIn] Excel Tips Weekly (2015-2019) MP4 WEB 720p - EN](/static/img/no-torrent-image.png "[LinkedIn] Excel Tips Weekly (2015-2019) MP4 WEB 720p - EN")
