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
Видео Top 10 Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files канала Chandoo
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
Видео Top 10 Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explained](https://i.ytimg.com/vi/4MVNjzsGokc/default.jpg)
![Awesome Power Query example - Calendar data to table format 📅➡📄](https://i.ytimg.com/vi/9eR8NMC8Vq0/default.jpg)
![Employee Shift Tracker Excel Template - How it works](https://i.ytimg.com/vi/Qb365Z5vSOE/default.jpg)
![Convert number to words with this Excel formula + LET Function Demo](https://i.ytimg.com/vi/Kx3Tq95ceX8/default.jpg)
![May the Power BI with you - Demo of Star Wars Infographic](https://i.ytimg.com/vi/1ijAlPini24/default.jpg)
![🧇 Yummy WAFFLE Chart in Power BI - How to make one?](https://i.ytimg.com/vi/OZPc42xnv8s/default.jpg)
![How to do weighted sorting in Excel?](https://i.ytimg.com/vi/xlBKwXner4c/default.jpg)
![Celebrate Halloween with Creepy Spider Web Chart in Excel](https://i.ytimg.com/vi/HsW0hlSQVjg/default.jpg)
![KNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌](https://i.ytimg.com/vi/LsQKzcu74Mg/default.jpg)
![How to create a fully *INTERACTIVE* and AWESOME Dashboard in Excel (PART 2)](https://i.ytimg.com/vi/2hzUJwz1rik/default.jpg)
![How to split text values in Excel with formulas - Quick Solution ⏳](https://i.ytimg.com/vi/SI2YbN3CY5s/default.jpg)
![Combine Excel Sheets with *this* simple formula](https://i.ytimg.com/vi/eg53SjXxveY/default.jpg)
![DAX Concepts: How to Create Best in Category Calculations with Ease](https://i.ytimg.com/vi/IGIV_V4rcUY/default.jpg)
![Where to get FREE Datasets to practice Data Analytics](https://i.ytimg.com/vi/4FZyHnMQRuc/default.jpg)
![Average calculation in Excel, but with a twist 🥨](https://i.ytimg.com/vi/m4J9eRlMvFU/default.jpg)
![Try this yummy Lollipop Chart 🍭 (Excel trick)](https://i.ytimg.com/vi/pRZ2JzvRVlA/default.jpg)
![Easiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire)](https://i.ytimg.com/vi/VQhwn7TlZY0/default.jpg)
![Can you split The Hangover expenses using Excel?](https://i.ytimg.com/vi/0DCdH2z_MkY/default.jpg)
![How to connect to Amazon AWS S3 Buckets from Power BI - Step by Step Tutorial (with code samples)](https://i.ytimg.com/vi/5WPrvgC7u2w/default.jpg)
![6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) ⏰](https://i.ytimg.com/vi/YK4IDGz46bc/default.jpg)
![Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...](https://i.ytimg.com/vi/fOyvqXxADvE/default.jpg)