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

Éditeur : Linkedin (autrefois Lynda)
Date de parution : 2015-2019
Genre : Tableur, feuille de calcul ...
Langue : Anglais avec sous-titres
Niveau de compétences : Intermédiaire
Durée : Plus de 26 heures
Format : MP4 @ 1280 x 720 px
Source : Web-DL 720 @ 436 kbps
Audio : AAC LC @ 64,0 kbps (mono)
Plateforme : PC / MAC
Autres: Fichiers d'exercices inclus



Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.
Dennis
has experience working as an author, speaker, seminar leader, and
facilitator. Since the mid-90s, he has been the author/presenter of
numerous Excel video and online courses and has traveled throughout the
U.S. and Canada presenting over 300 seminars and classes. He has
authored or co-authored multiple books on spreadsheet software and has
presented over 500 Excel webinars to a diversity of audiences. Dennis
has worked with hundreds of different corporations and governmental
agencies as well as colleges and universities. He lives in Boulder,
Colorado.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 379.37 MB | Nawel087 | 1 year | 36 | 0 | |
| 415.95 MB | Nawel087 | 1 year | 26 | 0 | |
| 602.97 MB | Nawel087 | 2 years | 20 | 0 | |
| 143.8 MB | Nawel087 | 2 years | 1 | 1 | |
| 223.39 MB | Nawel087 | 2 years | 36 | 0 |
All Comments