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

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

Leave a Reply

Close Menu