In this course, you will learn how to make a dynamic range we will focus on names and offset function then tada the dynamic range will be ready.
In this full course we use functions of excel efficiently, work with tables, power queries, pivot tables, and power pivots, and finally create a PM Dashboard from cost and manhour Power Pivots. You can also reach to the full course with the link below
Udemy
https://www.udemy.com/course/excelallyouneed-en/?referralCode=E8FD1D64C042E65B6774
Besides of Projects we are travellers, I upload the wonderful places on Instagram you can follow us:
https://www.instagram.com/marzname/?hl=en
We appreciate it if you subscribe us on Youtube and enjoy learning :)
Time Stamps:
Intro: (00:00)
Names: (00:34)
Offset Function: (02:10)
Dynamic Range: (06:17)