589689.xyz

2015-2018-LinkedIn-Excel_Tips_Weekly_()-IVY

  • 收录时间:2019-02-28 11:41:15
  • 文件大小:5GB
  • 下载次数:25
  • 最近下载:2020-05-06 20:21:19
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 089-Adjust_banded_row_formatting.mp4 58MB
  2. 073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 55MB
  3. 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 51MB
  4. 061-Working_with_formulas_in_tables.mp4 48MB
  5. 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 48MB
  6. 141-Freezing_column_and_row_titles.mp4 42MB
  7. 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 41MB
  8. 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4 41MB
  9. 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 40MB
  10. 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 40MB
  11. 048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 39MB
  12. 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 39MB
  13. 047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 38MB
  14. 087-Alter_numeric_data_without_formulas.mp4 37MB
  15. 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 37MB
  16. 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 36MB
  17. 163-Create_numeric_formats_Display_in_thousands_or_millions.mp4 36MB
  18. 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 36MB
  19. 091-How_and_when_to_use_Excels_10_rounding_functions.mp4 35MB
  20. 079-How_to_use_locked_cells_and_sheet_protection.mp4 35MB
  21. 126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4 35MB
  22. 129-Creating_heat_maps_using_conditional_formatting.mp4 35MB
  23. 088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 34MB
  24. 052-Using_Excels_error_checking_functions.mp4 34MB
  25. 014-Adding_illustrations_to_your_workbook.mp4 34MB
  26. 074-Use_special_tricks_for_working_with_dates_in_Charts.mp4 33MB
  27. 057-Building_a_flexible_monthly_table_using_functions.mp4 33MB
  28. 143-Avoiding_common_chart_distortions.mp4 33MB
  29. 151-Sorting_tips_and_shortcuts.mp4 32MB
  30. 119-Displaying_multiple_worksheets_and_workbooks_together.mp4 32MB
  31. 099-How_to_create_time_interval_entries.mp4 32MB
  32. 137-Differentiating_weekdays_and_weekends_in_Excel_data.mp4 32MB
  33. 120-Tips_for_creating_and_updating_sample_data.mp4 32MB
  34. 096-Accelerate_data_entry_with_five_special_techniques.mp4 32MB
  35. 066-Pasting_picture_links.mp4 31MB
  36. 086-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 31MB
  37. 045-Creating_Variable_Conditional_Formatting_Rules.mp4 31MB
  38. 054-Auditing.mp4 31MB
  39. 132-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4 30MB
  40. 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 30MB
  41. 166-Freeze_Panes_and_Split.mp4 30MB
  42. 140-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4 30MB
  43. 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 30MB
  44. 072-Work_with_formulas_in_tables.mp4 30MB
  45. 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4 30MB
  46. 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 30MB
  47. 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 30MB
  48. 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 30MB
  49. 098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 30MB
  50. 034-Calculating_with_hours_minutes_and_times_of_day.mp4 30MB
  51. 131-Displaying_tips_when_using_Excel_in_presentations.mp4 30MB
  52. 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 30MB
  53. 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 29MB
  54. 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 29MB
  55. 082-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 29MB
  56. 069-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 29MB
  57. 165-Create_custom_lists_for_letter_series_like_A_to_Z.mp4 29MB
  58. 062-Locating_Data_Validation_rules_and_violations.mp4 29MB
  59. 130-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4 28MB
  60. 068-Set_up_a_macro_for_sorting_dynamic_data.mp4 28MB
  61. 146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4 28MB
  62. 043-Exploring_what_if_scenarios_using_Goal_Seek.mp4 28MB
  63. 148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4 28MB
  64. 149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4 28MB
  65. 154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4 28MB
  66. 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 28MB
  67. 081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 28MB
  68. 059-ADDRESS_ROW_and_COLUMN_functions.mp4 28MB
  69. 175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp4 27MB
  70. 064-Restoring_missing_column_titles.mp4 26MB
  71. 070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 26MB
  72. 134-Working_with_multiple_worksheets_simultaneously.mp4 26MB
  73. 085-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 26MB
  74. 109-Keyboard_shortcuts_for_numeric_formats.mp4 26MB
  75. 030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 26MB
  76. 142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4 26MB
  77. 055-Adding_comments_and_shapes.mp4 25MB
  78. 139-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4 25MB
  79. 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 25MB
  80. 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 25MB
  81. 100-How_to_create_frequency_tabulations_and_distributions.mp4 25MB
  82. 075-Use_a_data_form_for_data_entry_and_exploring_data.mp4 25MB
  83. 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 25MB
  84. 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 24MB
  85. 125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4 24MB
  86. 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 24MB
  87. 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4 24MB
  88. 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 24MB
  89. 053-Custom_formats_relative_addressing_and_conditional_formatting.mp4 24MB
  90. 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 24MB
  91. 050-Create_an_Organization_Chart.mp4 24MB
  92. 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 24MB
  93. 123-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4 23MB
  94. 093-How_to_use_mixed_cell_references.mp4 23MB
  95. 029-Quick_formatting_tips.mp4 23MB
  96. 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 23MB
  97. 013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23MB
  98. 13-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23MB
  99. 063-Creating_an_Excel_template.mp4 23MB
  100. 138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4 23MB
  101. 176-Create_artistic_charts_with_random_numbers.mp4 23MB
  102. 084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 23MB
  103. 174-Identify_or_extract_unique_entries_in_a_list.mp4 23MB
  104. 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 23MB
  105. 160-Create_your_own_customized_date_and_time_formats.mp4 23MB
  106. 162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4 22MB
  107. 127-Dealing_with_circular_errors.mp4 22MB
  108. 077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 22MB
  109. 157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4 22MB
  110. 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 22MB
  111. 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 22MB
  112. 155-Control_gridlines_in_charts_and_on_worksheets.mp4 22MB
  113. 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 22MB
  114. 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 21MB
  115. 056-Drawing_borders_and_border_grids.mp4 21MB
  116. 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 21MB
  117. 022-Increasing_your_productivity_with_custom_lists.mp4 21MB
  118. 080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 21MB
  119. 012-Splitting_and_consolidating_workbooks.mp4 21MB
  120. 12-Splitting_and_consolidating_workbooks.mp4 21MB
  121. 010-Applying_conditional_formatting_across_rows_of_data.mp4 20MB
  122. 017-Dynamically_presenting_data_via_chart_slicers.mp4 20MB
  123. 024-Customizing_templates_to_fit_your_unique_needs.mp4 20MB
  124. 181-Customize_your_Quick_Access_Toolbar.mp4 20MB
  125. 046-Handling_Dates_with_unusual_formats.mp4 20MB
  126. 124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4 20MB
  127. 067-Using_Command_Shortcuts_with_the_Alt_key.mp4 20MB
  128. 026-Enhancing_table_filtering_with_slicers.mp4 20MB
  129. 156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4 20MB
  130. 058-Adding_pictures_as_worksheet_backgrounds.mp4 20MB
  131. 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 20MB
  132. 076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 20MB
  133. 037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 19MB
  134. 090-Change_the_shape_of_comment_boxes_and_other_objects.mp4 19MB
  135. 128-Tips_for_creating_charts_quickly.mp4 19MB
  136. 023-Highlighting_PivotTable_results_with_conditional_formatting.mp4 19MB
  137. 078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 19MB
  138. 159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4 19MB
  139. 117-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 19MB
  140. 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 19MB
  141. 092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 19MB
  142. 065-Creating_a_pick_list_dependent_on_another_pick_list.mp4 19MB
  143. 173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp4 19MB
  144. 161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4 19MB
  145. 184-Differences_and_limitations_of_converting_data_to_a_table.mp4 19MB
  146. 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4 19MB
  147. 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4 19MB
  148. 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18MB
  149. 171-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4 18MB
  150. 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4 18MB
  151. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 18MB
  152. 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4 18MB
  153. 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4 18MB
  154. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 18MB
  155. 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 17MB
  156. 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17MB
  157. 001-Hide_and_unhide_worksheets_securely.mp4 17MB
  158. 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 17MB
  159. 169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4 17MB
  160. 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 17MB
  161. 188-Use_date_functions_for_age_and_tenure_calculations.mp4 16MB
  162. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16MB
  163. 183-How_to_adjust_names.mp4 16MB
  164. 172-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4 16MB
  165. 027-Converting_charts_into_pictures.mp4 16MB
  166. 071-Replace_characters_by_position_with_the_REPLACE_function.mp4 16MB
  167. 186-Explore_formatting_options_not_available_on_the_Home_tab.mp4 16MB
  168. 180-Use_range_names_for_more_readable_formulas.mp4 16MB
  169. 190-Sorting_by_moving_columns.mp4 15MB
  170. 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4 15MB
  171. 167-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4 15MB
  172. 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 15MB
  173. 194-Keystroke_shortcuts_using_the_Alt_key.mp4 15MB
  174. 136-Using_WordArt_for_special_titles_and_headings.mp4 15MB
  175. 018-Parsing_your_data_to_create_unique_lists.mp4 15MB
  176. 168-Calculate_%_of_change.mp4 14MB
  177. 170-Use_the_COUNT_and_COUNTA_functions.mp4 14MB
  178. 011-Exploring_various_layouts_for_your_PivotTable.mp4 14MB
  179. 11-Exploring_various_layouts_for_your_PivotTable.mp4 14MB
  180. 185-Avoid_the_#DIV_0_error_message.mp4 14MB
  181. 182-Conditional_formatting_based_on_date_proximity.mp4 14MB
  182. 153-Work_with_formulas_and_formats_Decimals_and_fractions.mp4 14MB
  183. 179-How_to_covert_ROMAN_numberals.mp4 13MB
  184. 178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4 13MB
  185. 177-Extract_day_month_and_year_from_date_fields.mp4 13MB
  186. 028-Custom_grouping_in_PivotTables.mp4 13MB
  187. 192-Using_the_CONVERT_function_for_different_numbering_systems.mp4 13MB
  188. 187-Control_table_formatting_with_custom_formats.mp4 12MB
  189. 164-Converting_dates_like_20102006_into_usable_date_entries.mp4 12MB
  190. 135-Exploring_font_choices_not_found_on_the_Home_tab.mp4 12MB
  191. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11MB
  192. 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 11MB
  193. 193-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.mp4 11MB
  194. 191-Calculating_cumulative_totals.mp4 11MB
  195. 144-Use_the_new_Funnel_chart_available_in_Excel_365.mp4 11MB
  196. 189-Avoid_unintentional_entries_when_typing_code_numbers.mp4 10MB
  197. 019-Using_the_REPT_function_to_represent_data_visually.mp4 9MB
  198. Exercise Files/124_Quick_Charts.zip 862KB
  199. Exercise Files/133_Weekday_Weekend.zip 512KB
  200. Exercise Files/126_INDEX_Function.zip 492KB
  201. Exercise Files/123_Book1.zip 460KB
  202. Exercise Files/135_Borders_Gridlines.zip 438KB
  203. Exercise Files/132_WordArt_Variations.zip 426KB
  204. Exercise Files/131_Other_Font_Options.zip 367KB
  205. Exercise Files/134_Two_Way_Lookups.zip 361KB
  206. Exercise Files/127_Display_Tips.zip 334KB
  207. Exercise Files/171_Zoom_and_Display_Variations.zip 259KB
  208. Exercise Files/182_FormattingOptions.zip 238KB
  209. Exercise Files/180_Table_Differences.zip 237KB
  210. Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 226KB
  211. Exercise Files/167_Excel_Sheet_Commands.zip 219KB
  212. Exercise Files/170_Unique_and_Duplicate_Data.zip 211KB
  213. Exercise Files/157_Comments_and_Reminders.zip 183KB
  214. Exercise Files/176_Range_Names.zip 165KB
  215. Exercise Files/158_Replace_Format_or_Content.zip 155KB
  216. Exercise Files/165_Fill_in_Blanks.zip 153KB
  217. Exercise Files/169_PivotTable_Date_Grouping.zip 151KB
  218. Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 144KB
  219. Exercise Files/160_Date_Format_Conversions.zip 134KB
  220. Exercise Files/184_Date_Calculations.zip 128KB
  221. Exercise Files/153_Expand_Collapse_PivotTables.zip 123KB
  222. Exercise Files/183_New_Table_Style.zip 123KB
  223. Exercise Files/156_Date_Time_Formats.zip 120KB
  224. Exercise Files/161_Custom_Lists.zip 118KB
  225. Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 115KB
  226. Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 73KB
  227. Exercise Files/150_Mixed_References.zip 65KB
  228. Exercise Files/151_Chart_gridlines_and_borders.zip 65KB
  229. Exercise Files/128_Wrap_text_Merge_Indent.zip 60KB
  230. Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 60KB
  231. Exercise Files/168_Ranking_Data.zip 58KB
  232. Exercise Files/125_Heat_Maps.zip 51KB
  233. Exercise Files/159_Number_Formats.zip 41KB
  234. Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 40KB
  235. Exercise Files/186_Sort_by_Moving_Columns.zip 39KB
  236. 073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31KB
  237. Exercise Files/181_Avoiding_DIV_Error.zip 30KB
  238. 089-Adjust_banded_row_formatting.srt 28KB
  239. 061-Working_with_formulas_in_tables.srt 28KB
  240. Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27KB
  241. Exercise Files/149_Decimals_and_Fractions.zip 26KB
  242. 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25KB
  243. Exercise Files/129_Fill_Effects.zip 25KB
  244. Exercise Files/189_Alt_Key_Shortcuts.zip 25KB
  245. 091-How_and_when_to_use_Excels_10_rounding_functions.srt 24KB
  246. 057-Building_a_flexible_monthly_table_using_functions.srt 24KB
  247. 096-Accelerate_data_entry_with_five_special_techniques.srt 23KB
  248. 014-Adding_illustrations_to_your_workbook.srt 23KB
  249. 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 23KB
  250. 126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 23KB
  251. 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22KB
  252. 048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22KB
  253. 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22KB
  254. Exercise Files/164_Percent_change_and_Goal_Seek.zip 22KB
  255. 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22KB
  256. 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 22KB
  257. 163-Create_numeric_formats_Display_in_thousands_or_millions.srt 22KB
  258. 143-Avoiding_common_chart_distortions.srt 21KB
  259. 137-Differentiating_weekdays_and_weekends_in_Excel_data.srt 21KB
  260. 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21KB
  261. 099-How_to_create_time_interval_entries.srt 21KB
  262. 074-Use_special_tricks_for_working_with_dates_in_Charts.srt 21KB
  263. 120-Tips_for_creating_and_updating_sample_data.srt 21KB
  264. 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 21KB
  265. 052-Using_Excels_error_checking_functions.srt 20KB
  266. Exercise Files/175_ROMAN_ARABIC.zip 20KB
  267. 119-Displaying_multiple_worksheets_and_workbooks_together.srt 20KB
  268. 142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt 20KB
  269. 130-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20KB
  270. 069-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 20KB
  271. 086-Use_the_OFFSET_function_for_tabulating_moving_data.srt 20KB
  272. 079-How_to_use_locked_cells_and_sheet_protection.srt 19KB
  273. 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19KB
  274. 087-Alter_numeric_data_without_formulas.srt 19KB
  275. Exercise Files/179_Date_Proximity_Formatting_final.zip 19KB
  276. 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19KB
  277. 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19KB
  278. 088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19KB
  279. 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 19KB
  280. 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 19KB
  281. Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 19KB
  282. Exercise Files/178_Adjusting_Names.zip 19KB
  283. 068-Set_up_a_macro_for_sorting_dynamic_data.srt 19KB
  284. 034-Calculating_with_hours_minutes_and_times_of_day.srt 18KB
  285. 066-Pasting_picture_links.srt 18KB
  286. 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18KB
  287. 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18KB
  288. 148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt 18KB
  289. 146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt 18KB
  290. 054-Auditing.srt 18KB
  291. 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 18KB
  292. 134-Working_with_multiple_worksheets_simultaneously.srt 18KB
  293. 072-Work_with_formulas_in_tables.srt 18KB
  294. 149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt 18KB
  295. 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 18KB
  296. 082-Use_slicers_and_charts_together_for_dynamic_presentations.srt 18KB
  297. 047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 18KB
  298. 085-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17KB
  299. 132-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17KB
  300. 050-Create_an_Organization_Chart.srt 17KB
  301. 070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17KB
  302. 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 17KB
  303. Exercise Files/130_Multiple_Worksheets.zip 17KB
  304. 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 17KB
  305. 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 17KB
  306. Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16KB
  307. 151-Sorting_tips_and_shortcuts.srt 16KB
  308. 139-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16KB
  309. 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16KB
  310. 043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16KB
  311. 063-Creating_an_Excel_template.srt 16KB
  312. 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16KB
  313. 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16KB
  314. 059-ADDRESS_ROW_and_COLUMN_functions.srt 16KB
  315. 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 16KB
  316. 093-How_to_use_mixed_cell_references.srt 16KB
  317. 055-Adding_comments_and_shapes.srt 16KB
  318. 053-Custom_formats_relative_addressing_and_conditional_formatting.srt 16KB
  319. 129-Creating_heat_maps_using_conditional_formatting.srt 16KB
  320. 098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 16KB
  321. 125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15KB
  322. 140-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt 15KB
  323. 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15KB
  324. 109-Keyboard_shortcuts_for_numeric_formats.srt 15KB
  325. 084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 15KB
  326. 029-Quick_formatting_tips.srt 15KB
  327. 081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 15KB
  328. 062-Locating_Data_Validation_rules_and_violations.srt 15KB
  329. 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 15KB
  330. 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 15KB
  331. 160-Create_your_own_customized_date_and_time_formats.srt 15KB
  332. 155-Control_gridlines_in_charts_and_on_worksheets.srt 15KB
  333. 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 15KB
  334. 127-Dealing_with_circular_errors.srt 15KB
  335. 176-Create_artistic_charts_with_random_numbers.srt 15KB
  336. 141-Freezing_column_and_row_titles.srt 15KB
  337. 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 15KB
  338. 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14KB
  339. Exercise Files/185_Unintentional_Entries.zip 14KB
  340. 045-Creating_Variable_Conditional_Formatting_Rules.srt 14KB
  341. 017-Dynamically_presenting_data_via_chart_slicers.srt 14KB
  342. 077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14KB
  343. 100-How_to_create_frequency_tabulations_and_distributions.srt 14KB
  344. 154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt 14KB
  345. 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 14KB
  346. 037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 14KB
  347. 157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt 14KB
  348. 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 14KB
  349. 065-Creating_a_pick_list_dependent_on_another_pick_list.srt 14KB
  350. 076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 14KB
  351. 064-Restoring_missing_column_titles.srt 14KB
  352. 013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB
  353. 13-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB
  354. 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt 13KB
  355. 123-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13KB
  356. 092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13KB
  357. 080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13KB
  358. 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13KB
  359. 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt 13KB
  360. Exercise Files/154_Phone_and_ZipCode_Formats.zip 13KB
  361. 117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13KB
  362. 012-Splitting_and_consolidating_workbooks.srt 13KB
  363. 12-Splitting_and_consolidating_workbooks.srt 13KB
  364. 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt 13KB
  365. 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 13KB
  366. 075-Use_a_data_form_for_data_entry_and_exploring_data.srt 13KB
  367. 128-Tips_for_creating_charts_quickly.srt 13KB
  368. 138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 13KB
  369. 124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 13KB
  370. 056-Drawing_borders_and_border_grids.srt 13KB
  371. 090-Change_the_shape_of_comment_boxes_and_other_objects.srt 13KB
  372. 001-Hide_and_unhide_worksheets_securely.srt 12KB
  373. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12KB
  374. 078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12KB
  375. 165-Create_custom_lists_for_letter_series_like_A_to_Z.srt 12KB
  376. 024-Customizing_templates_to_fit_your_unique_needs.srt 12KB
  377. 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12KB
  378. 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12KB
  379. 010-Applying_conditional_formatting_across_rows_of_data.srt 12KB
  380. 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12KB
  381. 156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt 12KB
  382. 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt 12KB
  383. 030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 12KB
  384. 023-Highlighting_PivotTable_results_with_conditional_formatting.srt 12KB
  385. 159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt 12KB
  386. Exercise Files/187_Cumulative_Totals.zip 12KB
  387. 161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt 12KB
  388. 131-Displaying_tips_when_using_Excel_in_presentations.srt 12KB
  389. 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt 12KB
  390. 166-Freeze_Panes_and_Split.srt 12KB
  391. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11KB
  392. 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11KB
  393. 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11KB
  394. 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11KB
  395. 171-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt 11KB
  396. 181-Customize_your_Quick_Access_Toolbar.srt 11KB
  397. 046-Handling_Dates_with_unusual_formats.srt 11KB
  398. 172-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt 11KB
  399. 162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt 11KB
  400. 067-Using_Command_Shortcuts_with_the_Alt_key.srt 11KB
  401. 194-Keystroke_shortcuts_using_the_Alt_key.srt 11KB
  402. 175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt 11KB
  403. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 11KB
  404. 153-Work_with_formulas_and_formats_Decimals_and_fractions.srt 11KB
  405. 188-Use_date_functions_for_age_and_tenure_calculations.srt 11KB
  406. 174-Identify_or_extract_unique_entries_in_a_list.srt 11KB
  407. 167-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt 11KB
  408. 173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt 10KB
  409. 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10KB
  410. 058-Adding_pictures_as_worksheet_backgrounds.srt 10KB
  411. 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt 10KB
  412. 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10KB
  413. 026-Enhancing_table_filtering_with_slicers.srt 10KB
  414. 071-Replace_characters_by_position_with_the_REPLACE_function.srt 10KB
  415. 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10KB
  416. 168-Calculate_%_of_change.srt 10KB
  417. 184-Differences_and_limitations_of_converting_data_to_a_table.srt 10KB
  418. 180-Use_range_names_for_more_readable_formulas.srt 10KB
  419. 183-How_to_adjust_names.srt 10KB
  420. 177-Extract_day_month_and_year_from_date_fields.srt 10KB
  421. 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 10KB
  422. 178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt 10KB
  423. Exercise Files/188_CONVERT_Function.zip 10KB
  424. 185-Avoid_the_#DIV_0_error_message.srt 9KB
  425. 022-Increasing_your_productivity_with_custom_lists.srt 9KB
  426. 182-Conditional_formatting_based_on_date_proximity.srt 9KB
  427. 027-Converting_charts_into_pictures.srt 9KB
  428. 136-Using_WordArt_for_special_titles_and_headings.srt 9KB
  429. 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 9KB
  430. 028-Custom_grouping_in_PivotTables.srt 9KB
  431. 144-Use_the_new_Funnel_chart_available_in_Excel_365.srt 8KB
  432. 011-Exploring_various_layouts_for_your_PivotTable.srt 8KB
  433. 11-Exploring_various_layouts_for_your_PivotTable.srt 8KB
  434. 169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt 8KB
  435. 192-Using_the_CONVERT_function_for_different_numbering_systems.srt 8KB
  436. 189-Avoid_unintentional_entries_when_typing_code_numbers.srt 8KB
  437. 186-Explore_formatting_options_not_available_on_the_Home_tab.srt 8KB
  438. 164-Converting_dates_like_20102006_into_usable_date_entries.srt 8KB
  439. 193-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.srt 8KB
  440. 179-How_to_covert_ROMAN_numberals.srt 8KB
  441. 190-Sorting_by_moving_columns.srt 8KB
  442. 170-Use_the_COUNT_and_COUNTA_functions.srt 8KB
  443. 191-Calculating_cumulative_totals.srt 8KB
  444. 135-Exploring_font_choices_not_found_on_the_Home_tab.srt 7KB
  445. 018-Parsing_your_data_to_create_unique_lists.srt 7KB
  446. Exercise Files/189_Chart_based_on_a_Table.zip 7KB
  447. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6KB
  448. 187-Control_table_formatting_with_custom_formats.srt 6KB
  449. 019-Using_the_REPT_function_to_represent_data_visually.srt 6KB