From the course: Excel Tips Weekly
Unlock this course with a free trial
Join today to access over 23,700 courses taught by industry experts.
Tracking down conditional formatting and data validation rules - Microsoft Excel Tutorial
From the course: Excel Tips Weekly
Tracking down conditional formatting and data validation rules
- [Instructor] Excel has two different features, 2 not related to one another. 3 One allows us to control the appearance 4 of sales and worksheets. 5 The other controls the actual content. 6 Conditional Formatting found on the home tab has a variety 7 of tools for highlighting data. 8 On the Data tab in the ribbon, 9 we've got Data Validation that allows us 10 to control the content. 11 Now imagine this workbook was sent to you. 12 You may or may not be familiar with those tools. 13 One thing that annoys you perhaps is 14 in column G we've got some colored backgrounds here. 15 Let's get rid of those. 16 What you might consider at least at first, 17 click column G. 18 On the Home tab, 19 go to the Fill Color bucket, 20 click the drop arrow and choose No Fill. 21 And what happens? 22 Change occurs in cell G1, 23 but these colors are still here. 24 Now at this point you probably would know 25 or have to know that…
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
Contents
-
-
-
(Locked)
Hide and unhide worksheets securely6m 6s
-
(Locked)
Resizing, moving, copying, and manipulating charts and other objects10m 17s
-
(Locked)
Using list boxes and combo boxes to facilitate forms creation7m 36s
-
(Locked)
Using the FORMULATEXT and N functions for worksheet and formula documentation5m 53s
-
(Locked)
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells7m 55s
-
(Locked)
Summarizing data from diverse ranges with Data > Consolidate9m 33s
-
(Locked)
Using check boxes and conditional formatting together for dynamic displays5m 58s
-
(Locked)
Becoming more productive with these 10 tiny tips you'll use often8m
-
(Locked)
Transposing data and charts for a different perspective on your data8m 57s
-
(Locked)
Applying conditional formatting across rows of data6m 43s
-
(Locked)
Exploring various layouts for your PivotTable4m 27s
-
(Locked)
Splitting and consolidating workbooks6m 47s
-
(Locked)
Using date and time as metrics in a PivotTable6m 53s
-
(Locked)
Adding illustrations to your workbook12m 7s
-
(Locked)
Using a pick list, VLOOKUP, table, and chart together8m 5s
-
(Locked)
Using formulas to calculate values across worksheets and workbooks11m 12s
-
(Locked)
Dynamically presenting data via chart slicers7m 15s
-
(Locked)
Parsing your data to create unique lists3m 21s
-
(Locked)
Using the REPT function to represent data visually3m 6s
-
(Locked)
Using source data from a table to make your PivotTable more dynamic7m 8s
-
(Locked)
Accelerating Cut, Copy, Paste, and Insert tasks7m 26s
-
(Locked)
Increasing your productivity with custom lists5m 9s
-
(Locked)
Highlighting PivotTable results with conditional formatting6m 10s
-
(Locked)
Customizing templates to fit your unique needs6m 6s
-
(Locked)
Creating dynamic charts with in-cell conditional formatting3m 26s
-
(Locked)
Enhancing table filtering with slicers5m 23s
-
(Locked)
Converting charts into pictures4m 51s
-
(Locked)
Custom grouping in PivotTables4m 31s
-
(Locked)
Quick formatting tips8m 9s
-
(Locked)
The top five unknown but useful keyboard shortcuts6m 17s
-
(Locked)
Using the TREND and GROWTH functions for projecting future results5m 54s
-
(Locked)
Using scroll bars and spin buttons to facilitate forms creation10m 1s
-
(Locked)
Creating colorful 3D buttons for worksheet annotation and macro buttons6m 52s
-
(Locked)
Calculating with hours, minutes, and times of day11m 2s
-
(Locked)
Tracking down cell dependencies across multiple worksheets and workbooks6m 24s
-
(Locked)
Discovering time-saving tools in the Go To Special feature11m 22s
-
(Locked)
Using Go To Special6m 1s
-
(Locked)
Reducing data entry time by expanding AutoCorrect options6m 10s
-
(Locked)
Setting up custom views for quick access to different worksheet displays6m 30s
-
(Locked)
Using hyperlinks for rapidly switching worksheet locations and jumping to websites7m 18s
-
(Locked)
Controlling worksheet security by allowing selected users to edit specific cell ranges7m 22s
-
(Locked)
Using option buttons, group boxes, and checkboxes to facilitate forms creation8m 7s
-
(Locked)
Exploring what-if scenarios using Goal Seek9m 55s
-
(Locked)
Creating text, numerical, date, and time lists in a flash6m 54s
-
(Locked)
Creating variable conditional formatting rules8m 4s
-
(Locked)
Handling dates with unusual formats6m 5s
-
(Locked)
Ten quick tips to use daily: formulas, formatting, and accessing commands6m 32s
-
View all worksheet names with new Navigation pane on the View tab4m 9s
-
(Locked)
Using wildcards (asterisk, tilde, and question mark)11m
-
(Locked)
Custom formats using asterisk, semicolon, and brackets13m
-
(Locked)
Meeting unusual filtering needs via Advanced Filter5m 28s
-
(Locked)
Create an organization chart8m 56s
-
(Locked)
Two-way lookup using the MATCH and INDEX functions11m 28s
-
(Locked)
Using Excel error-checking functions10m 37s
-
(Locked)
Custom formats, relative addressing, and conditional formatting8m 26s
-
(Locked)
Auditing9m 1s
-
(Locked)
Adding comments and shapes7m 35s
-
(Locked)
Drawing borders and border grids5m 45s
-
(Locked)
Building a flexible monthly table using functions11m 44s
-
(Locked)
Adding pictures as worksheet backgrounds4m 15s
-
(Locked)
ADDRESS, ROW, and COLUMN functions8m 8s
-
(Locked)
Join data with new CONCAT and TEXTJOIN functions6m 15s
-
(Locked)
Working with formulas in tables13m 2s
-
(Locked)
Locating data validation rules and violations7m 20s
-
(Locked)
Creating an Excel template7m 57s
-
(Locked)
Restoring missing column titles6m 41s
-
(Locked)
Creating a pick list dependent on another pick list6m 59s
-
(Locked)
Using command shortcuts with the Alt key5m 51s
-
(Locked)
Set up a macro for sorting dynamic data8m 42s
-
(Locked)
Use random number functions for sorting and creating sample data9m 57s
-
(Locked)
Use calcuated fields and calculated items in a PivotTable8m 57s
-
(Locked)
Replace characters by position with the REPLACE function5m 46s
-
(Locked)
Work with formulas in tables9m 3s
-
(Locked)
Keystroke shortcuts from A to Z: Using the Ctrl key16m 16s
-
(Locked)
Use special tricks for working with dates in charts11m 36s
-
(Locked)
Use a data form for data entry and exploring data6m 42s
-
(Locked)
Creating an Excel template to simplify updating a monthly file7m 10s
-
(Locked)
Calculate dates efficiently using Excel's hidden function - DATEDIF7m 36s
-
(Locked)
Create dynamic sheet name references with the INDIRECT function6m 45s
-
(Locked)
Avoid errors and hidden data with the powerful AGGREGATE function7m 8s
-
(Locked)
Hide worksheets, row, columns, cells and other Excel elements7m 26s
-
(Locked)
Use slicers and charts together for dynamic presentations9m 4s
-
(Locked)
Save a chart as a template: Use the template for current or new charts6m 2s
-
(Locked)
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions8m 12s
-
(Locked)
Adjust a chart's source data and adjust its series order9m 7s
-
(Locked)
Use the OFFSET function for tabulating moving data11m 23s
-
(Locked)
Alter numeric data without formulas10m 19s
-
(Locked)
Use Flash Fill to rapidly combine or separate columnar data10m 28s
-
(Locked)
Adjust banded-row formatting14m 35s
-
(Locked)
Change the shape of comment boxes and other objects6m 32s
-
(Locked)
How and when to use the 10 rounding functions in Excel13m 26s
-
(Locked)
Calculate faster with the AutoSum button and AutoSum keystroke shortcut6m 54s
-
(Locked)
How to use mixed cell references8m 25s
-
(Locked)
Activate the Speak On Enter and Speak Cells features5m 38s
-
(Locked)
Accelerate data entry with five special techniques12m 8s
-
(Locked)
Insert a text box or shape and link a cell's content to it6m 58s
-
(Locked)
Use Watch Window and other techniques to track changing cells8m 21s
-
(Locked)
How to create time interval entries11m 39s
-
(Locked)
How to create frequency tabulations and distributions8m 10s
-
(Locked)
Create an expanded list from a summary using PivotTable techniques7m 25s
-
(Locked)
Solve matching issues with matching phone numbers and SS numbers10m
-
(Locked)
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative7m 27s
-
(Locked)
Use outlining tools to quickly expand and collapse data for dynamic presentations9m 19s
-
(Locked)
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting9m 59s
-
(Locked)
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series10m 44s
-
(Locked)
Create linkage formulas that refer to other worksheets and workbooks11m 49s
-
(Locked)
Formula nesting: Using multiple functions in the same formula13m 22s
-
(Locked)
Keyboard shortcuts for numeric formats8m 18s
-
(Locked)
Use the Subtotal command to analyze data with single- or multiple-level subtotals9m 15s
-
(Locked)
Work with MAX, MAXIFS, LARGE, and related functions8m 14s
-
(Locked)
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations9m 24s
-
(Locked)
Use the FIND, MID, LEFT, and RIGHT functions10m 38s
-
(Locked)
Flip the left-to-right order of columns with the INDEX function or sort by columns8m 18s
-
(Locked)
Working with hidden data when copying cells and creating charts10m 58s
-
(Locked)
Use conditional formatting data bars to accentuate negative data4m 16s
-
(Locked)
Creative use of sparklines in merged cells with axes7m 1s
-
(Locked)
Copy formats quickly using dragging techniques and the Format Painter5m 25s
-
(Locked)
Displaying multiple worksheets and workbooks together10m 13s
-
(Locked)
Tips for creating and updating sample data11m 1s
-
(Locked)
Use conditional formatting to overcome formatting limitations of the IF function8m 54s
-
(Locked)
Use VLOOKUP, MATCH, and INDEX functions with array formulas10m 38s
-
(Locked)
Summarize data from different worksheets with a PivotTable7m 20s
-
(Locked)
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas6m 59s
-
(Locked)
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions8m 40s
-
(Locked)
Use custom formulas in data validation to keep out bad data13m 18s
-
(Locked)
Dealing with circular errors8m 20s
-
(Locked)
Tips for creating charts quickly6m 56s
-
(Locked)
Creating heat maps using conditional formatting8m 31s
-
(Locked)
Using the INDEX function to extract data by row and column11m 1s
-
(Locked)
Displaying tips when using Excel in presentations6m 23s
-
(Locked)
The Wrap Text, Merge and Center, and Indent options9m 2s
-
(Locked)
Using fill effects (gradients, patterns, styles) for colorful cell background variations5m 10s
-
(Locked)
Working with multiple worksheets simultaneously8m 42s
-
(Locked)
Exploring font choices not found on the Home tab4m 2s
-
(Locked)
Using WordArt for special titles and headings4m 33s
-
(Locked)
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions7m 34s
-
(Locked)
Borders and gridlines: Exploring variations, options, and differences8m 24s
-
(Locked)
New Excel 2016 chart types: Tree map and sunburst7m 29s
-
(Locked)
Freezing column and row titles7m 48s
-
(Locked)
Use data validation to force entries to be uppercase or lowercase10m 48s
-
(Locked)
Avoiding common chart distortions11m 49s
-
(Locked)
Use the new funnel chart available in Excel 3654m 3s
-
(Locked)
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character6m 1s
-
(Locked)
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!9m 39s
-
(Locked)
Creating cross-totals with the SUMIFS function and mixed references5m 50s
-
(Locked)
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10m 8s
-
(Locked)
Using the AND and OR functions independently or within IF functions9m 58s
-
(Locked)
Vertical and horizontal alignment settings and orientation options7m 12s
-
(Locked)
Sorting tips and shortcuts8m 40s
-
(Locked)
A look at new chart types in Excel 2016: Waterfall6m 57s
-
(Locked)
Work with formulas and formats: Decimals and fractions5m 42s
-
(Locked)
Creating mixed reference formulas; converting to a table; applying conditional formatting8m 6s
-
(Locked)
Control gridlines in charts and on worksheets7m 45s
-
(Locked)
Use the INDIRECT function with intersection formulas and range names to extract data6m 34s
-
(Locked)
Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes7m 14s
-
(Locked)
Control phone number and postal code formats using built-in options or customized formats7m 40s
-
(Locked)
Change the default Excel chart type; create and use chart templates6m 13s
-
(Locked)
Create your own customized date and time formats7m 31s
-
(Locked)
Create on-screen warnings and reminders with comments or data validation messages6m 18s
-
(Locked)
Use REPLACE for formats only, for data only, or for both6m 11s
-
(Locked)
Create numeric formats: Display in thousands or millions11m 40s
-
(Locked)
Converting dates like 20102006 into usable date entries4m 25s
-
(Locked)
Create custom lists for letter series like A to Z6m 26s
-
(Locked)
Freeze Panes and Split5m 30s
-
(Locked)
NETWORKDAYS.INTL and WORKDAY.INTL5m 29s
-
(Locked)
Calculate % of change5m 41s
-
(Locked)
Fill in all blank cells within a range with either formatting or data4m 13s
-
(Locked)
Use the COUNT and COUNTA functions4m 19s
-
(Locked)
Use workbook protection to prevent use of sheet commands5m 27s
-
(Locked)
Rank data with the RANK and RANK.AVG functions5m 37s
-
(Locked)
Use nonstandard fiscal years and quarters in PivotTables5m 35s
-
(Locked)
Identify or extract unique entries in a list5m 22s
-
(Locked)
Keyboard, mouse, and command techniques for viewing worksheets5m 18s
-
(Locked)
Create artistic charts with random numbers7m 23s
-
(Locked)
Extract day, month, and year from date fields5m 7s
-
(Locked)
Compare data with EXACT, FIND, and SEARCH functions4m 58s
-
(Locked)
How to covert ROMAN numberals4m 25s
-
(Locked)
Use range names for more readable formulas5m 38s
-
(Locked)
Customize your Quick Access Toolbar6m 7s
-
(Locked)
Conditional formatting based on date proximity4m 51s
-
(Locked)
How to adjust names5m 45s
-
(Locked)
Differences and limitations of converting data to a table5m 17s
-
(Locked)
Avoid the #DIV/0 error message4m 56s
-
(Locked)
Explore formatting options not available on the Home tab4m 25s
-
(Locked)
Control table formatting with custom formats3m 12s
-
(Locked)
Use date functions for age and tenure calculations5m 23s
-
(Locked)
Avoid unintentional entries when typing code numbers4m 29s
-
(Locked)
Sorting by moving columns4m 16s
-
(Locked)
Calculating cumulative totals3m 52s
-
(Locked)
Using the CONVERT function for different numbering systems4m 56s
-
(Locked)
Creating an automatically expanding chart by basing it on a table4m 24s
-
(Locked)
Keystroke shortcuts using the Alt key5m 20s
-
(Locked)
Using the Solver Add-in4m 29s
-
(Locked)
Column widths, row heights, merging cells, and related formatting issues5m 1s
-
(Locked)
Adjusting default layouts and date grouping in PivotTables4m 14s
-
(Locked)
Auditing cell content with Watch Window and dependent cell formulas4m 21s
-
(Locked)
Use the LEN and REPT functions for specialized cell testing and display options4m 4s
-
(Locked)
Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters5m 6s
-
(Locked)
Create double-spaced and triple-spaced printouts while repeating column headings4m 13s
-
(Locked)
Helpful keystroke shortcuts5m 2s
-
(Locked)
Identify weekdays and weekend days in data4m 50s
-
(Locked)
Use chart and filter for presentations4m 9s
-
(Locked)
Create picture links5m 37s
-
(Locked)
How to use the error-checking rules in Excel4m 59s
-
(Locked)
Protect worksheets and lock cells5m 24s
-
(Locked)
Use mixed addresses in Excel formulas5m 35s
-
(Locked)
Rapid filtering with Filter by Selection3m 45s
-
(Locked)
Display large values5m 16s
-
(Locked)
Tracking down conditional formatting and data validation rules5m 42s
-
(Locked)
Transposing data and using the TRANSPOSE function5m 43s
-
(Locked)
Displaying gridlines, borders, and column/row headings when printing4m 37s
-
(Locked)
Exploring some of the 200-plus SmartArt graphic options4m 1s
-
(Locked)
Using the CEILING and FLOOR functions for specialized rounding needs5m 16s
-
(Locked)
Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners5m 39s
-
(Locked)
Tabulating totals with the VLOOKUP function and array constants5m 12s
-
(Locked)
Working with array formulas more easily4m 23s
-
(Locked)
Using the new UNIQUE function to count and copy unique list entries3m 36s
-
(Locked)
Creating and updating sample data5m 43s
-
(Locked)
Format macros to make you a more efficient Excel user5m 23s
-
(Locked)
Use the new SORT and SORTBY functions to extract sorted lists5m 44s
-
(Locked)
Use themes to adjust worksheet colors, fonts, and effects3m 42s
-
(Locked)
Calculate loan payments and investments with PMT and FV functions6m 16s
-
(Locked)
Chart display options with blank cells in source data4m 25s
-
(Locked)
Adjust Conditional Formatting rules by altering percentage breakpoints4m 36s
-
(Locked)
Discover new formula capabilities with new functions and dynamic arrays5m 6s
-
(Locked)
Sort or filter data based on color font or cell color background5m 50s
-
(Locked)
Simplify the use of special characters and symbols5m 24s
-
(Locked)
Select from over 800 icons to enliven worksheets6m 29s
-
(Locked)
Use the new RANDARRAY function that replaces RAND and RANDBETWEEN6m 26s
-
(Locked)
How and when to use an area chart4m 16s
-
(Locked)
Insert colorful images with the People Graph Add-in5m 37s
-
(Locked)
Use formulas to create interactive charts5m 32s
-
(Locked)
Track variables using the Scenario Manager4m 43s
-
(Locked)
Get totals quickly without creating formulas5m 2s
-
(Locked)
Use column or row references to create dynamic formulas4m 31s
-
(Locked)
Overcoming obstacles when working with dates in charts4m 45s
-
(Locked)
Create map-type charts based on geographical locations4m 19s
-
(Locked)
Techniques for creating date series4m 42s
-
(Locked)
Extract filtered data with data validation and the FILTER function4m 34s
-
(Locked)
Use Find and Replace to change cell contents and formats6m 12s
-
(Locked)
Add formula tools and symbols to the Quick Access Toolbar5m 12s
-
(Locked)
Use the XLOOKUP function to replace VLOOKUP5m 23s
-
(Locked)
Change PivotTable settings for titles and summaries5m 58s
-
(Locked)
Use the Excel filtering capability for dates4m 57s
-
(Locked)
Use worksheet names in formulas5m 31s
-
(Locked)
Use data validation rules with special phone and social security formats5m 44s
-
(Locked)
Work with time calculations in formulas5m 14s
-
(Locked)
Prevent and locate duplicate worksheet entries4m 41s
-
(Locked)
Look forward and backward using EDATE and other date functions5m 37s
-
(Locked)
Display and highlight worksheet formula cells5m 46s
-
(Locked)
Split or join columnar data with Text to Columns or Flash Fill4m 55s
-
(Locked)
Highlight milestone data with conditional formatting and cumulative formulas5m 38s
-
(Locked)
Use the XMATCH function to replace MATCH3m 43s
-
(Locked)
Create a powerful macro4m 40s
-
(Locked)
Work with hidden and visible data in filtered and subtotaled lists5m 54s
-
(Locked)
Use TODAY, NOW, YEARFRAC, and DATEDIF6m 17s
-
(Locked)
Use data validation rules to prevent duplicate entries in a range4m 38s
-
(Locked)
Use various techniques to hide cells, rows, columns, and worksheets4m 56s
-
(Locked)
Align, arrange, and rotate shapes in worksheets5m 40s
-
(Locked)
File documentation with the Workbook Statistics button4m 22s
-
(Locked)
Avoid misleading visuals when rescaling5m 16s
-
(Locked)
Use the Fill Justify feature to wrap long text4m 2s
-
(Locked)
Create range names from Column and Row headings3m 51s
-
(Locked)
Use the SUBSTITUTE and REPLACE functions4m 47s
-
(Locked)
Accelerate Conditional Formatting with the Quick Access Toolbar4m 15s
-
(Locked)
Use wildcard symbols in functions5m 14s
-
(Locked)
Use wildcard symbols in filtering and commands6m 7s
-
(Locked)
Condense lengthy nested IF functions with the newer IFS function4m 43s
-
(Locked)
Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more6m 18s
-
(Locked)
Control worksheet security by allowing selected users to edit specific cell ranges5m 43s
-
(Locked)
Retrieve vital data based on location using the Geography tool5m 2s
-
(Locked)
Use the new SEQUENCE function to quickly build numeric and date arrays5m 46s
-
(Locked)
Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions6m 19s
-
(Locked)
Create a list box to facilitate selection of data from a list5m 35s
-
(Locked)
Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more5m 36s
-
(Locked)
Enhance readability with banded rows via conditional formatting5m 25s
-
(Locked)
Seven different ways to drag data using the Ctrl, Shift, and Alt keys6m 3s
-
(Locked)
Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions5m 48s
-
(Locked)
Adjust charts quickly with quick layout, change colors, and chart styles options4m 39s
-
(Locked)
Analyze PivotTable data with 13 different Show Values As options5m 10s
-
(Locked)
Expand/collapse or sort displayed results when using the SUBTOTAL command5m 18s
-
(Locked)
Use the AGGREGATE function to circumvent errors and ignore hidden data5m 17s
-
(Locked)
Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration6m 11s
-
(Locked)
Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH4m 29s
-
(Locked)
Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more5m 54s
-
(Locked)
Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect5m 56s
-
(Locked)
Using the LET function to simplify formulas via programming concepts5m 4s
-
(Locked)
Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash4m 35s
-
(Locked)
Create moving averages with formulas and chart trendlines5m 47s
-
(Locked)
Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR6m 5s
-
(Locked)
Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability5m 26s
-
(Locked)
Work with cell colors, patterns, and effects to emphasize data and provide visual flair4m 34s
-
(Locked)
Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells5m 27s
-
(Locked)
Fonts such as Arial and Calibri and a rundown of various available fonts in Excel6m 5s
-
(Locked)
Use 3D formulas to tabulate data from multiple worksheets with the same layout6m 36s
-
(Locked)
Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy6m 24s
-
(Locked)
Where does that cell get its data from?: Tracking down cell precedents4m 15s
-
(Locked)
Controlling date entry restrictions using data validation3m 59s
-
(Locked)
Remove duplicates from a list vs. creating a new list without duplicates4m 26s
-
(Locked)
New data types: Extract valuable online data into your worksheets5m 9s
-
(Locked)
Use the FILTER and UNIQUE functions together for dynamic extractions5m 1s
-
(Locked)
Adjusting text entries with the UPPER, LOWER, and PROPER functions4m 55s
-
(Locked)
Refine filtering needs via custom filter options5m 55s
-
(Locked)
Comparing column charts and bar charts: Pros and cons6m 28s
-
(Locked)
How to use exponentiation (powers and roots) in Excel formulas5m 50s
-
(Locked)
Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions4m 18s
-
(Locked)
Tips for saving time when typing function names6m 38s
-
(Locked)
SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted6m 37s
-
(Locked)
Conversion of values into binary, octal, decimal, and hexadecimal equivalents4m 30s
-
(Locked)
Quick number formatting with keystroke shortcuts and icon buttons7m 7s
-
(Locked)
Date calculation and formatting issues related to the 2029/2030 switch4m 34s
-
(Locked)
Using wildcards in the new XLOOKUP and XMATCH functions5m 56s
-
(Locked)
Using slicers as analytical tools6m 2s
-
(Locked)
Conditional formatting using contrasting heat maps on multiple vs.single ranges5m 44s
-
(Locked)
Create dynamic pick lists using the UNIQUE and SORT functions, and data validation6m 11s
-
(Locked)
Contrasting uses of clustered column and stacked column charts6m 57s
-
(Locked)
Use the XLOOKUP function with multiple column criteria and multiple column results4m 39s
-
(Locked)
Tips for updating entire columns of date entries when using real or sample data4m 15s
-
(Locked)
Filtering lists with AND and OR criteria when using the FILTER function4m 29s
-
(Locked)
Using TRIM, CLEAN and other functions to clean up text data5m 47s
-
(Locked)
Create multiple range names from the top row and/or left column5m 47s
-
(Locked)
Use dragging techniques to extend dates by weekdays only, month, or year3m 55s
-
(Locked)
Use the LAMBDA function to create worksheet functions6m 27s
-
(Locked)
Get the formula results you want using Goal Seek5m 7s
-
(Locked)
Sort your data based on a Custom List that you define5m 43s
-
(Locked)
Create a dynamic sheet name reference with the INDIRECT function4m 41s
-
(Locked)
Calculate dates and/or days of the week for selected future holidays4m 6s
-
(Locked)
Use dragging techniques for faster Paste Special options5m 12s
-
(Locked)
How to use and not use SS numbers; fake SS numbers; display as XXX-XX-99994m 51s
-
(Locked)
Five indispensable keystroke shortcuts for Windows and Mac users5m 35s
-
(Locked)
Using new formula-writing techniques to simplify wide-ranging formulas6m 6s
-
(Locked)
Calculate time differences within days and across multiple days6m 26s
-
(Locked)
Use keyboard, mouse, and commands to zoom in/out quickly in Excel Windows and Mac versions5m 45s
-
(Locked)
Make dynamic presentations with rapid expand/collapse detail features in outlining5m 54s
-
(Locked)
Get data analysis suggestions with the Analyze Data (formerly Ideas) tool5m 41s
-
(Locked)
Using the Distinct vs. Unique options when using the UNIQUE function4m 58s
-
(Locked)
Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it4m 29s
-
(Locked)
Exploring Excel's Sunburst chart to display hierarchical data5m 5s
-
(Locked)
Creating floating text boxes with shadow, reflection, glow, and other shape effects4m 27s
-
(Locked)
Page Setup tip: Print repeating titles, shrink-to-fit, landscape/portrait, double-spaced layout6m 4s
-
(Locked)
Use Data Validation based on multiple criteria5m 38s
-
(Locked)
Customize the Quick Access Toolbar using the Alt key or a mouse5m 44s
-
(Locked)
Exploring treemap charts to display hierarchical data6m 5s
-
(Locked)
Use the Quick Analysis tool for easy access to power tools3m 36s
-
(Locked)
Create a number series with the Ctrl key and left/right mouse button5m 56s
-
(Locked)
Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales4m 51s
-
(Locked)
Unhide multiple worksheets at once and use the very hidden option5m 5s
-
(Locked)
Use the Fill Justify command to quickly rewrap text into different cells3m 45s
-
(Locked)
Create a 15th day or end-of-month series and adjust to weekdays only4m 27s
-
(Locked)
Use the Go To Special option to select and populate blank cells5m 4s
-
(Locked)
Accentuate values with conditional formatting and sparklines6m 10s
-
(Locked)
Transpose data with formula substitution and the TRANSPOSE function4m 34s
-
(Locked)
Use emojis and other symbols in formulas and charts5m 50s
-
(Locked)
Use the Advanced Filter for specialized filtering needs5m 48s
-
(Locked)
Combo charts: Combine different chart types to present data more clearly5m 33s
-
(Locked)
Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells6m 29s
-
(Locked)
Exploring Edit Default Layout options when using PivotTables4m 28s
-
(Locked)
Navigation tips: Shortcuts to jump within and between worksheets and workbooks5m 44s
-
(Locked)
Use DATEDIF to calculate months or days after yearly or monthly anniversaries5m 18s
-
(Locked)
WordArt Transform: Special text character layouts5m 24s
-
(Locked)
Sort data based on months and weekdays, even when entered as text5m 36s
-
(Locked)
Use formulas to calculate values across worksheets and workbooks6m 32s
-
(Locked)
Use XLOOKUP instead of complex combinations of VLOOKUP, INDEX, and MATCH5m 41s
-
(Locked)
Use dragging techniques to create a forecast based on TREND and GROWTH functions5m 25s
-
(Locked)
Stock charts: Adding Open, High, Low, Close, and Volume values4m 49s
-
(Locked)
Control gridlines: Change colors, turn them on/off, and assign to a macro button4m 50s
-
(Locked)
Examples of TRANSPOSE and other functions working differently with the new calculation engine5m 18s
-
(Locked)
Locate formula dependencies via keystroke shortcuts and the Trace Dependents command4m 48s
-
(Locked)
Replace text based on formats, like cell attributes (bold, text color, etc.)5m 2s
-
(Locked)
Create forms using check boxes and option buttons to simplify data entry5m 47s
-
(Locked)
Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data6m 2s
-
(Locked)
Create a moving average with a chart or by using a formula4m 22s
-
(Locked)
Redesigned Data Validation feature: Now more efficient when using large lists4m 43s
-
(Locked)
Link pictures of data ranges to changing data4m 14s
-
(Locked)
Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas5m 29s
-
(Locked)
Create multiple PivotTables from a single source6m 47s
-
(Locked)
Explore icon sets in the Excel Conditional Formatting feature4m 46s
-
(Locked)
Use the IMAGE function to paste an image into a cell4m 40s
-
(Locked)
Use TOCOL and TOROW to realign array data into single columns and rows5m 28s
-
(Locked)
Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows5m 3s
-
(Locked)
Use bubble charts to show relationships between sets of values5m 35s
-
(Locked)
Contrast TEXTJOIN, CONCAT, and TEXTSPLIT to gather and split data5m 47s
-
(Locked)
Use shrink-to-fit options to adjust the display of cell content and compress printed output4m 22s
-
(Locked)
Locate formula precedents via keystroke shortcuts and the Trace Precedents command4m 5s
-
(Locked)
Try these editing tips and keystroke shortcuts to use with long formulas5m 38s
-
(Locked)
Customize and utilize status bar displays and copy/paste its data4m 57s
-
(Locked)
Command and keystroke shortcuts for sorting frequently used data4m 57s
-
(Locked)
Extract text from cells using the new TEXTBEFORE and TEXTAFTER functions4m 14s
-
(Locked)
Quickly link cell content for main titles and axis titles for selected chart types4m
-
(Locked)
Use the TAKE, DROP, FILTER and SORTBY functions to build dependent lists6m 9s
-
(Locked)
Create new lists by changing the PivotTable Report Layout to Tabular and adding repeating labels4m 10s
-
(Locked)
Rapid filtering by content, cell color, or font color via right-clicking3m 31s
-
(Locked)
Restructure column/row data using new WRAPROWS and WRAPCOLS functions6m 2s
-
(Locked)
Working with date and time-based data and the over-24-hour display issue5m 25s
-
(Locked)
Multiple tips for creating charts quickly5m 44s
-
(Locked)
Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions5m 16s
-
(Locked)
Overcoming rounding concerns in formulas with functions and decimal displays4m 13s
-
(Locked)
Highlighting PivotTable results with conditional formatting4m 42s
-
(Locked)
An overview of the 12 database functions in Excel5m 21s
-
(Locked)
Advantages and disadvantages of using pie charts to display data4m 20s
-
(Locked)
Rapid sorting via right-clicking options3m 20s
-
(Locked)
Converting charts into pictures3m 50s
-
(Locked)
Using three functions to track worksheet cells that are text, numbers, or formulas6m 44s
-
(Locked)
Using new BYROW and BYCOL functions to analyze data6m 25s
-
(Locked)
Create formulas rapidly with these shortcuts6m 50s
-
(Locked)
Exploring 3-D Column and 3-D Bar charts5m 55s
-
(Locked)
New VSTACK and HSTACK functions6m 35s
-
(Locked)
Calculating day of the week totals from a large transaction list5m 27s
-
(Locked)
Contrasating uses of the newer functions: XMATCH and XLOOKUP7m 11s
-
(Locked)
Various techniques for highlighting (selecting) cell ranges quickly7m 25s
-
(Locked)
Inserting special symbols using AutoCorrect options and the Insert Symbol command6m 39s
-
(Locked)
Reviewing Excel Information functions - ISBLANK, ISNUMBER, ISTEXT, etc.6m 31s
-
(Locked)
Manipulating text functions LEFT, MID, and TEXT to create new ID numbers5m 10s
-
(Locked)
Discovering timesaving tools in the Go To Special feature6m 13s
-
(Locked)
Calculating chronological and fiscal quarters6m 10s
-
(Locked)
Sorting by moving columns left/right - in tables, Pivot Tables, SORT and SORTBY5m 37s
-
(Locked)
Using Conditional Formatting for analysis and data emphasis6m 11s
-
(Locked)
Using Indent buttons to control text displays and currency formatting3m 32s
-
(Locked)
Create shapes and text boxes with content linked to worksheet cells5m 2s
-
(Locked)
Dynamically presenting data via chart slicers5m 6s
-
(Locked)
Sorting by day of month for birthday and anniversary lists3m 34s
-
(Locked)
Using wildcards (asterisk, question mark, and tilde) in formulas and commands7m 32s
-
(Locked)
Using SEARCH, FIND, and COUNT to tabulate data occurrences4m 30s
-
(Locked)
Comparing the Data Analysis Histogram feature and Excel's Histogram chart5m 9s
-
(Locked)
Using the AND and OR functions independently or within IF functions6m 25s
-
(Locked)
Use various techniques to flip lists upside-down or left-to-right4m 52s
-
(Locked)
Combine data with the TEXTJOIN, CONCAT, and CONCATENATE5m 9s
-
(Locked)
Use Excel's Advanced Options to fine-tune settings and increase efficiency5m 19s
-
(Locked)
Use ALT and other shortcuts when working with AutoComplete, Data Validation, etc.4m 5s
-
(Locked)
Use the powerful COUNTIF family—8 functions—for statistical analysis7m 18s
-
(Locked)
Show relationships between sets of values with a Scatter(XY) Chart7m 4s
-
(Locked)
Locate and track a worksheet's Data Validation rules and violations5m 40s
-
(Locked)
Use AGGREGATE to avoid errors and ignore hidden data5m 52s
-
(Locked)
Explore multiple approaches for locating, preventing, and deleting duplicate data5m 20s
-
(Locked)
Use a single SEQUENCE function to create various date layouts5m 24s
-
(Locked)
Combine a Validation list, XLOOKUP function, table, and chart to build a presentation model5m 10s
-
(Locked)
Pros and cons of using Stacked Area charts and Stacked Column Charts5m 7s
-
(Locked)
Nested use of FILTER, SORT, and CHOOSECOLS functions for selective column retrieval6m 41s
-
(Locked)
Learn about the new Office Theme, the default Aptos Font and new colors in M365 apps5m 7s
-
(Locked)
Analyze data using TOCOL, TOROW, LARGE, and SMALL4m 49s
-
(Locked)
Refine chart elements quickly with the powerful and overlooked Quick Layout button5m 43s
-
(Locked)
Tips and techniques for displaying Excel worksheets effectively during presentations6m 51s
-
(Locked)
Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions6m 39s
-
(Locked)
Using entire column (or row) references to create more dynamic formulas6m 51s
-
(Locked)
Using Excel's Accessibility Checker to follow best practices for those with disabilities5m 10s
-
(Locked)
Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data6m 28s
-
(Locked)
Create dynamic presentations with Slicers, Filters, and Charts6m 39s
-
(Locked)
Compare and contrast multiple column sorting with SORT and SORTBY9m 8s
-
(Locked)
Use keystroke and mouse shortcuts to display and navigate worksheets7m 35s
-
(Locked)
Show gain/loss in census figures with the RANK, IF, and LET functions7m 28s
-
(Locked)
Apply conditional formatting across data rows7m 43s
-
(Locked)
Expand and collapse date displays in PivotTables4m 19s
-
(Locked)
Use TODAY and NOW for real-time up-to-date calculations5m 9s
-
(Locked)
Use Freeze Panes and Split to view different worksheet portions7m 19s
-
(Locked)
Use CEILING and FLOOR for specialized numeric rounding needs6m 31s
-
(Locked)
Highlight negative positive values with Conditional Formatting and Data Bars5m 56s
-
(Locked)
Use AutoSum to simplify and accelerate formula creations4m 44s
-
(Locked)
Dynamic sheet name reference with INDIRECT5m 27s
-
(Locked)
Create custom and built-in lists to sort and fill in sequences8m 11s
-
(Locked)
Consolidate and split workbooks5m 51s
-
(Locked)
Expand, collapse and sort displayed results when using Subtotal6m 39s
-
(Locked)
Random number functions: RAND, RANDBETWEEN, and RANDARRAY5m 48s
-
(Locked)
Using the new GROUPBY and PIVOTBY functions6m 28s
-
(Locked)
Creating 3D and other formulas that use data from different worksheets7m 34s
-
(Locked)
Quick searching for menu commands with the right mouse button3m 41s
-
(Locked)
Using the new Checkbox button on the Insert tab4m 13s
-
(Locked)
Using Ctrl+Shift+V and other quick methods to copy values without formulas5m 18s
-
(Locked)
Use SORT and FILTER function to create charts based on dynamic arrays7m 44s
-
(Locked)
Extracting data from an online image6m 17s
-
(Locked)
Create custom views7m 3s
-
(Locked)
Calculating percentages using formulas and the new PERCENTOF function4m 44s
-
(Locked)
Adding shadow boxes to charts and other objects for flair and emphasis5m 8s
-
(Locked)
Updating and testing sample data (salaries, dates, etc.) quickly6m 8s
-
(Locked)
Using the powerful XLOOKUP function with multiple fields6m 9s
-
(Locked)