2015-2017-Lynda com-Excel_Tips_Weekly_ Updated_06 06 2017 -IVY

1. 01-Hide_and_unhide_worksheets_securely.mp417.01MB
2. 02-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp427.85MB
3. 03-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp421.48MB
4. 04-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp416.4MB
5. 05-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp423.75MB
6. 06-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp429.4MB
7. 07-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp440.45MB
8. 08-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp424.1MB
9. 09-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp430.3MB
10. 10-Applying_conditional_formatting_across_rows_of_data.mp420.45MB
11. 100-How_to_create_frequency_tabulations_and_distributions.mp424.93MB
12. 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp436.74MB
13. 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp435.66MB
14. 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp416.52MB
15. 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp435.93MB
16. 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp430.07MB
17. 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp429.79MB
18. 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp429.86MB
19. 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp438.99MB
20. 109-Keyboard_shortcuts_for_numeric_formats.mp425.85MB
21. 11-Exploring_various_layouts_for_your_PivotTable.mp413.86MB
22. 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp441.35MB
23. 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp424.59MB
24. 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp424.29MB
25. 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp429.82MB
26. 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp429.38MB
27. 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp440.93MB
28. 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp411.45MB
29. 117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp419.03MB
30. 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp417.39MB
31. 119-Displaying_multiple_worksheets_and_workbooks_together.mp432.4MB
32. 12-Splitting_and_consolidating_workbooks.mp420.53MB
33. 120-Tips_for_creating_and_updating_sample_data.mp431.62MB
34. 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp424.14MB
35. 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp429.89MB
36. 123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp423.43MB
37. 13-Using_date_and_time_as_metrics_in_a_PivotTable.mp423.2MB
38. 14-Adding_illustrations_to_your_workbook.mp433.62MB
39. 15-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp422.57MB
40. 16-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp429.52MB
41. 17-Dynamically_presenting_data_via_chart_slicers.mp420.42MB
42. 18-Parsing_your_data_to_create_unique_lists.mp414.51MB
43. 19-Using_the_REPT_function_to_represent_data_visually.mp48.82MB
44. 20-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp424.96MB
45. 21-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp423.25MB
46. 22-Increasing_your_productivity_with_custom_lists.mp420.89MB
47. 23-Highlighting_PivotTable_results_with_conditional_formatting.mp419.23MB
48. 24-Customizing_templates_to_fit_your_unique_needs.mp420.37MB
49. 25-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp411.49MB
50. 26-Enhancing_table_filtering_with_slicers.mp420.19MB
51. 27-Converting_charts_into_pictures.mp415.93MB
52. 28-Custom_grouping_in_PivotTables.mp412.99MB
53. 29-Quick_formatting_tips.mp423.4MB
54. 30-The_top_five_unknown_but_useful_keyboard_shortcuts.mp425.61MB
55. 31-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp421.61MB
56. 32-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp423.56MB
57. 33-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp421.88MB
58. 34-Calculating_with_hours_minutes_and_times_of_day.mp429.66MB
59. 35-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp421.74MB
60. 36-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp440.04MB
61. 37-Adding_managing_and_printing_comments_for_worksheet_documentation.mp419.26MB
62. 38-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp418.99MB
63. 39-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp425.08MB
64. 40-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp421.15MB
65. 41-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp424.18MB
66. 42-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp419.93MB
67. 43-Exploring_what_if_scenarios_using_Goal_Seek.mp428.04MB
68. 44-Creating_text_numerical_date_and_time_lists_in_a_flash.mp417.89MB
69. 45-Creating_Variable_Conditional_Formatting_Rules.mp430.8MB
70. 46-Handling_Dates_with_unusual_formats.mp420.25MB
71. 47-Using_wildcards_(asterisk_tilde_and_question_mark).mp438.13MB
72. 48-Custom_formats_using_asterisk_semicolon_and_brackets.mp439.18MB
73. 49-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp447.68MB
74. 50-Create_an_Organization_Chart.mp423.64MB
75. 51-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp450.68MB
76. 52-Using_Excels_error_checking_functions.mp433.63MB
77. 53-Custom_formats_relative_addressing_and_conditional_formatting.mp423.95MB
78. 54-Auditing.mp430.66MB
79. 55-Adding_comments_and_shapes.mp425.43MB
80. 56-Drawing_borders_and_border_grids.mp421.36MB
81. 57-Building_a_flexible_monthly_table_using_functions.mp432.81MB
82. 58-Adding_pictures_as_worksheet_backgrounds.mp420.05MB
83. 59-ADDRESS_ROW_and_COLUMN_functions.mp427.67MB
84. 60-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp417.57MB
85. 61-Working_with_formulas_in_tables.mp448.15MB
86. 62-Locating_Data_Validation_rules_and_violations.mp428.54MB
87. 63-Creating_an_Excel_template.mp423.18MB
88. 64-Restoring_missing_column_titles.mp426.37MB
89. 65-Creating_a_pick_list_dependent_on_another_pick_list.mp418.84MB
90. 66-Pasting_picture_links.mp431.03MB
91. 67-Using_Command_Shortcuts_with_the_Alt_key.mp420.2MB
92. 68-Set_up_a_macro_for_sorting_dynamic_data.mp428.18MB
93. 69-Use_random_number_functions_for_sorting_and_creating_sample_data.mp428.83MB
94. 70-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp426.32MB
95. 71-Replace_characters_by_position_with_the_REPLACE_function.mp415.57MB
96. 72-Work_with_formulas_in_tables.mp430.04MB
97. 73-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp455.03MB
98. 74-Use_special_tricks_for_working_with_dates_in_Charts.mp433.2MB
99. 75-Use_a_data_form_for_data_entry_and_exploring_data.mp424.91MB
100. 76-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp419.66MB
101. 77-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp422.16MB
102. 78-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp419.17MB
103. 79-How_to_use_locked_cells_and_sheet_protection.mp435.04MB
104. 80-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp420.84MB
105. 81-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp427.8MB
106. 82-Use_slicers_and_charts_together_for_dynamic_presentations.mp429.07MB
107. 83-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp418.4MB
108. 84-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp422.7MB
109. 85-Adjust_a_charts_source_data_and_adjust_its_series_order.mp425.94MB
110. 86-Use_the_OFFSET_function_for_tabulating_moving_data.mp430.82MB
111. 87-Alter_numeric_data_without_formulas.mp437.41MB
112. 88-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp434.31MB
113. 89-Adjust_banded_row_formatting.mp457.78MB
114. 90-Change_the_shape_of_comment_boxes_and_other_objects.mp419.25MB
115. 91-How_and_when_to_use_Excels_10_rounding_functions.mp435.35MB
116. 92-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp418.91MB
117. 93-How_to_use_mixed_cell_references.mp423.41MB
118. 94-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp417.84MB
119. 95-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp414.71MB
120. 96-Accelerate_data_entry_with_five_special_techniques.mp431.52MB
121. 97-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp416.99MB
122. 98-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp429.69MB
123. 99-How_to_create_time_interval_entries.mp432.38MB