Data Analysis with Excel 📈📉📊✅ - Top 10 Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files

Want to analyse data in Excel but don't want to waste hours? In this crisp & informative live stream, learn my favourite top 10 tricks for getting things done in Excel fast and right. We are going to learn: 1) *NEW* Dynamic Array functionality in Excel 2) *NEW* Text processing functions 3) Forecasting with a single click 4) Quick analytics 5) Conditional Formatting 6) How to combine two tables of data 7) Pivot Tables ++ 8) Instant Dynamic Chart 9) Even Better Dynamic Chart 10) Getting more out of your data ⏱ Video Timestamps: ================== 6:36 Contents Overview 17:28 Tip 0 : Data Table 21:24 Tip 1 : Dynamic Array Functions 31:49 Point to be noted in Dynamic Array Functions 36:33 Tip 2 : New Text Functions 38:13 (a) TEXTBEFORE 38:49 (b) TEXTAFTER 39:28 (c) TEXTSPLIT 46:08 Tip 3 : One Click Forecasting 52:30 Tip 4 : Quick Analysis 59:18 Tip 5 : Conditional Formatting 01:02:31 (a) Highlight complete row based on a Formula 01:07:40 Tip 6 : Combine 2 Tables (DATA → RELATIONSHIPS) 01:16:09 Tip 7 : Pivot Table + + OR Power Pivot 01:26:36 Tip 8 : Instant Dynamic Chart 01:31:49 Tip 9 : Even Better Dynamic Chart 01:42:53 Tip 10 : Some Basic Tips Thanks to Hritik Raj for creating these timestamps. 😀 📂 Download Sample File: ====================== Blank Data File: https://chandoo.org/wp/wp-content/uploads/2023/01/top10-tricks.xlsx Completed Workbook: https://chandoo.org/wp/wp-content/uploads/2023/01/top10-tricks-from-stream.xlsx 📺 Videos mentioned in the stream: ============================== Power Pivot & DAX - https://youtu.be/eCuPRqQNe6Y Dynamic Array Functions - https://youtu.be/8IV_W13VFkw XLOOKUP - https://youtu.be/DDlZXXEI1bU # Operator - https://youtu.be/kR6czKY4FEw Power Query (intro) - https://youtu.be/UAFExySaSPY Power Query (combine files) - https://youtu.be/SGzegma9bdY #dataanalytics #advancedexcel