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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：5289fe9f40c0b0f68433bcdfdd932089d933b1f5
文件大小： 5.36G
已经下载：703次
下载速度：极快
收录时间：2020-04-18
最近下载：2025-07-22

地址随时变，回家记住路

小野猫.com黑猫警长.com哆啦a猫.com御猫.com科目三.com猫哭老鼠.com女猫.com☜☜☜找最新地址请保存左面网址

磁力链接

magnet:?xt=urn:btih:5289FE9F40C0B0F68433BCDFDD932089D933B1F5
推荐使用PIKPAK网盘下载资源，PIKPAK是目前最好用网盘，10T超大空间，不和谐任何资源，支持无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 在线观看 世界之窗 含羞草 极乐禁地 91视频 51品茶 逼哩逼哩 萝莉岛 欲漫涩 91短视频 成人快手 抖阴破解版 ai色色 pilipili 草榴社区 哆哔涩漫 好色先生 疯马秀 TikTok成人版 悠悠禁区 波多 听泉鉴鲍 xvideo 外网天堂 PornHub 抖音Max 呦乐园 拔萝卜 糖心视频 麻豆Vlog 暗网Xvideo

资源截图

API Integration

最近搜索

文件列表

  • 087-Adjust_banded_row_formatting.mp4 60.6 MB
  • 072-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 57.7 MB
  • 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 53.1 MB
  • 061-Working_with_formulas_in_tables.mp4 50.5 MB
  • 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 50.0 MB
  • 137-Freezing_column_and_row_titles.mp4 43.9 MB
  • 107-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 43.4 MB
  • 112-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4 42.9 MB
  • 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 42.4 MB
  • 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 42.0 MB
  • 048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 41.1 MB
  • 105-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 40.9 MB
  • 047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 40.0 MB
  • 085-Alter_numeric_data_without_formulas.mp4 39.2 MB
  • 098-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 38.5 MB
  • 101-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 37.7 MB
  • 159-Create_numeric_formats_Display_in_thousands_or_millions.mp4 37.5 MB
  • 099-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 37.4 MB
  • 089-How_and_when_to_use_Excels_10_rounding_functions.mp4 37.1 MB
  • 123-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4 36.7 MB
  • 126-Creating_heat_maps_using_conditional_formatting.mp4 36.6 MB
  • 086-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 36.0 MB
  • 052-Using_Excels_error_checking_functions.mp4 35.3 MB
  • 014-Adding_illustrations_to_your_workbook.mp4 35.3 MB
  • 073-Use_special_tricks_for_working_with_dates_in_Charts.mp4 34.8 MB
  • 057-Building_a_flexible_monthly_table_using_functions.mp4 34.4 MB
  • 139-Avoiding_common_chart_distortions.mp4 34.3 MB
  • 147-Sorting_tips_and_shortcuts.mp4 34.0 MB
  • 116-Displaying_multiple_worksheets_and_workbooks_together.mp4 34.0 MB
  • 096-How_to_create_time_interval_entries.mp4 34.0 MB
  • 117-Tips_for_creating_and_updating_sample_data.mp4 33.2 MB
  • 093-Accelerate_data_entry_with_five_special_techniques.mp4 33.1 MB
  • 084-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 32.3 MB
  • 045-Creating_Variable_Conditional_Formatting_Rules.mp4 32.3 MB
  • 054-Auditing.mp4 32.1 MB
  • 129-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4 31.8 MB
  • 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 31.8 MB
  • 162-Freeze_Panes_and_Split.mp4 31.7 MB
  • 136-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4 31.6 MB
  • 102-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 31.5 MB
  • 071-Work_with_formulas_in_tables.mp4 31.5 MB
  • 119-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4 31.3 MB
  • 104-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 31.3 MB
  • 110-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 31.3 MB
  • 103-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 31.2 MB
  • 095-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 31.1 MB
  • 034-Calculating_with_hours_minutes_and_times_of_day.mp4 31.1 MB
  • 128-Displaying_tips_when_using_Excel_in_presentations.mp4 31.1 MB
  • 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 30.9 MB
  • 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 30.8 MB
  • 111-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 30.8 MB
  • 080-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 30.5 MB
  • 068-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 30.2 MB
  • 161-Create_custom_lists_for_letter_series_like_A_to_Z.mp4 30.1 MB
  • 062-Locating_Data_Validation_rules_and_violations.mp4 29.9 MB
  • 127-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4 29.8 MB
  • 067-Set_up_a_macro_for_sorting_dynamic_data.mp4 29.5 MB
  • 142-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4 29.4 MB
  • 043-Exploring_what_if_scenarios_using_Goal_Seek.mp4 29.4 MB
  • 144-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4 29.4 MB
  • 145-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4 29.3 MB
  • 150-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4 29.2 MB
  • 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 29.2 MB
  • 079-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 29.1 MB
  • 059-ADDRESS_ROW_and_COLUMN_functions.mp4 29.0 MB
  • 171-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp4 28.4 MB
  • 064-Restoring_missing_column_titles.mp4 27.6 MB
  • 069-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 27.6 MB
  • 131-Working_with_multiple_worksheets_simultaneously.mp4 27.3 MB
  • 083-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 27.2 MB
  • 106-Keyboard_shortcuts_for_numeric_formats.mp4 27.1 MB
  • 030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 26.9 MB
  • 138-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4 26.8 MB
  • 055-Adding_comments_and_shapes.mp4 26.7 MB
  • 135-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4 26.3 MB
  • 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 26.3 MB
  • 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 26.2 MB
  • 097-How_to_create_frequency_tabulations_and_distributions.mp4 26.1 MB
  • 074-Use_a_data_form_for_data_entry_and_exploring_data.mp4 26.1 MB
  • 108-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 25.8 MB
  • 109-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 25.5 MB
  • 122-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4 25.5 MB
  • 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 25.4 MB
  • 118-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4 25.3 MB
  • 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 25.3 MB
  • 053-Custom_formats_relative_addressing_and_conditional_formatting.mp4 25.1 MB
  • 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 24.9 MB
  • 225 - Sort or filter data based on color font or cell color background.mp4 24.9 MB
  • 050-Create_an_Organization_Chart.mp4 24.8 MB
  • 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 24.7 MB
  • 120-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4 24.6 MB
  • 091-How_to_use_mixed_cell_references.mp4 24.6 MB
  • 029-Quick_formatting_tips.mp4 24.5 MB
  • 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 24.4 MB
  • 013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 24.3 MB
  • 063-Creating_an_Excel_template.mp4 24.3 MB
  • 134-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4 23.9 MB
  • 172-Create_artistic_charts_with_random_numbers.mp4 23.8 MB
  • 082-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 23.8 MB
  • 170-Identify_or_extract_unique_entries_in_a_list.mp4 23.8 MB
  • 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 23.7 MB
  • 156-Create_your_own_customized_date_and_time_formats.mp4 23.6 MB
  • 158-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4 23.6 MB
  • 124-Dealing_with_circular_errors.mp4 23.5 MB
  • 076-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 23.2 MB
  • 153-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4 23.0 MB
  • 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 22.9 MB
  • 239 - Use Find and Replace to change cell contents and formats.mp4 22.8 MB
  • 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 22.8 MB
  • 151-Control_gridlines_in_charts_and_on_worksheets.mp4 22.7 MB
  • 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 22.7 MB
  • 252 - Work with hidden and visible data in filtered and subtotaled lists.mp4 22.6 MB
  • 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 22.5 MB
  • 056-Drawing_borders_and_border_grids.mp4 22.4 MB
  • 198-Helpful_keystroke_shortcuts.mp4 22.3 MB
  • 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 22.2 MB
  • 022-Increasing_your_productivity_with_custom_lists.mp4 21.9 MB
  • 078-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 21.8 MB
  • 012-Splitting_and_consolidating_workbooks.mp4 21.5 MB
  • 010-Applying_conditional_formatting_across_rows_of_data.mp4 21.4 MB
  • 017-Dynamically_presenting_data_via_chart_slicers.mp4 21.4 MB
  • 024-Customizing_templates_to_fit_your_unique_needs.mp4 21.4 MB
  • 177-Customize_your_Quick_Access_Toolbar.mp4 21.3 MB
  • 046-Handling_Dates_with_unusual_formats.mp4 21.2 MB
  • 121-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4 21.2 MB
  • 066-Using_Command_Shortcuts_with_the_Alt_key.mp4 21.2 MB
  • 026-Enhancing_table_filtering_with_slicers.mp4 21.2 MB
  • 152-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4 21.1 MB
  • 058-Adding_pictures_as_worksheet_backgrounds.mp4 21.0 MB
  • 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 20.9 MB
  • 075-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 20.6 MB
  • 037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 20.2 MB
  • 088-Change_the_shape_of_comment_boxes_and_other_objects.mp4 20.2 MB
  • 125-Tips_for_creating_charts_quickly.mp4 20.2 MB
  • 201-Create_picture_links.mp4 20.2 MB
  • 023-Highlighting_PivotTable_results_with_conditional_formatting.mp4 20.2 MB
  • 077-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 20.1 MB
  • 155-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4 20.1 MB
  • 114-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 20.0 MB
  • 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 19.9 MB
  • 207-Tracking_down_conditional_formatting_and_data_validation_rules.mp4 19.9 MB
  • 090-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 19.8 MB
  • 065-Creating_a_pick_list_dependent_on_another_pick_list.mp4 19.8 MB
  • 169-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp4 19.7 MB
  • 157-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4 19.7 MB
  • 180-Differences_and_limitations_of_converting_data_to_a_table.mp4 19.7 MB
  • 154-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4 19.6 MB
  • 146-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4 19.4 MB
  • 081-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 19.3 MB
  • 167-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4 18.9 MB
  • 148-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4 18.9 MB
  • 044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 18.8 MB
  • 218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 18.6 MB
  • 143-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4 18.5 MB
  • 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 18.4 MB
  • 115-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 18.2 MB
  • 206-Display_large_values.mp4 18.1 MB
  • 203-Protect_worksheets_and_lock_cells.mp4 18.1 MB
  • 130-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17.9 MB
  • 001-Hide_and_unhide_worksheets_securely.mp4 17.8 MB
  • 094-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 17.8 MB
  • 233 - Get totals quickly without creating formulas.mp4 17.6 MB
  • 241 - Change PivotTable settings for titles and summaries.mp4 17.6 MB
  • 165-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4 17.4 MB
  • 100-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 17.3 MB
  • 240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 17.3 MB
  • 227 - Select from over 800 icons to enliven worksheets.mp4 17.3 MB
  • 184-Use_date_functions_for_age_and_tenure_calculations.mp4 17.2 MB
  • 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 17.2 MB
  • 232 - Track variables using the Scenario Manager.mp4 17.1 MB
  • 179-How_to_adjust_names.mp4 17.0 MB
  • 168-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4 16.9 MB
  • 027-Converting_charts_into_pictures.mp4 16.7 MB
  • 247 - Look forward and backward using EDATE and other date functions.mp4 16.6 MB
  • 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 16.5 MB
  • 216 - Creating and updating sample data.mp4 16.5 MB
  • 070-Replace_characters_by_position_with_the_REPLACE_function.mp4 16.3 MB
  • 182-Explore_formatting_options_not_available_on_the_Home_tab.mp4 16.3 MB
  • 176-Use_range_names_for_more_readable_formulas.mp4 16.3 MB
  • 186-Sorting_by_moving_columns.mp4 16.1 MB
  • 141-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4 16.0 MB
  • 248 - Display and highlight worksheet formula cells.mp4 16.0 MB
  • 221 - Use the XLOOKUP function to replace VLOOKUP.mp4 15.7 MB
  • 230 - Insert colorful images with the People Graph Add-in.mp4 15.6 MB
  • 163-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4 15.5 MB
  • 092-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 15.4 MB
  • 190-Keystroke_shortcuts_using_the_Alt_key.mp4 15.4 MB
  • 133-Using_WordArt_for_special_titles_and_headings.mp4 15.3 MB
  • 018-Parsing_your_data_to_create_unique_lists.mp4 15.2 MB
  • 217 - Format macros to make you a more efficient Excel user.mp4 15.2 MB
  • 164-Calculate_%_of_change.mp4 14.7 MB
  • 238 - Extract filtered data with data validation and the FILTER function.mp4 14.6 MB
  • 166-Use_the_COUNT_and_COUNTA_functions.mp4 14.6 MB
  • 011-Exploring_various_layouts_for_your_PivotTable.mp4 14.5 MB
  • 253 - Create a powerful macro.mp4 14.5 MB
  • 246 - Prevent and locate duplicate worksheet entries.mp4 14.5 MB
  • 181-Avoid_the_#DIV_0_error_message.mp4 14.4 MB
  • 178-Conditional_formatting_based_on_date_proximity.mp4 14.4 MB
  • 224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 14.3 MB
  • 202-How_to_use_the_error_checking_rules_in_Excel.mp4 14.3 MB
  • 149-Work_with_formulas_and_formats_Decimals_and_fractions.mp4 14.2 MB
  • 213 - Tabulating totals with the VLOOKUP function and array constants.mp4 14.2 MB
  • 209 - Displaying gridlines, borders, and column_row headings when printing.mp4 14.1 MB
  • 208 - Transposing data and using the TRANSPOSE function.mp4 14.1 MB
  • 175-How_to_covert_ROMAN_numberals.mp4 13.9 MB
  • 234 - Use column or row references to create dynamic formulas.mp4 13.9 MB
  • 174-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4 13.8 MB
  • 249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 13.8 MB
  • 173-Extract_day_month_and_year_from_date_fields.mp4 13.8 MB
  • 242 - Use the Excel filtering capability for dates.mp4 13.7 MB
  • 028-Custom_grouping_in_PivotTables.mp4 13.6 MB
  • 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 13.6 MB
  • 244 - Use data validation rules with special phone and social security formats.mp4 13.6 MB
  • 188-Using_the_CONVERT_function_for_different_numbering_systems.mp4 13.5 MB
  • 250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 13.3 MB
  • 197-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.mp4 13.3 MB
  • 204-Use_mixed_addresses_in_Excel_formulas.mp4 13.3 MB
  • 205-Rapid_filtering_with_Filter_by_Selection.mp4 13.3 MB
  • 220 - Calculate loan payments and investments with PMT and FV functions.mp4 13.0 MB
  • 183-Control_table_formatting_with_custom_formats.mp4 12.8 MB
  • 235 - Overcoming obstacles when working with dates in charts.mp4 12.7 MB
  • 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 12.7 MB
  • 199-Identify_weekdays_and_weekend_days_in_data.mp4 12.6 MB
  • 196-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.mp4 12.6 MB
  • 160-Converting_dates_like_20102006_into_usable_date_entries.mp4 12.6 MB
  • 243 - Use worksheet names in formulas.mp4 12.5 MB
  • 211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 12.4 MB
  • 191-Using_the_Solver_Add-in.mp4 12.3 MB
  • 132-Exploring_font_choices_not_found_on_the_Home_tab.mp4 12.2 MB
  • 226 - Simplify the use of special characters and symbols.mp4 12.0 MB
  • 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 12.0 MB
  • 113-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 12.0 MB
  • 245 - Work with time calculations in formulas.mp4 12.0 MB
  • 193-Adjusting_default_layouts_and_date_grouping_in_PivotTables.mp4 12.0 MB
  • 219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 11.9 MB
  • 189-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.mp4 11.8 MB
  • 231 - Use formulas to create interactive charts.mp4 11.8 MB
  • 187-Calculating_cumulative_totals.mp4 11.8 MB
  • 229 - How and when to use an area chart.mp4 11.6 MB
  • 214 - Working with array formulas more easily.mp4 11.6 MB
  • 192-Column_widths_row_heights_merging_cells_and_related_formatting_issues.mp4 11.5 MB
  • 237 - Techniques for creating date series.mp4 11.3 MB
  • 140-Use_the_new_Funnel_chart_available_in_Excel_365.mp4 11.1 MB
  • 195-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.mp4 11.1 MB
  • 215 - Using the new UNIQUE function to count and copy unique list entries.mp4 10.7 MB
  • 222 - Chart display options with blank cells in source data.mp4 10.6 MB
  • 194-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.mp4 10.4 MB
  • 185-Avoid_unintentional_entries_when_typing_code_numbers.mp4 10.0 MB
  • 200-Use_chart_and_filter_for_presentations.mp4 10.0 MB
  • 236 - Create map-type charts based on geographical locations.mp4 9.9 MB
  • 251 - Use the XMATCH function to replace MATCH.mp4 9.9 MB
  • 210 - Exploring some of the 200-plus SmartArt graphic options.mp4 9.5 MB
  • 019-Using_the_REPT_function_to_represent_data_visually.mp4 9.3 MB
  • Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip 1.6 MB
  • Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip 1.5 MB
  • Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip 1.1 MB
  • Exercise Files/124_Quick_Charts.zip 882.9 kB
  • Exercise Files/133_Weekday_Weekend.zip 524.8 kB
  • Exercise Files/126_INDEX_Function.zip 503.7 kB
  • Exercise Files/123_Book1.zip 471.0 kB
  • Exercise Files/135_Borders_Gridlines.zip 448.7 kB
  • Exercise Files/132_WordArt_Variations.zip 436.7 kB
  • Exercise Files/211_GoTo_Special.zip 416.1 kB
  • Exercise Files/131_Other_Font_Options.zip 376.1 kB
  • Exercise Files/134_Two_Way_Lookups.zip 369.2 kB
  • Exercise Files/215_AdvancedFilter.zip 353.2 kB
  • Exercise Files/127_Display_Tips.zip 342.5 kB
  • Exercise Files/223_BlankCellsInCharts.zip 341.0 kB
  • Exercise Files/201_Error_Checking_Indicators.zip 323.2 kB
  • Exercise Files/197_Helpful_Keystroke_Shortcuts.zip 313.2 kB
  • Exercise Files/171_Zoom_and_Display_Variations.zip 264.9 kB
  • Exercise Files/198_Weekdays_and_Weekends.zip 254.3 kB
  • Exercise Files/182_FormattingOptions.zip 243.4 kB
  • Exercise Files/180_Table_Differences.zip 242.4 kB
  • Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 231.5 kB
  • Exercise Files/167_Excel_Sheet_Commands.zip 224.2 kB
  • Exercise Files/170_Unique_and_Duplicate_Data.zip 216.0 kB
  • Exercise Files/157_Comments_and_Reminders.zip 187.8 kB
  • Exercise Files/243_XLOOKUP_Function.zip 169.0 kB
  • Exercise Files/176_Range_Names.zip 168.8 kB
  • Exercise Files/240_Find_Select.zip 161.5 kB
  • Exercise Files/158_Replace_Format_or_Content.zip 158.4 kB
  • Exercise Files/165_Fill_in_Blanks.zip 156.3 kB
  • Exercise Files/169_PivotTable_Date_Grouping.zip 154.3 kB
  • Exercise Files/196_Double_and_Triple_Spaced_Printing.zip 150.3 kB
  • Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 147.5 kB
  • Exercise Files/160_Date_Format_Conversions.zip 136.9 kB
  • Exercise Files/250_EDate_EMonth_DatedIF.zip 132.3 kB
  • Exercise Files/184_Date_Calculations.zip 131.5 kB
  • Exercise Files/216_ArrayFormulaUpdates.zip 131.1 kB
  • Exercise Files/153_Expand_Collapse_PivotTables.zip 126.4 kB
  • Exercise Files/183_New_Table_Style.zip 126.3 kB
  • Exercise Files/156_Date_Time_Formats.zip 123.3 kB
  • Exercise Files/161_Custom_Lists.zip 120.9 kB
  • Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 117.8 kB
  • Exercise Files/207_CheckBox_ConditionalFormatting.zip 109.8 kB
  • Exercise Files/206_ConditionalFormatting_and_DataValidation.zip 109.7 kB
  • Exercise Files/194_Watch_Window.zip 107.9 kB
  • Exercise Files/255_Hidden_Visible_Data.zip 87.2 kB
  • Exercise Files/249_Prevent_Locate_Duplicates.zip 79.4 kB
  • Exercise Files/195_TRIM_and_CLEAN.zip 76.9 kB
  • Exercise Files/246_Sheet_Names.zip 75.8 kB
  • Exercise Files/226_Sort_by_Color.zip 75.6 kB
  • Exercise Files/204_Filter_by_Selection.zip 75.1 kB
  • Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 74.8 kB
  • Exercise Files/239_Data_Validation_and_Filter.zip 72.1 kB
  • Exercise Files/192_PivotTable_Settings.zip 69.0 kB
  • Exercise Files/200_Linking_Pictures.zip 67.8 kB
  • Exercise Files/234_Status_Bar.zip 66.8 kB
  • Exercise Files/150_Mixed_References.zip 66.8 kB
  • Exercise Files/151_Chart_gridlines_and_borders.zip 66.1 kB
  • Exercise Files/220_SORT_and_SORTBY_Functions.zip 64.1 kB
  • Exercise Files/128_Wrap_text_Merge_Indent.zip 61.6 kB
  • Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 61.3 kB
  • Exercise Files/235_Columns_and_Rows.zip 61.3 kB
  • Exercise Files/231_People_Graph.zip 60.9 kB
  • Exercise Files/168_Ranking_Data.zip 59.3 kB
  • Exercise Files/241_AverageCountSubscript.zip 58.6 kB
  • Exercise Files/202_Worksheet_Protection.zip 56.9 kB
  • Exercise Files/218_Sample_Data.zip 52.5 kB
  • Exercise Files/125_Heat_Maps.zip 52.4 kB
  • Exercise Files/248_Time_Math.zip 49.4 kB
  • Exercise Files/244_PivotTable_Settings.zip 47.5 kB
  • Exercise Files/225_New_Formulas.zip 46.2 kB
  • Exercise Files/228_Icons.zip 43.4 kB
  • Exercise Files/217_UNIQUE_function.zip 42.2 kB
  • Exercise Files/159_Number_Formats.zip 42.1 kB
  • Exercise Files/221_Themes.zip 40.9 kB
  • Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 40.8 kB
  • Exercise Files/194_LEN_and_REPT.zip 40.1 kB
  • Exercise Files/186_Sort_by_Moving_Columns.zip 39.7 kB
  • Exercise Files/254_XMATCH_Function.zip 39.2 kB
  • Exercise Files/205_Displaying_Large_Values.zip 33.6 kB
  • 072-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 32.0 kB
  • Exercise Files/181_Avoiding_DIV_Error.zip 30.3 kB
  • Exercise Files/245_FilterYearDay.zip 29.0 kB
  • 087-Adjust_banded_row_formatting.srt 28.8 kB
  • 061-Working_with_formulas_in_tables.srt 28.6 kB
  • Exercise Files/233_ScenarioManager.zip 27.9 kB
  • Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27.8 kB
  • Exercise Files/149_Decimals_and_Fractions.zip 27.1 kB
  • 105-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25.7 kB
  • Exercise Files/129_Fill_Effects.zip 25.3 kB
  • Exercise Files/189_Alt_Key_Shortcuts.zip 25.2 kB
  • 089-How_and_when_to_use_Excels_10_rounding_functions.srt 24.8 kB
  • 057-Building_a_flexible_monthly_table_using_functions.srt 24.2 kB
  • 093-Accelerate_data_entry_with_five_special_techniques.srt 23.8 kB
  • 014-Adding_illustrations_to_your_workbook.srt 23.5 kB
  • Exercise Files/242_CopyFormats.zip 23.4 kB
  • 007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 23.4 kB
  • 123-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 23.1 kB
  • 016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 23.0 kB
  • 048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 23.0 kB
  • 049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22.8 kB
  • Exercise Files/164_Percent_change_and_Goal_Seek.zip 22.7 kB
  • 112-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22.6 kB
  • 051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 22.4 kB
  • 159-Create_numeric_formats_Display_in_thousands_or_millions.srt 22.2 kB
  • 139-Avoiding_common_chart_distortions.srt 22.0 kB
  • 104-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21.9 kB
  • 096-How_to_create_time_interval_entries.srt 21.8 kB
  • 073-Use_special_tricks_for_working_with_dates_in_Charts.srt 21.5 kB
  • 117-Tips_for_creating_and_updating_sample_data.srt 21.4 kB
  • Exercise Files/224_CondFormattingBreakpoints.zip 21.2 kB
  • 036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 21.1 kB
  • 052-Using_Excels_error_checking_functions.srt 20.9 kB
  • Exercise Files/175_ROMAN_ARABIC.zip 20.8 kB
  • 116-Displaying_multiple_worksheets_and_workbooks_together.srt 20.6 kB
  • 138-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt 20.5 kB
  • 127-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20.5 kB
  • 068-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 20.4 kB
  • 084-Use_the_OFFSET_function_for_tabulating_moving_data.srt 20.2 kB
  • 103-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19.7 kB
  • 085-Alter_numeric_data_without_formulas.srt 19.6 kB
  • Exercise Files/179_Date_Proximity_Formatting_final.zip 19.5 kB
  • 110-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19.5 kB
  • 002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19.5 kB
  • 086-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19.5 kB
  • 119-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 19.2 kB
  • 032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 19.1 kB
  • Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 19.1 kB
  • Exercise Files/178_Adjusting_Names.zip 19.1 kB
  • 067-Set_up_a_macro_for_sorting_dynamic_data.srt 19.1 kB
  • 034-Calculating_with_hours_minutes_and_times_of_day.srt 18.9 kB
  • 102-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18.8 kB
  • 099-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18.8 kB
  • 144-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt 18.8 kB
  • Exercise Files/203_Mixed_Cell_Addresses.zip 18.7 kB
  • 142-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt 18.5 kB
  • 054-Auditing.srt 18.5 kB
  • 006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 18.4 kB
  • 131-Working_with_multiple_worksheets_simultaneously.srt 18.4 kB
  • 071-Work_with_formulas_in_tables.srt 18.2 kB
  • 145-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt 18.1 kB
  • 101-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 18.1 kB
  • 080-Use_slicers_and_charts_together_for_dynamic_presentations.srt 18.0 kB
  • 047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 17.9 kB
  • 083-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17.9 kB
  • Exercise Files/210_SmartArt.zip 17.8 kB
  • 129-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17.7 kB
  • 050-Create_an_Organization_Chart.srt 17.6 kB
  • 069-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17.5 kB
  • Exercise Files/256_Macro_Highlight_Formula_Cells.zip 17.4 kB
  • 009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 17.3 kB
  • Exercise Files/219_Utility_Macros.zip 17.2 kB
  • Exercise Files/130_Multiple_Worksheets.zip 17.2 kB
  • 107-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 17.2 kB
  • 109-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 17.2 kB
  • Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16.9 kB
  • 147-Sorting_tips_and_shortcuts.srt 16.8 kB
  • 135-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16.8 kB
  • Exercise Files/209_Borders_Gridlines_Printing.zip 16.7 kB
  • 008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16.7 kB
  • 043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16.6 kB
  • 063-Creating_an_Excel_template.srt 16.6 kB
  • Exercise Files/238_Date_Time_Series.zip 16.6 kB
  • Exercise Files/251_Find_Highlight_Formula_cells.zip 16.5 kB
  • 015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16.5 kB
  • 108-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16.5 kB
  • Exercise Files/213_Shapes_and_Stars.zip 16.4 kB
  • 059-ADDRESS_ROW_and_COLUMN_functions.srt 16.4 kB
  • Exercise Files/208_Transpose.zip 16.3 kB
  • 118-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 16.3 kB
  • 091-How_to_use_mixed_cell_references.srt 16.2 kB
  • 055-Adding_comments_and_shapes.srt 16.1 kB
  • Exercise Files/199_Charts_and_Filters.zip 16.0 kB
  • 053-Custom_formats_relative_addressing_and_conditional_formatting.srt 16.0 kB
  • 126-Creating_heat_maps_using_conditional_formatting.srt 15.9 kB
  • 095-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 15.9 kB
  • 122-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15.8 kB
  • 136-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt 15.7 kB
  • Exercise Files/214_Array_Constants_withVLOOKUP.zip 15.6 kB
  • 021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15.5 kB
  • 106-Keyboard_shortcuts_for_numeric_formats.srt 15.4 kB
  • 082-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 15.3 kB
  • 029-Quick_formatting_tips.srt 15.3 kB
  • 079-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 15.2 kB
  • 062-Locating_Data_Validation_rules_and_violations.srt 15.2 kB
  • 111-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 15.1 kB
  • 005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 15.1 kB
  • 156-Create_your_own_customized_date_and_time_formats.srt 15.0 kB
  • 151-Control_gridlines_in_charts_and_on_worksheets.srt 15.0 kB
  • 020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 14.9 kB
  • 124-Dealing_with_circular_errors.srt 14.9 kB
  • 172-Create_artistic_charts_with_random_numbers.srt 14.9 kB
  • 137-Freezing_column_and_row_titles.srt 14.9 kB
  • Exercise Files/191_Columns_Widths.zip 14.9 kB
  • 003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 14.9 kB
  • 042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14.8 kB
  • Exercise Files/185_Unintentional_Entries.zip 14.8 kB
  • 045-Creating_Variable_Conditional_Formatting_Rules.srt 14.8 kB
  • 017-Dynamically_presenting_data_via_chart_slicers.srt 14.8 kB
  • 076-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14.7 kB
  • Exercise Files/232_GrowingChart.zip 14.5 kB
  • 097-How_to_create_frequency_tabulations_and_distributions.srt 14.3 kB
  • 150-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt 14.3 kB
  • 100-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 14.2 kB
  • 037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 14.2 kB
  • 153-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt 14.1 kB
  • 040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 14.0 kB
  • 065-Creating_a_pick_list_dependent_on_another_pick_list.srt 13.9 kB
  • 075-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 13.9 kB
  • 064-Restoring_missing_column_titles.srt 13.9 kB
  • 013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13.7 kB
  • 154-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt 13.7 kB
  • 120-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13.7 kB
  • 090-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13.6 kB
  • 078-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13.6 kB
  • 098-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13.6 kB
  • 148-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt 13.4 kB
  • Exercise Files/154_Phone_and_ZipCode_Formats.zip 13.4 kB
  • 114-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13.3 kB
  • Exercise Files/229_Random_Functions.zip 13.3 kB
  • 012-Splitting_and_consolidating_workbooks.srt 13.3 kB
  • 146-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt 13.3 kB
  • 041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 13.3 kB
  • 074-Use_a_data_form_for_data_entry_and_exploring_data.srt 13.3 kB
  • 125-Tips_for_creating_charts_quickly.srt 13.3 kB
  • 134-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 13.2 kB
  • 121-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 13.2 kB
  • Exercise Files/227_Special_Characters.zip 13.2 kB
  • 056-Drawing_borders_and_border_grids.srt 12.9 kB
  • 088-Change_the_shape_of_comment_boxes_and_other_objects.srt 12.8 kB
  • 001-Hide_and_unhide_worksheets_securely.srt 12.8 kB
  • 044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12.7 kB
  • 077-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12.7 kB
  • 161-Create_custom_lists_for_letter_series_like_A_to_Z.srt 12.6 kB
  • 024-Customizing_templates_to_fit_your_unique_needs.srt 12.6 kB
  • 081-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12.6 kB
  • 094-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12.5 kB
  • 010-Applying_conditional_formatting_across_rows_of_data.srt 12.5 kB
  • 033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12.4 kB
  • 227 - Select from over 800 icons to enliven worksheets.srt 12.2 kB
  • 152-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt 12.2 kB
  • 030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 12.0 kB
  • 023-Highlighting_PivotTable_results_with_conditional_formatting.srt 12.0 kB
  • 155-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt 11.9 kB
  • Exercise Files/187_Cumulative_Totals.zip 11.9 kB
  • 157-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt 11.9 kB
  • 128-Displaying_tips_when_using_Excel_in_presentations.srt 11.9 kB
  • 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt 11.8 kB
  • 141-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt 11.8 kB
  • 162-Freeze_Panes_and_Split.srt 11.8 kB
  • 060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11.8 kB
  • 039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11.6 kB
  • 225 - Sort or filter data based on color font or cell color background.srt 11.6 kB
  • 220 - Calculate loan payments and investments with PMT and FV functions.srt 11.5 kB
  • 038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11.5 kB
  • 035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11.5 kB
  • 167-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt 11.4 kB
  • 177-Customize_your_Quick_Access_Toolbar.srt 11.4 kB
  • 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt 11.4 kB
  • 046-Handling_Dates_with_unusual_formats.srt 11.2 kB
  • 168-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt 11.2 kB
  • 158-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt 11.2 kB
  • 066-Using_Command_Shortcuts_with_the_Alt_key.srt 11.2 kB
  • 241 - Change PivotTable settings for titles and summaries.srt 11.2 kB
  • 190-Keystroke_shortcuts_using_the_Alt_key.srt 11.2 kB
  • 231 - Use formulas to create interactive charts.srt 11.1 kB
  • 244 - Use data validation rules with special phone and social security formats.srt 11.1 kB
  • 171-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt 11.0 kB
  • 004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 11.0 kB
  • Exercise Files/252_Text_Columns_Flash_Fill.zip 10.9 kB
  • 149-Work_with_formulas_and_formats_Decimals_and_fractions.srt 10.9 kB
  • 230 - Insert colorful images with the People Graph Add-in.srt 10.9 kB
  • 184-Use_date_functions_for_age_and_tenure_calculations.srt 10.8 kB
  • 170-Identify_or_extract_unique_entries_in_a_list.srt 10.8 kB
  • 163-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt 10.8 kB
  • 239 - Use Find and Replace to change cell contents and formats.srt 10.7 kB
  • 169-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt 10.7 kB
  • 221 - Use the XLOOKUP function to replace VLOOKUP.srt 10.7 kB
  • 115-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10.6 kB
  • 058-Adding_pictures_as_worksheet_backgrounds.srt 10.6 kB
  • 143-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt 10.6 kB
  • 243 - Use worksheet names in formulas.srt 10.6 kB
  • 195-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.srt 10.5 kB
  • 130-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10.5 kB
  • 026-Enhancing_table_filtering_with_slicers.srt 10.5 kB
  • 196-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.srt 10.5 kB
  • 207-Tracking_down_conditional_formatting_and_data_validation_rules.srt 10.5 kB
  • 208 - Transposing data and using the TRANSPOSE function.srt 10.4 kB
  • 248 - Display and highlight worksheet formula cells.srt 10.4 kB
  • 070-Replace_characters_by_position_with_the_REPLACE_function.srt 10.4 kB
  • 031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10.3 kB
  • 164-Calculate_%_of_change.srt 10.3 kB
  • 226 - Simplify the use of special characters and symbols.srt 10.3 kB
  • 213 - Tabulating totals with the VLOOKUP function and array constants.srt 10.3 kB
  • 202-How_to_use_the_error_checking_rules_in_Excel.srt 10.3 kB
  • Exercise Files/236_Dates_in_Charts.zip 10.3 kB
  • 192-Column_widths_row_heights_merging_cells_and_related_formatting_issues.srt 10.2 kB
  • 180-Differences_and_limitations_of_converting_data_to_a_table.srt 10.2 kB
  • Exercise Files/212_CEILINGandFLOOR.zip 10.2 kB
  • 176-Use_range_names_for_more_readable_formulas.srt 10.2 kB
  • 205-Rapid_filtering_with_Filter_by_Selection.srt 10.1 kB
  • 252 - Work with hidden and visible data in filtered and subtotaled lists.srt 10.1 kB
  • 216 - Creating and updating sample data.srt 10.1 kB
  • 179-How_to_adjust_names.srt 10.1 kB
  • 197-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.srt 10.0 kB
  • 250 - Highlight milestone data with conditional formatting and cumulative formulas.srt 10.0 kB
  • 173-Extract_day_month_and_year_from_date_fields.srt 10.0 kB
  • 247 - Look forward and backward using EDATE and other date functions.srt 9.9 kB
  • Exercise Files/253_Cumulative_Formulas.zip 9.8 kB
  • 198-Helpful_keystroke_shortcuts.srt 9.8 kB
  • 218 - Use the new SORT and SORTBY functions to extract sorted lists.srt 9.8 kB
  • 235 - Overcoming obstacles when working with dates in charts.srt 9.8 kB
  • 092-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 9.8 kB
  • 174-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt 9.8 kB
  • 204-Use_mixed_addresses_in_Excel_formulas.srt 9.8 kB
  • Exercise Files/188_CONVERT_Function.zip 9.7 kB
  • 181-Avoid_the_#DIV_0_error_message.srt 9.7 kB
  • 022-Increasing_your_productivity_with_custom_lists.srt 9.7 kB
  • 224 - Discover new formula capabilities with new functions and dynamic arrays.srt 9.6 kB
  • 211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt 9.6 kB
  • 240 - Add formula tools and symbols to the Quick Access Toolbar.srt 9.5 kB
  • 178-Conditional_formatting_based_on_date_proximity.srt 9.4 kB
  • 200-Use_chart_and_filter_for_presentations.srt 9.4 kB
  • 217 - Format macros to make you a more efficient Excel user.srt 9.4 kB
  • Exercise Files/247_Phone_ZipFormats.zip 9.3 kB
  • Exercise Files/222_Financial_Functions.zip 9.3 kB
  • 233 - Get totals quickly without creating formulas.srt 9.3 kB
  • 209 - Displaying gridlines, borders, and column_row headings when printing.srt 9.2 kB
  • 237 - Techniques for creating date series.srt 9.2 kB
  • Exercise Files/190_Solver.zip 9.2 kB
  • 027-Converting_charts_into_pictures.srt 9.2 kB
  • 133-Using_WordArt_for_special_titles_and_headings.srt 9.0 kB
  • 113-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 8.9 kB
  • 028-Custom_grouping_in_PivotTables.srt 8.9 kB
  • Exercise Files/230_Area_Charts.zip 8.9 kB
  • 242 - Use the Excel filtering capability for dates.srt 8.9 kB
  • 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt 8.8 kB
  • 249 - Split or join columnar data with Text to Columns or Flash Fill.srt 8.8 kB
  • 245 - Work with time calculations in formulas.srt 8.8 kB
  • 140-Use_the_new_Funnel_chart_available_in_Excel_365.srt 8.7 kB
  • 011-Exploring_various_layouts_for_your_PivotTable.srt 8.6 kB
  • 201-Create_picture_links.srt 8.6 kB
  • 165-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt 8.6 kB
  • 229 - How and when to use an area chart.srt 8.5 kB
  • 236 - Create map-type charts based on geographical locations.srt 8.5 kB
  • 246 - Prevent and locate duplicate worksheet entries.srt 8.5 kB
  • 188-Using_the_CONVERT_function_for_different_numbering_systems.srt 8.4 kB
  • 253 - Create a powerful macro.srt 8.3 kB
  • Exercise Files/237_Geographic_Maps.zip 8.3 kB
  • 238 - Extract filtered data with data validation and the FILTER function.srt 8.3 kB
  • 185-Avoid_unintentional_entries_when_typing_code_numbers.srt 8.2 kB
  • 182-Explore_formatting_options_not_available_on_the_Home_tab.srt 8.2 kB
  • 160-Converting_dates_like_20102006_into_usable_date_entries.srt 8.2 kB
  • 189-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.srt 8.2 kB
  • 232 - Track variables using the Scenario Manager.srt 8.2 kB
  • 194-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.srt 8.1 kB
  • 175-How_to_covert_ROMAN_numberals.srt 8.1 kB
  • 214 - Working with array formulas more easily.srt 8.1 kB
  • 234 - Use column or row references to create dynamic formulas.srt 8.1 kB
  • 186-Sorting_by_moving_columns.srt 8.0 kB
  • 166-Use_the_COUNT_and_COUNTA_functions.srt 8.0 kB
  • 193-Adjusting_default_layouts_and_date_grouping_in_PivotTables.srt 8.0 kB
  • 203-Protect_worksheets_and_lock_cells.srt 8.0 kB
  • 191-Using_the_Solver_Add-in.srt 7.9 kB
  • 222 - Chart display options with blank cells in source data.srt 7.8 kB
  • 187-Calculating_cumulative_totals.srt 7.8 kB
  • 132-Exploring_font_choices_not_found_on_the_Home_tab.srt 7.6 kB
  • 219 - Use themes to adjust worksheet colors, fonts, and effects.srt 7.5 kB
  • 210 - Exploring some of the 200-plus SmartArt graphic options.srt 7.3 kB
  • 199-Identify_weekdays_and_weekend_days_in_data.srt 7.1 kB
  • 206-Display_large_values.srt 6.8 kB
  • 018-Parsing_your_data_to_create_unique_lists.srt 6.7 kB
  • Exercise Files/189_Chart_based_on_a_Table.zip 6.7 kB
  • 025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6.6 kB
  • 183-Control_table_formatting_with_custom_formats.srt 6.4 kB
  • 215 - Using the new UNIQUE function to count and copy unique list entries.srt 6.4 kB
  • 251 - Use the XMATCH function to replace MATCH.srt 6.2 kB
  • 019-Using_the_REPT_function_to_represent_data_visually.srt 6.1 kB

温馨提示

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！