From the course: Excel Tips Weekly
Unlock this course with a free trial
Join today to access over 21,700 courses taught by industry experts.
Use Excel's Advanced Options to fine-tune settings and increase efficiency - Microsoft Excel Tutorial
From the course: Excel Tips Weekly
Use Excel's Advanced Options to fine-tune settings and increase efficiency
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