Software Training

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

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