Download link
File List
-
019-Using_the_REPT_function_to_represent_data_visually.srt 5.91 KB
251 - Use the XMATCH function to replace MATCH.srt 6.09 KB
215 - Using the new UNIQUE function to count and copy unique list entries.srt 6.2 KB
183-Control_table_formatting_with_custom_formats.srt 6.23 KB
025-Creating_dynamic_charts_with_in_cell_conditional_formatting.srt 6.44 KB
Exercise Files/189_Chart_based_on_a_Table.zip 6.52 KB
018-Parsing_your_data_to_create_unique_lists.srt 6.56 KB
206-Display_large_values.srt 6.64 KB
199-Identify_weekdays_and_weekend_days_in_data.srt 6.92 KB
210 - Exploring some of the 200-plus SmartArt graphic options.srt 7.11 KB
219 - Use themes to adjust worksheet colors, fonts, and effects.srt 7.31 KB
132-Exploring_font_choices_not_found_on_the_Home_tab.srt 7.38 KB
187-Calculating_cumulative_totals.srt 7.63 KB
222 - Chart display options with blank cells in source data.srt 7.66 KB
191-Using_the_Solver_Add-in.srt 7.73 KB
203-Protect_worksheets_and_lock_cells.srt 7.77 KB
193-Adjusting_default_layouts_and_date_grouping_in_PivotTables.srt 7.82 KB
166-Use_the_COUNT_and_COUNTA_functions.srt 7.83 KB
186-Sorting_by_moving_columns.srt 7.83 KB
234 - Use column or row references to create dynamic formulas.srt 7.86 KB
214 - Working with array formulas more easily.srt 7.88 KB
175-How_to_covert_ROMAN_numberals.srt 7.88 KB
194-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.srt 7.92 KB
232 - Track variables using the Scenario Manager.srt 7.96 KB
189-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.srt 7.97 KB
160-Converting_dates_like_20102006_into_usable_date_entries.srt 7.99 KB
182-Explore_formatting_options_not_available_on_the_Home_tab.srt 8 KB
185-Avoid_unintentional_entries_when_typing_code_numbers.srt 8.01 KB
238 - Extract filtered data with data validation and the FILTER function.srt 8.08 KB
Exercise Files/237_Geographic_Maps.zip 8.11 KB
253 - Create a powerful macro.srt 8.15 KB
188-Using_the_CONVERT_function_for_different_numbering_systems.srt 8.24 KB
246 - Prevent and locate duplicate worksheet entries.srt 8.27 KB
236 - Create map-type charts based on geographical locations.srt 8.27 KB
229 - How and when to use an area chart.srt 8.27 KB
165-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.srt 8.41 KB
201-Create_picture_links.srt 8.41 KB
011-Exploring_various_layouts_for_your_PivotTable.srt 8.42 KB
140-Use_the_new_Funnel_chart_available_in_Excel_365.srt 8.49 KB
245 - Work with time calculations in formulas.srt 8.6 KB
249 - Split or join columnar data with Text to Columns or Flash Fill.srt 8.63 KB
223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt 8.63 KB
242 - Use the Excel filtering capability for dates.srt 8.69 KB
Exercise Files/230_Area_Charts.zip 8.7 KB
028-Custom_grouping_in_PivotTables.srt 8.71 KB
113-Use_conditional_formatting_data_bars_to_accentuate_negative_data.srt 8.74 KB
133-Using_WordArt_for_special_titles_and_headings.srt 8.78 KB
027-Converting_charts_into_pictures.srt 8.97 KB
Exercise Files/190_Solver.zip 8.98 KB
237 - Techniques for creating date series.srt 8.99 KB
209 - Displaying gridlines, borders, and column_row headings when printing.srt 9.01 KB
233 - Get totals quickly without creating formulas.srt 9.03 KB
Exercise Files/222_Financial_Functions.zip 9.04 KB
Exercise Files/247_Phone_ZipFormats.zip 9.04 KB
217 - Format macros to make you a more efficient Excel user.srt 9.18 KB
200-Use_chart_and_filter_for_presentations.srt 9.19 KB
178-Conditional_formatting_based_on_date_proximity.srt 9.21 KB
240 - Add formula tools and symbols to the Quick Access Toolbar.srt 9.31 KB
211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt 9.37 KB
224 - Discover new formula capabilities with new functions and dynamic arrays.srt 9.39 KB
022-Increasing_your_productivity_with_custom_lists.srt 9.44 KB
181-Avoid_the_#DIV_0_error_message.srt 9.47 KB
Exercise Files/188_CONVERT_Function.zip 9.5 KB
204-Use_mixed_addresses_in_Excel_formulas.srt 9.53 KB
174-Compare_data_with_EXACT_FIND_and_SEARCH_functions.srt 9.54 KB
092-Activate_the_Speak_On_Enter_and_Speak_Cells_features.srt 9.55 KB
235 - Overcoming obstacles when working with dates in charts.srt 9.57 KB
218 - Use the new SORT and SORTBY functions to extract sorted lists.srt 9.59 KB
198-Helpful_keystroke_shortcuts.srt 9.6 KB
Exercise Files/253_Cumulative_Formulas.zip 9.61 KB
247 - Look forward and backward using EDATE and other date functions.srt 9.62 KB
250 - Highlight milestone data with conditional formatting and cumulative formulas.srt 9.75 KB
173-Extract_day_month_and_year_from_date_fields.srt 9.75 KB
197-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.srt 9.79 KB
179-How_to_adjust_names.srt 9.82 KB
216 - Creating and updating sample data.srt 9.83 KB
252 - Work with hidden and visible data in filtered and subtotaled lists.srt 9.86 KB
205-Rapid_filtering_with_Filter_by_Selection.srt 9.87 KB
176-Use_range_names_for_more_readable_formulas.srt 9.93 KB
Exercise Files/212_CEILINGandFLOOR.zip 9.97 KB
180-Differences_and_limitations_of_converting_data_to_a_table.srt 9.97 KB
192-Column_widths_row_heights_merging_cells_and_related_formatting_issues.srt 9.98 KB
Exercise Files/236_Dates_in_Charts.zip 10.02 KB
202-How_to_use_the_error_checking_rules_in_Excel.srt 10.03 KB
213 - Tabulating totals with the VLOOKUP function and array constants.srt 10.04 KB
164-Calculate_%_of_change.srt 10.08 KB
226 - Simplify the use of special characters and symbols.srt 10.08 KB
031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.srt 10.09 KB
070-Replace_characters_by_position_with_the_REPLACE_function.srt 10.11 KB
248 - Display and highlight worksheet formula cells.srt 10.13 KB
208 - Transposing data and using the TRANSPOSE function.srt 10.18 KB
207-Tracking_down_conditional_formatting_and_data_validation_rules.srt 10.22 KB
196-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.srt 10.23 KB
026-Enhancing_table_filtering_with_slicers.srt 10.24 KB
130-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.srt 10.29 KB
195-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.srt 10.3 KB
243 - Use worksheet names in formulas.srt 10.32 KB
143-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.srt 10.33 KB
058-Adding_pictures_as_worksheet_backgrounds.srt 10.33 KB
115-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.srt 10.36 KB
169-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.srt 10.41 KB
221 - Use the XLOOKUP function to replace VLOOKUP.srt 10.41 KB
239 - Use Find and Replace to change cell contents and formats.srt 10.42 KB
163-NETWORKDAYS.INTL_and_WORKDAY.INTL.srt 10.52 KB
170-Identify_or_extract_unique_entries_in_a_list.srt 10.54 KB
184-Use_date_functions_for_age_and_tenure_calculations.srt 10.57 KB
230 - Insert colorful images with the People Graph Add-in.srt 10.63 KB
149-Work_with_formulas_and_formats_Decimals_and_fractions.srt 10.65 KB
Exercise Files/252_Text_Columns_Flash_Fill.zip 10.67 KB
004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.srt 10.7 KB
171-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.srt 10.78 KB
244 - Use data validation rules with special phone and social security formats.srt 10.81 KB
231 - Use formulas to create interactive charts.srt 10.87 KB
190-Keystroke_shortcuts_using_the_Alt_key.srt 10.9 KB
241 - Change PivotTable settings for titles and summaries.srt 10.95 KB
066-Using_Command_Shortcuts_with_the_Alt_key.srt 10.95 KB
158-Use_REPLACE_for_formats_only_for_data_only_or_for_both.srt 10.96 KB
168-Rank_data_with_the_RANK_and_RANK.AVG_functions.srt 10.98 KB
046-Handling_Dates_with_unusual_formats.srt 10.98 KB
212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt 11.09 KB
177-Customize_your_Quick_Access_Toolbar.srt 11.12 KB
167-Use_workbook_protection_to_prevent_use_of_sheet_commands.srt 11.15 KB
035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.srt 11.21 KB
038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.srt 11.21 KB
220 - Calculate loan payments and investments with PMT and FV functions.srt 11.25 KB
225 - Sort or filter data based on color font or cell color background.srt 11.33 KB
039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.srt 11.34 KB
060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.srt 11.48 KB
162-Freeze_Panes_and_Split.srt 11.51 KB
141-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.srt 11.54 KB
228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt 11.56 KB
128-Displaying_tips_when_using_Excel_in_presentations.srt 11.59 KB
157-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.srt 11.61 KB
Exercise Files/187_Cumulative_Totals.zip 11.63 KB
155-Change_the_default_Excel_chart_type_create_and_use_chart_templates.srt 11.66 KB
023-Highlighting_PivotTable_results_with_conditional_formatting.srt 11.73 KB
030-The_top_five_unknown_but_useful_keyboard_shortcuts.srt 11.77 KB
152-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.srt 11.9 KB
227 - Select from over 800 icons to enliven worksheets.srt 11.94 KB
033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.srt 12.1 KB
010-Applying_conditional_formatting_across_rows_of_data.srt 12.2 KB
094-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.srt 12.22 KB
081-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.srt 12.29 KB
024-Customizing_templates_to_fit_your_unique_needs.srt 12.29 KB
161-Create_custom_lists_for_letter_series_like_A_to_Z.srt 12.31 KB
077-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.srt 12.36 KB
044-Creating_text_numerical_date_and_time_lists_in_a_flash.srt 12.4 KB
001-Hide_and_unhide_worksheets_securely.srt 12.48 KB
088-Change_the_shape_of_comment_boxes_and_other_objects.srt 12.53 KB
056-Drawing_borders_and_border_grids.srt 12.55 KB
Exercise Files/227_Special_Characters.zip 12.84 KB
121-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.srt 12.88 KB
134-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.srt 12.9 KB
125-Tips_for_creating_charts_quickly.srt 12.95 KB
074-Use_a_data_form_for_data_entry_and_exploring_data.srt 12.95 KB
041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.srt 12.97 KB
146-Vertical_and_horizontal_alignment_settings_and_orientation_options.srt 12.98 KB
012-Splitting_and_consolidating_workbooks.srt 12.99 KB
Exercise Files/229_Random_Functions.zip 12.99 KB
114-Creative_use_of_sparklines_in_merged_cells_with_axes.srt 13.03 KB
Exercise Files/154_Phone_and_ZipCode_Formats.zip 13.05 KB
148-A_look_at_new_chart_types_in_Excel_2016_Waterfall.srt 13.12 KB
098-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.srt 13.27 KB
078-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.srt 13.31 KB
090-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.srt 13.33 KB
120-Summarize_data_from_different_worksheets_with_a_PivotTable.srt 13.35 KB
154-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.srt 13.36 KB
013-Using_date_and_time_as_metrics_in_a_PivotTable.srt 13.42 KB
064-Restoring_missing_column_titles.srt 13.57 KB
075-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.srt 13.61 KB
065-Creating_a_pick_list_dependent_on_another_pick_list.srt 13.61 KB
040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.srt 13.71 KB
153-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.srt 13.75 KB
037-Adding_managing_and_printing_comments_for_worksheet_documentation.srt 13.86 KB
100-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.srt 13.89 KB
150-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.srt 13.92 KB
097-How_to_create_frequency_tabulations_and_distributions.srt 13.99 KB
Exercise Files/232_GrowingChart.zip 14.16 KB
076-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.srt 14.37 KB
017-Dynamically_presenting_data_via_chart_slicers.srt 14.46 KB
045-Creating_Variable_Conditional_Formatting_Rules.srt 14.47 KB
Exercise Files/185_Unintentional_Entries.zip 14.47 KB
042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.srt 14.49 KB
003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.srt 14.51 KB
Exercise Files/191_Columns_Widths.zip 14.53 KB
137-Freezing_column_and_row_titles.srt 14.54 KB
172-Create_artistic_charts_with_random_numbers.srt 14.57 KB
124-Dealing_with_circular_errors.srt 14.57 KB
020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.srt 14.59 KB
151-Control_gridlines_in_charts_and_on_worksheets.srt 14.64 KB
156-Create_your_own_customized_date_and_time_formats.srt 14.66 KB
005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.srt 14.7 KB
111-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.srt 14.74 KB
062-Locating_Data_Validation_rules_and_violations.srt 14.8 KB
079-Hide_worksheets_row_columns_cells_and_other_Excel_elements.srt 14.85 KB
029-Quick_formatting_tips.srt 14.94 KB
082-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.srt 14.94 KB
106-Keyboard_shortcuts_for_numeric_formats.srt 15.06 KB
021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.srt 15.14 KB
Exercise Files/214_Array_Constants_withVLOOKUP.zip 15.28 KB
136-New_Excel_2016_chart_types_Tree_map_and_sunburst.srt 15.37 KB
122-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.srt 15.4 KB
095-Use_Watch_Window_and_other_techniques_to_track_changing_cells.srt 15.54 KB
126-Creating_heat_maps_using_conditional_formatting.srt 15.55 KB
053-Custom_formats_relative_addressing_and_conditional_formatting.srt 15.63 KB
Exercise Files/199_Charts_and_Filters.zip 15.65 KB
055-Adding_comments_and_shapes.srt 15.77 KB
091-How_to_use_mixed_cell_references.srt 15.79 KB
118-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.srt 15.88 KB
Exercise Files/208_Transpose.zip 15.96 KB
059-ADDRESS_ROW_and_COLUMN_functions.srt 15.98 KB
Exercise Files/213_Shapes_and_Stars.zip 16 KB
108-Work_with_MAX_MAXIFS_LARGE_and_related_functions.srt 16.08 KB
015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.srt 16.1 KB
Exercise Files/251_Find_Highlight_Formula_cells.zip 16.1 KB
Exercise Files/238_Date_Time_Series.zip 16.18 KB
063-Creating_an_Excel_template.srt 16.2 KB
043-Exploring_what_if_scenarios_using_Goal_Seek.srt 16.22 KB
008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.srt 16.33 KB
Exercise Files/209_Borders_Gridlines_Printing.zip 16.34 KB
135-Borders_and_gridlines_Exploring_variations_options_and_differences.srt 16.42 KB
147-Sorting_tips_and_shortcuts.srt 16.44 KB
Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16.47 KB
109-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.srt 16.76 KB
107-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.srt 16.77 KB
Exercise Files/130_Multiple_Worksheets.zip 16.8 KB
Exercise Files/219_Utility_Macros.zip 16.83 KB
009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.srt 16.85 KB
Exercise Files/256_Macro_Highlight_Formula_Cells.zip 16.94 KB
069-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.srt 17.06 KB
050-Create_an_Organization_Chart.srt 17.23 KB
129-The_Wrap_Text_Merge_and_Center_and_Indent_options.srt 17.32 KB
Exercise Files/210_SmartArt.zip 17.38 KB
083-Adjust_a_charts_source_data_and_adjust_its_series_order.srt 17.46 KB
047-Using_wildcards_(asterisk_tilde_and_question_mark).srt 17.52 KB
080-Use_slicers_and_charts_together_for_dynamic_presentations.srt 17.61 KB
101-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.srt 17.65 KB
145-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.srt 17.69 KB
071-Work_with_formulas_in_tables.srt 17.81 KB
131-Working_with_multiple_worksheets_simultaneously.srt 17.96 KB
006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.srt 17.99 KB
054-Auditing.srt 18.06 KB
142-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.srt 18.09 KB
Exercise Files/203_Mixed_Cell_Addresses.zip 18.3 KB
144-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.srt 18.34 KB
099-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.srt 18.36 KB
102-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.srt 18.38 KB
034-Calculating_with_hours_minutes_and_times_of_day.srt 18.48 KB
067-Set_up_a_macro_for_sorting_dynamic_data.srt 18.61 KB
Exercise Files/178_Adjusting_Names.zip 18.63 KB
Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 18.66 KB
032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.srt 18.7 KB
119-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.srt 18.79 KB
002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.srt 19.02 KB
086-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.srt 19.02 KB
110-Use_the_FIND_MID_LEFT_and_RIGHT_functions.srt 19.06 KB
Exercise Files/179_Date_Proximity_Formatting_final.zip 19.09 KB
085-Alter_numeric_data_without_formulas.srt 19.19 KB
103-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.srt 19.24 KB
084-Use_the_OFFSET_function_for_tabulating_moving_data.srt 19.72 KB
068-Use_random_number_functions_for_sorting_and_creating_sample_data.srt 19.95 KB
127-Using_the_INDEX_function_to_extract_data_by_row_and_column.srt 20.02 KB
138-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.srt 20.02 KB
116-Displaying_multiple_worksheets_and_workbooks_together.srt 20.07 KB
Exercise Files/175_ROMAN_ARABIC.zip 20.33 KB
052-Using_Excels_error_checking_functions.srt 20.44 KB
036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.srt 20.64 KB
Exercise Files/224_CondFormattingBreakpoints.zip 20.72 KB
117-Tips_for_creating_and_updating_sample_data.srt 20.85 KB
073-Use_special_tricks_for_working_with_dates_in_Charts.srt 21.02 KB
096-How_to_create_time_interval_entries.srt 21.29 KB
104-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.srt 21.38 KB
139-Avoiding_common_chart_distortions.srt 21.49 KB
159-Create_numeric_formats_Display_in_thousands_or_millions.srt 21.69 KB
051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.srt 21.89 KB
112-Working_with_hidden_data_when_copying_cells_and_creating_charts.srt 22.07 KB
Exercise Files/164_Percent_change_and_Goal_Seek.zip 22.12 KB
049-Meeting_unusual_filtering_needs_via_Advanced_Filter.srt 22.23 KB
048-Custom_formats_using_asterisk_semicolon_and_brackets.srt 22.45 KB
016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.srt 22.49 KB
123-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.srt 22.53 KB
007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.srt 22.81 KB
Exercise Files/242_CopyFormats.zip 22.89 KB
014-Adding_illustrations_to_your_workbook.srt 22.95 KB
093-Accelerate_data_entry_with_five_special_techniques.srt 23.29 KB
057-Building_a_flexible_monthly_table_using_functions.srt 23.64 KB
089-How_and_when_to_use_Excels_10_rounding_functions.srt 24.22 KB
Exercise Files/189_Alt_Key_Shortcuts.zip 24.63 KB
Exercise Files/129_Fill_Effects.zip 24.75 KB
105-Formula_nesting_Using_multiple_functions_in_the_same_formula.srt 25.09 KB
Exercise Files/149_Decimals_and_Fractions.zip 26.43 KB
Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27.14 KB
Exercise Files/233_ScenarioManager.zip 27.28 KB
061-Working_with_formulas_in_tables.srt 27.97 KB
087-Adjust_banded_row_formatting.srt 28.13 KB
Exercise Files/245_FilterYearDay.zip 28.36 KB
Exercise Files/181_Avoiding_DIV_Error.zip 29.6 KB
072-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.srt 31.23 KB
Exercise Files/205_Displaying_Large_Values.zip 32.84 KB
Exercise Files/254_XMATCH_Function.zip 38.3 KB
Exercise Files/186_Sort_by_Moving_Columns.zip 38.81 KB
Exercise Files/194_LEN_and_REPT.zip 39.19 KB
Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 39.89 KB
Exercise Files/221_Themes.zip 39.96 KB
Exercise Files/159_Number_Formats.zip 41.15 KB
Exercise Files/217_UNIQUE_function.zip 41.25 KB
Exercise Files/228_Icons.zip 42.37 KB
Exercise Files/225_New_Formulas.zip 45.17 KB
Exercise Files/244_PivotTable_Settings.zip 46.41 KB
Exercise Files/248_Time_Math.zip 48.2 KB
Exercise Files/125_Heat_Maps.zip 51.16 KB
Exercise Files/218_Sample_Data.zip 51.25 KB
Exercise Files/202_Worksheet_Protection.zip 55.52 KB
Exercise Files/241_AverageCountSubscript.zip 57.23 KB
Exercise Files/168_Ranking_Data.zip 57.87 KB
Exercise Files/231_People_Graph.zip 59.43 KB
Exercise Files/235_Columns_and_Rows.zip 59.83 KB
Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 59.89 KB
Exercise Files/128_Wrap_text_Merge_Indent.zip 60.12 KB
Exercise Files/220_SORT_and_SORTBY_Functions.zip 62.63 KB
Exercise Files/151_Chart_gridlines_and_borders.zip 64.55 KB
Exercise Files/150_Mixed_References.zip 65.27 KB
Exercise Files/234_Status_Bar.zip 65.27 KB
Exercise Files/200_Linking_Pictures.zip 66.24 KB
Exercise Files/192_PivotTable_Settings.zip 67.39 KB
Exercise Files/239_Data_Validation_and_Filter.zip 70.41 KB
Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 73.04 KB
Exercise Files/204_Filter_by_Selection.zip 73.31 KB
Exercise Files/226_Sort_by_Color.zip 73.82 KB
Exercise Files/246_Sheet_Names.zip 74.02 KB
Exercise Files/195_TRIM_and_CLEAN.zip 75.07 KB
Exercise Files/249_Prevent_Locate_Duplicates.zip 77.52 KB
Exercise Files/255_Hidden_Visible_Data.zip 85.18 KB
Exercise Files/194_Watch_Window.zip 105.34 KB
Exercise Files/206_ConditionalFormatting_and_DataValidation.zip 107.14 KB
Exercise Files/207_CheckBox_ConditionalFormatting.zip 107.23 KB
Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 115.03 KB
Exercise Files/161_Custom_Lists.zip 118.02 KB
Exercise Files/156_Date_Time_Formats.zip 120.41 KB
Exercise Files/183_New_Table_Style.zip 123.33 KB
Exercise Files/153_Expand_Collapse_PivotTables.zip 123.43 KB
Exercise Files/216_ArrayFormulaUpdates.zip 128.04 KB
Exercise Files/184_Date_Calculations.zip 128.46 KB
Exercise Files/250_EDate_EMonth_DatedIF.zip 129.25 KB
Exercise Files/160_Date_Format_Conversions.zip 133.7 KB
Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 144.02 KB
Exercise Files/196_Double_and_Triple_Spaced_Printing.zip 146.8 KB
Exercise Files/169_PivotTable_Date_Grouping.zip 150.65 KB
Exercise Files/165_Fill_in_Blanks.zip 152.65 KB
Exercise Files/158_Replace_Format_or_Content.zip 154.66 KB
Exercise Files/240_Find_Select.zip 157.7 KB
Exercise Files/176_Range_Names.zip 164.88 KB
Exercise Files/243_XLOOKUP_Function.zip 165.03 KB
Exercise Files/157_Comments_and_Reminders.zip 183.4 KB
Exercise Files/170_Unique_and_Duplicate_Data.zip 210.96 KB
Exercise Files/167_Excel_Sheet_Commands.zip 218.96 KB
Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 226.04 KB
Exercise Files/180_Table_Differences.zip 236.76 KB
Exercise Files/182_FormattingOptions.zip 237.66 KB
Exercise Files/198_Weekdays_and_Weekends.zip 248.3 KB
Exercise Files/171_Zoom_and_Display_Variations.zip 258.71 KB
Exercise Files/197_Helpful_Keystroke_Shortcuts.zip 305.83 KB
Exercise Files/201_Error_Checking_Indicators.zip 315.6 KB
Exercise Files/223_BlankCellsInCharts.zip 333.02 KB
Exercise Files/127_Display_Tips.zip 334.47 KB
Exercise Files/215_AdvancedFilter.zip 344.95 KB
Exercise Files/134_Two_Way_Lookups.zip 360.59 KB
Exercise Files/131_Other_Font_Options.zip 367.32 KB
Exercise Files/211_GoTo_Special.zip 406.31 KB
Exercise Files/132_WordArt_Variations.zip 426.48 KB
Exercise Files/135_Borders_Gridlines.zip 438.22 KB
Exercise Files/123_Book1.zip 460 KB
Exercise Files/126_INDEX_Function.zip 491.93 KB
Exercise Files/133_Weekday_Weekend.zip 512.45 KB
Exercise Files/124_Quick_Charts.zip 862.18 KB
Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip 1.08 MB
Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip 1.47 MB
Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip 1.49 MB
019-Using_the_REPT_function_to_represent_data_visually.mp4 8.82 MB
210 - Exploring some of the 200-plus SmartArt graphic options.mp4 9.03 MB
251 - Use the XMATCH function to replace MATCH.mp4 9.47 MB
236 - Create map-type charts based on geographical locations.mp4 9.49 MB
200-Use_chart_and_filter_for_presentations.mp4 9.52 MB
185-Avoid_unintentional_entries_when_typing_code_numbers.mp4 9.52 MB
194-Auditing_cell_content_with_Watch_Window_and_dependent_cell_formulas.mp4 9.94 MB
222 - Chart display options with blank cells in source data.mp4 10.13 MB
215 - Using the new UNIQUE function to count and copy unique list entries.mp4 10.23 MB
195-Use_the_LEN_and_REPT_functions_for_specialized_cell_testing_and_display_options.mp4 10.58 MB
140-Use_the_new_Funnel_chart_available_in_Excel_365.mp4 10.63 MB
237 - Techniques for creating date series.mp4 10.81 MB
192-Column_widths_row_heights_merging_cells_and_related_formatting_issues.mp4 10.97 MB
214 - Working with array formulas more easily.mp4 11.05 MB
229 - How and when to use an area chart.mp4 11.11 MB
187-Calculating_cumulative_totals.mp4 11.22 MB
231 - Use formulas to create interactive charts.mp4 11.25 MB
189-Creating_an_automatically_expanding_chart_by_basing_it_on_a_table.mp4 11.3 MB
219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 11.3 MB
193-Adjusting_default_layouts_and_date_grouping_in_PivotTables.mp4 11.42 MB
245 - Work with time calculations in formulas.mp4 11.43 MB
113-Use_conditional_formatting_data_bars_to_accentuate_negative_data.mp4 11.45 MB
025-Creating_dynamic_charts_with_in_cell_conditional_formatting.mp4 11.49 MB
226 - Simplify the use of special characters and symbols.mp4 11.49 MB
132-Exploring_font_choices_not_found_on_the_Home_tab.mp4 11.68 MB
191-Using_the_Solver_Add-in.mp4 11.75 MB
211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 11.87 MB
243 - Use worksheet names in formulas.mp4 11.93 MB
160-Converting_dates_like_20102006_into_usable_date_entries.mp4 11.98 MB
196-Use_the_TRIM_and_CLEAN_functions_to_remove_excess_spaces_and_non_printing_characters.mp4 11.98 MB
199-Identify_weekdays_and_weekend_days_in_data.mp4 11.98 MB
223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 12.08 MB
235 - Overcoming obstacles when working with dates in charts.mp4 12.15 MB
183-Control_table_formatting_with_custom_formats.mp4 12.2 MB
220 - Calculate loan payments and investments with PMT and FV functions.mp4 12.35 MB
205-Rapid_filtering_with_Filter_by_Selection.mp4 12.68 MB
204-Use_mixed_addresses_in_Excel_formulas.mp4 12.68 MB
197-Create_double_spaced_and_triple_spaced_printouts_while_repeating_column_headings.mp4 12.71 MB
250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 12.72 MB
188-Using_the_CONVERT_function_for_different_numbering_systems.mp4 12.85 MB
244 - Use data validation rules with special phone and social security formats.mp4 12.94 MB
212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 12.95 MB
028-Custom_grouping_in_PivotTables.mp4 12.99 MB
242 - Use the Excel filtering capability for dates.mp4 13.11 MB
173-Extract_day_month_and_year_from_date_fields.mp4 13.15 MB
249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 13.17 MB
174-Compare_data_with_EXACT_FIND_and_SEARCH_functions.mp4 13.17 MB
234 - Use column or row references to create dynamic formulas.mp4 13.23 MB
175-How_to_covert_ROMAN_numberals.mp4 13.25 MB
208 - Transposing data and using the TRANSPOSE function.mp4 13.41 MB
209 - Displaying gridlines, borders, and column_row headings when printing.mp4 13.46 MB
213 - Tabulating totals with the VLOOKUP function and array constants.mp4 13.51 MB
149-Work_with_formulas_and_formats_Decimals_and_fractions.mp4 13.53 MB
202-How_to_use_the_error_checking_rules_in_Excel.mp4 13.63 MB
224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 13.68 MB
178-Conditional_formatting_based_on_date_proximity.mp4 13.75 MB
181-Avoid_the_#DIV_0_error_message.mp4 13.76 MB
246 - Prevent and locate duplicate worksheet entries.mp4 13.8 MB
253 - Create a powerful macro.mp4 13.8 MB
011-Exploring_various_layouts_for_your_PivotTable.mp4 13.86 MB
166-Use_the_COUNT_and_COUNTA_functions.mp4 13.93 MB
238 - Extract filtered data with data validation and the FILTER function.mp4 13.97 MB
164-Calculate_%_of_change.mp4 14 MB
217 - Format macros to make you a more efficient Excel user.mp4 14.5 MB
018-Parsing_your_data_to_create_unique_lists.mp4 14.51 MB
133-Using_WordArt_for_special_titles_and_headings.mp4 14.54 MB
190-Keystroke_shortcuts_using_the_Alt_key.mp4 14.71 MB
092-Activate_the_Speak_On_Enter_and_Speak_Cells_features.mp4 14.71 MB
163-NETWORKDAYS.INTL_and_WORKDAY.INTL.mp4 14.74 MB
230 - Insert colorful images with the People Graph Add-in.mp4 14.87 MB
221 - Use the XLOOKUP function to replace VLOOKUP.mp4 14.96 MB
248 - Display and highlight worksheet formula cells.mp4 15.23 MB
141-Combine_data_using_CONCATENATE_CONCAT_and_TEXTJOIN_functions_and_the_ampersand_(&)_character.mp4 15.23 MB
186-Sorting_by_moving_columns.mp4 15.31 MB
176-Use_range_names_for_more_readable_formulas.mp4 15.5 MB
182-Explore_formatting_options_not_available_on_the_Home_tab.mp4 15.55 MB
070-Replace_characters_by_position_with_the_REPLACE_function.mp4 15.57 MB
216 - Creating and updating sample data.mp4 15.74 MB
228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 15.76 MB
247 - Look forward and backward using EDATE and other date functions.mp4 15.84 MB
027-Converting_charts_into_pictures.mp4 15.93 MB
168-Rank_data_with_the_RANK_and_RANK.AVG_functions.mp4 16.11 MB
179-How_to_adjust_names.mp4 16.21 MB
232 - Track variables using the Scenario Manager.mp4 16.33 MB
004-Using_the_FORMULATEXT_and_N_functions_for_worksheet_and_formula_documentation.mp4 16.4 MB
184-Use_date_functions_for_age_and_tenure_calculations.mp4 16.43 MB
227 - Select from over 800 icons to enliven worksheets.mp4 16.46 MB
240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 16.51 MB
100-Use_CHOOSE_to_calculate_fiscal_quarters_and_as_a_VLOOKUP_alternative.mp4 16.52 MB
165-Fill_in_all_blank_cells_within_a_range_with_either_formatting_or_data.mp4 16.56 MB
241 - Change PivotTable settings for titles and summaries.mp4 16.75 MB
233 - Get totals quickly without creating formulas.mp4 16.76 MB
094-Insert_a_text_box_or_shape_and_link_a_cells_content_to_it.mp4 16.99 MB
001-Hide_and_unhide_worksheets_securely.mp4 17.01 MB
130-Using_fill_effects_(gradients_patterns_styles)_for_colorful_cell_background_variations.mp4 17.05 MB
203-Protect_worksheets_and_lock_cells.mp4 17.24 MB
206-Display_large_values.mp4 17.27 MB
115-Copy_formats_quickly_using_dragging_techniques_and_the_Format_Painter.mp4 17.39 MB
060-Join_data_with_new_CONCAT_and_TEXTJOIN_functions.mp4 17.57 MB
143-Creating_cross-totals_with_the_SUMIFS_function_and_mixed_references.mp4 17.62 MB
218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 17.7 MB
044-Creating_text_numerical_date_and_time_lists_in_a_flash.mp4 17.89 MB
148-A_look_at_new_chart_types_in_Excel_2016_Waterfall.mp4 17.99 MB
167-Use_workbook_protection_to_prevent_use_of_sheet_commands.mp4 18 MB
081-Save_a_chart_as_a_template_use_the_template_for_current_or_new_charts.mp4 18.4 MB
146-Vertical_and_horizontal_alignment_settings_and_orientation_options.mp4 18.54 MB
154-Control_phone_number_and_postal_code_formats_using_built-in_options_or_customized_formats.mp4 18.7 MB
180-Differences_and_limitations_of_converting_data_to_a_table.mp4 18.78 MB
157-Create_on_screen_warnings_and_reminders_with_comments_or_data_validation_messages.mp4 18.79 MB
169-Use_nonstandard_fiscal_years_and_quarters_in_PivotTables.mp4 18.83 MB
065-Creating_a_pick_list_dependent_on_another_pick_list.mp4 18.84 MB
090-Calculate_faster_with_the_AutoSum_button_and_AutoSum_keystroke_shortcut.mp4 18.91 MB
207-Tracking_down_conditional_formatting_and_data_validation_rules.mp4 18.94 MB
038-Reducing_data_entry_time_by_expanding_AutoCorrect_options.mp4 18.99 MB
114-Creative_use_of_sparklines_in_merged_cells_with_axes.mp4 19.03 MB
155-Change_the_default_Excel_chart_type_create_and_use_chart_templates.mp4 19.14 MB
077-Create_dynamic_sheet_name_references_with_the_INDIRECT_function.mp4 19.17 MB
023-Highlighting_PivotTable_results_with_conditional_formatting.mp4 19.23 MB
201-Create_picture_links.mp4 19.23 MB
125-Tips_for_creating_charts_quickly.mp4 19.24 MB
088-Change_the_shape_of_comment_boxes_and_other_objects.mp4 19.25 MB
037-Adding_managing_and_printing_comments_for_worksheet_documentation.mp4 19.26 MB
075-Creating_an_Excel_template_to_simplify_updating_a_monthly_file.mp4 19.66 MB
042-Using_option_buttons_group_boxes_and_checkboxes_to_facilitate_forms_creation.mp4 19.93 MB
058-Adding_pictures_as_worksheet_backgrounds.mp4 20.05 MB
152-Use_the_INDIRECT_function_with_intersection_formulas_and_range_names_to_extract_data.mp4 20.16 MB
026-Enhancing_table_filtering_with_slicers.mp4 20.19 MB
066-Using_Command_Shortcuts_with_the_Alt_key.mp4 20.2 MB
121-AutoFill_shortcuts_for_date_series_one_two_week_intervals_EOM_and_formulas.mp4 20.22 MB
046-Handling_Dates_with_unusual_formats.mp4 20.25 MB
177-Customize_your_Quick_Access_Toolbar.mp4 20.33 MB
024-Customizing_templates_to_fit_your_unique_needs.mp4 20.37 MB
017-Dynamically_presenting_data_via_chart_slicers.mp4 20.42 MB
010-Applying_conditional_formatting_across_rows_of_data.mp4 20.45 MB
012-Splitting_and_consolidating_workbooks.mp4 20.53 MB
078-Avoid_errors_and_hidden_data_with_the_powerful_AGGREGATE_function.mp4 20.84 MB
022-Increasing_your_productivity_with_custom_lists.mp4 20.89 MB
040-Using_hyperlinks_for_rapidly_switching_worksheet_locations_and_jumping_to_websites.mp4 21.15 MB
198-Helpful_keystroke_shortcuts.mp4 21.27 MB
056-Drawing_borders_and_border_grids.mp4 21.36 MB
003-Using_list_boxes_and_combo_boxes_to_facilitate_forms_creation.mp4 21.48 MB
252 - Work with hidden and visible data in filtered and subtotaled lists.mp4 21.59 MB
031-Using_the_TREND_and_GROWTH_functions_for_projecting_future_results.mp4 21.61 MB
151-Control_gridlines_in_charts_and_on_worksheets.mp4 21.68 MB
035-Tracking_down_cell_dependencies_across_multiple_worksheets_and_workbooks.mp4 21.74 MB
239 - Use Find and Replace to change cell contents and formats.mp4 21.75 MB
033-Creating_colorful_3D_buttons_for_worksheet_annotation_and_macro_buttons.mp4 21.88 MB
153-Using_Expand_Collapse_on_PivotTables_and_PivotCharts_for_rapid_display_changes.mp4 21.95 MB
076-Calculate_dates_efficiently_using_Excels_hidden_function_DATEDIF.mp4 22.16 MB
124-Dealing_with_circular_errors.mp4 22.37 MB
158-Use_REPLACE_for_formats_only_for_data_only_or_for_both.mp4 22.46 MB
156-Create_your_own_customized_date_and_time_formats.mp4 22.5 MB
015-Using_Pick_list_VLOOKUP_Table_and_Chart_together.mp4 22.57 MB
170-Identify_or_extract_unique_entries_in_a_list.mp4 22.68 MB
082-MAXIFS_and_MINIFS_added_to_the_COUNTIF_SUMIF_family_of_functions.mp4 22.7 MB
172-Create_artistic_charts_with_random_numbers.mp4 22.72 MB
134-Creating_a_2_way_lookup_with_VLOOKUP_HLOOKUP_INDEX_and_MATCH_functions.mp4 22.8 MB
063-Creating_an_Excel_template.mp4 23.18 MB
013-Using_date_and_time_as_metrics_in_a_PivotTable.mp4 23.2 MB
021-Accelerating_Cut_Copy_Paste_and_Insert_tasks.mp4 23.25 MB
029-Quick_formatting_tips.mp4 23.4 MB
091-How_to_use_mixed_cell_references.mp4 23.41 MB
120-Summarize_data_from_different_worksheets_with_a_PivotTable.mp4 23.43 MB
032-Using_scroll_bars_and_spin_buttons_to_facilitate_forms_creation.mp4 23.56 MB
050-Create_an_Organization_Chart.mp4 23.64 MB
225 - Sort or filter data based on color font or cell color background.mp4 23.75 MB
005-Using_the_ISBLANK_and_COUNTBLANK_functions_to_check_for_and_tabulate_blank_cells.mp4 23.75 MB
053-Custom_formats_relative_addressing_and_conditional_formatting.mp4 23.95 MB
008-Becoming_more_productive_with_these_10_tiny_tips_you_ll_use_often.mp4 24.1 MB
118-Use_conditional_formatting_to_overcome_formatting_limitations_of_the_IF_function.mp4 24.14 MB
041-Controlling_worksheet_security_by_allowing_selected_users_to_edit_specific_cell_ranges.mp4 24.18 MB
122-Create_summary_statistics_using_COUNTIFS_SUMIFS_and_AVERAGEIFS_functions.mp4 24.27 MB
109-Use_the_dynamic_TODAY_and_NOW_functions_for_real_time_up_to_date_calculations.mp4 24.29 MB
108-Work_with_MAX_MAXIFS_LARGE_and_related_functions.mp4 24.59 MB
074-Use_a_data_form_for_data_entry_and_exploring_data.mp4 24.91 MB
097-How_to_create_frequency_tabulations_and_distributions.mp4 24.93 MB
020-Using_source_data_from_a_table_to_make_your_PivotTable_more_dynamic.mp4 24.96 MB
039-Setting_up_custom_views_for_quick_access_to_different_worksheet_displays.mp4 25.08 MB
135-Borders_and_gridlines_Exploring_variations_options_and_differences.mp4 25.12 MB
055-Adding_comments_and_shapes.mp4 25.43 MB
138-Use_data_validation_to_force_entries_to_be_uppercase_or_lowercase.mp4 25.51 MB
030-The_top_five_unknown_but_useful_keyboard_shortcuts.mp4 25.61 MB
106-Keyboard_shortcuts_for_numeric_formats.mp4 25.85 MB
083-Adjust_a_charts_source_data_and_adjust_its_series_order.mp4 25.94 MB
131-Working_with_multiple_worksheets_simultaneously.mp4 25.99 MB
069-Use_calcuated_fields_and_calculated_items_in_a_PivotTable.mp4 26.32 MB
064-Restoring_missing_column_titles.mp4 26.37 MB
171-Keyboard_mouse_and_command_techniques_for_viewing_worksheets.mp4 27.06 MB
059-ADDRESS_ROW_and_COLUMN_functions.mp4 27.67 MB
079-Hide_worksheets_row_columns_cells_and_other_Excel_elements.mp4 27.8 MB
002-Resizing_moving_copying_and_manipulating_charts_and_other_objects.mp4 27.85 MB
150-Creating_mixed_reference_formulas_converting_to_a_table_applying_conditional_formatting.mp4 27.89 MB
145-Using_the_AND_and_OR_functions_independently_or_within_IF_functions.mp4 27.92 MB
144-New_Excel_2016_chart_types_Histogram_Pareto_and_box_and_whisker.mp4 28.03 MB
043-Exploring_what_if_scenarios_using_Goal_Seek.mp4 28.04 MB
142-Recognizing_Excel_Formula_errors_#N_A_#VALUE!_#REF!_#DIV_0!_#NUM_and_#NAME!.mp4 28.07 MB
067-Set_up_a_macro_for_sorting_dynamic_data.mp4 28.18 MB
127-Using_the_INDEX_function_to_extract_data_by_row_and_column.mp4 28.38 MB
062-Locating_Data_Validation_rules_and_violations.mp4 28.54 MB
161-Create_custom_lists_for_letter_series_like_A_to_Z.mp4 28.74 MB
068-Use_random_number_functions_for_sorting_and_creating_sample_data.mp4 28.83 MB
080-Use_slicers_and_charts_together_for_dynamic_presentations.mp4 29.07 MB
111-Flip_the_left_to_right_order_of_columns_with_the_INDEX_function_or_sort_by_columns.mp4 29.38 MB
006-Summarizing_data_from_diverse_ranges_with_Data_Consolidate.mp4 29.4 MB
016-Using_formulas_to_calculate_values_across_worksheets_and_workbooks.mp4 29.52 MB
128-Displaying_tips_when_using_Excel_in_presentations.mp4 29.65 MB
034-Calculating_with_hours_minutes_and_times_of_day.mp4 29.66 MB
095-Use_Watch_Window_and_other_techniques_to_track_changing_cells.mp4 29.69 MB
103-Create_lists_of_all_2nd_Tuesdays_last_Tuesdays_and_other_date_series.mp4 29.79 MB
110-Use_the_FIND_MID_LEFT_and_RIGHT_functions.mp4 29.82 MB
104-Create_linkage_formulas_that_refer_to_other_worksheets_and_workbooks.mp4 29.86 MB
119-Use_VLOOKUP_MATCH_and_Index_functions_with_array_formulas.mp4 29.89 MB
071-Work_with_formulas_in_tables.mp4 30.04 MB
102-Use_the_SUBTOTAL_(and_AGGREGATE)_functions_to_avoid_double_counting.mp4 30.07 MB
136-New_Excel_2016_chart_types_Tree_map_and_sunburst.mp4 30.13 MB
162-Freeze_Panes_and_Split.mp4 30.26 MB
009-Transposing_data_and_charts_for_a_different_perspective_on_your_data.mp4 30.3 MB
129-The_Wrap_Text_Merge_and_Center_and_Indent_options.mp4 30.35 MB
054-Auditing.mp4 30.66 MB
045-Creating_Variable_Conditional_Formatting_Rules.mp4 30.8 MB
084-Use_the_OFFSET_function_for_tabulating_moving_data.mp4 30.82 MB
093-Accelerate_data_entry_with_five_special_techniques.mp4 31.52 MB
117-Tips_for_creating_and_updating_sample_data.mp4 31.62 MB
096-How_to_create_time_interval_entries.mp4 32.38 MB
116-Displaying_multiple_worksheets_and_workbooks_together.mp4 32.4 MB
147-Sorting_tips_and_shortcuts.mp4 32.43 MB
139-Avoiding_common_chart_distortions.mp4 32.73 MB
057-Building_a_flexible_monthly_table_using_functions.mp4 32.81 MB
073-Use_special_tricks_for_working_with_dates_in_Charts.mp4 33.2 MB
014-Adding_illustrations_to_your_workbook.mp4 33.62 MB
052-Using_Excels_error_checking_functions.mp4 33.63 MB
086-Use_Flash_Fill_to_rapidly_combine_or_separate_columnar_data.mp4 34.31 MB
126-Creating_heat_maps_using_conditional_formatting.mp4 34.91 MB
123-Use_custom_formulas_in_data_validation_to_keep_out_bad_data.mp4 35.01 MB
089-How_and_when_to_use_Excels_10_rounding_functions.mp4 35.35 MB
099-Solve_matching_issues_with_matching_phone_numbers_and_SS_numbers.mp4 35.66 MB
159-Create_numeric_formats_Display_in_thousands_or_millions.mp4 35.8 MB
101-Use_Outlining_tools_to_quickly_expand_and_collapse_data_for_dynamic_presentations.mp4 35.93 MB
098-Create_an_expanded_list_from_a_summary_using_PivotTable_techniques.mp4 36.74 MB
085-Alter_numeric_data_without_formulas.mp4 37.41 MB
047-Using_wildcards_(asterisk_tilde_and_question_mark).mp4 38.13 MB
105-Formula_nesting_Using_multiple_functions_in_the_same_formula.mp4 38.99 MB
048-Custom_formats_using_asterisk_semicolon_and_brackets.mp4 39.18 MB
036-Discovering_time_saving_tools_in_the_Go_To_Special_feature.mp4 40.04 MB
007-Using_check_boxes_and_Conditional_Formatting_together_for_dynamic_displays.mp4 40.45 MB
112-Working_with_hidden_data_when_copying_cells_and_creating_charts.mp4 40.93 MB
107-Use_the_Subtotal_command_to_analyze_data_with_single_or_multiple_level_subtotals.mp4 41.35 MB
137-Freezing_column_and_row_titles.mp4 41.85 MB
049-Meeting_unusual_filtering_needs_via_Advanced_Filter.mp4 47.68 MB
061-Working_with_formulas_in_tables.mp4 48.15 MB
051-Two_way_lookup_using_the_MATCH_and_INDEX_functions.mp4 50.68 MB
072-Keystroke_shortcuts_from_A_to_Z_using_the_Ctrl_key.mp4 55.03 MB
087-Adjust_banded_row_formatting.mp4 57.78 MB
Download Info
-
Tips
“(2015-2020) Excel Tips Weekly (Updated 07.04.2020)-IVY” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.