2015-2018-LinkedIn-Excel_Tips_Weekly_ Updated_13 11 2018 -IVY

1. 001-Hide_and_unhide_worksheets_securely.mp417.01MB
2. 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp427.85MB
3. 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp421.48MB
4. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp416.4MB
5. 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp423.75MB
6. 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp429.4MB
7. 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp440.45MB
8. 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp424.1MB
9. 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp430.3MB
10. 010-Applying_conditional_formatting_across_rows_of_data.mp420.45MB
11. 011-Exploring_various_layouts_for_your_PivotTable.mp413.86MB
12. 012-Splitting_and_consolidating_workbooks.mp420.53MB
13. 013-Using_date_and_time_as_metrics_in_a_PivotTable.mp423.2MB
14. 014-Adding_illustrations_to_your_workbook.mp433.62MB
15. 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp422.57MB
16. 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp429.52MB
17. 017-Dynamically_presenting_data_via_chart_slicers.mp420.42MB
18. 018-Parsing_your_data_to_create_unique_lists.mp414.51MB
19. 019-Using_the_REPT_function_to_represent_data_visually.mp48.82MB
20. 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp424.96MB
21. 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp423.25MB
22. 022-Increasing_your_productivity_with_custom_lists.mp420.89MB
23. 023-Highlighting_PivotTable_results_with_conditional_formatting.mp419.23MB
24. 024-Customizing_templates_to_fit_your_unique_needs.mp420.37MB
25. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp411.49MB
26. 026-Enhancing_table_filtering_with_slicers.mp420.19MB
27. 027-Converting_charts_into_pictures.mp415.93MB
28. 028-Custom_grouping_in_PivotTables.mp412.99MB
29. 029-Quick_formatting_tips.mp423.4MB
30. 030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp425.61MB
31. 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp421.61MB
32. 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp423.56MB
33. 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp421.88MB
34. 034-Calculating_with_hours_minutes_and_times_of_day.mp429.66MB
35. 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp421.74MB
36. 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp440.04MB
37. 037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp419.26MB
38. 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp418.99MB
39. 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp425.08MB
40. 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp421.15MB
41. 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp424.18MB
42. 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp419.93MB
43. 043-Exploring_what_if_scenarios_using_Goal_Seek.mp428.04MB
44. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp417.89MB
45. 045-Creating_Variable_Conditional_Formatting_Rules.mp430.8MB
46. 046-Handling_Dates_with_unusual_formats.mp420.25MB
47. 047-Using_wildcards_(asterisk_tilde_and_question_mark).mp438.13MB
48. 048-Custom_formats_using_asterisk_semicolon_and_brackets.mp439.18MB
49. 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp447.68MB
50. 050-Create_an_Organization_Chart.mp423.64MB
51. 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp450.68MB
52. 052-Using_Excels_error_checking_functions.mp433.63MB
53. 053-Custom_formats_relative_addressing_and_conditional_formatting.mp423.95MB
54. 054-Auditing.mp430.66MB
55. 055-Adding_comments_and_shapes.mp425.43MB
56. 056-Drawing_borders_and_border_grids.mp421.36MB
57. 057-Building_a_flexible_monthly_table_using_functions.mp432.81MB
58. 058-Adding_pictures_as_worksheet_backgrounds.mp420.05MB
59. 059-ADDRESS_ROW_and_COLUMN_functions.mp427.67MB
60. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp417.57MB
61. 061-Working_with_formulas_in_tables.mp448.15MB
62. 062-Locating_Data_Validation_rules_and_violations.mp428.54MB
63. 063-Creating_an_Excel_template.mp423.18MB
64. 064-Restoring_missing_column_titles.mp426.37MB
65. 065-Creating_a_pick_list_dependent_on_another_pick_list.mp418.84MB
66. 066-Pasting_picture_links.mp431.03MB
67. 067-Using_Command_Shortcuts_with_the_Alt_key.mp420.2MB
68. 068-Set_up_a_macro_for_sorting_dynamic_data.mp428.18MB
69. 069-Use_random_number_functions_for_sorting_and_creating_sample_data.mp428.83MB
70. 070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp426.32MB
71. 071-Replace_characters_by_position_with_the_REPLACE_function.mp415.57MB
72. 072-Work_with_formulas_in_tables.mp430.04MB
73. 073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp455.03MB
74. 074-Use_special_tricks_for_working_with_dates_in_Charts.mp433.2MB
75. 075-Use_a_data_form_for_data_entry_and_exploring_data.mp424.91MB
76. 076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp419.66MB
77. 077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp422.16MB
78. 078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp419.17MB
79. 079-How_to_use_locked_cells_and_sheet_protection.mp435.04MB
80. 080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp420.84MB
81. 081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp427.8MB
82. 082-Use_slicers_and_charts_together_for_dynamic_presentations.mp429.07MB
83. 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp418.4MB
84. 084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp422.7MB
85. 085-Adjust_a_charts_source_data_and_adjust_its_series_order.mp425.94MB
86. 086-Use_the_OFFSET_function_for_tabulating_moving_data.mp430.82MB
87. 087-Alter_numeric_data_without_formulas.mp437.41MB
88. 088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp434.31MB
89. 089-Adjust_banded_row_formatting.mp457.78MB
90. 090-Change_the_shape_of_comment_boxes_and_other_objects.mp419.25MB
91. 091-How_and_when_to_use_Excels_10_rounding_functions.mp435.35MB
92. 092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp418.91MB
93. 093-How_to_use_mixed_cell_references.mp423.41MB
94. 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp417.84MB
95. 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp414.71MB
96. 096-Accelerate_data_entry_with_five_special_techniques.mp431.52MB
97. 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp416.99MB
98. 098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp429.69MB
99. 099-How_to_create_time_interval_entries.mp432.38MB
100. 100-How_to_create_frequency_tabulations_and_distributions.mp424.93MB
101. 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp436.74MB
102. 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp435.66MB
103. 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp416.52MB
104. 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp435.93MB
105. 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp430.07MB
106. 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp429.79MB
107. 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp429.86MB
108. 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp438.99MB
109. 109-Keyboard_shortcuts_for_numeric_formats.mp425.85MB
110. 11-Exploring_various_layouts_for_your_PivotTable.mp413.86MB
111. 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp441.35MB
112. 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp424.59MB
113. 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp424.29MB
114. 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp429.82MB
115. 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp429.38MB
116. 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp440.93MB
117. 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp411.45MB
118. 117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp419.03MB
119. 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp417.39MB
120. 119-Displaying_multiple_worksheets_and_workbooks_together.mp432.4MB
121. 12-Splitting_and_consolidating_workbooks.mp420.53MB
122. 120-Tips_for_creating_and_updating_sample_data.mp431.62MB
123. 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp424.14MB
124. 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp429.89MB
125. 123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp423.43MB
126. 124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp420.22MB
127. 125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp424.27MB
128. 126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp435.01MB
129. 127-Dealing_with_circular_errors.mp422.37MB
130. 128-Tips_for_creating_charts_quickly.mp419.24MB
131. 129-Creating_heat_maps_using_conditional_formatting.mp434.91MB
132. 13-Using_date_and_time_as_metrics_in_a_PivotTable.mp423.2MB
133. 130-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp428.38MB
134. 131-Displaying_tips_when_using_Excel_in_presentations.mp429.65MB
135. 132-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp430.35MB
136. 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp417.05MB
137. 134-Working_with_multiple_worksheets_simultaneously.mp425.99MB
138. 135-Exploring_font_choices_not_found_on_the_Home_tab.mp411.68MB
139. 136-Using_WordArt_for_special_titles_and_headings.mp414.54MB
140. 137-Differentiating_weekdays_and_weekends_in_Excel_data.mp431.82MB
141. 138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp422.8MB
142. 139-Borders_and_gridlines_Exploring_variations_options_and_differences.mp425.12MB
143. 140-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp430.13MB
144. 141-Freezing_column_and_row_titles.mp441.85MB
145. 142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp425.51MB
146. 143-Avoiding_common_chart_distortions.mp432.73MB
147. 144-Use_the_new_Funnel_chart_available_in_Excel_365.mp410.63MB
148. 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp415.23MB
149. 146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp428.07MB
150. 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp417.62MB
151. 148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp428.03MB
152. 149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp427.92MB
153. 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp418.54MB
154. 151-Sorting_tips_and_shortcuts.mp432.43MB
155. 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp417.99MB
156. 153-Work_with_formulas_and_formats_Decimals_and_fractions.mp413.53MB
157. 154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp427.89MB
158. 155-Control_gridlines_in_charts_and_on_worksheets.mp421.68MB
159. 156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp420.16MB
160. 157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp421.95MB
161. 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp418.7MB
162. 159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp419.14MB
163. 160-Create_your_own_customized_date_and_time_formats.mp422.5MB
164. 161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp418.79MB
165. 162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp422.46MB
166. 163-Create_numeric_formats_Display_in_thousands_or_millions.mp435.8MB
167. 164-Converting_dates_like_20102006_into_usable_date_entries.mp411.98MB
168. 165-Create_custom_lists_for_letter_series_like_A_to_Z.mp428.74MB
169. 166-Freeze_Panes_and_Split.mp430.26MB
170. 167-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp414.74MB
171. 168-Calculate_%_of_change.mp414MB
172. 169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp416.56MB
173. 170-Use_the_COUNT_and_COUNTA_functions.mp413.93MB
174. 171-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp418MB
175. 172-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp416.11MB
176. 173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp418.83MB
177. 174-Identify_or_extract_unique_entries_in_a_list.mp422.68MB
178. 175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp427.06MB
179. 176-Create_artistic_charts_with_random_numbers.mp422.72MB
180. 177-Extract_day_month_and_year_from_date_fields.mp413.15MB
181. 178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp413.17MB
182. 179-How_to_covert_ROMAN_numberals.mp413.25MB
183. 180-Use_range_names_for_more_readable_formulas.mp415.5MB
184. 181-Customize_your_Quick_Access_Toolbar.mp420.33MB
185. 182-Conditional_formatting_based_on_date_proximity.mp413.75MB
186. 183-How_to_adjust_names.mp416.21MB
187. 184-Differences_and_limitations_of_converting_data_to_a_table.mp418.78MB
188. 185-Avoid_the_#DIV_0_error_message.mp413.76MB
189. 186-Explore_formatting_options_not_available_on_the_Home_tab.mp415.55MB
190. 187-Control_table_formatting_with_custom_formats.mp412.2MB
191. 188-Use_date_functions_for_age_and_tenure_calculations.mp416.43MB
192. 189-Avoid_unintentional_entries_when_typing_code_numbers.mp49.52MB
193. 190-Sorting_by_moving_columns.mp415.31MB
194. 191-Calculating_cumulative_totals.mp411.22MB
195. 192-Using_the_CONVERT_function_for_different_numbering_systems.mp412.85MB
196. 193-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.mp411.3MB
197. 194-Keystroke_shortcuts_using_the_Alt_key.mp414.71MB