| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/01-Hide_and_unhide_worksheets_securely.mp4 |
17 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/01-Hide_and_unhide_worksheets_securely.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 |
27.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 |
21.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 |
16.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 |
23.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 |
29.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 |
40.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt |
23 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 |
24.1 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 |
30.3 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt |
17 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/10-Applying_conditional_formatting_across_rows_of_data.mp4 |
20.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/10-Applying_conditional_formatting_across_rows_of_data.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/100-How_to_create_frequency_tabulations_and_distributions.mp4 |
24.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/100-How_to_create_frequency_tabulations_and_distributions.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 |
36.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 |
35.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 |
16.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 |
35.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 |
30.1 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 |
29.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 |
29.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt |
21 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 |
39 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt |
25 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/109-Keyboard_shortcuts_for_numeric_formats.mp4 |
25.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/109-Keyboard_shortcuts_for_numeric_formats.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/11-Exploring_various_layouts_for_your_PivotTable.mp4 |
13.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/11-Exploring_various_layouts_for_your_PivotTable.srt |
8 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 |
41.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt |
17 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 |
24.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 |
24.3 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt |
17 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 |
29.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 |
29.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4 |
40.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt |
22 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 |
11.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt |
9 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 |
19 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 |
17.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt |
10 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/119-Displaying_multiple_worksheets_and_workbooks_together.mp4 |
32.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/119-Displaying_multiple_worksheets_and_workbooks_together.srt |
20 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/12-Splitting_and_consolidating_workbooks.mp4 |
20.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/12-Splitting_and_consolidating_workbooks.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/13-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 |
23.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/13-Using_date_and_time_as_metrics_in_a_PivotTable.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/14-Adding_illustrations_to_your_workbook.mp4 |
33.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/14-Adding_illustrations_to_your_workbook.srt |
23 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 |
22.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 |
29.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt |
22 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/17-Dynamically_presenting_data_via_chart_slicers.mp4 |
20.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/17-Dynamically_presenting_data_via_chart_slicers.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/18-Parsing_your_data_to_create_unique_lists.mp4 |
14.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/18-Parsing_your_data_to_create_unique_lists.srt |
7 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/19-Using_the_REPT_function_to_represent_data_visually.mp4 |
8.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/19-Using_the_REPT_function_to_represent_data_visually.srt |
6 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 |
25 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 |
23.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/22-Increasing_your_productivity_with_custom_lists.mp4 |
20.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/22-Increasing_your_productivity_with_custom_lists.srt |
9 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/23-Highlighting_PivotTable_results_with_conditional_formatting.mp4 |
19.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/23-Highlighting_PivotTable_results_with_conditional_formatting.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/24-Customizing_templates_to_fit_your_unique_needs.mp4 |
20.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/24-Customizing_templates_to_fit_your_unique_needs.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/25-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 |
11.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/25-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt |
6 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/26-Enhancing_table_filtering_with_slicers.mp4 |
20.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/26-Enhancing_table_filtering_with_slicers.srt |
10 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/27-Converting_charts_into_pictures.mp4 |
15.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/27-Converting_charts_into_pictures.srt |
9 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/28-Custom_grouping_in_PivotTables.mp4 |
13 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/28-Custom_grouping_in_PivotTables.srt |
9 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/29-Quick_formatting_tips.mp4 |
23.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/29-Quick_formatting_tips.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/30-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 |
25.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/30-The_top_five_unknown_but_useful_keyboard_shortcuts.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 |
21.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt |
10 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 |
23.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 |
21.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/34-Calculating_with_hours_minutes_and_times_of_day.mp4 |
29.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/34-Calculating_with_hours_minutes_and_times_of_day.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 |
21.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 |
40 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt |
21 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/37-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 |
19.3 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/37-Adding_managing_and_printing_comments_for_worksheet_documentation.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 |
19 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 |
25.1 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 |
21.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 |
24.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 |
19.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/43-Exploring_what_if_scenarios_using_Goal_Seek.mp4 |
28 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/43-Exploring_what_if_scenarios_using_Goal_Seek.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/44-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 |
17.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/44-Creating_text_numerical_date_and_time_lists_in_a_flash.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/45-Creating_Variable_Conditional_Formatting_Rules.mp4 |
30.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/45-Creating_Variable_Conditional_Formatting_Rules.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/46-Handling_Dates_with_unusual_formats.mp4 |
20.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/46-Handling_Dates_with_unusual_formats.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/47-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 |
38.1 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/47-Using_wildcards_(asterisk_tilde_and_question_mark).srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/48-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 |
39.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/48-Custom_formats_using_asterisk_semicolon_and_brackets.srt |
22 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/49-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 |
47.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/49-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt |
22 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/50-Create_an_Organization_Chart.mp4 |
23.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/50-Create_an_Organization_Chart.srt |
17 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 |
50.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt |
22 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/52-Using_Excels_error_checking_functions.mp4 |
33.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/52-Using_Excels_error_checking_functions.srt |
20 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/53-Custom_formats_relative_addressing_and_conditional_formatting.mp4 |
23.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/53-Custom_formats_relative_addressing_and_conditional_formatting.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/54-Auditing.mp4 |
30.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/54-Auditing.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/55-Adding_comments_and_shapes.mp4 |
25.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/55-Adding_comments_and_shapes.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/56-Drawing_borders_and_border_grids.mp4 |
21.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/56-Drawing_borders_and_border_grids.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/57-Building_a_flexible_monthly_table_using_functions.mp4 |
32.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/57-Building_a_flexible_monthly_table_using_functions.srt |
24 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/58-Adding_pictures_as_worksheet_backgrounds.mp4 |
20 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/58-Adding_pictures_as_worksheet_backgrounds.srt |
10 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/59-ADDRESS_ROW_and_COLUMN_functions.mp4 |
27.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/59-ADDRESS_ROW_and_COLUMN_functions.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 |
17.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/61-Working_with_formulas_in_tables.mp4 |
48.1 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/61-Working_with_formulas_in_tables.srt |
28 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/62-Locating_Data_Validation_rules_and_violations.mp4 |
28.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/62-Locating_Data_Validation_rules_and_violations.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/63-Creating_an_Excel_template.mp4 |
23.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/63-Creating_an_Excel_template.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/64-Restoring_missing_column_titles.mp4 |
26.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/64-Restoring_missing_column_titles.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/65-Creating_a_pick_list_dependent_on_another_pick_list.mp4 |
18.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/65-Creating_a_pick_list_dependent_on_another_pick_list.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/66-Pasting_picture_links.mp4 |
31 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/66-Pasting_picture_links.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/67-Using_Command_Shortcuts_with_the_Alt_key.mp4 |
20.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/67-Using_Command_Shortcuts_with_the_Alt_key.srt |
11 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/68-Set_up_a_macro_for_sorting_dynamic_data.mp4 |
28.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/68-Set_up_a_macro_for_sorting_dynamic_data.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/69-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 |
28.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/69-Use_random_number_functions_for_sorting_and_creating_sample_data.srt |
20 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 |
26.3 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt |
17 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/71-Replace_characters_by_position_with_the_REPLACE_function.mp4 |
15.6 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/71-Replace_characters_by_position_with_the_REPLACE_function.srt |
10 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/72-Work_with_formulas_in_tables.mp4 |
30 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/72-Work_with_formulas_in_tables.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 |
55 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt |
31 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/74-Use_special_tricks_for_working_with_dates_in_Charts.mp4 |
33.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/74-Use_special_tricks_for_working_with_dates_in_Charts.srt |
21 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/75-Use_a_data_form_for_data_entry_and_exploring_data.mp4 |
24.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/75-Use_a_data_form_for_data_entry_and_exploring_data.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 |
19.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 |
22.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt |
14 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 |
19.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/79-How_to_use_locked_cells_and_sheet_protection.mp4 |
35 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/79-How_to_use_locked_cells_and_sheet_protection.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 |
20.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 |
27.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/82-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 |
29.1 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/82-Use_slicers_and_charts_together_for_dynamic_presentations.srt |
18 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 |
18.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 |
22.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt |
15 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/85-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 |
25.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/85-Adjust_a_charts_source_data_and_adjust_its_series_order.srt |
17 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/86-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 |
30.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/86-Use_the_OFFSET_function_for_tabulating_moving_data.srt |
20 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/87-Alter_numeric_data_without_formulas.mp4 |
37.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/87-Alter_numeric_data_without_formulas.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 |
34.3 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt |
19 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/89-Adjust_banded_row_formatting.mp4 |
57.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/89-Adjust_banded_row_formatting.srt |
28 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/90-Change_the_shape_of_comment_boxes_and_other_objects.mp4 |
19.2 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/90-Change_the_shape_of_comment_boxes_and_other_objects.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/91-How_and_when_to_use_Excels_10_rounding_functions.mp4 |
35.3 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/91-How_and_when_to_use_Excels_10_rounding_functions.srt |
24 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 |
18.9 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt |
13 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/93-How_to_use_mixed_cell_references.mp4 |
23.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/93-How_to_use_mixed_cell_references.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4 |
17.8 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 |
14.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt |
10 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/96-Accelerate_data_entry_with_five_special_techniques.mp4 |
31.5 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/96-Accelerate_data_entry_with_five_special_techniques.srt |
23 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 |
17 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt |
12 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 |
29.7 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt |
16 KB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/99-How_to_create_time_interval_entries.mp4 |
32.4 MB |
| 2015-2017-Lynda.com-Excel_Tips_Weekly_(Updated_09.05.2017)-IVY/99-How_to_create_time_interval_entries.srt |
21 KB |
Magnet link
