MS Excel and Google Sheets on Steroids!

I admit: I use MS Excel a lot and I'm still amazed how much more there is 'under the hood' in terms of functions, analysis options, and charting tricks - here are a few good ones I came across recently:

• An Empty Bar (Ann K. Emery)
• Removing the Double Y Axis (Ann K. Emery)
• VLookup (Ann K. Emery)
• From Data to Charts in 5 minutes (Ann K. Emery)
• Excel Elbow Grease (great tricks by Ann K. Emery)
• Muted Grid Lines and Area Charts (Ann K. Emery)
• Number Formatting / Conditional Formatting (Ann K. Emery)
• Formatting Months, Days, and Years in Excel (Ann K. Emery)
• Label Axis and/or Data? (Ann K. Emery)
• Formatting Names (Ann K. Emery)
• Sorting and Filtering your Spreadsheets (Ann K. Emery)
• Place Labels Directly On Line Graph (Ann K. Emery)
• Custom Color Codes in Excel (Anne K. Emery)
• Categorize values with =IF() and =VLOOKUP() (Ann K. Emery)
• How to Use Vlookup in MS Excel (Anne K. Emery)
• How to match data with VLOOKUP in Excel & Google Sheets (Lisa Charlotte Muth)
• Sparklines and Data Bars (Ann K. Emery)
• Add Dotted Lines to Line Graphs (Ann K. Emery)
• Direct Labeling in Excel (Stephanie Evergreen)
• Make a Pictogram in Excel (Stephanie Evergreen)
• Fast Small Multiple Graphs (Stephanie Evergreen)
• Easy Dot Plots in MS Excel (Stephanie Evergreen)
• Dumbbell Dot Plots in MS Excel I (Stephanie Evergreen)
• Dumbbell Dot Plots in MS Excel II (Stephanie Evergreen)
• Dumbbell Dot Plots Way Easier (Stephanie Evergreen)
• Make a Slopegraph in Excel (Stephanie Evergreen)
• How to make a scatter plot in Excel (Storytelling with Data)
• Adding a Benchmark Line (Stephanie Evergreen)
• Customizing Colors (Stephanie Evergreen)
• Showing Standard Deviation (Stephanie Evergreen)
• Confidence Intervals to Dot Plots (Stephanie Evergreen)
• Margin of Error in Excel with “Slider Plots” (Andrew Forsman)
• Directly Labeling Excel Charts (Jonathan Schwabish)
• Edit a ledgend in Excel (Storytelling with Data)
• Swimmer Plots (Jon Peltier)
• Pivot Tables (Jon Peltier)
• Interactive data dashboards (Ben Collins)
• Supercategory axis labels (Cole Nussbaumer Knaflic)
• Plotting value within range (Cole Nussbaumer Knaflic)
• Embedding a vertical reference line in Excel (Elizabeth Ricks)
• How to do it in Excel: a shaded range (Elizabeth Ricks)
• How to do it in Excel: adding data labels (Elizabeth Ricks)
• Data prep for MS Excel / Google Sheets (Chartable)
• Extract Text from Data Columns (Chartable)
• Create a dot plot (Storytelling with Data)
• Save As Template (Stephanie Evergreen)