12.9. Scatter plot | Excel pivot tables COURSE

Are you working in Excel? Improve your skills 🚀 in pivot tables - the most flexible & easy to understand analytical tool. In this course you will learn how to create, modify, filter, and visualize pivot tables and create dashboards based on pivot tables, charts, and slicers.

👉 Sign up for 13 hours of FREE Excel video course (formulas, pivot tables, maps), trusted by 50 000 people, and get all training materials FREE:

Full course playlist:

▼▼▼▼▼▼▼▼▼▼

👉 Subscribe to my YouTube channel:

▼▼▼▼▼▼▼▼▼▼

👉 Pivot table course is a great base for further development in Excel - learning about Power Query, Power Pivot, and Power BI. Get 22 hours of Power video course with a 20% DISCOUNT 🏷 by using the code: YOUTUBE.

👉 The package contains:
• 5 hours on Power Query – getting & transforming data in Excel and Power BI
• 5 hours on Data model & DAX for Power Pivot and Power BI users
• 5 hours on Power BI Desktop – the new BI platform from Microsoft
• 7 hours on Data Visualization & Dashboard Design

Our online Academy has been trusted by +1000 companies from all over the world 🌐.

▼▼▼▼▼▼▼▼▼▼

👉 Watch our animations on Power tools to convince your boss 🤴:

▼▼▼▼▼▼▼▼▼▼

👉 We have already trained +100 companies on Power Query, Power Pivot and Power BI. Invite us to your company for the live training:

👉 Check our unique training offer:
• Only practical exercises based on typical challenges you will face in daily life
• Infographic summary of the training
• Post-training task as a follow-up and certification process
• Support after the training included in the price
• We have been a trusted partner of Danone, HSBC, Santander, Roedl, Dentons, MARS, Philips, Schenker, Lufthansa and many more

▼▼▼▼▼▼▼▼▼▼

👉 Questions? Contact me:
Bartosz Czapiewski
Phone: [phone]

[jameswelch]

For anyone else reading this who may want to copy the function, here's the first instance of it in the video:



(I am using 2019 Excel and had to use commas rather than semicolons)



The 5 arguments are as follows:

- Reference: Where you want to start in reference to
(The first row with data in the first column)

- Rows: How many rows over from the reference point you want to use as a starting point
(We are using this cell as a start, so 0)

- Columns: How many columns over from the reference point you want to use as a starting point
(We are just using this cell as a start, so 0)

- Height: How many rows down do you want to capture from the reference point
(COUNTA gets the number of non-empty cells in the column, then we subtract 1 for the header line above)

- Width: How many columns wide you want to capture from the reference point
(We just want this column, so 1)

[stefdereys]

Thanks. This was really magical. Great help.