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

About this tutorial:

Video duration: 00:20:01
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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads