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