[LinkedIn] Excel Tips Weekly (2015-2019) MP4 WEB 720p - EN

seeders: 0
leechers: 0
Added 7 years ago by Totiney in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

[LinkedIn] Excel Tips Weekly (2015-2019) MP4 WEB 720p - EN (Size: 4.9 GB)
  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

Description


0rg5.jpg?042148



É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




Détails du cours

This
tips-based course will show Excel users productivity-boosting tricks,
cool hidden features, need-to-know functions, and advanced content on
subjects such as using PivotTables for data analysis. Tune in every
Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a
short, self-contained lesson guaranteed to give you new insights into
Excel.
?

q2du.jpg?042148

05r7.jpg?042148


About the Author



n51c.jpg?042148
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.

Related Torrents

torrent name size uploader age seed leech
0
0
0
1
0