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
Видео 10 awesome things you can do in Excel - WITHOUT any formulas or pivots канала Chandoo
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
Видео 10 awesome things you can do in Excel - WITHOUT any formulas or pivots канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Power Query Tutorial - What is it, how to use it & 4 complete examples + Free downloadThe *ONLY* 10 Excel keyboard shortcuts you need to masterReduce VBA Errors by 90% (with this little-known Method)Bill Jelen - MrExcel's Best Excel Tips (including a secret tip from FBI 😮)50 Ultimate Excel Tips and Tricks for 2020Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards10 Excel formatting tricks only experts would knowExcel Cell Reference: Absolute, Relative or Mixed?Secrets to Building Excel Dashboards in Under 15 Minutes!How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files☑️ Top 30 Advanced Excel Tips and Tricks2020 Introduction to Power BI - What is it, how to use it and create your first report with Power BIDrop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)19 Advanced Excel Shortcuts (do you know them all?)Excel Dashboard - Plan vs Actual Variances - FREE DownloadExcel VBA Beginner TutorialGoogle Sheets BEATS Excel with THESE 10 Features!How to get Grand Totals on Top for Excel Pivot Tables?6 FREE Add-Ins for Excel to Start Using Now