Top 10 Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files

Опубликовано: 06 Октябрь 2024
на канале: Chandoo

314,064

3.3k

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/upl...
Completed Workbook: https://chandoo.org/wp/wp-content/upl...

📺 Videos mentioned in the stream:
==============================

Power Pivot & DAX -    • Getting started with Power Pivot & DA...
Dynamic Array Functions -    • Beginner to Pro ~ Excel Dynamic Array...
XLOOKUP -    • I don't use VLOOKUP anymore. I use th...
Operator -    • Excel Dynamic Arrays and How to use t...
Power Query (intro) -    • Learn Power Query & Automate Boring D...
Power Query (combine files) -    • Powerful trick to combine all Excel f...

#dataanalytics #advancedexcel