589689.xyz

2015-2018-Lynda-Excel_Tips_Weekly_()-IVY

  • 收录时间:2019-05-23 00:26:48
  • 文件大小:4GB
  • 下载次数:7
  • 最近下载:2020-08-20 15:14:05
  • 磁力链接:
立即下载 复制链接

文件列表

  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. 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4 19MB
  146. 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4 19MB
  147. 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18MB
  148. 171-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4 18MB
  149. 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4 18MB
  150. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 18MB
  151. 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.mp4 18MB
  152. 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4 18MB
  153. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 18MB
  154. 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 17MB
  155. 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17MB
  156. 001-Hide_and_unhide_worksheets_securely.mp4 17MB
  157. 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 17MB
  158. 169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4 17MB
  159. 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 17MB
  160. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16MB
  161. 172-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4 16MB
  162. 027-Converting_charts_into_pictures.mp4 16MB
  163. 071-Replace_characters_by_position_with_the_REPLACE_function.mp4 16MB
  164. 180-Use_range_names_for_more_readable_formulas.mp4 16MB
  165. 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4 15MB
  166. 167-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4 15MB
  167. 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 15MB
  168. 136-Using_WordArt_for_special_titles_and_headings.mp4 15MB
  169. 018-Parsing_your_data_to_create_unique_lists.mp4 15MB
  170. 168-Calculate_%_of_change.mp4 14MB
  171. 170-Use_the_COUNT_and_COUNTA_functions.mp4 14MB
  172. 011-Exploring_various_layouts_for_your_PivotTable.mp4 14MB
  173. 11-Exploring_various_layouts_for_your_PivotTable.mp4 14MB
  174. 153-Work_with_formulas_and_formats_Decimals_and_fractions.mp4 14MB
  175. 179-How_to_covert_ROMAN_numberals.mp4 13MB
  176. 178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4 13MB
  177. 177-Extract_day_month_and_year_from_date_fields.mp4 13MB
  178. 028-Custom_grouping_in_PivotTables.mp4 13MB
  179. 164-Converting_dates_like_20102006_into_usable_date_entries.mp4 12MB
  180. 135-Exploring_font_choices_not_found_on_the_Home_tab.mp4 12MB
  181. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11MB
  182. 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 11MB
  183. 144-Use_the_new_Funnel_chart_available_in_Excel_365.mp4 11MB
  184. 019-Using_the_REPT_function_to_represent_data_visually.mp4 9MB
  185. Exercise Files/171_Zoom_and_Display_Variations.zip 259KB
  186. Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 226KB
  187. Exercise Files/167_Excel_Sheet_Commands.zip 219KB
  188. Exercise Files/170_Unique_and_Duplicate_Data.zip 211KB
  189. Exercise Files/157_Comments_and_Reminders.zip 183KB
  190. Exercise Files/176_Range_Names.zip 165KB
  191. Exercise Files/158_Replace_Format_or_Content.zip 155KB
  192. Exercise Files/165_Fill_in_Blanks.zip 153KB
  193. Exercise Files/169_PivotTable_Date_Grouping.zip 151KB
  194. Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 144KB
  195. Exercise Files/160_Date_Format_Conversions.zip 134KB
  196. Exercise Files/153_Expand_Collapse_PivotTables.zip 123KB
  197. Exercise Files/156_Date_Time_Formats.zip 120KB
  198. Exercise Files/161_Custom_Lists.zip 118KB
  199. Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 115KB
  200. Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 73KB
  201. Exercise Files/150_Mixed_References.zip 65KB
  202. Exercise Files/151_Chart_gridlines_and_borders.zip 65KB
  203. Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 60KB
  204. Exercise Files/168_Ranking_Data.zip 58KB
  205. Exercise Files/159_Number_Formats.zip 41KB
  206. Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 40KB
  207. 073-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31KB
  208. 089-Adjust_banded_row_formatting.srt 28KB
  209. 061-Working_with_formulas_in_tables.srt 28KB
  210. Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27KB
  211. Exercise Files/149_Decimals_and_Fractions.zip 26KB
  212. 108-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25KB
  213. 091-How_and_when_to_use_Excels_10_rounding_functions.srt 24KB
  214. 057-Building_a_flexible_monthly_table_using_functions.srt 24KB
  215. 096-Accelerate_data_entry_with_five_special_techniques.srt 23KB
  216. 014-Adding_illustrations_to_your_workbook.srt 23KB
  217. 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 23KB
  218. 126-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 23KB
  219. 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22KB
  220. 048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22KB
  221. 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22KB
  222. Exercise Files/164_Percent_change_and_Goal_Seek.zip 22KB
  223. 115-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22KB
  224. 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 22KB
  225. 163-Create_numeric_formats_Display_in_thousands_or_millions.srt 22KB
  226. 143-Avoiding_common_chart_distortions.srt 21KB
  227. 137-Differentiating_weekdays_and_weekends_in_Excel_data.srt 21KB
  228. 107-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21KB
  229. 099-How_to_create_time_interval_entries.srt 21KB
  230. 074-Use_special_tricks_for_working_with_dates_in_Charts.srt 21KB
  231. 120-Tips_for_creating_and_updating_sample_data.srt 21KB
  232. 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 21KB
  233. 052-Using_Excels_error_checking_functions.srt 20KB
  234. Exercise Files/175_ROMAN_ARABIC.zip 20KB
  235. 119-Displaying_multiple_worksheets_and_workbooks_together.srt 20KB
  236. 142-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt 20KB
  237. 130-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20KB
  238. 069-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 20KB
  239. 086-Use_the_OFFSET_function_for_tabulating_moving_data.srt 20KB
  240. 079-How_to_use_locked_cells_and_sheet_protection.srt 19KB
  241. 106-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19KB
  242. 087-Alter_numeric_data_without_formulas.srt 19KB
  243. 113-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19KB
  244. 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19KB
  245. 088-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19KB
  246. 122-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 19KB
  247. 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 19KB
  248. Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 19KB
  249. 068-Set_up_a_macro_for_sorting_dynamic_data.srt 19KB
  250. 034-Calculating_with_hours_minutes_and_times_of_day.srt 18KB
  251. 066-Pasting_picture_links.srt 18KB
  252. 105-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18KB
  253. 102-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18KB
  254. 148-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt 18KB
  255. 146-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt 18KB
  256. 054-Auditing.srt 18KB
  257. 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 18KB
  258. 134-Working_with_multiple_worksheets_simultaneously.srt 18KB
  259. 072-Work_with_formulas_in_tables.srt 18KB
  260. 149-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt 18KB
  261. 104-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 18KB
  262. 082-Use_slicers_and_charts_together_for_dynamic_presentations.srt 18KB
  263. 047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 18KB
  264. 085-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17KB
  265. 132-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17KB
  266. 050-Create_an_Organization_Chart.srt 17KB
  267. 070-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17KB
  268. 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 17KB
  269. 110-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 17KB
  270. 112-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 17KB
  271. Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16KB
  272. 151-Sorting_tips_and_shortcuts.srt 16KB
  273. 139-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16KB
  274. 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16KB
  275. 043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16KB
  276. 063-Creating_an_Excel_template.srt 16KB
  277. 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16KB
  278. 111-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16KB
  279. 059-ADDRESS_ROW_and_COLUMN_functions.srt 16KB
  280. 121-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 16KB
  281. 093-How_to_use_mixed_cell_references.srt 16KB
  282. 055-Adding_comments_and_shapes.srt 16KB
  283. 053-Custom_formats_relative_addressing_and_conditional_formatting.srt 16KB
  284. 129-Creating_heat_maps_using_conditional_formatting.srt 16KB
  285. 098-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 16KB
  286. 125-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15KB
  287. 140-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt 15KB
  288. 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15KB
  289. 109-Keyboard_shortcuts_for_numeric_formats.srt 15KB
  290. 084-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 15KB
  291. 029-Quick_formatting_tips.srt 15KB
  292. 081-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 15KB
  293. 062-Locating_Data_Validation_rules_and_violations.srt 15KB
  294. 114-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 15KB
  295. 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 15KB
  296. 160-Create_your_own_customized_date_and_time_formats.srt 15KB
  297. 155-Control_gridlines_in_charts_and_on_worksheets.srt 15KB
  298. 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 15KB
  299. 127-Dealing_with_circular_errors.srt 15KB
  300. 176-Create_artistic_charts_with_random_numbers.srt 15KB
  301. 141-Freezing_column_and_row_titles.srt 15KB
  302. 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 15KB
  303. 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14KB
  304. 045-Creating_Variable_Conditional_Formatting_Rules.srt 14KB
  305. 017-Dynamically_presenting_data_via_chart_slicers.srt 14KB
  306. 077-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14KB
  307. 100-How_to_create_frequency_tabulations_and_distributions.srt 14KB
  308. 154-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt 14KB
  309. 103-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 14KB
  310. 037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 14KB
  311. 157-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt 14KB
  312. 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 14KB
  313. 065-Creating_a_pick_list_dependent_on_another_pick_list.srt 14KB
  314. 076-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 14KB
  315. 064-Restoring_missing_column_titles.srt 14KB
  316. 013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB
  317. 13-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB
  318. 158-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt 13KB
  319. 123-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13KB
  320. 092-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13KB
  321. 080-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13KB
  322. 101-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13KB
  323. 152-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt 13KB
  324. Exercise Files/154_Phone_and_ZipCode_Formats.zip 13KB
  325. 117-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13KB
  326. 012-Splitting_and_consolidating_workbooks.srt 13KB
  327. 12-Splitting_and_consolidating_workbooks.srt 13KB
  328. 150-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt 13KB
  329. 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 13KB
  330. 075-Use_a_data_form_for_data_entry_and_exploring_data.srt 13KB
  331. 128-Tips_for_creating_charts_quickly.srt 13KB
  332. 138-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 13KB
  333. 124-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 13KB
  334. 056-Drawing_borders_and_border_grids.srt 13KB
  335. 090-Change_the_shape_of_comment_boxes_and_other_objects.srt 13KB
  336. 001-Hide_and_unhide_worksheets_securely.srt 12KB
  337. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12KB
  338. 078-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12KB
  339. 165-Create_custom_lists_for_letter_series_like_A_to_Z.srt 12KB
  340. 024-Customizing_templates_to_fit_your_unique_needs.srt 12KB
  341. 083-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12KB
  342. 097-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12KB
  343. 010-Applying_conditional_formatting_across_rows_of_data.srt 12KB
  344. 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12KB
  345. 156-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt 12KB
  346. 094-Adjust_formatting_to_display_large_values_in_thousands_millions_etc.srt 12KB
  347. 030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 12KB
  348. 023-Highlighting_PivotTable_results_with_conditional_formatting.srt 12KB
  349. 159-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt 12KB
  350. 161-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt 12KB
  351. 131-Displaying_tips_when_using_Excel_in_presentations.srt 12KB
  352. 145-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt 12KB
  353. 166-Freeze_Panes_and_Split.srt 12KB
  354. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11KB
  355. 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11KB
  356. 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11KB
  357. 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11KB
  358. 171-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt 11KB
  359. 181-Customize_your_Quick_Access_Toolbar.srt 11KB
  360. 046-Handling_Dates_with_unusual_formats.srt 11KB
  361. 172-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt 11KB
  362. 162-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt 11KB
  363. 067-Using_Command_Shortcuts_with_the_Alt_key.srt 11KB
  364. 175-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt 11KB
  365. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 11KB
  366. 153-Work_with_formulas_and_formats_Decimals_and_fractions.srt 11KB
  367. 174-Identify_or_extract_unique_entries_in_a_list.srt 11KB
  368. 167-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt 11KB
  369. 173-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt 10KB
  370. 118-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10KB
  371. 058-Adding_pictures_as_worksheet_backgrounds.srt 10KB
  372. 147-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt 10KB
  373. 133-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10KB
  374. 026-Enhancing_table_filtering_with_slicers.srt 10KB
  375. 071-Replace_characters_by_position_with_the_REPLACE_function.srt 10KB
  376. 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10KB
  377. 168-Calculate_%_of_change.srt 10KB
  378. 180-Use_range_names_for_more_readable_formulas.srt 10KB
  379. 177-Extract_day_month_and_year_from_date_fields.srt 10KB
  380. 095-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 10KB
  381. 178-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt 10KB
  382. 022-Increasing_your_productivity_with_custom_lists.srt 9KB
  383. 027-Converting_charts_into_pictures.srt 9KB
  384. 136-Using_WordArt_for_special_titles_and_headings.srt 9KB
  385. 116-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 9KB
  386. 028-Custom_grouping_in_PivotTables.srt 9KB
  387. 144-Use_the_new_Funnel_chart_available_in_Excel_365.srt 8KB
  388. 011-Exploring_various_layouts_for_your_PivotTable.srt 8KB
  389. 11-Exploring_various_layouts_for_your_PivotTable.srt 8KB
  390. 169-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt 8KB
  391. 164-Converting_dates_like_20102006_into_usable_date_entries.srt 8KB
  392. 179-How_to_covert_ROMAN_numberals.srt 8KB
  393. 170-Use_the_COUNT_and_COUNTA_functions.srt 8KB
  394. 135-Exploring_font_choices_not_found_on_the_Home_tab.srt 7KB
  395. 018-Parsing_your_data_to_create_unique_lists.srt 7KB
  396. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6KB
  397. 019-Using_the_REPT_function_to_represent_data_visually.srt 6KB