Download link
File List
-
01-Hide_and_unhide_worksheets_securely.mp4 17.01 MB
01-Hide_and_unhide_worksheets_securely.srt 12.48 KB
02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 27.85 MB
02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19.02 KB
03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 21.48 MB
03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 14.51 KB
04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16.4 MB
04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 10.7 KB
05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 23.75 MB
05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 14.7 KB
06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 29.4 MB
06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 17.99 KB
07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 40.45 MB
07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 22.81 KB
08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 24.1 MB
08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16.33 KB
09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 30.3 MB
09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 16.85 KB
10-Applying_conditional_formatting_across_rows_of_data.mp4 20.45 MB
10-Applying_conditional_formatting_across_rows_of_data.srt 12.2 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
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
14-Adding_illustrations_to_your_workbook.mp4 33.62 MB
14-Adding_illustrations_to_your_workbook.srt 22.95 KB
15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 22.57 MB
15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16.1 KB
16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 29.52 MB
16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22.49 KB
17-Dynamically_presenting_data_via_chart_slicers.mp4 20.42 MB
17-Dynamically_presenting_data_via_chart_slicers.srt 14.46 KB
18-Parsing_your_data_to_create_unique_lists.mp4 14.51 MB
18-Parsing_your_data_to_create_unique_lists.srt 6.56 KB
19-Using_the_REPT_function_to_represent_data_visually.mp4 8.82 MB
19-Using_the_REPT_function_to_represent_data_visually.srt 5.91 KB
20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 24.96 MB
20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 14.59 KB
21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 23.25 MB
21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15.14 KB
22-Increasing_your_productivity_with_custom_lists.mp4 20.89 MB
22-Increasing_your_productivity_with_custom_lists.srt 9.44 KB
23-Highlighting_PivotTable_results_with_conditional_formatting.mp4 19.23 MB
23-Highlighting_PivotTable_results_with_conditional_formatting.srt 11.73 KB
24-Customizing_templates_to_fit_your_unique_needs.mp4 20.37 MB
24-Customizing_templates_to_fit_your_unique_needs.srt 12.29 KB
25-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11.49 MB
25-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6.44 KB
26-Enhancing_table_filtering_with_slicers.mp4 20.19 MB
26-Enhancing_table_filtering_with_slicers.srt 10.24 KB
27-Converting_charts_into_pictures.mp4 15.93 MB
27-Converting_charts_into_pictures.srt 8.97 KB
28-Custom_grouping_in_PivotTables.mp4 12.99 MB
28-Custom_grouping_in_PivotTables.srt 8.71 KB
29-Quick_formatting_tips.mp4 23.4 MB
29-Quick_formatting_tips.srt 14.94 KB
30-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 25.61 MB
30-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 11.77 KB
31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 21.61 MB
31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10.09 KB
32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 23.56 MB
32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 18.7 KB
33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 21.88 MB
33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12.1 KB
34-Calculating_with_hours_minutes_and_times_of_day.mp4 29.66 MB
34-Calculating_with_hours_minutes_and_times_of_day.srt 18.48 KB
35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 21.74 MB
35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11.21 KB
36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 40.04 MB
36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 20.64 KB
37-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 19.26 MB
37-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 13.86 KB
38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 18.99 MB
38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11.21 KB
39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 25.08 MB
39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11.34 KB
40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 21.15 MB
40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 13.71 KB
41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 24.18 MB
41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 12.97 KB
42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 19.93 MB
42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14.49 KB
43-Exploring_what_if_scenarios_using_Goal_Seek.mp4 28.04 MB
43-Exploring_what_if_scenarios_using_Goal_Seek.srt 16.22 KB
44-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 17.89 MB
44-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12.4 KB
45-Creating_Variable_Conditional_Formatting_Rules.mp4 30.8 MB
45-Creating_Variable_Conditional_Formatting_Rules.srt 14.47 KB
46-Handling_Dates_with_unusual_formats.mp4 20.25 MB
46-Handling_Dates_with_unusual_formats.srt 10.98 KB
47-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 38.13 MB
47-Using_wildcards_(asterisk_tilde_and_question_mark).srt 17.52 KB
48-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 39.18 MB
48-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22.45 KB
49-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 47.68 MB
49-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22.23 KB
50-Create_an_Organization_Chart.mp4 23.64 MB
50-Create_an_Organization_Chart.srt 17.23 KB
51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 50.68 MB
51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 21.89 KB
52-Using_Excels_error_checking_functions.mp4 33.63 MB
52-Using_Excels_error_checking_functions.srt 20.44 KB
53-Custom_formats_relative_addressing_and_conditional_formatting.mp4 23.95 MB
53-Custom_formats_relative_addressing_and_conditional_formatting.srt 15.63 KB
54-Auditing.mp4 30.66 MB
54-Auditing.srt 18.06 KB
55-Adding_comments_and_shapes.mp4 25.43 MB
55-Adding_comments_and_shapes.srt 15.77 KB
56-Drawing_borders_and_border_grids.mp4 21.36 MB
56-Drawing_borders_and_border_grids.srt 12.55 KB
57-Building_a_flexible_monthly_table_using_functions.mp4 32.81 MB
57-Building_a_flexible_monthly_table_using_functions.srt 23.64 KB
58-Adding_pictures_as_worksheet_backgrounds.mp4 20.05 MB
58-Adding_pictures_as_worksheet_backgrounds.srt 10.33 KB
59-ADDRESS_ROW_and_COLUMN_functions.mp4 27.67 MB
59-ADDRESS_ROW_and_COLUMN_functions.srt 15.98 KB
60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 17.57 MB
60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11.48 KB
61-Working_with_formulas_in_tables.mp4 48.15 MB
61-Working_with_formulas_in_tables.srt 27.97 KB
62-Locating_Data_Validation_rules_and_violations.mp4 28.54 MB
62-Locating_Data_Validation_rules_and_violations.srt 14.8 KB
63-Creating_an_Excel_template.mp4 23.18 MB
63-Creating_an_Excel_template.srt 16.2 KB
64-Restoring_missing_column_titles.mp4 26.37 MB
64-Restoring_missing_column_titles.srt 13.57 KB
65-Creating_a_pick_list_dependent_on_another_pick_list.mp4 18.84 MB
65-Creating_a_pick_list_dependent_on_another_pick_list.srt 13.61 KB
66-Pasting_picture_links.mp4 31.03 MB
66-Pasting_picture_links.srt 18.47 KB
67-Using_Command_Shortcuts_with_the_Alt_key.mp4 20.2 MB
67-Using_Command_Shortcuts_with_the_Alt_key.srt 10.95 KB
68-Set_up_a_macro_for_sorting_dynamic_data.mp4 28.18 MB
68-Set_up_a_macro_for_sorting_dynamic_data.srt 18.61 KB
69-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 28.83 MB
69-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 19.95 KB
70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 26.32 MB
70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17.06 KB
71-Replace_characters_by_position_with_the_REPLACE_function.mp4 15.57 MB
71-Replace_characters_by_position_with_the_REPLACE_function.srt 10.11 KB
72-Work_with_formulas_in_tables.mp4 30.04 MB
72-Work_with_formulas_in_tables.srt 17.81 KB
73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 55.03 MB
73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31.23 KB
74-Use_special_tricks_for_working_with_dates_in_Charts.mp4 33.2 MB
74-Use_special_tricks_for_working_with_dates_in_Charts.srt 21.02 KB
75-Use_a_data_form_for_data_entry_and_exploring_data.mp4 24.91 MB
75-Use_a_data_form_for_data_entry_and_exploring_data.srt 12.95 KB
76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 19.66 MB
76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 13.61 KB
77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 22.16 MB
77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14.37 KB
78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 19.17 MB
78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12.36 KB
79-How_to_use_locked_cells_and_sheet_protection.mp4 35.04 MB
79-How_to_use_locked_cells_and_sheet_protection.srt 19.44 KB
80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 20.84 MB
80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13.31 KB
81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 27.8 MB
81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 14.85 KB
82-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 29.07 MB
82-Use_slicers_and_charts_together_for_dynamic_presentations.srt 17.61 KB
83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18.4 MB
83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12.29 KB
84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 22.7 MB
84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 14.94 KB
85-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 25.94 MB
85-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17.46 KB
86-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 30.82 MB
86-Use_the_OFFSET_function_for_tabulating_moving_data.srt 19.72 KB
87-Alter_numeric_data_without_formulas.mp4 37.41 MB
87-Alter_numeric_data_without_formulas.srt 19.19 KB
88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 34.31 MB
88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19.02 KB
89-Adjust_banded_row_formatting.mp4 57.78 MB
89-Adjust_banded_row_formatting.srt 28.13 KB
90-Change_the_shape_of_comment_boxes_and_other_objects.mp4 19.25 MB
90-Change_the_shape_of_comment_boxes_and_other_objects.srt 12.53 KB
91-How_and_when_to_use_Excels_10_rounding_functions.mp4 35.35 MB
91-How_and_when_to_use_Excels_10_rounding_functions.srt 24.22 KB
92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 18.91 MB
92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13.33 KB
93-How_to_use_mixed_cell_references.mp4 23.41 MB
93-How_to_use_mixed_cell_references.srt 15.79 KB
94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4 17.84 MB
94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt 11.83 KB
95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 14.71 MB
95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 9.55 KB
96-Accelerate_data_entry_with_five_special_techniques.mp4 31.52 MB
96-Accelerate_data_entry_with_five_special_techniques.srt 23.29 KB
97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 16.99 MB
97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12.22 KB
98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 29.69 MB
98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 15.54 KB
99-How_to_create_time_interval_entries.mp4 32.38 MB
99-How_to_create_time_interval_entries.srt 21.29 KB
Download Info
-
Tips
“2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.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.