In this lesson, We are going to explore:
0:00 The OFFSET function - dynamic range.
0:19 The OFFSET exercise - finding out the date of the last lecture and the number of attendees dynamically.
1:11 The OFFSET exercise - The OFFSET exercise - calculating the average attendance in the last three lectures dynamically.
All explanations are simple and to the point.
Feel free to make your copy of this spreadsheet:
[ Ссылка ]

#GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor)
[ Ссылка ]

Google Sheets training:
[ Ссылка ]

The whole playlist link:
[ Ссылка ]-

Follow us on Pinterest:
[ Ссылка ]

Sound from Zapsplat.com

Apple logo
[ Ссылка ]

Windows logo
[ Ссылка ]

Welcome back, Educators.
Our mission is to find out the date of the last lecture and the number of attendees.
And the average attendance in the last lectures dynamically.
Type =OFFSET(
The start cell is A1.
To find out the number of offset rows, we use the COUNTA function.
Type = COUNTA(
Select the range.
Close parenthesis.
Set the offset columns to 0.
Set the height to 1.
Set the width to 2.
Press Enter.
And here is it.
And now we calculate the average attendance in the last three lectures.
Type =OFFSET(
The start cell is B1.
To find out the number of offset rows, we use the COUNTA function.
Type = COUNTA(
Select the range.
Close parenthesis.
Subtract 2.
Set the offset columns to 0.
Set the height to 3.
And here is it.
We've added a custom number format to these cells to facilitate reading the data.
Surround all with AVERAGE function.
Press Enter.
We’ve done the mission.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.

свернуть