589689.xyz

2015-2019-LinkedIn-Excel_Tips_Weekly_()-IVY

  • 收录时间:2019-11-27 22:45:27
  • 文件大小:5GB
  • 下载次数:92
  • 最近下载:2020-12-26 18:26:51
  • 磁力链接:
立即下载 复制链接

文件列表

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