From the course: Excel Tips Weekly
Join today to access over 24,600 courses taught by industry experts.
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions - Microsoft Excel Tutorial
From the course: Excel Tips Weekly
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions
Play video to see the transcript
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
- 164_Percent_change_and_Goal_Seek.zip
- Ex_Files_Excel_Tips_Weekly_2018_Q2.zip
- 166_COUNT_COUNTA_and_Status_Bar.zip
- 165_Fill_in_Blanks.zip
- Ex_Files_Excel_Tips_Weekly_2018_Q3.zip
- 162_Freeze_Panes_and_Split_Screens.zip
- 203_Mixed_Cell_Addresses.zip
- 202_Worksheet_Protection.zip
- 161_Custom_Lists.zip
- 201_Error_Checking_Indicators.zip
- 205_Displaying_Large_Values.zip
- 163_NETWORKDAYS_and_WORKDAY.zip
- 204_Filter_by_Selection.zip
- 160_Date_Format_Conversions.zip
- 159_Number_Formats.zip
- 200_Linking_Pictures.zip
- 199_Charts_and_Filters.zip
- 198_Weekdays_and_Weekends.zip
- 197_Helpful_Keystroke_Shortcuts.zip
- 157_Comments_and_Reminders.zip
- 156_Date_Time_Formats.zip
- 196_Double_and_Triple_Spaced_Printing.zip
- 195_TRIM_and_CLEAN.zip
- 194_LEN_and_REPT.zip
- 158_Replace_Format_or_Content.zip
- 155_Default_Chart_Type_and_Chart_Templates.zip
- 154_Phone_and_ZipCode_Formats.zip
- 192_PivotTable_Settings.zip
- 151_Chart_gridlines_and_borders.zip
- 150_Mixed_References.zip
- 153_Expand_Collapse_PivotTables.zip
- 190_Solver.zip
- 152_INDIRECT_Intersection_RangeNames.zip
- 191_Columns_Widths.zip
- 149_Decimals_and_Fractions.zip
- 194_Watch_Window.zip
- 189_Alt_Key_Shortcuts.zip
- 123_Book1.zip
- 186_Sort_by_Moving_Columns.zip
- 185_Unintentional_Entries.zip
- 188_CONVERT_Function.zip
- 187_Cumulative_Totals.zip
- 184_Date_Calculations.zip
- 124_Quick_Charts.zip
- 183_New_Table_Style.zip
- 180_Table_Differences.zip
- 179_Date_Proximity_Formatting_final.zip
- 182_FormattingOptions.zip
- 181_Avoiding_DIV_Error.zip
- 126_INDEX_Function.zip
- 127_Display_Tips.zip
- 128_Wrap_text_Merge_Indent.zip
- 129_Fill_Effects.zip
- 125_Heat_Maps.zip
- 134_Two_Way_Lookups.zip
- 178_Adjusting_Names.zip
- 130_Multiple_Worksheets.zip
- 131_Other_Font_Options.zip
- 132_WordArt_Variations.zip
- 133_Weekday_Weekend.zip
- 175_ROMAN_ARABIC.zip
- 174_EXACT_FIND_SEARCH_Functions.zip
- 177_Customize_the_Quick_Access_Toolbar.zip
- 176_Range_Names.zip
- 135_Borders_Gridlines.zip
- 173_YEAR_MONTH_DAY_WEEKDAY.zip
- 172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip
- 189_Chart_based_on_a_Table.zip
- 169_PivotTable_Date_Grouping.zip
- 171_Zoom_and_Display_Variations.zip
- 170_Unique_and_Duplicate_Data.zip
- 168_Ranking_Data.zip
- 167_Excel_Sheet_Commands.zip
- Ex_Files_Excel_Tips_Weekly_2018_Q1.zip
- 206_ConditionalFormatting_and_DataValidation.zip
- 207_CheckBox_ConditionalFormatting.zip
- 208_Transpose.zip
- 209_Borders_Gridlines_Printing.zip
- 210_SmartArt.zip
- 211_GoTo_Special.zip
- 212_CEILINGandFLOOR.zip
- 213_Shapes_and_Stars.zip
- 214_Array_Constants_withVLOOKUP.zip
- 215_AdvancedFilter.zip
- 216_ArrayFormulaUpdates.zip
- 217_UNIQUE_function.zip
- 218_Sample_Data.zip
- 219_Utility_Macros.zip
- 220_SORT_and_SORTBY_Functions.zip
- 221_Themes.zip
- 222_Financial_Functions.zip
- 223_BlankCellsInCharts.zip
- 224_CondFormattingBreakpoints.zip
- 225_New_Formulas.zip
- 226_Sort_by_Color.zip
- 227_Special_Characters.zip
- 228_Icons.zip
- 229_Random_Functions.zip
- 230_Area_Charts.zip
- 231_People_Graph.zip
- 232_GrowingChart.zip
- 233_ScenarioManager.zip
- 234_Status_Bar.zip
- 235_Columns_and_Rows.zip
- 236_Dates_in_Charts.zip
- 237_Geographic_Maps.zip
- 238_Date_Time_Series.zip
- 239_Data_Validation_and_Filter.zip
- 240_Find_Select.zip
- 241_AverageCountSubscript.zip
- 242_CopyFormats.zip
- 243_XLOOKUP_Function.zip
- 244_PivotTable_Settings.zip
- 245_FilterYearDay.zip
- 246_Sheet_Names.zip
- 247_Phone_ZipFormats.zip
- 248_Time_Math.zip
- 249_Prevent_Locate_Duplicates.zip
- 250_EDate_EMonth_DatedIF.zip
- 251_Find_Highlight_Formula_cells.zip
- 252_Text_Columns_Flash_Fill.zip
- 253_Cumulative_Formulas.zip
- 254_XMATCH_Function.zip
- 255_Hidden_Visible_Data.zip
- 256_Macro_Highlight_Formula_Cells.zip
- 257_TODAY_NOW_Date_Functions.zip
- 258_Prevent_Duplicates.zip
- 259_Hide_cells_rows_columns_sheets.zip
- 260_Align_Arrange_Rotate_Shapes.zip
- 261_Worksheet_Statistics.zip
- 262_Re_scaling_Column_and_Line_Charts.zip
- 263_Fill_Justify_Wrap_Text.zip
- 264_Names_Based_On_Column_Row_Headings.zip
- 265_SUBSTITUTE_and_REPLACE_Functions.zip
- 266_Buttons_for_Conditional_Formatting.zip
- 267_Wildcards_Part_1_Filter_and_Commands.zip
- 268_Wildcards_Part_2_Functions_.zip
- 269_IFS_Function.zip
- 270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip
- 271_Protect_Cell_Ranges.zip
- 272_Geography_Data.zip
- 273_SEQUENCE_function.zip
- 274_LEN_SUBSTITUTE_and_TRIM_functions.zip
- 275_List_Box.zip
- 276_COUNT_COUNTA_and_COUNTBLANK_functions.zip
- 277_Banded_Rows_or_Columns.zip
- 278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip
- 279_SWITCH_function.zip
- 280_Chart_Design_Tools.zip
- 281_PivotTable_Analysis.zip
- 282_Subtotal.zip
- 283_AGGREGATE_Function.zip
- 284_The_F9_Key.zip
- 285_XLOOKUP_XMATCH.zip
- 286_Paste_Special_Options.zip
- 287_Data_Entry_Tips.zip
- 288_LET_function.zip
- 289_Create_Worksheets_Fast.zip
- 290_MovingAverage.zip
- 291_Error_Checking_Functions.zip
- 292_Line_Wrap_and_Wrap_Text.zip
- 293_Cell_Colors_Patterns_Effects.zip
- 294_Dynamic_Arrays.zip
- 295_Fonts.zip
- 296_3D_Formulas.zip
- 297_Date_Formats.zip
- 298_Cell_Precedents.zip
- 299_Date_Controls_with_Data_Validation.zip
- 300_Managing_Duplicate_Data.zip
- 301_New_Data_Types.zip
- 302_FILTER_and_UNIQUE_functions.zip
- 303_UPPER_lower_Proper.zip
- 304_Custom_Filter.zip
- 26_01_Column_and_Bar_Charts.zip
- 26_02_Powers_and_Roots.zip
- 26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip
- 26_04_Function_Names.zip
- 26_05_SUM_SUMPRODUCT_SUMIF.zip
- 26_06_Binary_Octal_Decimal_Hexadecimal.zip
- 26_07_Numeric_Formatting.zip
- 26_08_Dates_and_the_1930_2029_split.zip
- 26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip
- 26_10_Slicers_Analysis.zip
- 26_11_Heat_Maps.zip
- 26_12_Validation_with_UNIQUE_and_SORT_functions.zip
- 26_13_Clustered_vs_Stacked_Chart_Types.zip
- 27_01_XLOOKUP.zip
- 27_02_Update_Date_Entries.zip
- 27_03_Eliminate_Spaces_and_Special_Characters.zip
- 27_04_Create_Range_Names_From_Headings.zip
- 27_05_Date_Series_Creation.zip
- 27_06_LAMBDA_Function.zip
- 27_07_Goal_Seek.zip
- 27_08_Sort_by_Custom_List.zip
- 27_09_INDIRECT_function.zip
- 27_10_Holiday_Calculations.zip
- 27_11_Paste_Special_Drag_Options.zip
- 27_12_SS_Numbers.zip
- 28_01_Five_Invaluable_Keystroke_Shortcuts.zip
- 28_02_New_Formula_Techniques.zip
- 28_03_Time_differencees.zip
- 28_04_Zoom_Techniques.zip
- 28_05_Outlining_Tools.zip
- 28_06_Analyze_Data.zip
- 28_07_UNIQUE_Unique_vs_Distinct.zip
- 28_08_Screen_Snip.zip
- 28_09_Sunburst_Charts.zip
- 28_10_Shadow_Glow_Reflection.zip
- 28_11_Printing_Tips.zip
- 29_01_Data_Validation_Multiple_Criteria.zip
- 29_02_Quick_Access_Toolbar_QAT_Tips.zip
- 29_03_Treemap_Charts.zip
- 29_04_Quick_Analysis_Button.zip
- 29_05_Dragging_Number_Cells.zip
- 29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip
- 29_07_Hide_Unhide_Worksheets.zip
- 29_08_Fill_Justify_Re_wrap_text.zip
- 29_09_Date_Series_15th_and_Month_End.zip
- 29_10_Filling_Blank_Cells.zip
- 29_11_Sparklines_and_Conditional_Formatting.zip
- 29_12_Transpose.zip
- 30_01_Emojis_and_Pictures.zip
- 30_02_Advanced_Filter.zip
- 30_03_Combo_Charts.zip
- 30_04_MID_SEQUENCE_LEN_Functions.zip
- 30_05_PivotTable_Settings.zip
- 30_06_Navigation.zip
- 30_07_DATEDIF_Function.zip
- 30_08_Word_Art_Transform.zip
- 30_09_Dates_Months_Weekdays.zip
- 30_10_Linkage_Formulas.zip
- 30_11_XLOOKUP_Solutions.zip
- 30_12_TREND_and_GROWTH.zip
- 30_13_Stock_Charts.zip
- 31_01_Gridlines_On_Off.zip
- 31_02_Formulas_Changes.zip
- 31_03_Dependencies.zip
- 31_04_Replace_Formats.zip
- 31_05_Option_Buttons_and_Check_Boxes.zip
- 31_06_SORT_and_FILTER_Functions.zip
- 31_07_Moving_Average.zip
- 31_08_Data_Validation.zip
- 31_09_Picture_Links.zip
- 31_10_SUMIF_and_SUMIFS.zip
- 31_11_Multiple_PivotTables_from_one_source.zip
- 31_12_Conditional_Formatting_Icons.zip
- IMAGE_Function.zip
- 378_TOROW_and_TOCOL_functions.zip
- 379_Formulas_with_hidden_rows.zip
- 380_Bubble_charts.zip
- 381_CONCAT_TEXTJOIN_TEXTSPLIT_functions.zip
- 382_Shrink_to_fit_options.zip
- 383_Precedent_Cells.zip
- 384_Formula_editing.zip
- 385_Status_Bar_Control.zip
- 386_Sorting_Tips.zip
- 387_TEXTBEFORE_TEXTAFTER.zip
- 388_Quick_Chart_Titles.zip
- 390_TAKE_DROP_FILTER_SORTBY.zip
- 391_Pivot_Table_Detail.zip
- 392_Right_click_Filtering.zip
- 393_WRAPROWS_and_WRAPCOLS_Functions.zip
- 394_Dates_and_Times.zip
- 395_Creating_Charts_Quickly.zip
- 396_CHOOSEROWS_and_CHOOSECOLS_Functions.zip
- 397_Decimals_Rounding_Formulas.zip
- 398_Pivot_Table_Formatting.zip
- 399_DB_Functions.zip
- 400_Pie_Charts.zip
- 401_Quick_Sorting.zip
- 402_Charts_to_Pictures.zip
- 402_Tracking_Cell_Types.zip
- 403_BYROW_and_BYCOL_Functions.zip
- 404_Formula_Shortcuts.zip
- 405_3_D_Column_and_Bar_Chart.zip
- 406 _VSTACK_and_HSTACK_functions.zip
- 407_Calculating_by_Day_of_the_Week.zip
- 408_XMATCH_and_XLOOKUP.zip
- 409_Select_Cell_Ranges.zip
- 410_Inserting_Symbols.zip
- 411_Using_IS_Information_functions.zip
- 412_Using_LEFT_MID_TEXT_functions.zip
- 413_Edit_Go_To_Options.zip
- 414_Fiscal_Year_Calculations.zip
- 415_SORT_Left_Right.zip
- 416_Conditional_Formatting_Analysis.zip
- 417_Indenting.zip
- 418_FILTER_AND_OR_Functions.zip
- 419_Shapes_Linked_to_Worksheet_Cells.zip
- 420_Slicers_with_Charts.zip
- 421_Sort_by_Day_of_Month.zip
- 422_Wildcards.zip
- 423_FIND_SEARCH_COUNT_Functions.zip
- 424_Histogram_Charts.zip
- 425_AND_and_OR_Functions.zip
- 426_Flipping_Lists.zip
- 427_TEXTJOIN_CONCAT.zip
- 428_Excel_Options.zip
- 429_Alt_key_shortcuts.zip
- 430_COUNTIF_family.zip
- 431_Scatter_XY_Charts.zip
- 432_Tracking_Data_Validation.zip
- 433_AGGREGATE_Function.zip
- 434_Duplicate_Data.zip
- 435_SEQUENCE_Function.zip
- 436_Tables_Validation_XLOOKUP_Chart.zip
- 437_Stacked_Column_and_Area_Charts.zip
- 438_FILTER_SORT_and_CHOOSECOLS_functions.zip
- 440_New_Office_Theme.zip
- 441_TOCAL_LARGE_SMALL.zip
- 442_Chart_Quick_Layout_Options.zip
- 443_Display_and_Presentation_Tips.zip
- 444_WORKDAY_NETWORKDAYS_SEQUENCE.zip
- 445_Column_and_Row_References.zip
- 446_Accessibility.zip
- 447_XLOOKUP_multiple_column_return.zip
- 448_Charts_with_Filters_and_Slicers.zip
- 449_SORT_and_SORTBY_functions.zip
- 450_Navigation_Tools.zip
- 451_Using_RANK_and_LET_functions.zip
- 452_Conditional_Formatting_across_Rows.zip
- 453_PivotTable_Dates.zip
- 454_TODAY_and_NOW_Functions.zip
- 455_Freeze_and_Split.zip
- 456_Rounding_functions_CEILING_and_FLOOR.zip
- 457_Data_Bars.zip
- 458_AutoSum_Tips.zip
- 459_INDIRECT_Function.zip
- 460_Custom_Lists.zip
- 461_Split_Consolidate.zip
- 462_Subtotals.zip
- 463_Random_Functions.zip
- 464_Ten_Quick_Tips.zip
- 465_GROUPBY_and_PIVOTBY_Functions.zip
- 466_Formulas_based_on_different_worksheets.zip
- 467_Command_Locator.zip
- 468_Check_Box.zip
- 469_Paste_Values.zip
- 470_Chart_Array_SORT_FILTER.zip
- 471_Extract_data_from_picture.zip
- 472_Custom_Views.zip
- 473_PERCENTOF.zip
- 474_Navigation_Pane.zip
- 475_Shadow_Boxes.zip
- 476_Updating.zip
- 477_XLOOKUP_multiple_columns.zip
- 478_Forecast_Tool.zip
- 479_Default_Chart_Type_Chart Templates.zip
- 480_Group_Pivot_Table_Fields.zip
- 481_ISFORMULA_and_Formula_Auditing.zip
- 482_Filtering_with_Slicers.zip
- 483_TRANSPOSE.zip
- 484_Goal_Seek.zip
- 485_Repeating_Tiles.zip
- 486_SUBSTITUTE_and_REPLACE_functions.zip
- 487_Bar_Charts.zip
- 488_Selection_Pane.zip
- 489_Pivot_Table_Layouts.zip
- 490_Flash_Fill.zip
- 491_Cell_Protection_Schemes.zip
- 492_Number_Formats.zip
- 493_3D_Models.zip
- 494_COUNT_COUNTA_COUNTBLANK_ISBLANK.zip
- 495_PMT_and_FV_Functions.zip
- 496_GROUPBY_Function.zip
- 497_Check_Box_Conditional_Formatting.zip
- 498_Time_Math.zip
- 499_Alt_Key_Shortcuts.zip
- 500_PIVOTBY_Function.zip
- 501_Focus_Feature.zip
- 502_Custom_Lists.zip
- 503_Dragging_Techniques.zip
- 504_TRIMRANGE_and_new_address_symbol.zip
- 505_Shapes.zip
- 506_XMATCH_and_INDEX.zip
- 507_Files_Options_General_Settings.zip
- 508_SEQUENCE_Function.zip
- 509_Borders_Gridlines.zip
- 510_Database_Functions.zip
- 511_TAKE_Function.zip
- 512_Hidden_Visible_Data.zip
- 513_TRANSLATE_and_STCTLANGUAGE.zip
- 514_PivotTable_Time_based_Grouping.zip
- 515_FIND_MID_TEXTAFTER_TEXTBEFORE_Functions.zip
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
(Locked)
Group PivotTable data in different time frames, year, quarter, month, week, and more6m 41s
-
(Locked)
New TRANSLATE and DETECTLANGUAGE functions uses with foreign languages6m 6s
-
(Locked)
Working with hidden and visible data in filtered and subtotaled lists5m 27s
-
(Locked)
Exploring TAKE function capabilities, like replacing the INDEX function5m 59s
-
(Locked)
Exploring 12 overlooked database functions7m 13s
-
(Locked)
Contrasting uses of borders and gridlines in displays and printouts5m 52s
-
(Locked)
Creative and powerful uses of the SEQUENCE function for quick list creation7m 11s
-
(Locked)
Exploring Excel settings under the File Options General command6m 25s
-
(Locked)
Conditional Formatting with the INDEX and XMATCH functions6m
-
Creating and manipulating shapes using the Shift, Ctrl, and Alt keys5m 45s
-
(Locked)
Working with Excel's new TRIMRANGE function and trim references4m 45s
-
(Locked)
Accelerate copy/move/insert tasks with dragging techniques3m 52s
-
(Locked)
Create Custom Lists for specialized sorting and quick data entry for lists5m 29s
-
(Locked)
Exploring the new Focus Cell on the View tab5m 31s
-
(Locked)
Use the PIVOTBY function to aggregate values by row and column fields6m 30s
-
(Locked)
Using the Alt key for for faster menu access and for command shortcuts5m 19s
-
(Locked)
Calculating with hours, minutes, and times of day6m 51s
-
(Locked)
Use the new Check Box tool with conditional formatting for dynamic displays5m 38s
-
(Locked)
Using the GROUPBY function to create a summary of list data via formulas6m 30s
-
(Locked)
PMT and FV functions: Calculating monthly payments and earnings6m 47s
-
(Locked)
Use Excel's various count functions: COUNT, COUNTA, COUNTBLANK, and more5m 8s
-
(Locked)
Insert stock 3D models; move and resize similar images; rotate along three axes4m 30s
-
(Locked)
Create custom number formats: Display leading symbols, in thousands or millions6m 34s
-
(Locked)
Using the Allow Edit Ranges command to control cell editing by various users6m 37s
-
(Locked)
Using Flash Fill to automatically fill in data based on patterns6m 27s
-
(Locked)
Manipulating PivotTable layouts using Subtotals and Report Layout commands6m 1s
-
(Locked)
Manage worksheet objects with the Selection Pane (alt+F10)4m 37s
-
(Locked)
Benefits of using Bar charts: The horizontal version of Column charts5m 26s
-
(Locked)
Clean up and adjust data with the SUBSTITUTE and REPLACE functions6m 35s
-
(Locked)
Hide repeating title information to improve readability and restore missing titles6m 3s
-
(Locked)
Exploring multiple what-if type scenarios with Goal Seek options6m 59s
-
(Locked)
Transposing data, charts, and using the TRANSPOSE function6m 1s
-
(Locked)
Filtering lists with the dynamic and colorful slicer feature6m 57s
-
(Locked)
Using the ISFORMULA function and managing worksheet formula cells4m 47s
-
(Locked)
Group PivotTable fields on the fly: Create expand/collapse scenarios6m 25s
-
(Locked)
Creating chart templates and adjusting the default chart type6m 34s
-
(Locked)
Use the FORECAST sheet tool to create a new worksheet to predict data trends4m 55s
-
(Locked)
Using the powerful XLOOKUP function with multiple fields6m 9s
-
(Locked)
Updating and testing sample data (salaries, dates, etc.) quickly6m 8s
-
(Locked)
Adding shadow boxes to charts and other objects for flair and emphasis5m 8s
-
(Locked)
Calculating percentages using formulas and the new PERCENTOF function4m 44s
-
(Locked)
Create custom views7m 3s
-
(Locked)
Extracting data from an online image6m 17s
-
(Locked)
Use SORT and FILTER function to create charts based on dynamic arrays7m 44s
-
(Locked)
Using Ctrl+Shift+V and other quick methods to copy values without formulas5m 18s
-
(Locked)
Using the new Checkbox button on the Insert tab4m 13s
-
(Locked)
Quick searching for menu commands with the right mouse button3m 41s
-
(Locked)
Creating 3D and other formulas that use data from different worksheets7m 34s
-
(Locked)
Using the new GROUPBY and PIVOTBY functions6m 28s
-
(Locked)
Random number functions: RAND, RANDBETWEEN, and RANDARRAY5m 48s
-
(Locked)
Expand, collapse and sort displayed results when using Subtotal6m 39s
-
(Locked)
Consolidate and split workbooks5m 51s
-
(Locked)
Create custom and built-in lists to sort and fill in sequences8m 11s
-
(Locked)
Dynamic sheet name reference with INDIRECT5m 27s
-
(Locked)
Use AutoSum to simplify and accelerate formula creations4m 44s
-
(Locked)
Highlight negative positive values with Conditional Formatting and Data Bars5m 56s
-
(Locked)
Use CEILING and FLOOR for specialized numeric rounding needs6m 31s
-
(Locked)
Use Freeze Panes and Split to view different worksheet portions7m 19s
-
(Locked)
Use TODAY and NOW for real-time up-to-date calculations5m 9s
-
(Locked)
Expand and collapse date displays in PivotTables4m 19s
-
(Locked)
Apply conditional formatting across data rows7m 43s
-
(Locked)
Show gain/loss in census figures with the RANK, IF, and LET functions7m 28s
-
(Locked)
Use keystroke and mouse shortcuts to display and navigate worksheets7m 35s
-
(Locked)
Compare and contrast multiple column sorting with SORT and SORTBY9m 8s
-
(Locked)
Create dynamic presentations with Slicers, Filters, and Charts6m 39s
-
(Locked)
Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data6m 28s
-
(Locked)
Using Excel's Accessibility Checker to follow best practices for those with disabilities5m 10s
-
(Locked)
Using entire column (or row) references to create more dynamic formulas6m 51s
-
(Locked)
Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions6m 39s
-
(Locked)
Tips and techniques for displaying Excel worksheets effectively during presentations6m 51s
-
(Locked)
Refine chart elements quickly with the powerful and overlooked Quick Layout button5m 43s
-
(Locked)
Analyze data using TOCOL, TOROW, LARGE, and SMALL4m 49s
-
(Locked)
Learn about the new Office Theme, the default Aptos Font and new colors in M365 apps5m 7s
-
(Locked)
Nested use of FILTER, SORT, and CHOOSECOLS functions for selective column retrieval6m 41s
-
(Locked)
Pros and cons of using Stacked Area charts and Stacked Column Charts5m 7s
-
(Locked)
Combine a Validation list, XLOOKUP function, table, and chart to build a presentation model5m 10s
-
(Locked)
Use a single SEQUENCE function to create various date layouts5m 24s
-
(Locked)
Explore multiple approaches for locating, preventing, and deleting duplicate data5m 20s
-
(Locked)
Use AGGREGATE to avoid errors and ignore hidden data5m 52s
-
(Locked)
Locate and track a worksheet's Data Validation rules and violations5m 40s
-
(Locked)
Show relationships between sets of values with a Scatter(XY) Chart7m 4s
-
(Locked)
Use the powerful COUNTIF family—8 functions—for statistical analysis7m 18s
-
(Locked)
Use ALT and other shortcuts when working with AutoComplete, Data Validation, etc.4m 5s
-
(Locked)
Use Excel's Advanced Options to fine-tune settings and increase efficiency5m 19s
-
(Locked)
Combine data with the TEXTJOIN, CONCAT, and CONCATENATE5m 9s
-
(Locked)
Use various techniques to flip lists upside-down or left-to-right4m 52s
-
(Locked)
Using the AND and OR functions independently or within IF functions6m 25s
-
(Locked)
Comparing the Data Analysis Histogram feature and Excel's Histogram chart5m 9s
-
(Locked)
Using SEARCH, FIND, and COUNT to tabulate data occurrences4m 30s
-
(Locked)
Using wildcards (asterisk, question mark, and tilde) in formulas and commands7m 32s
-
(Locked)
Sorting by day of month for birthday and anniversary lists3m 34s
-
(Locked)
Dynamically presenting data via chart slicers5m 6s
-
(Locked)
Create shapes and text boxes with content linked to worksheet cells5m 2s
-
(Locked)
Using Indent buttons to control text displays and currency formatting3m 32s
-
(Locked)
Using Conditional Formatting for analysis and data emphasis6m 11s
-
(Locked)
Sorting by moving columns left/right - in tables, Pivot Tables, SORT and SORTBY5m 37s
-
(Locked)
Calculating chronological and fiscal quarters6m 10s
-
(Locked)
Discovering timesaving tools in the Go To Special feature6m 13s
-
(Locked)
Manipulating text functions LEFT, MID, and TEXT to create new ID numbers5m 10s
-
(Locked)
Reviewing Excel Information functions - ISBLANK, ISNUMBER, ISTEXT, etc.6m 31s
-
(Locked)
Inserting special symbols using AutoCorrect options and the Insert Symbol command6m 39s
-
(Locked)
Various techniques for highlighting (selecting) cell ranges quickly7m 25s
-
(Locked)
Contrasating uses of the newer functions: XMATCH and XLOOKUP7m 11s
-
(Locked)
Calculating day of the week totals from a large transaction list5m 27s
-
(Locked)
New VSTACK and HSTACK functions6m 35s
-
(Locked)
Exploring 3-D Column and 3-D Bar charts5m 55s
-
(Locked)
Create formulas rapidly with these shortcuts6m 50s
-
(Locked)
Using new BYROW and BYCOL functions to analyze data6m 25s
-
(Locked)
Using three functions to track worksheet cells that are text, numbers, or formulas6m 44s
-
(Locked)
Converting charts into pictures3m 50s
-
(Locked)
Rapid sorting via right-clicking options3m 20s
-
(Locked)
Advantages and disadvantages of using pie charts to display data4m 20s
-
(Locked)
An overview of the 12 database functions in Excel5m 21s
-
(Locked)
Highlighting PivotTable results with conditional formatting4m 42s
-
(Locked)
Overcoming rounding concerns in formulas with functions and decimal displays4m 13s
-
(Locked)
Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions5m 16s
-
(Locked)
Multiple tips for creating charts quickly5m 44s
-
(Locked)
Working with date and time-based data and the over-24-hour display issue5m 25s
-
(Locked)
Restructure column/row data using new WRAPROWS and WRAPCOLS functions6m 2s
-
(Locked)
Rapid filtering by content, cell color, or font color via right-clicking3m 31s
-
(Locked)
Create new lists by changing the PivotTable Report Layout to Tabular and adding repeating labels4m 10s
-
(Locked)
Use the TAKE, DROP, FILTER and SORTBY functions to build dependent lists6m 9s
-
(Locked)
Quickly link cell content for main titles and axis titles for selected chart types4m
-
(Locked)
Extract text from cells using the new TEXTBEFORE and TEXTAFTER functions4m 14s
-
(Locked)
Command and keystroke shortcuts for sorting frequently used data4m 57s
-
(Locked)
Customize and utilize status bar displays and copy/paste its data4m 57s
-
(Locked)
Try these editing tips and keystroke shortcuts to use with long formulas5m 38s
-
(Locked)
Locate formula precedents via keystroke shortcuts and the Trace Precedents command4m 5s
-
(Locked)
Use shrink-to-fit options to adjust the display of cell content and compress printed output4m 22s
-
(Locked)
Contrast TEXTJOIN, CONCAT, and TEXTSPLIT to gather and split data5m 47s
-
(Locked)
Use bubble charts to show relationships between sets of values5m 35s
-
(Locked)
Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows5m 3s
-
(Locked)
Use TOCOL and TOROW to realign array data into single columns and rows5m 28s
-
(Locked)
Use the IMAGE function to paste an image into a cell4m 40s
-
(Locked)
Explore icon sets in the Excel Conditional Formatting feature4m 46s
-
(Locked)
Create multiple PivotTables from a single source6m 47s
-
(Locked)
Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas5m 29s
-
(Locked)
Link pictures of data ranges to changing data4m 14s
-
(Locked)
Redesigned Data Validation feature: Now more efficient when using large lists4m 43s
-
(Locked)
Create a moving average with a chart or by using a formula4m 22s
-
(Locked)
Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data6m 2s
-
(Locked)
Create forms using check boxes and option buttons to simplify data entry5m 47s
-
(Locked)
Replace text based on formats, like cell attributes (bold, text color, etc.)5m 2s
-
(Locked)
Locate formula dependencies via keystroke shortcuts and the Trace Dependents command4m 48s
-
(Locked)
Examples of TRANSPOSE and other functions working differently with the new calculation engine5m 18s
-
(Locked)
Control gridlines: Change colors, turn them on/off, and assign to a macro button4m 50s
-
(Locked)
Stock charts: Adding Open, High, Low, Close, and Volume values4m 49s
-
(Locked)
Use dragging techniques to create a forecast based on TREND and GROWTH functions5m 25s
-
(Locked)
Use XLOOKUP instead of complex combinations of VLOOKUP, INDEX, and MATCH5m 41s
-
(Locked)
Use formulas to calculate values across worksheets and workbooks6m 32s
-
(Locked)
Sort data based on months and weekdays, even when entered as text5m 36s
-
(Locked)
WordArt Transform: Special text character layouts5m 24s
-
(Locked)
Use DATEDIF to calculate months or days after yearly or monthly anniversaries5m 18s
-
(Locked)
Navigation tips: Shortcuts to jump within and between worksheets and workbooks5m 44s
-
(Locked)
Exploring Edit Default Layout options when using PivotTables4m 28s
-
(Locked)
Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells6m 29s
-
(Locked)
Combo charts: Combine different chart types to present data more clearly5m 33s
-
(Locked)
Use the Advanced Filter for specialized filtering needs5m 48s
-
(Locked)
Use emojis and other symbols in formulas and charts5m 50s
-
(Locked)
Transpose data with formula substitution and the TRANSPOSE function4m 34s
-
(Locked)
Accentuate values with conditional formatting and sparklines6m 10s
-
(Locked)
Use the Go To Special option to select and populate blank cells5m 4s
-
(Locked)
Create a 15th day or end-of-month series and adjust to weekdays only4m 27s
-
(Locked)
Use the Fill Justify command to quickly rewrap text into different cells3m 45s
-
(Locked)
Unhide multiple worksheets at once and use the very hidden option5m 5s
-
(Locked)
Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales4m 51s
-
(Locked)
Create a number series with the Ctrl key and left/right mouse button5m 56s
-
(Locked)
Use the Quick Analysis tool for easy access to power tools3m 36s
-
(Locked)
Exploring treemap charts to display hierarchical data6m 5s
-
(Locked)
Customize the Quick Access Toolbar using the Alt key or a mouse5m 44s
-
(Locked)
Use Data Validation based on multiple criteria5m 38s
-
(Locked)
Page Setup tip: Print repeating titles, shrink-to-fit, landscape/portrait, double-spaced layout6m 4s
-
(Locked)
Creating floating text boxes with shadow, reflection, glow, and other shape effects4m 27s
-
(Locked)
Exploring Excel's Sunburst chart to display hierarchical data5m 5s
-
(Locked)
Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it4m 29s
-
(Locked)
Using the Distinct vs. Unique options when using the UNIQUE function4m 58s
-
(Locked)
Get data analysis suggestions with the Analyze Data (formerly Ideas) tool5m 41s
-
(Locked)
Make dynamic presentations with rapid expand/collapse detail features in outlining5m 54s
-
(Locked)
Use keyboard, mouse, and commands to zoom in/out quickly in Excel Windows and Mac versions5m 45s
-
(Locked)
Calculate time differences within days and across multiple days6m 26s
-
(Locked)
Using new formula-writing techniques to simplify wide-ranging formulas6m 6s
-
(Locked)
Five indispensable keystroke shortcuts for Windows and Mac users5m 35s
-
(Locked)
How to use and not use SS numbers; fake SS numbers; display as XXX-XX-99994m 51s
-
(Locked)
Use dragging techniques for faster Paste Special options5m 12s
-
(Locked)
Calculate dates and/or days of the week for selected future holidays4m 6s
-
(Locked)
Create a dynamic sheet name reference with the INDIRECT function4m 41s
-
(Locked)
Sort your data based on a Custom List that you define5m 43s
-
(Locked)
Get the formula results you want using Goal Seek5m 7s
-
(Locked)
Use the LAMBDA function to create worksheet functions6m 27s
-
(Locked)
Use dragging techniques to extend dates by weekdays only, month, or year3m 55s
-
(Locked)
Create multiple range names from the top row and/or left column5m 47s
-
(Locked)
Using TRIM, CLEAN and other functions to clean up text data5m 47s
-
(Locked)
Filtering lists with AND and OR criteria when using the FILTER function4m 29s
-
(Locked)
Tips for updating entire columns of date entries when using real or sample data4m 15s
-
(Locked)
Use the XLOOKUP function with multiple column criteria and multiple column results4m 39s
-
(Locked)
Contrasting uses of clustered column and stacked column charts6m 57s
-
(Locked)
Create dynamic pick lists using the UNIQUE and SORT functions, and data validation6m 11s
-
(Locked)
Conditional formatting using contrasting heat maps on multiple vs.single ranges5m 44s
-
(Locked)
Using slicers as analytical tools6m 2s
-
(Locked)
Using wildcards in the new XLOOKUP and XMATCH functions5m 56s
-
(Locked)
Date calculation and formatting issues related to the 2029/2030 switch4m 34s
-
(Locked)
Quick number formatting with keystroke shortcuts and icon buttons7m 7s
-
(Locked)
Conversion of values into binary, octal, decimal, and hexadecimal equivalents4m 30s
-
(Locked)
SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted6m 37s
-
(Locked)
Tips for saving time when typing function names6m 38s
-
(Locked)
Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions4m 18s
-
(Locked)
How to use exponentiation (powers and roots) in Excel formulas5m 50s
-
(Locked)
Comparing column charts and bar charts: Pros and cons6m 28s
-
(Locked)
Refine filtering needs via custom filter options5m 55s
-
(Locked)
Adjusting text entries with the UPPER, LOWER, and PROPER functions4m 55s
-
(Locked)
Use the FILTER and UNIQUE functions together for dynamic extractions5m 1s
-
(Locked)
New data types: Extract valuable online data into your worksheets5m 9s
-
(Locked)
Remove duplicates from a list vs. creating a new list without duplicates4m 26s
-
(Locked)
Controlling date entry restrictions using data validation3m 59s
-
(Locked)
Where does that cell get its data from?: Tracking down cell precedents4m 15s
-
(Locked)
Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy6m 24s
-
(Locked)
Use 3D formulas to tabulate data from multiple worksheets with the same layout6m 36s
-
(Locked)
Fonts such as Arial and Calibri and a rundown of various available fonts in Excel6m 5s
-
(Locked)
Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells5m 27s
-
(Locked)
Work with cell colors, patterns, and effects to emphasize data and provide visual flair4m 34s
-
(Locked)
Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability5m 26s
-
(Locked)
Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR6m 5s
-
(Locked)
Create moving averages with formulas and chart trendlines5m 47s
-
(Locked)
Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash4m 35s
-
(Locked)
Using the LET function to simplify formulas via programming concepts5m 4s
-
(Locked)
Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect5m 56s
-
(Locked)
Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more5m 54s
-
(Locked)
Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH4m 29s
-
(Locked)
Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration6m 11s
-
(Locked)
Use the AGGREGATE function to circumvent errors and ignore hidden data5m 17s
-
(Locked)
Expand/collapse or sort displayed results when using the SUBTOTAL command5m 18s
-
(Locked)
Analyze PivotTable data with 13 different Show Values As options5m 10s
-
(Locked)
Adjust charts quickly with quick layout, change colors, and chart styles options4m 39s
-
(Locked)
Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions5m 48s
-
(Locked)
Seven different ways to drag data using the Ctrl, Shift, and Alt keys6m 3s
-
(Locked)
Enhance readability with banded rows via conditional formatting5m 25s
-
(Locked)
Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more5m 36s
-
(Locked)
Create a list box to facilitate selection of data from a list5m 35s
-
(Locked)
Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions6m 19s
-
(Locked)
Use the new SEQUENCE function to quickly build numeric and date arrays5m 46s
-
(Locked)
Retrieve vital data based on location using the Geography tool5m 2s
-
(Locked)
Control worksheet security by allowing selected users to edit specific cell ranges5m 43s
-
(Locked)
Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more6m 18s
-
(Locked)
Condense lengthy nested IF functions with the newer IFS function4m 43s
-
(Locked)
Use wildcard symbols in filtering and commands6m 7s
-
(Locked)
Use wildcard symbols in functions5m 14s
-
(Locked)
Accelerate Conditional Formatting with the Quick Access Toolbar4m 15s
-
(Locked)
Use the SUBSTITUTE and REPLACE functions4m 47s
-
(Locked)
Create range names from Column and Row headings3m 51s
-
(Locked)
Use the Fill Justify feature to wrap long text4m 2s
-
(Locked)
Avoid misleading visuals when rescaling5m 16s
-
(Locked)
File documentation with the Workbook Statistics button4m 22s
-
(Locked)
Align, arrange, and rotate shapes in worksheets5m 40s
-
(Locked)
Use various techniques to hide cells, rows, columns, and worksheets4m 56s
-
(Locked)
Use data validation rules to prevent duplicate entries in a range4m 38s
-
(Locked)
Use TODAY, NOW, YEARFRAC, and DATEDIF6m 17s
-
(Locked)
Work with hidden and visible data in filtered and subtotaled lists5m 54s
-
(Locked)
Create a powerful macro4m 40s
-
(Locked)
Use the XMATCH function to replace MATCH3m 43s
-
(Locked)
Highlight milestone data with conditional formatting and cumulative formulas5m 38s
-
(Locked)
Split or join columnar data with Text to Columns or Flash Fill4m 55s
-
(Locked)
Display and highlight worksheet formula cells5m 46s
-
(Locked)
Look forward and backward using EDATE and other date functions5m 37s
-
(Locked)
Prevent and locate duplicate worksheet entries4m 41s
-
(Locked)
Work with time calculations in formulas5m 14s
-
(Locked)
Use data validation rules with special phone and social security formats5m 44s
-
(Locked)
Use worksheet names in formulas5m 31s
-
(Locked)
Use the Excel filtering capability for dates4m 57s
-
(Locked)
Change PivotTable settings for titles and summaries5m 58s
-
(Locked)
Use the XLOOKUP function to replace VLOOKUP5m 23s
-
(Locked)
Add formula tools and symbols to the Quick Access Toolbar5m 12s
-
(Locked)
Use Find and Replace to change cell contents and formats6m 12s
-
(Locked)
Extract filtered data with data validation and the FILTER function4m 34s
-
(Locked)
Techniques for creating date series4m 42s
-
(Locked)
Create map-type charts based on geographical locations4m 19s
-
(Locked)
Overcoming obstacles when working with dates in charts4m 45s
-
(Locked)
Use column or row references to create dynamic formulas4m 31s
-
(Locked)
Get totals quickly without creating formulas5m 2s
-
(Locked)
Track variables using the Scenario Manager4m 43s
-
(Locked)
Use formulas to create interactive charts5m 32s
-
(Locked)
Insert colorful images with the People Graph Add-in5m 37s
-
(Locked)
How and when to use an area chart4m 16s
-
(Locked)
Use the new RANDARRAY function that replaces RAND and RANDBETWEEN6m 26s
-
(Locked)
Select from over 800 icons to enliven worksheets6m 29s
-
(Locked)
Simplify the use of special characters and symbols5m 24s
-
(Locked)
Sort or filter data based on color font or cell color background5m 50s
-
(Locked)
Discover new formula capabilities with new functions and dynamic arrays5m 6s
-
(Locked)
Adjust Conditional Formatting rules by altering percentage breakpoints4m 36s
-
(Locked)
Chart display options with blank cells in source data4m 25s
-
(Locked)
Calculate loan payments and investments with PMT and FV functions6m 16s
-
(Locked)
Use themes to adjust worksheet colors, fonts, and effects3m 42s
-
(Locked)
Use the new SORT and SORTBY functions to extract sorted lists5m 44s
-
(Locked)
Format macros to make you a more efficient Excel user5m 23s
-
(Locked)
Creating and updating sample data5m 43s
-
(Locked)
Using the new UNIQUE function to count and copy unique list entries3m 36s
-
(Locked)
Working with array formulas more easily4m 23s
-
(Locked)
Tabulating totals with the VLOOKUP function and array constants5m 12s
-
(Locked)
Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners5m 39s
-
(Locked)
Using the CEILING and FLOOR functions for specialized rounding needs5m 16s
-
(Locked)
Exploring some of the 200-plus SmartArt graphic options4m 1s
-
(Locked)
Displaying gridlines, borders, and column/row headings when printing4m 37s
-
(Locked)
Transposing data and using the TRANSPOSE function5m 43s
-
(Locked)
Tracking down conditional formatting and data validation rules5m 42s
-
(Locked)
Display large values5m 16s
-
(Locked)
Rapid filtering with Filter by Selection3m 45s
-
(Locked)
Use mixed addresses in Excel formulas5m 35s
-
(Locked)
Protect worksheets and lock cells5m 24s
-
(Locked)
How to use the error-checking rules in Excel4m 59s
-
(Locked)
Create picture links5m 37s
-
(Locked)
Use chart and filter for presentations4m 9s
-
(Locked)
Identify weekdays and weekend days in data4m 50s
-
(Locked)
Helpful keystroke shortcuts5m 2s
-
(Locked)
Create double-spaced and triple-spaced printouts while repeating column headings4m 13s
-
(Locked)
Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters5m 6s
-
(Locked)
Use the LEN and REPT functions for specialized cell testing and display options4m 4s
-
(Locked)
Auditing cell content with Watch Window and dependent cell formulas4m 21s
-
(Locked)
Adjusting default layouts and date grouping in PivotTables4m 14s
-
(Locked)
Column widths, row heights, merging cells, and related formatting issues5m 1s
-
(Locked)
Using the Solver Add-in4m 29s
-
(Locked)
Keystroke shortcuts using the Alt key5m 20s
-
(Locked)
Creating an automatically expanding chart by basing it on a table4m 24s
-
(Locked)
Using the CONVERT function for different numbering systems4m 56s
-
(Locked)
Calculating cumulative totals3m 52s
-
(Locked)
Sorting by moving columns4m 16s
-
(Locked)
Avoid unintentional entries when typing code numbers4m 29s
-
(Locked)
Use date functions for age and tenure calculations5m 23s
-
(Locked)
Control table formatting with custom formats3m 12s
-
(Locked)
Explore formatting options not available on the Home tab4m 25s
-
(Locked)
Avoid the #DIV/0 error message4m 56s
-
(Locked)
Differences and limitations of converting data to a table5m 17s
-
(Locked)
How to adjust names5m 45s
-
(Locked)
Conditional formatting based on date proximity4m 51s
-
(Locked)
Customize your Quick Access Toolbar6m 7s
-
(Locked)
Use range names for more readable formulas5m 38s
-
(Locked)
How to covert ROMAN numberals4m 25s
-
(Locked)
Compare data with EXACT, FIND, and SEARCH functions4m 58s
-
(Locked)
Extract day, month, and year from date fields5m 7s
-
(Locked)
Create artistic charts with random numbers7m 23s
-
(Locked)
Keyboard, mouse, and command techniques for viewing worksheets5m 18s
-
(Locked)
Identify or extract unique entries in a list5m 22s
-
(Locked)
Use nonstandard fiscal years and quarters in PivotTables5m 35s
-
(Locked)
Rank data with the RANK and RANK.AVG functions5m 37s
-
(Locked)
Use workbook protection to prevent use of sheet commands5m 27s
-
(Locked)
Use the COUNT and COUNTA functions4m 19s
-
(Locked)
Fill in all blank cells within a range with either formatting or data4m 13s
-
(Locked)
Calculate % of change5m 41s
-
(Locked)
NETWORKDAYS.INTL and WORKDAY.INTL5m 29s
-
(Locked)
Freeze Panes and Split5m 30s
-
(Locked)
Create custom lists for letter series like A to Z6m 26s
-
(Locked)
Converting dates like 20102006 into usable date entries4m 25s
-
(Locked)
Create numeric formats: Display in thousands or millions11m 40s
-
(Locked)
Use REPLACE for formats only, for data only, or for both6m 11s
-
(Locked)
Create on-screen warnings and reminders with comments or data validation messages6m 18s
-
(Locked)
Create your own customized date and time formats7m 31s
-
(Locked)
Change the default Excel chart type; create and use chart templates6m 13s
-
(Locked)
Control phone number and postal code formats using built-in options or customized formats7m 40s
-
(Locked)
Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes7m 14s
-
(Locked)
Use the INDIRECT function with intersection formulas and range names to extract data6m 34s
-
(Locked)
Control gridlines in charts and on worksheets7m 45s
-
(Locked)
Creating mixed reference formulas; converting to a table; applying conditional formatting8m 6s
-
(Locked)
Work with formulas and formats: Decimals and fractions5m 42s
-
(Locked)
A look at new chart types in Excel 2016: Waterfall6m 57s
-
(Locked)
Sorting tips and shortcuts8m 40s
-
(Locked)
Vertical and horizontal alignment settings and orientation options7m 12s
-
(Locked)
Using the AND and OR functions independently or within IF functions9m 58s
-
(Locked)
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10m 8s
-
(Locked)
Creating cross-totals with the SUMIFS function and mixed references5m 50s
-
(Locked)
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!9m 39s
-
(Locked)
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character6m 1s
-
(Locked)
Use the new funnel chart available in Excel 3654m 3s
-
(Locked)
Avoiding common chart distortions11m 49s
-
(Locked)
Use data validation to force entries to be uppercase or lowercase10m 48s
-
(Locked)
Freezing column and row titles7m 48s
-
(Locked)
New Excel 2016 chart types: Tree map and sunburst7m 29s
-
(Locked)
Borders and gridlines: Exploring variations, options, and differences8m 24s
-
(Locked)
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions7m 34s
-
(Locked)
Using WordArt for special titles and headings4m 33s
-
(Locked)
Exploring font choices not found on the Home tab4m 2s
-
(Locked)
Working with multiple worksheets simultaneously8m 42s
-
(Locked)
Using fill effects (gradients, patterns, styles) for colorful cell background variations5m 10s
-
(Locked)
The Wrap Text, Merge and Center, and Indent options9m 2s
-
(Locked)
Displaying tips when using Excel in presentations6m 23s
-
(Locked)
Using the INDEX function to extract data by row and column11m 1s
-
(Locked)
Creating heat maps using conditional formatting8m 31s
-
(Locked)
Tips for creating charts quickly6m 56s
-
(Locked)
Dealing with circular errors8m 20s
-
(Locked)
Use custom formulas in data validation to keep out bad data13m 18s
-
(Locked)
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions8m 40s
-
(Locked)
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas6m 59s
-
(Locked)
Summarize data from different worksheets with a PivotTable7m 20s
-
(Locked)
Use VLOOKUP, MATCH, and INDEX functions with array formulas10m 38s
-
(Locked)
Use conditional formatting to overcome formatting limitations of the IF function8m 54s
-
(Locked)
Tips for creating and updating sample data11m 1s
-
(Locked)
Displaying multiple worksheets and workbooks together10m 13s
-
(Locked)
Copy formats quickly using dragging techniques and the Format Painter5m 25s
-
(Locked)
Creative use of sparklines in merged cells with axes7m 1s
-
(Locked)
Use conditional formatting data bars to accentuate negative data4m 16s
-
(Locked)
Working with hidden data when copying cells and creating charts10m 58s
-
(Locked)
Flip the left-to-right order of columns with the INDEX function or sort by columns8m 18s
-
(Locked)
Use the FIND, MID, LEFT, and RIGHT functions10m 38s
-
(Locked)
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations9m 24s
-
(Locked)
Work with MAX, MAXIFS, LARGE, and related functions8m 14s
-
(Locked)
Use the Subtotal command to analyze data with single- or multiple-level subtotals9m 15s
-
(Locked)
Keyboard shortcuts for numeric formats8m 18s
-
(Locked)
Formula nesting: Using multiple functions in the same formula13m 22s
-
(Locked)
Create linkage formulas that refer to other worksheets and workbooks11m 49s
-
(Locked)
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series10m 44s
-
(Locked)
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting9m 59s
-
(Locked)
Use outlining tools to quickly expand and collapse data for dynamic presentations9m 19s
-
(Locked)
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative7m 27s
-
(Locked)
Solve matching issues with matching phone numbers and SS numbers10m
-
(Locked)
Create an expanded list from a summary using PivotTable techniques7m 25s
-
(Locked)
How to create frequency tabulations and distributions8m 10s
-
(Locked)
How to create time interval entries11m 39s
-
(Locked)
Use Watch Window and other techniques to track changing cells8m 21s
-
(Locked)
Insert a text box or shape and link a cell's content to it6m 58s
-
(Locked)
Accelerate data entry with five special techniques12m 8s
-
(Locked)
Activate the Speak On Enter and Speak Cells features5m 38s
-
(Locked)
How to use mixed cell references8m 25s
-
(Locked)
Calculate faster with the AutoSum button and AutoSum keystroke shortcut6m 54s
-
(Locked)
How and when to use the 10 rounding functions in Excel13m 26s
-
(Locked)
Change the shape of comment boxes and other objects6m 32s
-
(Locked)
Adjust banded-row formatting14m 35s
-
(Locked)
Use Flash Fill to rapidly combine or separate columnar data10m 28s
-
(Locked)
Alter numeric data without formulas10m 19s
-
(Locked)
Use the OFFSET function for tabulating moving data11m 23s
-
(Locked)
Adjust a chart's source data and adjust its series order9m 7s
-
(Locked)
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions8m 12s
-
(Locked)
Save a chart as a template: Use the template for current or new charts6m 2s
-
(Locked)
Use slicers and charts together for dynamic presentations9m 4s
-
(Locked)
Hide worksheets, row, columns, cells and other Excel elements7m 26s
-
(Locked)
Avoid errors and hidden data with the powerful AGGREGATE function7m 8s
-
(Locked)
Create dynamic sheet name references with the INDIRECT function6m 45s
-
(Locked)
Calculate dates efficiently using Excel's hidden function - DATEDIF7m 36s
-
(Locked)
Creating an Excel template to simplify updating a monthly file7m 10s
-
(Locked)
Use a data form for data entry and exploring data6m 42s
-
(Locked)
Use special tricks for working with dates in charts11m 36s
-
(Locked)
Keystroke shortcuts from A to Z: Using the Ctrl key16m 16s
-
(Locked)
Work with formulas in tables9m 3s
-
(Locked)
Replace characters by position with the REPLACE function5m 46s
-
(Locked)
Use calcuated fields and calculated items in a PivotTable8m 57s
-
(Locked)
Use random number functions for sorting and creating sample data9m 57s
-
(Locked)
Set up a macro for sorting dynamic data8m 42s
-
(Locked)
Using command shortcuts with the Alt key5m 51s
-
(Locked)
Creating a pick list dependent on another pick list6m 59s
-
(Locked)
Restoring missing column titles6m 41s
-
(Locked)
Creating an Excel template7m 57s
-
(Locked)
Locating data validation rules and violations7m 20s
-
(Locked)
Working with formulas in tables13m 2s
-
(Locked)
Join data with new CONCAT and TEXTJOIN functions6m 15s
-
(Locked)
ADDRESS, ROW, and COLUMN functions8m 8s
-
(Locked)
Adding pictures as worksheet backgrounds4m 15s
-
(Locked)
Building a flexible monthly table using functions11m 44s
-
(Locked)
Drawing borders and border grids5m 45s
-
(Locked)
Adding comments and shapes7m 35s
-
(Locked)
Auditing9m 1s
-
(Locked)
Custom formats, relative addressing, and conditional formatting8m 26s
-
(Locked)
Using Excel error-checking functions10m 37s
-
(Locked)
Two-way lookup using the MATCH and INDEX functions11m 28s
-
(Locked)
Create an organization chart8m 56s
-
(Locked)
Meeting unusual filtering needs via Advanced Filter5m 28s
-
(Locked)
Custom formats using asterisk, semicolon, and brackets13m
-
(Locked)
Using wildcards (asterisk, tilde, and question mark)11m
-
(Locked)
View all worksheet names with new Navigation pane on the View tab4m 9s
-
(Locked)
Ten quick tips to use daily: formulas, formatting, and accessing commands6m 32s
-
(Locked)
Handling dates with unusual formats6m 5s
-
(Locked)
Creating variable conditional formatting rules8m 4s
-
(Locked)
Creating text, numerical, date, and time lists in a flash6m 54s
-
(Locked)
Exploring what-if scenarios using Goal Seek9m 55s
-
(Locked)
Using option buttons, group boxes, and checkboxes to facilitate forms creation8m 7s
-
(Locked)
Controlling worksheet security by allowing selected users to edit specific cell ranges7m 22s
-
(Locked)
Using hyperlinks for rapidly switching worksheet locations and jumping to websites7m 18s
-
(Locked)
Setting up custom views for quick access to different worksheet displays6m 30s
-
(Locked)
Reducing data entry time by expanding AutoCorrect options6m 10s
-
(Locked)
Using Go To Special6m 1s
-
(Locked)
Discovering time-saving tools in the Go To Special feature11m 22s
-
(Locked)
Tracking down cell dependencies across multiple worksheets and workbooks6m 24s
-
(Locked)
Calculating with hours, minutes, and times of day11m 2s
-
(Locked)
Creating colorful 3D buttons for worksheet annotation and macro buttons6m 52s
-
(Locked)
Using scroll bars and spin buttons to facilitate forms creation10m 1s
-
(Locked)
Using the TREND and GROWTH functions for projecting future results5m 54s
-
(Locked)
The top five unknown but useful keyboard shortcuts6m 17s
-
(Locked)
Quick formatting tips8m 9s
-
(Locked)
Custom grouping in PivotTables4m 31s
-
(Locked)
Converting charts into pictures4m 51s
-
(Locked)
Enhancing table filtering with slicers5m 23s
-
(Locked)
Creating dynamic charts with in-cell conditional formatting3m 26s
-
(Locked)
Customizing templates to fit your unique needs6m 6s
-
(Locked)
Highlighting PivotTable results with conditional formatting6m 10s
-
(Locked)
Increasing your productivity with custom lists5m 9s
-
(Locked)
Accelerating Cut, Copy, Paste, and Insert tasks7m 26s
-
(Locked)
Using source data from a table to make your PivotTable more dynamic7m 8s
-
(Locked)
Using the REPT function to represent data visually3m 6s
-
(Locked)
Parsing your data to create unique lists3m 21s
-
(Locked)
Dynamically presenting data via chart slicers7m 15s
-
(Locked)
Using formulas to calculate values across worksheets and workbooks11m 12s
-
(Locked)
Using a pick list, VLOOKUP, table, and chart together8m 5s
-
(Locked)
Adding illustrations to your workbook12m 7s
-
(Locked)
Using date and time as metrics in a PivotTable6m 53s
-
(Locked)
Splitting and consolidating workbooks6m 47s
-
(Locked)
Exploring various layouts for your PivotTable4m 27s
-
(Locked)
Applying conditional formatting across rows of data6m 43s
-
(Locked)
Transposing data and charts for a different perspective on your data8m 57s
-
(Locked)
Becoming more productive with these 10 tiny tips you'll use often8m
-
(Locked)
Using check boxes and conditional formatting together for dynamic displays5m 58s
-
(Locked)
Summarizing data from diverse ranges with Data > Consolidate9m 33s
-
(Locked)
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells7m 55s
-
(Locked)
Using the FORMULATEXT and N functions for worksheet and formula documentation5m 53s
-
(Locked)
Using list boxes and combo boxes to facilitate forms creation7m 36s
-
(Locked)
Resizing, moving, copying, and manipulating charts and other objects10m 17s
-
(Locked)
Hide and unhide worksheets securely6m 6s
-
(Locked)