589689.xyz

(2015-2020) Excel Tips Weekly (Updated )-IVY

  • 收录时间:2020-05-23 20:04:17
  • 文件大小:5GB
  • 下载次数:32
  • 最近下载:2021-01-14 01:40:03
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 087-Adjust_banded_row_formatting.mp4 58MB
  2. 072-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. 137-Freezing_column_and_row_titles.mp4 42MB
  7. 107-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 41MB
  8. 112-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. 105-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 39MB
  13. 047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 38MB
  14. 085-Alter_numeric_data_without_formulas.mp4 37MB
  15. 098-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 37MB
  16. 101-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 36MB
  17. 159-Create_numeric_formats_Display_in_thousands_or_millions.mp4 36MB
  18. 099-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 36MB
  19. 089-How_and_when_to_use_Excels_10_rounding_functions.mp4 35MB
  20. 123-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4 35MB
  21. 126-Creating_heat_maps_using_conditional_formatting.mp4 35MB
  22. 086-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 34MB
  23. 052-Using_Excels_error_checking_functions.mp4 34MB
  24. 014-Adding_illustrations_to_your_workbook.mp4 34MB
  25. 073-Use_special_tricks_for_working_with_dates_in_Charts.mp4 33MB
  26. 057-Building_a_flexible_monthly_table_using_functions.mp4 33MB
  27. 139-Avoiding_common_chart_distortions.mp4 33MB
  28. 147-Sorting_tips_and_shortcuts.mp4 32MB
  29. 116-Displaying_multiple_worksheets_and_workbooks_together.mp4 32MB
  30. 096-How_to_create_time_interval_entries.mp4 32MB
  31. 117-Tips_for_creating_and_updating_sample_data.mp4 32MB
  32. 093-Accelerate_data_entry_with_five_special_techniques.mp4 32MB
  33. 084-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 31MB
  34. 045-Creating_Variable_Conditional_Formatting_Rules.mp4 31MB
  35. 054-Auditing.mp4 31MB
  36. 129-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4 30MB
  37. 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 30MB
  38. 162-Freeze_Panes_and_Split.mp4 30MB
  39. 136-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4 30MB
  40. 102-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 30MB
  41. 071-Work_with_formulas_in_tables.mp4 30MB
  42. 119-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4 30MB
  43. 104-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 30MB
  44. 110-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 30MB
  45. 103-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 30MB
  46. 095-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 30MB
  47. 034-Calculating_with_hours_minutes_and_times_of_day.mp4 30MB
  48. 128-Displaying_tips_when_using_Excel_in_presentations.mp4 30MB
  49. 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 30MB
  50. 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 29MB
  51. 111-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 29MB
  52. 080-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 29MB
  53. 068-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 29MB
  54. 161-Create_custom_lists_for_letter_series_like_A_to_Z.mp4 29MB
  55. 062-Locating_Data_Validation_rules_and_violations.mp4 29MB
  56. 127-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4 28MB
  57. 067-Set_up_a_macro_for_sorting_dynamic_data.mp4 28MB
  58. 142-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4 28MB
  59. 043-Exploring_what_if_scenarios_using_Goal_Seek.mp4 28MB
  60. 144-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4 28MB
  61. 145-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4 28MB
  62. 150-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4 28MB
  63. 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 28MB
  64. 079-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 28MB
  65. 059-ADDRESS_ROW_and_COLUMN_functions.mp4 28MB
  66. 171-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp4 27MB
  67. 064-Restoring_missing_column_titles.mp4 26MB
  68. 069-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 26MB
  69. 131-Working_with_multiple_worksheets_simultaneously.mp4 26MB
  70. 083-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 26MB
  71. 106-Keyboard_shortcuts_for_numeric_formats.mp4 26MB
  72. 030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 26MB
  73. 138-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4 26MB
  74. 055-Adding_comments_and_shapes.mp4 25MB
  75. 135-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4 25MB
  76. 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 25MB
  77. 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 25MB
  78. 097-How_to_create_frequency_tabulations_and_distributions.mp4 25MB
  79. 074-Use_a_data_form_for_data_entry_and_exploring_data.mp4 25MB
  80. 108-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 25MB
  81. 109-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 24MB
  82. 122-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4 24MB
  83. 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 24MB
  84. 118-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4 24MB
  85. 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 24MB
  86. 053-Custom_formats_relative_addressing_and_conditional_formatting.mp4 24MB
  87. 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 24MB
  88. 225 - Sort or filter data based on color font or cell color background.mp4 24MB
  89. 050-Create_an_Organization_Chart.mp4 24MB
  90. 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 24MB
  91. 120-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4 23MB
  92. 091-How_to_use_mixed_cell_references.mp4 23MB
  93. 029-Quick_formatting_tips.mp4 23MB
  94. 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 23MB
  95. 013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23MB
  96. 063-Creating_an_Excel_template.mp4 23MB
  97. 134-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4 23MB
  98. 172-Create_artistic_charts_with_random_numbers.mp4 23MB
  99. 082-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 23MB
  100. 170-Identify_or_extract_unique_entries_in_a_list.mp4 23MB
  101. 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 23MB
  102. 156-Create_your_own_customized_date_and_time_formats.mp4 23MB
  103. 158-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4 22MB
  104. 124-Dealing_with_circular_errors.mp4 22MB
  105. 076-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 22MB
  106. 153-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4 22MB
  107. 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 22MB
  108. 239 - Use Find and Replace to change cell contents and formats.mp4 22MB
  109. 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 22MB
  110. 151-Control_gridlines_in_charts_and_on_worksheets.mp4 22MB
  111. 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 22MB
  112. 252 - Work with hidden and visible data in filtered and subtotaled lists.mp4 22MB
  113. 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 21MB
  114. 056-Drawing_borders_and_border_grids.mp4 21MB
  115. 198-Helpful_keystroke_shortcuts.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. 078-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 21MB
  119. 012-Splitting_and_consolidating_workbooks.mp4 21MB
  120. 010-Applying_conditional_formatting_across_rows_of_data.mp4 20MB
  121. 017-Dynamically_presenting_data_via_chart_slicers.mp4 20MB
  122. 024-Customizing_templates_to_fit_your_unique_needs.mp4 20MB
  123. 177-Customize_your_Quick_Access_Toolbar.mp4 20MB
  124. 046-Handling_Dates_with_unusual_formats.mp4 20MB
  125. 121-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4 20MB
  126. 066-Using_Command_Shortcuts_with_the_Alt_key.mp4 20MB
  127. 026-Enhancing_table_filtering_with_slicers.mp4 20MB
  128. 152-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4 20MB
  129. 058-Adding_pictures_as_worksheet_backgrounds.mp4 20MB
  130. 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 20MB
  131. 075-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 20MB
  132. 037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 19MB
  133. 088-Change_the_shape_of_comment_boxes_and_other_objects.mp4 19MB
  134. 125-Tips_for_creating_charts_quickly.mp4 19MB
  135. 201-Create_picture_links.mp4 19MB
  136. 023-Highlighting_PivotTable_results_with_conditional_formatting.mp4 19MB
  137. 077-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 19MB
  138. 155-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4 19MB
  139. 114-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 19MB
  140. 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 19MB
  141. 207-Tracking_down_conditional_formatting_and_data_validation_rules.mp4 19MB
  142. 090-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 19MB
  143. 065-Creating_a_pick_list_dependent_on_another_pick_list.mp4 19MB
  144. 169-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp4 19MB
  145. 157-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4 19MB
  146. 180-Differences_and_limitations_of_converting_data_to_a_table.mp4 19MB
  147. 154-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4 19MB
  148. 146-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4 19MB
  149. 081-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18MB
  150. 167-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4 18MB
  151. 148-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4 18MB
  152. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 18MB
  153. 218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 18MB
  154. 143-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4 18MB
  155. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 18MB
  156. 115-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 17MB
  157. 206-Display_large_values.mp4 17MB
  158. 203-Protect_worksheets_and_lock_cells.mp4 17MB
  159. 130-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17MB
  160. 001-Hide_and_unhide_worksheets_securely.mp4 17MB
  161. 094-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 17MB
  162. 233 - Get totals quickly without creating formulas.mp4 17MB
  163. 241 - Change PivotTable settings for titles and summaries.mp4 17MB
  164. 165-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4 17MB
  165. 100-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 17MB
  166. 240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 17MB
  167. 227 - Select from over 800 icons to enliven worksheets.mp4 16MB
  168. 184-Use_date_functions_for_age_and_tenure_calculations.mp4 16MB
  169. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16MB
  170. 232 - Track variables using the Scenario Manager.mp4 16MB
  171. 179-How_to_adjust_names.mp4 16MB
  172. 168-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4 16MB
  173. 027-Converting_charts_into_pictures.mp4 16MB
  174. 247 - Look forward and backward using EDATE and other date functions.mp4 16MB
  175. 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 16MB
  176. 216 - Creating and updating sample data.mp4 16MB
  177. 070-Replace_characters_by_position_with_the_REPLACE_function.mp4 16MB
  178. 182-Explore_formatting_options_not_available_on_the_Home_tab.mp4 16MB
  179. 176-Use_range_names_for_more_readable_formulas.mp4 16MB
  180. 186-Sorting_by_moving_columns.mp4 15MB
  181. 141-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4 15MB
  182. 248 - Display and highlight worksheet formula cells.mp4 15MB
  183. 221 - Use the XLOOKUP function to replace VLOOKUP.mp4 15MB
  184. 230 - Insert colorful images with the People Graph Add-in.mp4 15MB
  185. 163-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4 15MB
  186. 092-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 15MB
  187. 190-Keystroke_shortcuts_using_the_Alt_key.mp4 15MB
  188. 133-Using_WordArt_for_special_titles_and_headings.mp4 15MB
  189. 018-Parsing_your_data_to_create_unique_lists.mp4 15MB
  190. 217 - Format macros to make you a more efficient Excel user.mp4 15MB
  191. 164-Calculate_%_of_change.mp4 14MB
  192. 238 - Extract filtered data with data validation and the FILTER function.mp4 14MB
  193. 166-Use_the_COUNT_and_COUNTA_functions.mp4 14MB
  194. 011-Exploring_various_layouts_for_your_PivotTable.mp4 14MB
  195. 253 - Create a powerful macro.mp4 14MB
  196. 246 - Prevent and locate duplicate worksheet entries.mp4 14MB
  197. 181-Avoid_the_#DIV_0_error_message.mp4 14MB
  198. 178-Conditional_formatting_based_on_date_proximity.mp4 14MB
  199. 224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 14MB
  200. 202-How_to_use_the_error_checking_rules_in_Excel.mp4 14MB
  201. 149-Work_with_formulas_and_formats_Decimals_and_fractions.mp4 14MB
  202. 213 - Tabulating totals with the VLOOKUP function and array constants.mp4 14MB
  203. 209 - Displaying gridlines, borders, and column_row headings when printing.mp4 13MB
  204. 208 - Transposing data and using the TRANSPOSE function.mp4 13MB
  205. 175-How_to_covert_ROMAN_numberals.mp4 13MB
  206. 234 - Use column or row references to create dynamic formulas.mp4 13MB
  207. 174-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4 13MB
  208. 249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 13MB
  209. 173-Extract_day_month_and_year_from_date_fields.mp4 13MB
  210. 242 - Use the Excel filtering capability for dates.mp4 13MB
  211. 028-Custom_grouping_in_PivotTables.mp4 13MB
  212. 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 13MB
  213. 244 - Use data validation rules with special phone and social security formats.mp4 13MB
  214. 188-Using_the_CONVERT_function_for_different_numbering_systems.mp4 13MB
  215. 250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 13MB
  216. 197-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.mp4 13MB
  217. 204-Use_mixed_addresses_in_Excel_formulas.mp4 13MB
  218. 205-Rapid_filtering_with_Filter_by_Selection.mp4 13MB
  219. 220 - Calculate loan payments and investments with PMT and FV functions.mp4 12MB
  220. 183-Control_table_formatting_with_custom_formats.mp4 12MB
  221. 235 - Overcoming obstacles when working with dates in charts.mp4 12MB
  222. 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 12MB
  223. 199-Identify_weekdays_and_weekend_days_in_data.mp4 12MB
  224. 196-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.mp4 12MB
  225. 160-Converting_dates_like_20102006_into_usable_date_entries.mp4 12MB
  226. 243 - Use worksheet names in formulas.mp4 12MB
  227. 211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 12MB
  228. 191-Using_the_Solver_Add-in.mp4 12MB
  229. 132-Exploring_font_choices_not_found_on_the_Home_tab.mp4 12MB
  230. 226 - Simplify the use of special characters and symbols.mp4 11MB
  231. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11MB
  232. 113-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 11MB
  233. 245 - Work with time calculations in formulas.mp4 11MB
  234. 193-Adjusting_default_layouts_and_date_grouping_in_PivotTables.mp4 11MB
  235. 219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 11MB
  236. 189-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.mp4 11MB
  237. 231 - Use formulas to create interactive charts.mp4 11MB
  238. 187-Calculating_cumulative_totals.mp4 11MB
  239. 229 - How and when to use an area chart.mp4 11MB
  240. 214 - Working with array formulas more easily.mp4 11MB
  241. 192-Column_widths_row_heights_merging_cells_and_related_formatting_issues.mp4 11MB
  242. 237 - Techniques for creating date series.mp4 11MB
  243. 140-Use_the_new_Funnel_chart_available_in_Excel_365.mp4 11MB
  244. 195-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.mp4 11MB
  245. 215 - Using the new UNIQUE function to count and copy unique list entries.mp4 10MB
  246. 222 - Chart display options with blank cells in source data.mp4 10MB
  247. 194-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.mp4 10MB
  248. 185-Avoid_unintentional_entries_when_typing_code_numbers.mp4 10MB
  249. 200-Use_chart_and_filter_for_presentations.mp4 10MB
  250. 236 - Create map-type charts based on geographical locations.mp4 9MB
  251. 251 - Use the XMATCH function to replace MATCH.mp4 9MB
  252. 210 - Exploring some of the 200-plus SmartArt graphic options.mp4 9MB
  253. 019-Using_the_REPT_function_to_represent_data_visually.mp4 9MB
  254. Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip 1MB
  255. Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip 1MB
  256. Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip 1MB
  257. Exercise Files/124_Quick_Charts.zip 862KB
  258. Exercise Files/133_Weekday_Weekend.zip 512KB
  259. Exercise Files/126_INDEX_Function.zip 492KB
  260. Exercise Files/123_Book1.zip 460KB
  261. Exercise Files/135_Borders_Gridlines.zip 438KB
  262. Exercise Files/132_WordArt_Variations.zip 426KB
  263. Exercise Files/211_GoTo_Special.zip 406KB
  264. Exercise Files/131_Other_Font_Options.zip 367KB
  265. Exercise Files/134_Two_Way_Lookups.zip 361KB
  266. Exercise Files/215_AdvancedFilter.zip 345KB
  267. Exercise Files/127_Display_Tips.zip 334KB
  268. Exercise Files/223_BlankCellsInCharts.zip 333KB
  269. Exercise Files/201_Error_Checking_Indicators.zip 316KB
  270. Exercise Files/197_Helpful_Keystroke_Shortcuts.zip 306KB
  271. Exercise Files/171_Zoom_and_Display_Variations.zip 259KB
  272. Exercise Files/198_Weekdays_and_Weekends.zip 248KB
  273. Exercise Files/182_FormattingOptions.zip 238KB
  274. Exercise Files/180_Table_Differences.zip 237KB
  275. Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 226KB
  276. Exercise Files/167_Excel_Sheet_Commands.zip 219KB
  277. Exercise Files/170_Unique_and_Duplicate_Data.zip 211KB
  278. Exercise Files/157_Comments_and_Reminders.zip 183KB
  279. Exercise Files/243_XLOOKUP_Function.zip 165KB
  280. Exercise Files/176_Range_Names.zip 165KB
  281. Exercise Files/240_Find_Select.zip 158KB
  282. Exercise Files/158_Replace_Format_or_Content.zip 155KB
  283. Exercise Files/165_Fill_in_Blanks.zip 153KB
  284. Exercise Files/169_PivotTable_Date_Grouping.zip 151KB
  285. Exercise Files/196_Double_and_Triple_Spaced_Printing.zip 147KB
  286. Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 144KB
  287. Exercise Files/160_Date_Format_Conversions.zip 134KB
  288. Exercise Files/250_EDate_EMonth_DatedIF.zip 129KB
  289. Exercise Files/184_Date_Calculations.zip 128KB
  290. Exercise Files/216_ArrayFormulaUpdates.zip 128KB
  291. Exercise Files/153_Expand_Collapse_PivotTables.zip 123KB
  292. Exercise Files/183_New_Table_Style.zip 123KB
  293. Exercise Files/156_Date_Time_Formats.zip 120KB
  294. Exercise Files/161_Custom_Lists.zip 118KB
  295. Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 115KB
  296. Exercise Files/207_CheckBox_ConditionalFormatting.zip 107KB
  297. Exercise Files/206_ConditionalFormatting_and_DataValidation.zip 107KB
  298. Exercise Files/194_Watch_Window.zip 105KB
  299. Exercise Files/255_Hidden_Visible_Data.zip 85KB
  300. Exercise Files/249_Prevent_Locate_Duplicates.zip 78KB
  301. Exercise Files/195_TRIM_and_CLEAN.zip 75KB
  302. Exercise Files/246_Sheet_Names.zip 74KB
  303. Exercise Files/226_Sort_by_Color.zip 74KB
  304. Exercise Files/204_Filter_by_Selection.zip 73KB
  305. Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 73KB
  306. Exercise Files/239_Data_Validation_and_Filter.zip 70KB
  307. Exercise Files/192_PivotTable_Settings.zip 67KB
  308. Exercise Files/200_Linking_Pictures.zip 66KB
  309. Exercise Files/234_Status_Bar.zip 65KB
  310. Exercise Files/150_Mixed_References.zip 65KB
  311. Exercise Files/151_Chart_gridlines_and_borders.zip 65KB
  312. Exercise Files/220_SORT_and_SORTBY_Functions.zip 63KB
  313. Exercise Files/128_Wrap_text_Merge_Indent.zip 60KB
  314. Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 60KB
  315. Exercise Files/235_Columns_and_Rows.zip 60KB
  316. Exercise Files/231_People_Graph.zip 59KB
  317. Exercise Files/168_Ranking_Data.zip 58KB
  318. Exercise Files/241_AverageCountSubscript.zip 57KB
  319. Exercise Files/202_Worksheet_Protection.zip 56KB
  320. Exercise Files/218_Sample_Data.zip 51KB
  321. Exercise Files/125_Heat_Maps.zip 51KB
  322. Exercise Files/248_Time_Math.zip 48KB
  323. Exercise Files/244_PivotTable_Settings.zip 46KB
  324. Exercise Files/225_New_Formulas.zip 45KB
  325. Exercise Files/228_Icons.zip 42KB
  326. Exercise Files/217_UNIQUE_function.zip 41KB
  327. Exercise Files/159_Number_Formats.zip 41KB
  328. Exercise Files/221_Themes.zip 40KB
  329. Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 40KB
  330. Exercise Files/194_LEN_and_REPT.zip 39KB
  331. Exercise Files/186_Sort_by_Moving_Columns.zip 39KB
  332. Exercise Files/254_XMATCH_Function.zip 38KB
  333. Exercise Files/205_Displaying_Large_Values.zip 33KB
  334. 072-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31KB
  335. Exercise Files/181_Avoiding_DIV_Error.zip 30KB
  336. Exercise Files/245_FilterYearDay.zip 28KB
  337. 087-Adjust_banded_row_formatting.srt 28KB
  338. 061-Working_with_formulas_in_tables.srt 28KB
  339. Exercise Files/233_ScenarioManager.zip 27KB
  340. Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27KB
  341. Exercise Files/149_Decimals_and_Fractions.zip 26KB
  342. 105-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25KB
  343. Exercise Files/129_Fill_Effects.zip 25KB
  344. Exercise Files/189_Alt_Key_Shortcuts.zip 25KB
  345. 089-How_and_when_to_use_Excels_10_rounding_functions.srt 24KB
  346. 057-Building_a_flexible_monthly_table_using_functions.srt 24KB
  347. 093-Accelerate_data_entry_with_five_special_techniques.srt 23KB
  348. 014-Adding_illustrations_to_your_workbook.srt 23KB
  349. Exercise Files/242_CopyFormats.zip 23KB
  350. 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 23KB
  351. 123-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 23KB
  352. 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22KB
  353. 048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22KB
  354. 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22KB
  355. Exercise Files/164_Percent_change_and_Goal_Seek.zip 22KB
  356. 112-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22KB
  357. 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 22KB
  358. 159-Create_numeric_formats_Display_in_thousands_or_millions.srt 22KB
  359. 139-Avoiding_common_chart_distortions.srt 21KB
  360. 104-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21KB
  361. 096-How_to_create_time_interval_entries.srt 21KB
  362. 073-Use_special_tricks_for_working_with_dates_in_Charts.srt 21KB
  363. 117-Tips_for_creating_and_updating_sample_data.srt 21KB
  364. Exercise Files/224_CondFormattingBreakpoints.zip 21KB
  365. 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 21KB
  366. 052-Using_Excels_error_checking_functions.srt 20KB
  367. Exercise Files/175_ROMAN_ARABIC.zip 20KB
  368. 116-Displaying_multiple_worksheets_and_workbooks_together.srt 20KB
  369. 138-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt 20KB
  370. 127-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20KB
  371. 068-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 20KB
  372. 084-Use_the_OFFSET_function_for_tabulating_moving_data.srt 20KB
  373. 103-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19KB
  374. 085-Alter_numeric_data_without_formulas.srt 19KB
  375. Exercise Files/179_Date_Proximity_Formatting_final.zip 19KB
  376. 110-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19KB
  377. 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19KB
  378. 086-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19KB
  379. 119-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 19KB
  380. 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 19KB
  381. Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 19KB
  382. Exercise Files/178_Adjusting_Names.zip 19KB
  383. 067-Set_up_a_macro_for_sorting_dynamic_data.srt 19KB
  384. 034-Calculating_with_hours_minutes_and_times_of_day.srt 18KB
  385. 102-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18KB
  386. 099-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18KB
  387. 144-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt 18KB
  388. Exercise Files/203_Mixed_Cell_Addresses.zip 18KB
  389. 142-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt 18KB
  390. 054-Auditing.srt 18KB
  391. 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 18KB
  392. 131-Working_with_multiple_worksheets_simultaneously.srt 18KB
  393. 071-Work_with_formulas_in_tables.srt 18KB
  394. 145-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt 18KB
  395. 101-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 18KB
  396. 080-Use_slicers_and_charts_together_for_dynamic_presentations.srt 18KB
  397. 047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 18KB
  398. 083-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17KB
  399. Exercise Files/210_SmartArt.zip 17KB
  400. 129-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17KB
  401. 050-Create_an_Organization_Chart.srt 17KB
  402. 069-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17KB
  403. Exercise Files/256_Macro_Highlight_Formula_Cells.zip 17KB
  404. 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 17KB
  405. Exercise Files/219_Utility_Macros.zip 17KB
  406. Exercise Files/130_Multiple_Worksheets.zip 17KB
  407. 107-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 17KB
  408. 109-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 17KB
  409. Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16KB
  410. 147-Sorting_tips_and_shortcuts.srt 16KB
  411. 135-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16KB
  412. Exercise Files/209_Borders_Gridlines_Printing.zip 16KB
  413. 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16KB
  414. 043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16KB
  415. 063-Creating_an_Excel_template.srt 16KB
  416. Exercise Files/238_Date_Time_Series.zip 16KB
  417. Exercise Files/251_Find_Highlight_Formula_cells.zip 16KB
  418. 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16KB
  419. 108-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16KB
  420. Exercise Files/213_Shapes_and_Stars.zip 16KB
  421. 059-ADDRESS_ROW_and_COLUMN_functions.srt 16KB
  422. Exercise Files/208_Transpose.zip 16KB
  423. 118-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 16KB
  424. 091-How_to_use_mixed_cell_references.srt 16KB
  425. 055-Adding_comments_and_shapes.srt 16KB
  426. Exercise Files/199_Charts_and_Filters.zip 16KB
  427. 053-Custom_formats_relative_addressing_and_conditional_formatting.srt 16KB
  428. 126-Creating_heat_maps_using_conditional_formatting.srt 16KB
  429. 095-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 16KB
  430. 122-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15KB
  431. 136-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt 15KB
  432. Exercise Files/214_Array_Constants_withVLOOKUP.zip 15KB
  433. 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15KB
  434. 106-Keyboard_shortcuts_for_numeric_formats.srt 15KB
  435. 082-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 15KB
  436. 029-Quick_formatting_tips.srt 15KB
  437. 079-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 15KB
  438. 062-Locating_Data_Validation_rules_and_violations.srt 15KB
  439. 111-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 15KB
  440. 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 15KB
  441. 156-Create_your_own_customized_date_and_time_formats.srt 15KB
  442. 151-Control_gridlines_in_charts_and_on_worksheets.srt 15KB
  443. 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 15KB
  444. 124-Dealing_with_circular_errors.srt 15KB
  445. 172-Create_artistic_charts_with_random_numbers.srt 15KB
  446. 137-Freezing_column_and_row_titles.srt 15KB
  447. Exercise Files/191_Columns_Widths.zip 15KB
  448. 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 15KB
  449. 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14KB
  450. Exercise Files/185_Unintentional_Entries.zip 14KB
  451. 045-Creating_Variable_Conditional_Formatting_Rules.srt 14KB
  452. 017-Dynamically_presenting_data_via_chart_slicers.srt 14KB
  453. 076-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14KB
  454. Exercise Files/232_GrowingChart.zip 14KB
  455. 097-How_to_create_frequency_tabulations_and_distributions.srt 14KB
  456. 150-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt 14KB
  457. 100-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 14KB
  458. 037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 14KB
  459. 153-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt 14KB
  460. 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 14KB
  461. 065-Creating_a_pick_list_dependent_on_another_pick_list.srt 14KB
  462. 075-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 14KB
  463. 064-Restoring_missing_column_titles.srt 14KB
  464. 013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13KB
  465. 154-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt 13KB
  466. 120-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13KB
  467. 090-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13KB
  468. 078-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13KB
  469. 098-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13KB
  470. 148-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt 13KB
  471. Exercise Files/154_Phone_and_ZipCode_Formats.zip 13KB
  472. 114-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13KB
  473. Exercise Files/229_Random_Functions.zip 13KB
  474. 012-Splitting_and_consolidating_workbooks.srt 13KB
  475. 146-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt 13KB
  476. 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 13KB
  477. 074-Use_a_data_form_for_data_entry_and_exploring_data.srt 13KB
  478. 125-Tips_for_creating_charts_quickly.srt 13KB
  479. 134-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 13KB
  480. 121-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 13KB
  481. Exercise Files/227_Special_Characters.zip 13KB
  482. 056-Drawing_borders_and_border_grids.srt 13KB
  483. 088-Change_the_shape_of_comment_boxes_and_other_objects.srt 13KB
  484. 001-Hide_and_unhide_worksheets_securely.srt 12KB
  485. 044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12KB
  486. 077-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12KB
  487. 161-Create_custom_lists_for_letter_series_like_A_to_Z.srt 12KB
  488. 024-Customizing_templates_to_fit_your_unique_needs.srt 12KB
  489. 081-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12KB
  490. 094-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12KB
  491. 010-Applying_conditional_formatting_across_rows_of_data.srt 12KB
  492. 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12KB
  493. 227 - Select from over 800 icons to enliven worksheets.srt 12KB
  494. 152-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt 12KB
  495. 030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 12KB
  496. 023-Highlighting_PivotTable_results_with_conditional_formatting.srt 12KB
  497. 155-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt 12KB
  498. Exercise Files/187_Cumulative_Totals.zip 12KB
  499. 157-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt 12KB
  500. 128-Displaying_tips_when_using_Excel_in_presentations.srt 12KB
  501. 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt 12KB
  502. 141-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt 12KB
  503. 162-Freeze_Panes_and_Split.srt 12KB
  504. 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11KB
  505. 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11KB
  506. 225 - Sort or filter data based on color font or cell color background.srt 11KB
  507. 220 - Calculate loan payments and investments with PMT and FV functions.srt 11KB
  508. 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11KB
  509. 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11KB
  510. 167-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt 11KB
  511. 177-Customize_your_Quick_Access_Toolbar.srt 11KB
  512. 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt 11KB
  513. 046-Handling_Dates_with_unusual_formats.srt 11KB
  514. 168-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt 11KB
  515. 158-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt 11KB
  516. 066-Using_Command_Shortcuts_with_the_Alt_key.srt 11KB
  517. 241 - Change PivotTable settings for titles and summaries.srt 11KB
  518. 190-Keystroke_shortcuts_using_the_Alt_key.srt 11KB
  519. 231 - Use formulas to create interactive charts.srt 11KB
  520. 244 - Use data validation rules with special phone and social security formats.srt 11KB
  521. 171-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt 11KB
  522. 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 11KB
  523. Exercise Files/252_Text_Columns_Flash_Fill.zip 11KB
  524. 149-Work_with_formulas_and_formats_Decimals_and_fractions.srt 11KB
  525. 230 - Insert colorful images with the People Graph Add-in.srt 11KB
  526. 184-Use_date_functions_for_age_and_tenure_calculations.srt 11KB
  527. 170-Identify_or_extract_unique_entries_in_a_list.srt 11KB
  528. 163-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt 11KB
  529. 239 - Use Find and Replace to change cell contents and formats.srt 10KB
  530. 169-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt 10KB
  531. 221 - Use the XLOOKUP function to replace VLOOKUP.srt 10KB
  532. 115-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10KB
  533. 058-Adding_pictures_as_worksheet_backgrounds.srt 10KB
  534. 143-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt 10KB
  535. 243 - Use worksheet names in formulas.srt 10KB
  536. 195-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.srt 10KB
  537. 130-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10KB
  538. 026-Enhancing_table_filtering_with_slicers.srt 10KB
  539. 196-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.srt 10KB
  540. 207-Tracking_down_conditional_formatting_and_data_validation_rules.srt 10KB
  541. 208 - Transposing data and using the TRANSPOSE function.srt 10KB
  542. 248 - Display and highlight worksheet formula cells.srt 10KB
  543. 070-Replace_characters_by_position_with_the_REPLACE_function.srt 10KB
  544. 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10KB
  545. 164-Calculate_%_of_change.srt 10KB
  546. 226 - Simplify the use of special characters and symbols.srt 10KB
  547. 213 - Tabulating totals with the VLOOKUP function and array constants.srt 10KB
  548. 202-How_to_use_the_error_checking_rules_in_Excel.srt 10KB
  549. Exercise Files/236_Dates_in_Charts.zip 10KB
  550. 192-Column_widths_row_heights_merging_cells_and_related_formatting_issues.srt 10KB
  551. 180-Differences_and_limitations_of_converting_data_to_a_table.srt 10KB
  552. Exercise Files/212_CEILINGandFLOOR.zip 10KB
  553. 176-Use_range_names_for_more_readable_formulas.srt 10KB
  554. 205-Rapid_filtering_with_Filter_by_Selection.srt 10KB
  555. 252 - Work with hidden and visible data in filtered and subtotaled lists.srt 10KB
  556. 216 - Creating and updating sample data.srt 10KB
  557. 179-How_to_adjust_names.srt 10KB
  558. 197-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.srt 10KB
  559. 250 - Highlight milestone data with conditional formatting and cumulative formulas.srt 10KB
  560. 173-Extract_day_month_and_year_from_date_fields.srt 10KB
  561. 247 - Look forward and backward using EDATE and other date functions.srt 10KB
  562. Exercise Files/253_Cumulative_Formulas.zip 10KB
  563. 198-Helpful_keystroke_shortcuts.srt 10KB
  564. 218 - Use the new SORT and SORTBY functions to extract sorted lists.srt 10KB
  565. 235 - Overcoming obstacles when working with dates in charts.srt 10KB
  566. 092-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 10KB
  567. 174-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt 10KB
  568. 204-Use_mixed_addresses_in_Excel_formulas.srt 10KB
  569. Exercise Files/188_CONVERT_Function.zip 10KB
  570. 181-Avoid_the_#DIV_0_error_message.srt 9KB
  571. 022-Increasing_your_productivity_with_custom_lists.srt 9KB
  572. 224 - Discover new formula capabilities with new functions and dynamic arrays.srt 9KB
  573. 211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt 9KB
  574. 240 - Add formula tools and symbols to the Quick Access Toolbar.srt 9KB
  575. 178-Conditional_formatting_based_on_date_proximity.srt 9KB
  576. 200-Use_chart_and_filter_for_presentations.srt 9KB
  577. 217 - Format macros to make you a more efficient Excel user.srt 9KB
  578. Exercise Files/247_Phone_ZipFormats.zip 9KB
  579. Exercise Files/222_Financial_Functions.zip 9KB
  580. 233 - Get totals quickly without creating formulas.srt 9KB
  581. 209 - Displaying gridlines, borders, and column_row headings when printing.srt 9KB
  582. 237 - Techniques for creating date series.srt 9KB
  583. Exercise Files/190_Solver.zip 9KB
  584. 027-Converting_charts_into_pictures.srt 9KB
  585. 133-Using_WordArt_for_special_titles_and_headings.srt 9KB
  586. 113-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 9KB
  587. 028-Custom_grouping_in_PivotTables.srt 9KB
  588. Exercise Files/230_Area_Charts.zip 9KB
  589. 242 - Use the Excel filtering capability for dates.srt 9KB
  590. 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt 9KB
  591. 249 - Split or join columnar data with Text to Columns or Flash Fill.srt 9KB
  592. 245 - Work with time calculations in formulas.srt 9KB
  593. 140-Use_the_new_Funnel_chart_available_in_Excel_365.srt 8KB
  594. 011-Exploring_various_layouts_for_your_PivotTable.srt 8KB
  595. 201-Create_picture_links.srt 8KB
  596. 165-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt 8KB
  597. 229 - How and when to use an area chart.srt 8KB
  598. 236 - Create map-type charts based on geographical locations.srt 8KB
  599. 246 - Prevent and locate duplicate worksheet entries.srt 8KB
  600. 188-Using_the_CONVERT_function_for_different_numbering_systems.srt 8KB
  601. 253 - Create a powerful macro.srt 8KB
  602. Exercise Files/237_Geographic_Maps.zip 8KB
  603. 238 - Extract filtered data with data validation and the FILTER function.srt 8KB
  604. 185-Avoid_unintentional_entries_when_typing_code_numbers.srt 8KB
  605. 182-Explore_formatting_options_not_available_on_the_Home_tab.srt 8KB
  606. 160-Converting_dates_like_20102006_into_usable_date_entries.srt 8KB
  607. 189-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.srt 8KB
  608. 232 - Track variables using the Scenario Manager.srt 8KB
  609. 194-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.srt 8KB
  610. 175-How_to_covert_ROMAN_numberals.srt 8KB
  611. 214 - Working with array formulas more easily.srt 8KB
  612. 234 - Use column or row references to create dynamic formulas.srt 8KB
  613. 186-Sorting_by_moving_columns.srt 8KB
  614. 166-Use_the_COUNT_and_COUNTA_functions.srt 8KB
  615. 193-Adjusting_default_layouts_and_date_grouping_in_PivotTables.srt 8KB
  616. 203-Protect_worksheets_and_lock_cells.srt 8KB
  617. 191-Using_the_Solver_Add-in.srt 8KB
  618. 222 - Chart display options with blank cells in source data.srt 8KB
  619. 187-Calculating_cumulative_totals.srt 8KB
  620. 132-Exploring_font_choices_not_found_on_the_Home_tab.srt 7KB
  621. 219 - Use themes to adjust worksheet colors, fonts, and effects.srt 7KB
  622. 210 - Exploring some of the 200-plus SmartArt graphic options.srt 7KB
  623. 199-Identify_weekdays_and_weekend_days_in_data.srt 7KB
  624. 206-Display_large_values.srt 7KB
  625. 018-Parsing_your_data_to_create_unique_lists.srt 7KB
  626. Exercise Files/189_Chart_based_on_a_Table.zip 7KB
  627. 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6KB
  628. 183-Control_table_formatting_with_custom_formats.srt 6KB
  629. 215 - Using the new UNIQUE function to count and copy unique list entries.srt 6KB
  630. 251 - Use the XMATCH function to replace MATCH.srt 6KB
  631. 019-Using_the_REPT_function_to_represent_data_visually.srt 6KB