2015-2018-Lynda-Excel_Tips_Weekly_()-IVY 收录时间:2018-05-08 00:16:18 文件大小:4GB 下载次数:73 最近下载:2020-05-01 15:40:08 磁力链接: magnet:?xt=urn:btih:32a965dce48f13e62b8b5ce695b4ae371d77f584 立即下载 复制链接 文件列表 089-Adjust_banded_row_formatting.mp4 58MB 073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 55MB 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 51MB 061-Working_with_formulas_in_tables.mp4 48MB 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 48MB 141-Freezing_column_and_row_titles.mp4 42MB 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 41MB 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4 41MB 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 40MB 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 40MB 048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 39MB 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 39MB 047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 38MB 087-Alter_numeric_data_without_formulas.mp4 37MB 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 37MB 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 36MB 163-Create_numeric_formats_Display_in_thousands_or_millions.mp4 36MB 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 36MB 091-How_and_when_to_use_Excels_10_rounding_functions.mp4 35MB 079-How_to_use_locked_cells_and_sheet_protection.mp4 35MB 126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4 35MB 129-Creating_heat_maps_using_conditional_formatting.mp4 35MB 088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 34MB 052-Using_Excels_error_checking_functions.mp4 34MB 014-Adding_illustrations_to_your_workbook.mp4 34MB 074-Use_special_tricks_for_working_with_dates_in_Charts.mp4 33MB 057-Building_a_flexible_monthly_table_using_functions.mp4 33MB 143-Avoiding_common_chart_distortions.mp4 33MB 151-Sorting_tips_and_shortcuts.mp4 32MB 119-Displaying_multiple_worksheets_and_workbooks_together.mp4 32MB 099-How_to_create_time_interval_entries.mp4 32MB 137-Differentiating_weekdays_and_weekends_in_Excel_data.mp4 32MB 120-Tips_for_creating_and_updating_sample_data.mp4 32MB 096-Accelerate_data_entry_with_five_special_techniques.mp4 32MB 066-Pasting_picture_links.mp4 31MB 086-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 31MB 045-Creating_Variable_Conditional_Formatting_Rules.mp4 31MB 054-Auditing.mp4 31MB 132-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4 30MB 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 30MB 140-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4 30MB 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 30MB 072-Work_with_formulas_in_tables.mp4 30MB 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4 30MB 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 30MB 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 30MB 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 30MB 098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 30MB 034-Calculating_with_hours_minutes_and_times_of_day.mp4 30MB 131-Displaying_tips_when_using_Excel_in_presentations.mp4 30MB 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 30MB 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 29MB 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 29MB 082-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 29MB 069-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 29MB 062-Locating_Data_Validation_rules_and_violations.mp4 29MB 130-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4 28MB 068-Set_up_a_macro_for_sorting_dynamic_data.mp4 28MB 146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4 28MB 043-Exploring_what_if_scenarios_using_Goal_Seek.mp4 28MB 148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4 28MB 149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4 28MB 154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4 28MB 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 28MB 081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 28MB 059-ADDRESS_ROW_and_COLUMN_functions.mp4 28MB 064-Restoring_missing_column_titles.mp4 26MB 070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 26MB 134-Working_with_multiple_worksheets_simultaneously.mp4 26MB 085-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 26MB 109-Keyboard_shortcuts_for_numeric_formats.mp4 26MB 030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 26MB 142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4 26MB 055-Adding_comments_and_shapes.mp4 25MB 139-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4 25MB 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 25MB 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 25MB 100-How_to_create_frequency_tabulations_and_distributions.mp4 25MB 075-Use_a_data_form_for_data_entry_and_exploring_data.mp4 25MB 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 25MB 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 24MB 125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4 24MB 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 24MB 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4 24MB 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 24MB 053-Custom_formats_relative_addressing_and_conditional_formatting.mp4 24MB 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 24MB 050-Create_an_Organization_Chart.mp4 24MB 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 24MB 123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4 23MB 093-How_to_use_mixed_cell_references.mp4 23MB 029-Quick_formatting_tips.mp4 23MB 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 23MB 013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23MB 13-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23MB 063-Creating_an_Excel_template.mp4 23MB 138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4 23MB 084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 23MB 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 23MB 160-Create_your_own_customized_date_and_time_formats.mp4 23MB 162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4 22MB 127-Dealing_with_circular_errors.mp4 22MB 077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 22MB 157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4 22MB 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 22MB 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 22MB 155-Control_gridlines_in_charts_and_on_worksheets.mp4 22MB 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 22MB 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 21MB 056-Drawing_borders_and_border_grids.mp4 21MB 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 21MB 022-Increasing_your_productivity_with_custom_lists.mp4 21MB 080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 21MB 012-Splitting_and_consolidating_workbooks.mp4 21MB 12-Splitting_and_consolidating_workbooks.mp4 21MB 010-Applying_conditional_formatting_across_rows_of_data.mp4 20MB 017-Dynamically_presenting_data_via_chart_slicers.mp4 20MB 024-Customizing_templates_to_fit_your_unique_needs.mp4 20MB 046-Handling_Dates_with_unusual_formats.mp4 20MB 124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4 20MB 067-Using_Command_Shortcuts_with_the_Alt_key.mp4 20MB 026-Enhancing_table_filtering_with_slicers.mp4 20MB 156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4 20MB 058-Adding_pictures_as_worksheet_backgrounds.mp4 20MB 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 20MB 076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 20MB 037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 19MB 090-Change_the_shape_of_comment_boxes_and_other_objects.mp4 19MB 128-Tips_for_creating_charts_quickly.mp4 19MB 023-Highlighting_PivotTable_results_with_conditional_formatting.mp4 19MB 078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 19MB 159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4 19MB 117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 19MB 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 19MB 092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 19MB 065-Creating_a_pick_list_dependent_on_another_pick_list.mp4 19MB 161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4 19MB 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4 19MB 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4 19MB 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18MB 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4 18MB 044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 18MB 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4 18MB 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4 18MB 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 18MB 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 17MB 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17MB 001-Hide_and_unhide_worksheets_securely.mp4 17MB 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 17MB 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 17MB 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16MB 027-Converting_charts_into_pictures.mp4 16MB 071-Replace_characters_by_position_with_the_REPLACE_function.mp4 16MB 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4 15MB 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 15MB 136-Using_WordArt_for_special_titles_and_headings.mp4 15MB 018-Parsing_your_data_to_create_unique_lists.mp4 15MB 011-Exploring_various_layouts_for_your_PivotTable.mp4 14MB 11-Exploring_various_layouts_for_your_PivotTable.mp4 14MB 153-Work_with_formulas_and_formats_Decimals_and_fractions.mp4 14MB 028-Custom_grouping_in_PivotTables.mp4 13MB 135-Exploring_font_choices_not_found_on_the_Home_tab.mp4 12MB 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11MB 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 11MB 144-Use_the_new_Funnel_chart_available_in_Excel_365.mp4 11MB 019-Using_the_REPT_function_to_represent_data_visually.mp4 9MB 073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31KB 089-Adjust_banded_row_formatting.srt 28KB 061-Working_with_formulas_in_tables.srt 28KB 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25KB 091-How_and_when_to_use_Excels_10_rounding_functions.srt 24KB 057-Building_a_flexible_monthly_table_using_functions.srt 24KB 096-Accelerate_data_entry_with_five_special_techniques.srt 23KB 014-Adding_illustrations_to_your_workbook.srt 23KB 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 23KB 126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 23KB 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22KB 048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22KB 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22KB 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22KB 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 22KB 163-Create_numeric_formats_Display_in_thousands_or_millions.srt 22KB 143-Avoiding_common_chart_distortions.srt 21KB 137-Differentiating_weekdays_and_weekends_in_Excel_data.srt 21KB 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21KB 099-How_to_create_time_interval_entries.srt 21KB 074-Use_special_tricks_for_working_with_dates_in_Charts.srt 21KB 120-Tips_for_creating_and_updating_sample_data.srt 21KB 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 21KB 052-Using_Excels_error_checking_functions.srt 20KB 119-Displaying_multiple_worksheets_and_workbooks_together.srt 20KB 142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt 20KB 130-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20KB 069-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 20KB 086-Use_the_OFFSET_function_for_tabulating_moving_data.srt 20KB 079-How_to_use_locked_cells_and_sheet_protection.srt 19KB 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19KB 087-Alter_numeric_data_without_formulas.srt 19KB 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19KB 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19KB 088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19KB 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 19KB 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 19KB 068-Set_up_a_macro_for_sorting_dynamic_data.srt 19KB 034-Calculating_with_hours_minutes_and_times_of_day.srt 18KB 066-Pasting_picture_links.srt 18KB 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18KB 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18KB 148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt 18KB 146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt 18KB 054-Auditing.srt 18KB 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 18KB 134-Working_with_multiple_worksheets_simultaneously.srt 18KB 072-Work_with_formulas_in_tables.srt 18KB 149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt 18KB 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 18KB 082-Use_slicers_and_charts_together_for_dynamic_presentations.srt 18KB 047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 18KB 085-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17KB 132-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17KB 050-Create_an_Organization_Chart.srt 17KB 070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17KB 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 17KB 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 17KB 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 17KB 151-Sorting_tips_and_shortcuts.srt 16KB 139-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16KB 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16KB 043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16KB 063-Creating_an_Excel_template.srt 16KB 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16KB 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16KB 059-ADDRESS_ROW_and_COLUMN_functions.srt 16KB 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 16KB 093-How_to_use_mixed_cell_references.srt 16KB 055-Adding_comments_and_shapes.srt 16KB 053-Custom_formats_relative_addressing_and_conditional_formatting.srt 16KB 129-Creating_heat_maps_using_conditional_formatting.srt 16KB 098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 16KB 125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15KB 140-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt 15KB 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15KB 109-Keyboard_shortcuts_for_numeric_formats.srt 15KB 084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 15KB 029-Quick_formatting_tips.srt 15KB 081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 15KB 062-Locating_Data_Validation_rules_and_violations.srt 15KB 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 15KB 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 15KB 160-Create_your_own_customized_date_and_time_formats.srt 15KB 155-Control_gridlines_in_charts_and_on_worksheets.srt 15KB 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 15KB 127-Dealing_with_circular_errors.srt 15KB 141-Freezing_column_and_row_titles.srt 15KB 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 15KB 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14KB 045-Creating_Variable_Conditional_Formatting_Rules.srt 14KB 017-Dynamically_presenting_data_via_chart_slicers.srt 14KB 077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14KB 100-How_to_create_frequency_tabulations_and_distributions.srt 14KB 154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt 14KB 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 14KB 037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 14KB 157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt 14KB 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 14KB 065-Creating_a_pick_list_dependent_on_another_pick_list.srt 14KB 076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 14KB 064-Restoring_missing_column_titles.srt 14KB 013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB 13-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt 13KB 123-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13KB 092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13KB 080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13KB 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13KB 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt 13KB 117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13KB 012-Splitting_and_consolidating_workbooks.srt 13KB 12-Splitting_and_consolidating_workbooks.srt 13KB 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt 13KB 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 13KB 075-Use_a_data_form_for_data_entry_and_exploring_data.srt 13KB 128-Tips_for_creating_charts_quickly.srt 13KB 138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 13KB 124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 13KB 056-Drawing_borders_and_border_grids.srt 13KB 090-Change_the_shape_of_comment_boxes_and_other_objects.srt 13KB 001-Hide_and_unhide_worksheets_securely.srt 12KB 044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12KB 078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12KB 024-Customizing_templates_to_fit_your_unique_needs.srt 12KB 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12KB 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12KB 010-Applying_conditional_formatting_across_rows_of_data.srt 12KB 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12KB 156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt 12KB 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt 12KB 030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 12KB 023-Highlighting_PivotTable_results_with_conditional_formatting.srt 12KB 159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt 12KB 161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt 12KB 131-Displaying_tips_when_using_Excel_in_presentations.srt 12KB 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt 12KB 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11KB 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11KB 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11KB 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11KB 046-Handling_Dates_with_unusual_formats.srt 11KB 162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt 11KB 067-Using_Command_Shortcuts_with_the_Alt_key.srt 11KB 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 11KB 153-Work_with_formulas_and_formats_Decimals_and_fractions.srt 11KB 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10KB 058-Adding_pictures_as_worksheet_backgrounds.srt 10KB 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt 10KB 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10KB 026-Enhancing_table_filtering_with_slicers.srt 10KB 071-Replace_characters_by_position_with_the_REPLACE_function.srt 10KB 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10KB 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 10KB 022-Increasing_your_productivity_with_custom_lists.srt 9KB 027-Converting_charts_into_pictures.srt 9KB 136-Using_WordArt_for_special_titles_and_headings.srt 9KB 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 9KB 028-Custom_grouping_in_PivotTables.srt 9KB 144-Use_the_new_Funnel_chart_available_in_Excel_365.srt 8KB 011-Exploring_various_layouts_for_your_PivotTable.srt 8KB 11-Exploring_various_layouts_for_your_PivotTable.srt 8KB 135-Exploring_font_choices_not_found_on_the_Home_tab.srt 7KB 018-Parsing_your_data_to_create_unique_lists.srt 7KB 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6KB 019-Using_the_REPT_function_to_represent_data_visually.srt 6KB
