2015 2018 Lynda Excel Tips Weekly Updated 14 08 2018 IVY | 12BE059D3B55D7CED02518929C907D006D84FB28

2015 2018 Lynda Excel Tips Weekly Updated 14 08 2018 IVY

Name	2015-2018-Lynda-Excel_Tips_Weekly_(Updated_14.08.2018)-IVY	DOWNLOAD Copy Link
Total Size	4.8 GB
Total Files	397
Hash	12BE059D3B55D7CED02518929C907D006D84FB28

/
001-Hide_and_unhide_worksheets_securely.mp4	17.8 MB
001-Hide_and_unhide_worksheets_securely.srt	12.8 KB
002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4	29.2 MB
002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt	19.5 KB
003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4	22.5 MB
003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt	14.9 KB
004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4	17.2 MB
004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt	11.0 KB
005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4	24.9 MB
005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt	15.1 KB
006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4	30.8 MB
006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt	18.4 KB
007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4	42.4 MB
007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt	23.4 KB
008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4	25.3 MB
008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt	16.7 KB
009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4	31.8 MB
009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt	17.3 KB
010-Applying_conditional_formatting_across_rows_of_data.mp4	21.4 MB
010-Applying_conditional_formatting_across_rows_of_data.srt	12.5 KB
011-Exploring_various_layouts_for_your_PivotTable.mp4	14.5 MB
011-Exploring_various_layouts_for_your_PivotTable.srt	8.6 KB
012-Splitting_and_consolidating_workbooks.mp4	21.5 MB
012-Splitting_and_consolidating_workbooks.srt	13.3 KB
013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4	24.3 MB
013-Using_date_and_time_as_metrics_in_a_PivotTable.srt	13.7 KB
014-Adding_illustrations_to_your_workbook.mp4	35.3 MB
014-Adding_illustrations_to_your_workbook.srt	23.5 KB
015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4	23.7 MB
015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt	16.5 KB
016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4	30.9 MB
016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt	23.0 KB
017-Dynamically_presenting_data_via_chart_slicers.mp4	21.4 MB
017-Dynamically_presenting_data_via_chart_slicers.srt	14.8 KB
018-Parsing_your_data_to_create_unique_lists.mp4	15.2 MB
018-Parsing_your_data_to_create_unique_lists.srt	6.7 KB
019-Using_the_REPT_function_to_represent_data_visually.mp4	9.3 MB
019-Using_the_REPT_function_to_represent_data_visually.srt	6.1 KB
020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4	26.2 MB
020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt	14.9 KB
021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4	24.4 MB
021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt	15.5 KB
022-Increasing_your_productivity_with_custom_lists.mp4	21.9 MB
022-Increasing_your_productivity_with_custom_lists.srt	9.7 KB
023-Highlighting_PivotTable_results_with_conditional_formatting.mp4	20.2 MB
023-Highlighting_PivotTable_results_with_conditional_formatting.srt	12.0 KB
024-Customizing_templates_to_fit_your_unique_needs.mp4	21.4 MB
024-Customizing_templates_to_fit_your_unique_needs.srt	12.6 KB
025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4	12.0 MB
025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt	6.6 KB
026-Enhancing_table_filtering_with_slicers.mp4	21.2 MB
026-Enhancing_table_filtering_with_slicers.srt	10.5 KB
027-Converting_charts_into_pictures.mp4	16.7 MB
027-Converting_charts_into_pictures.srt	9.2 KB
028-Custom_grouping_in_PivotTables.mp4	13.6 MB
028-Custom_grouping_in_PivotTables.srt	8.9 KB
029-Quick_formatting_tips.mp4	24.5 MB
029-Quick_formatting_tips.srt	15.3 KB
030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4	26.9 MB
030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt	12.0 KB
031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4	22.7 MB
031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt	10.3 KB
032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4	24.7 MB
032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt	19.1 KB
033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4	22.9 MB
033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt	12.4 KB
034-Calculating_with_hours_minutes_and_times_of_day.mp4	31.1 MB
034-Calculating_with_hours_minutes_and_times_of_day.srt	18.9 KB
035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4	22.8 MB
035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt	11.5 KB
036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4	42.0 MB
036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt	21.1 KB
037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4	20.2 MB
037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt	14.2 KB
038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4	19.9 MB
038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt	11.5 KB
039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4	26.3 MB
039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt	11.6 KB
040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4	22.2 MB
040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt	14.0 KB
041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4	25.4 MB
041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt	13.3 KB
042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4	20.9 MB
042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt	14.8 KB
043-Exploring_what_if_scenarios_using_Goal_Seek.mp4	29.4 MB
043-Exploring_what_if_scenarios_using_Goal_Seek.srt	16.6 KB
044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4	18.8 MB
044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt	12.7 KB
045-Creating_Variable_Conditional_Formatting_Rules.mp4	32.3 MB
045-Creating_Variable_Conditional_Formatting_Rules.srt	14.8 KB
046-Handling_Dates_with_unusual_formats.mp4	21.2 MB
046-Handling_Dates_with_unusual_formats.srt	11.2 KB
047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4	40.0 MB
047-Using_wildcards_(asterisk_tilde_and_question_mark).srt	17.9 KB
048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4	41.1 MB
048-Custom_formats_using_asterisk_semicolon_and_brackets.srt	23.0 KB
049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4	50.0 MB
049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt	22.8 KB
050-Create_an_Organization_Chart.mp4	24.8 MB
050-Create_an_Organization_Chart.srt	17.6 KB
051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4	53.1 MB
051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt	22.4 KB
052-Using_Excels_error_checking_functions.mp4	35.3 MB
052-Using_Excels_error_checking_functions.srt	20.9 KB
053-Custom_formats_relative_addressing_and_conditional_formatting.mp4	25.1 MB
053-Custom_formats_relative_addressing_and_conditional_formatting.srt	16.0 KB
054-Auditing.mp4	32.1 MB
054-Auditing.srt	18.5 KB
055-Adding_comments_and_shapes.mp4	26.7 MB
055-Adding_comments_and_shapes.srt	16.1 KB
056-Drawing_borders_and_border_grids.mp4	22.4 MB
056-Drawing_borders_and_border_grids.srt	12.9 KB
057-Building_a_flexible_monthly_table_using_functions.mp4	34.4 MB
057-Building_a_flexible_monthly_table_using_functions.srt	24.2 KB
058-Adding_pictures_as_worksheet_backgrounds.mp4	21.0 MB
058-Adding_pictures_as_worksheet_backgrounds.srt	10.6 KB
059-ADDRESS_ROW_and_COLUMN_functions.mp4	29.0 MB
059-ADDRESS_ROW_and_COLUMN_functions.srt	16.4 KB
060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4	18.4 MB
060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt	11.8 KB
061-Working_with_formulas_in_tables.mp4	50.5 MB
061-Working_with_formulas_in_tables.srt	28.6 KB
062-Locating_Data_Validation_rules_and_violations.mp4	29.9 MB
062-Locating_Data_Validation_rules_and_violations.srt	15.2 KB
063-Creating_an_Excel_template.mp4	24.3 MB
063-Creating_an_Excel_template.srt	16.6 KB
064-Restoring_missing_column_titles.mp4	27.6 MB
064-Restoring_missing_column_titles.srt	13.9 KB
065-Creating_a_pick_list_dependent_on_another_pick_list.mp4	19.8 MB
065-Creating_a_pick_list_dependent_on_another_pick_list.srt	13.9 KB
066-Pasting_picture_links.mp4	32.5 MB
066-Pasting_picture_links.srt	18.9 KB
067-Using_Command_Shortcuts_with_the_Alt_key.mp4	21.2 MB
067-Using_Command_Shortcuts_with_the_Alt_key.srt	11.2 KB
068-Set_up_a_macro_for_sorting_dynamic_data.mp4	29.5 MB
068-Set_up_a_macro_for_sorting_dynamic_data.srt	19.1 KB
069-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4	30.2 MB
069-Use_random_number_functions_for_sorting_and_creating_sample_data.srt	20.4 KB
070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4	27.6 MB
070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt	17.5 KB
071-Replace_characters_by_position_with_the_REPLACE_function.mp4	16.3 MB
071-Replace_characters_by_position_with_the_REPLACE_function.srt	10.4 KB
072-Work_with_formulas_in_tables.mp4	31.5 MB
072-Work_with_formulas_in_tables.srt	18.2 KB
073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4	57.7 MB
073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt	32.0 KB
074-Use_special_tricks_for_working_with_dates_in_Charts.mp4	34.8 MB
074-Use_special_tricks_for_working_with_dates_in_Charts.srt	21.5 KB
075-Use_a_data_form_for_data_entry_and_exploring_data.mp4	26.1 MB
075-Use_a_data_form_for_data_entry_and_exploring_data.srt	13.3 KB
076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4	20.6 MB
076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt	13.9 KB
077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4	23.2 MB
077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt	14.7 KB
078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4	20.1 MB
078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt	12.7 KB
079-How_to_use_locked_cells_and_sheet_protection.mp4	36.7 MB
079-How_to_use_locked_cells_and_sheet_protection.srt	19.9 KB
080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4	21.8 MB
080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt	13.6 KB
081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4	29.1 MB
081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt	15.2 KB
082-Use_slicers_and_charts_together_for_dynamic_presentations.mp4	30.5 MB
082-Use_slicers_and_charts_together_for_dynamic_presentations.srt	18.0 KB
083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4	19.3 MB
083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt	12.6 KB
084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4	23.8 MB
084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt	15.3 KB
085-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4	27.2 MB
085-Adjust_a_charts_source_data_and_adjust_its_series_order.srt	17.9 KB
086-Use_the_OFFSET_function_for_tabulating_moving_data.mp4	32.3 MB
086-Use_the_OFFSET_function_for_tabulating_moving_data.srt	20.2 KB
087-Alter_numeric_data_without_formulas.mp4	39.2 MB
087-Alter_numeric_data_without_formulas.srt	19.6 KB
088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4	36.0 MB
088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt	19.5 KB
089-Adjust_banded_row_formatting.mp4	60.6 MB
089-Adjust_banded_row_formatting.srt	28.8 KB
090-Change_the_shape_of_comment_boxes_and_other_objects.mp4	20.2 MB
090-Change_the_shape_of_comment_boxes_and_other_objects.srt	12.8 KB
091-How_and_when_to_use_Excels_10_rounding_functions.mp4	37.1 MB
091-How_and_when_to_use_Excels_10_rounding_functions.srt	24.8 KB
092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4	19.8 MB
092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt	13.6 KB
093-How_to_use_mixed_cell_references.mp4	24.6 MB
093-How_to_use_mixed_cell_references.srt	16.2 KB
094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4	18.7 MB
094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt	12.1 KB
095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4	15.4 MB
095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt	9.8 KB
096-Accelerate_data_entry_with_five_special_techniques.mp4	33.1 MB
096-Accelerate_data_entry_with_five_special_techniques.srt	23.8 KB
097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4	17.8 MB
097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt	12.5 KB
098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4	31.1 MB
098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt	15.9 KB
099-How_to_create_time_interval_entries.mp4	34.0 MB
099-How_to_create_time_interval_entries.srt	21.8 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
124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4	21.2 MB
124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt	13.2 KB
125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4	25.5 MB
125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt	15.8 KB
126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4	36.7 MB
126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt	23.1 KB
127-Dealing_with_circular_errors.mp4	23.5 MB
127-Dealing_with_circular_errors.srt	14.9 KB
128-Tips_for_creating_charts_quickly.mp4	20.2 MB
128-Tips_for_creating_charts_quickly.srt	13.3 KB
129-Creating_heat_maps_using_conditional_formatting.mp4	36.6 MB
129-Creating_heat_maps_using_conditional_formatting.srt	15.9 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
130-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4	29.8 MB
130-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt	20.5 KB
131-Displaying_tips_when_using_Excel_in_presentations.mp4	31.1 MB
131-Displaying_tips_when_using_Excel_in_presentations.srt	11.9 KB
132-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4	31.8 MB
132-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt	17.7 KB
133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4	17.9 MB
133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt	10.5 KB
134-Working_with_multiple_worksheets_simultaneously.mp4	27.3 MB
134-Working_with_multiple_worksheets_simultaneously.srt	18.4 KB
135-Exploring_font_choices_not_found_on_the_Home_tab.mp4	12.2 MB
135-Exploring_font_choices_not_found_on_the_Home_tab.srt	7.6 KB
136-Using_WordArt_for_special_titles_and_headings.mp4	15.3 MB
136-Using_WordArt_for_special_titles_and_headings.srt	9.0 KB
137-Differentiating_weekdays_and_weekends_in_Excel_data.mp4	33.4 MB
137-Differentiating_weekdays_and_weekends_in_Excel_data.srt	21.9 KB
138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4	23.9 MB
138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt	13.2 KB
139-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4	26.3 MB
139-Borders_and_gridlines_Exploring_variations_options_and_differences.srt	16.8 KB
140-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4	31.6 MB
140-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt	15.7 KB
141-Freezing_column_and_row_titles.mp4	43.9 MB
141-Freezing_column_and_row_titles.srt	14.9 KB
142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4	26.8 MB
142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt	20.5 KB
143-Avoiding_common_chart_distortions.mp4	34.3 MB
143-Avoiding_common_chart_distortions.srt	22.0 KB
144-Use_the_new_Funnel_chart_available_in_Excel_365.mp4	11.1 MB
144-Use_the_new_Funnel_chart_available_in_Excel_365.srt	8.7 KB
145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4	16.0 MB
145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt	11.8 KB
146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4	29.4 MB
146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt	18.5 KB
147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4	18.5 MB
147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt	10.6 KB
148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4	29.4 MB
148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt	18.8 KB
149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4	29.3 MB
149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt	18.1 KB
150-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4	19.4 MB
150-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt	13.3 KB
151-Sorting_tips_and_shortcuts.mp4	34.0 MB
151-Sorting_tips_and_shortcuts.srt	16.8 KB
152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4	18.9 MB
152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt	13.4 KB
153-Work_with_formulas_and_formats_Decimals_and_fractions.mp4	14.2 MB
153-Work_with_formulas_and_formats_Decimals_and_fractions.srt	10.9 KB
154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4	29.2 MB
154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt	14.3 KB
155-Control_gridlines_in_charts_and_on_worksheets.mp4	22.7 MB
155-Control_gridlines_in_charts_and_on_worksheets.srt	15.0 KB
156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4	21.1 MB
156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt	12.2 KB
157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4	23.0 MB
157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt	14.1 KB
158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4	19.6 MB
158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt	13.7 KB
159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4	20.1 MB
159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt	11.9 KB
160-Create_your_own_customized_date_and_time_formats.mp4	23.6 MB
160-Create_your_own_customized_date_and_time_formats.srt	15.0 KB
161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4	19.7 MB
161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt	11.9 KB
162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4	23.6 MB
162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt	11.2 KB
163-Create_numeric_formats_Display_in_thousands_or_millions.mp4	37.5 MB
163-Create_numeric_formats_Display_in_thousands_or_millions.srt	22.2 KB
164-Converting_dates_like_20102006_into_usable_date_entries.mp4	12.6 MB
164-Converting_dates_like_20102006_into_usable_date_entries.srt	8.2 KB
165-Create_custom_lists_for_letter_series_like_A_to_Z.mp4	30.1 MB
165-Create_custom_lists_for_letter_series_like_A_to_Z.srt	12.6 KB
166-Freeze_Panes_and_Split.mp4	31.7 MB
166-Freeze_Panes_and_Split.srt	11.8 KB
167-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4	15.5 MB
167-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt	10.8 KB
168-Calculate_%_of_change.mp4	14.7 MB
168-Calculate_%_of_change.srt	10.3 KB
169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4	17.4 MB
169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt	8.6 KB
170-Use_the_COUNT_and_COUNTA_functions.mp4	14.6 MB
170-Use_the_COUNT_and_COUNTA_functions.srt	8.0 KB
171-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4	18.9 MB
171-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt	11.4 KB
172-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4	16.9 MB
172-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt	11.2 KB
173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp4	19.7 MB
173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt	10.7 KB
174-Identify_or_extract_unique_entries_in_a_list.mp4	23.8 MB
174-Identify_or_extract_unique_entries_in_a_list.srt	10.8 KB
175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp4	28.4 MB
175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt	11.0 KB
176-Create_artistic_charts_with_random_numbers.mp4	23.8 MB
176-Create_artistic_charts_with_random_numbers.srt	14.9 KB
177-Extract_day_month_and_year_from_date_fields.mp4	13.8 MB
177-Extract_day_month_and_year_from_date_fields.srt	10.0 KB
178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4	13.8 MB
178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt	9.8 KB
179-How_to_covert_ROMAN_numberals.mp4	13.9 MB
179-How_to_covert_ROMAN_numberals.srt	8.1 KB
180-Use_range_names_for_more_readable_formulas.mp4	16.3 MB
180-Use_range_names_for_more_readable_formulas.srt	10.2 KB
181-Customize_your_Quick_Access_Toolbar.mp4	21.3 MB
181-Customize_your_Quick_Access_Toolbar.srt	11.4 KB
/Exercise Files/
149_Decimals_and_Fractions.zip	27.1 KB
150_Mixed_References.zip	66.8 KB
151_Chart_gridlines_and_borders.zip	66.1 KB
152_INDIRECT_Intersection_RangeNames.zip	19.1 KB
153_Expand_Collapse_PivotTables.zip	126.4 KB
154_Phone_and_ZipCode_Formats.zip	13.4 KB
155_Default_Chart_Type_and_Chart_Templates.zip	40.8 KB
156_Date_Time_Formats.zip	123.3 KB
157_Comments_and_Reminders.zip	187.8 KB
158_Replace_Format_or_Content.zip	158.4 KB
159_Number_Formats.zip	42.1 KB
160_Date_Format_Conversions.zip	136.9 KB
161_Custom_Lists.zip	120.9 KB
162_Freeze_Panes_and_Split_Screens.zip	117.8 KB
163_NETWORKDAYS_and_WORKDAY.zip	27.8 KB
164_Percent_change_and_Goal_Seek.zip	22.7 KB
165_Fill_in_Blanks.zip	156.3 KB
166_COUNT_COUNTA_and_Status_Bar.zip	147.5 KB
167_Excel_Sheet_Commands.zip	224.2 KB
168_Ranking_Data.zip	59.3 KB
169_PivotTable_Date_Grouping.zip	154.3 KB
170_Unique_and_Duplicate_Data.zip	216.0 KB
171_Zoom_and_Display_Variations.zip	264.9 KB
172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip	74.8 KB
173_YEAR_MONTH_DAY_WEEKDAY.zip	231.5 KB
174_EXACT_FIND_SEARCH_Functions.zip	16.9 KB
175_ROMAN_ARABIC.zip	20.8 KB
176_Range_Names.zip	168.8 KB
177_Customize_the_Quick_Access_Toolbar.zip	61.3 KB
Total files 397