FREE Microsoft Excel Course - 10 awesome things you can do in Excel - WITHOUT any formulas or pivots

Every time you see something extraordinary in Excel, they have a formula or pivot table engine behind them. In this video, let me show you 10 incredibly cool and powerful things you can do in Excel, without writing a single formula or pivot table. The 10 things are... Initials from Names with flash fill Totals for Filtered values with "Total Row" feature Compare Lists with conditional formatting Frequency Distribution with histograms & box plots Running Totals with Quick analysis Forex Conversion with Paste Special Spot Extreme Values with Conditional formatting heatmaps Forecasting with "Forecast sheet" Interactive Chart with Tables + Slicers Asking Excel to Analyze Data with "Ideas" Timestamps: 0:00 - Introduction & topic overview 2:00 - Overview of the sample data 2:29 - Extract initials from names 4:03 - Totals for filtered values 6:40 - Compare two lists 7:35 - Frequency distribution analysis 9:45 - Running totals 11:02 - Currency exchange rate conversion 12:15 - Outlier analysis 13:34 - Forecasting 15:40 - Interactive charts 17:40 - Ideas feature Download Workbook: https://chandoo.org/wp/wp-content/uploads/2020/10/10-awesome-things-with-excel.xlsx #ExcelTips #MustWatch