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/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
Watch video Top 10 Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files online without registration, duration hours minute second in high quality. This video was added by user Chandoo 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 314,064 once and liked it 3.3 thousand people.