2015 2017 Lynda com Excel Tips Weekly Updated 06 2017 IVY | EAC665EEDA29597AD3979D7557F9850793C2ED45

2015 2017 Lynda com Excel Tips Weekly Updated 06 2017 IVY

Name	2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_06.06.2017)-IVY	DOWNLOAD Copy Link
Total Size	3.4 GB
Total Files	246
Hash	EAC665EEDA29597AD3979D7557F9850793C2ED45

/
01-Hide_and_unhide_worksheets_securely.mp4	17.8 MB
01-Hide_and_unhide_worksheets_securely.srt	12.8 KB
02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4	29.2 MB
02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt	19.5 KB
03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4	22.5 MB
03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt	14.9 KB
04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4	17.2 MB
04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt	11.0 KB
05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4	24.9 MB
05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt	15.1 KB
06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4	30.8 MB
06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt	18.4 KB
07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4	42.4 MB
07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt	23.4 KB
08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4	25.3 MB
08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt	16.7 KB
09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4	31.8 MB
09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt	17.3 KB
10-Applying_conditional_formatting_across_rows_of_data.mp4	21.4 MB
10-Applying_conditional_formatting_across_rows_of_data.srt	12.5 KB
100-How_to_create_frequency_tabulations_and_distributions.mp4	26.1 MB
100-How_to_create_frequency_tabulations_and_distributions.srt	14.3 KB
101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4	38.5 MB
101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt	13.6 KB
102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4	37.4 MB
102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt	18.8 KB
103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4	17.3 MB
103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt	14.2 KB
104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4	37.7 MB
104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt	18.1 KB
105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4	31.5 MB
105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt	18.8 KB
106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4	31.2 MB
106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt	19.7 KB
107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4	31.3 MB
107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt	21.9 KB
108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4	40.9 MB
108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt	25.7 KB
109-Keyboard_shortcuts_for_numeric_formats.mp4	27.1 MB
109-Keyboard_shortcuts_for_numeric_formats.srt	15.4 KB
11-Exploring_various_layouts_for_your_PivotTable.mp4	14.5 MB
11-Exploring_various_layouts_for_your_PivotTable.srt	8.6 KB
110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4	43.4 MB
110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt	17.2 KB
111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4	25.8 MB
111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt	16.5 KB
112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4	25.5 MB
112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt	17.2 KB
113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4	31.3 MB
113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt	19.5 KB
114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4	30.8 MB
114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt	15.1 KB
115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4	42.9 MB
115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt	22.6 KB
116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4	12.0 MB
116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt	8.9 KB
117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4	20.0 MB
117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt	13.3 KB
118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4	18.2 MB
118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt	10.6 KB
119-Displaying_multiple_worksheets_and_workbooks_together.mp4	34.0 MB
119-Displaying_multiple_worksheets_and_workbooks_together.srt	20.6 KB
12-Splitting_and_consolidating_workbooks.mp4	21.5 MB
12-Splitting_and_consolidating_workbooks.srt	13.3 KB
120-Tips_for_creating_and_updating_sample_data.mp4	33.2 MB
120-Tips_for_creating_and_updating_sample_data.srt	21.4 KB
121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4	25.3 MB
121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt	16.3 KB
122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4	31.3 MB
122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt	19.2 KB
123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4	24.6 MB
123-Summarize_data_from_different_worksheets_with_a_PivotTable.srt	13.7 KB
13-Using_date_and_time_as_metrics_in_a_PivotTable.mp4	24.3 MB
13-Using_date_and_time_as_metrics_in_a_PivotTable.srt	13.7 KB
14-Adding_illustrations_to_your_workbook.mp4	35.3 MB
14-Adding_illustrations_to_your_workbook.srt	23.5 KB
15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4	23.7 MB
15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt	16.5 KB
16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4	30.9 MB
16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt	23.0 KB
17-Dynamically_presenting_data_via_chart_slicers.mp4	21.4 MB
17-Dynamically_presenting_data_via_chart_slicers.srt	14.8 KB
18-Parsing_your_data_to_create_unique_lists.mp4	15.2 MB
18-Parsing_your_data_to_create_unique_lists.srt	6.7 KB
19-Using_the_REPT_function_to_represent_data_visually.mp4	9.3 MB
19-Using_the_REPT_function_to_represent_data_visually.srt	6.1 KB
20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4	26.2 MB
20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt	14.9 KB
21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4	24.4 MB
21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt	15.5 KB
22-Increasing_your_productivity_with_custom_lists.mp4	21.9 MB
22-Increasing_your_productivity_with_custom_lists.srt	9.7 KB
23-Highlighting_PivotTable_results_with_conditional_formatting.mp4	20.2 MB
23-Highlighting_PivotTable_results_with_conditional_formatting.srt	12.0 KB
24-Customizing_templates_to_fit_your_unique_needs.mp4	21.4 MB
24-Customizing_templates_to_fit_your_unique_needs.srt	12.6 KB
25-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4	12.0 MB
25-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt	6.6 KB
26-Enhancing_table_filtering_with_slicers.mp4	21.2 MB
26-Enhancing_table_filtering_with_slicers.srt	10.5 KB
27-Converting_charts_into_pictures.mp4	16.7 MB
27-Converting_charts_into_pictures.srt	9.2 KB
28-Custom_grouping_in_PivotTables.mp4	13.6 MB
28-Custom_grouping_in_PivotTables.srt	8.9 KB
29-Quick_formatting_tips.mp4	24.5 MB
29-Quick_formatting_tips.srt	15.3 KB
30-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4	26.9 MB
30-The_top_five_unknown_but_useful_keyboard_shortcuts.srt	12.0 KB
31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4	22.7 MB
31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt	10.3 KB
32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4	24.7 MB
32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt	19.1 KB
33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4	22.9 MB
33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt	12.4 KB
34-Calculating_with_hours_minutes_and_times_of_day.mp4	31.1 MB
34-Calculating_with_hours_minutes_and_times_of_day.srt	18.9 KB
35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4	22.8 MB
35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt	11.5 KB
36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4	42.0 MB
36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt	21.1 KB
37-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4	20.2 MB
37-Adding_managing_and_printing_comments_for_worksheet_documentation.srt	14.2 KB
38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4	19.9 MB
38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt	11.5 KB
39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4	26.3 MB
39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt	11.6 KB
40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4	22.2 MB
40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt	14.0 KB
41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4	25.4 MB
41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt	13.3 KB
42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4	20.9 MB
42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt	14.8 KB
43-Exploring_what_if_scenarios_using_Goal_Seek.mp4	29.4 MB
43-Exploring_what_if_scenarios_using_Goal_Seek.srt	16.6 KB
44-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4	18.8 MB
44-Creating_text_numerical_date_and_time_lists_in_a_flash.srt	12.7 KB
45-Creating_Variable_Conditional_Formatting_Rules.mp4	32.3 MB
45-Creating_Variable_Conditional_Formatting_Rules.srt	14.8 KB
46-Handling_Dates_with_unusual_formats.mp4	21.2 MB
46-Handling_Dates_with_unusual_formats.srt	11.2 KB
47-Using_wildcards_(asterisk_tilde_and_question_mark).mp4	40.0 MB
47-Using_wildcards_(asterisk_tilde_and_question_mark).srt	17.9 KB
48-Custom_formats_using_asterisk_semicolon_and_brackets.mp4	41.1 MB
48-Custom_formats_using_asterisk_semicolon_and_brackets.srt	23.0 KB
49-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4	50.0 MB
49-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt	22.8 KB
50-Create_an_Organization_Chart.mp4	24.8 MB
50-Create_an_Organization_Chart.srt	17.6 KB
51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4	53.1 MB
51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt	22.4 KB
52-Using_Excels_error_checking_functions.mp4	35.3 MB
52-Using_Excels_error_checking_functions.srt	20.9 KB
53-Custom_formats_relative_addressing_and_conditional_formatting.mp4	25.1 MB
53-Custom_formats_relative_addressing_and_conditional_formatting.srt	16.0 KB
54-Auditing.mp4	32.1 MB
54-Auditing.srt	18.5 KB
55-Adding_comments_and_shapes.mp4	26.7 MB
55-Adding_comments_and_shapes.srt	16.1 KB
56-Drawing_borders_and_border_grids.mp4	22.4 MB
56-Drawing_borders_and_border_grids.srt	12.9 KB
57-Building_a_flexible_monthly_table_using_functions.mp4	34.4 MB
57-Building_a_flexible_monthly_table_using_functions.srt	24.2 KB
58-Adding_pictures_as_worksheet_backgrounds.mp4	21.0 MB
58-Adding_pictures_as_worksheet_backgrounds.srt	10.6 KB
59-ADDRESS_ROW_and_COLUMN_functions.mp4	29.0 MB
59-ADDRESS_ROW_and_COLUMN_functions.srt	16.4 KB
60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4	18.4 MB
60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt	11.8 KB
61-Working_with_formulas_in_tables.mp4	50.5 MB
61-Working_with_formulas_in_tables.srt	28.6 KB
62-Locating_Data_Validation_rules_and_violations.mp4	29.9 MB
62-Locating_Data_Validation_rules_and_violations.srt	15.2 KB
63-Creating_an_Excel_template.mp4	24.3 MB
63-Creating_an_Excel_template.srt	16.6 KB
64-Restoring_missing_column_titles.mp4	27.6 MB
64-Restoring_missing_column_titles.srt	13.9 KB
65-Creating_a_pick_list_dependent_on_another_pick_list.mp4	19.8 MB
65-Creating_a_pick_list_dependent_on_another_pick_list.srt	13.9 KB
66-Pasting_picture_links.mp4	32.5 MB
66-Pasting_picture_links.srt	18.9 KB
67-Using_Command_Shortcuts_with_the_Alt_key.mp4	21.2 MB
67-Using_Command_Shortcuts_with_the_Alt_key.srt	11.2 KB
68-Set_up_a_macro_for_sorting_dynamic_data.mp4	29.5 MB
68-Set_up_a_macro_for_sorting_dynamic_data.srt	19.1 KB
69-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4	30.2 MB
69-Use_random_number_functions_for_sorting_and_creating_sample_data.srt	20.4 KB
70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4	27.6 MB
70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt	17.5 KB
71-Replace_characters_by_position_with_the_REPLACE_function.mp4	16.3 MB
71-Replace_characters_by_position_with_the_REPLACE_function.srt	10.4 KB
72-Work_with_formulas_in_tables.mp4	31.5 MB
72-Work_with_formulas_in_tables.srt	18.2 KB
73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4	57.7 MB
73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt	32.0 KB
74-Use_special_tricks_for_working_with_dates_in_Charts.mp4	34.8 MB
74-Use_special_tricks_for_working_with_dates_in_Charts.srt	21.5 KB
75-Use_a_data_form_for_data_entry_and_exploring_data.mp4	26.1 MB
75-Use_a_data_form_for_data_entry_and_exploring_data.srt	13.3 KB
76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4	20.6 MB
76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt	13.9 KB
77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4	23.2 MB
77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt	14.7 KB
78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4	20.1 MB
78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt	12.7 KB
79-How_to_use_locked_cells_and_sheet_protection.mp4	36.7 MB
79-How_to_use_locked_cells_and_sheet_protection.srt	19.9 KB
80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4	21.8 MB
80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt	13.6 KB
81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4	29.1 MB
81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt	15.2 KB
82-Use_slicers_and_charts_together_for_dynamic_presentations.mp4	30.5 MB
82-Use_slicers_and_charts_together_for_dynamic_presentations.srt	18.0 KB
83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4	19.3 MB
83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt	12.6 KB
84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4	23.8 MB
84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt	15.3 KB
85-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4	27.2 MB
85-Adjust_a_charts_source_data_and_adjust_its_series_order.srt	17.9 KB
86-Use_the_OFFSET_function_for_tabulating_moving_data.mp4	32.3 MB
86-Use_the_OFFSET_function_for_tabulating_moving_data.srt	20.2 KB
87-Alter_numeric_data_without_formulas.mp4	39.2 MB
87-Alter_numeric_data_without_formulas.srt	19.6 KB
88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4	36.0 MB
88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt	19.5 KB
89-Adjust_banded_row_formatting.mp4	60.6 MB
89-Adjust_banded_row_formatting.srt	28.8 KB
90-Change_the_shape_of_comment_boxes_and_other_objects.mp4	20.2 MB
90-Change_the_shape_of_comment_boxes_and_other_objects.srt	12.8 KB
91-How_and_when_to_use_Excels_10_rounding_functions.mp4	37.1 MB
91-How_and_when_to_use_Excels_10_rounding_functions.srt	24.8 KB
92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4	19.8 MB
92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt	13.6 KB
93-How_to_use_mixed_cell_references.mp4	24.6 MB
93-How_to_use_mixed_cell_references.srt	16.2 KB
94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4	18.7 MB
94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt	12.1 KB
95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4	15.4 MB
95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt	9.8 KB
96-Accelerate_data_entry_with_five_special_techniques.mp4	33.1 MB
96-Accelerate_data_entry_with_five_special_techniques.srt	23.8 KB
97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4	17.8 MB
97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt	12.5 KB
98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4	31.1 MB
98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt	15.9 KB
99-How_to_create_time_interval_entries.mp4	34.0 MB
99-How_to_create_time_interval_entries.srt	21.8 KB
Total files 246