Practice File for “Excel Experts Swear by the TAKE Function — Here’s Why”
This free Excel practice file goes along with my video “Excel Experts Swear by the TAKE Function — Here’s Why.” It’s designed to help you move beyond watching and start using the TAKE function the way Excel experts do.
You’ll work with real datasets and hands-on examples that show why TAKE is such a powerful and elegant way to extract rows and columns in modern Excel.
What’s included in the file
Practice datasets built specifically for the TAKE() function
Examples using rows, columns, and dynamic ranges
Common real-world use cases Excel experts rely on
Clean, easy-to-follow formulas
Works in Excel 365 / Excel for the web
How to use it
Download the practice file below
Watch the video (or pause and follow along)
Modify the formulas to see how TAKE behaves in different scenarios
This is the fastest way to understand why experts prefer TAKE—and when to use it.
ID used to identify users for 24 hours after last activity
24 hours
_gat
Used to monitor number of Google Analytics server requests when using Google Tag Manager
1 minute
_gac_
Contains information related to marketing campaigns of the user. These are shared with Google AdWords / Google Ads when the Google Ads and Google Analytics accounts are linked together.
90 days
__utma
ID used to identify users and sessions
2 years after last activity
__utmt
Used to monitor number of Google Analytics server requests
10 minutes
__utmb
Used to distinguish new sessions and visits. This cookie is set when the GA.js javascript library is loaded and there is no existing __utmb cookie. The cookie is updated every time data is sent to the Google Analytics server.
30 minutes after last activity
__utmc
Used only with old Urchin versions of Google Analytics and not with GA.js. Was used to distinguish between new sessions and visits at the end of a session.
End of session (browser)
__utmz
Contains information about the traffic source or campaign that directed user to the website. The cookie is set when the GA.js javascript is loaded and updated when data is sent to the Google Anaytics server
6 months after last activity
__utmv
Contains custom information set by the web developer via the _setCustomVar method in Google Analytics. This cookie is updated every time new data is sent to the Google Analytics server.
2 years after last activity
__utmx
Used to determine whether a user is included in an A / B or Multivariate test.
18 months
_ga
ID used to identify users
2 years
_gali
Used by Google Analytics to determine which links on a page are being clicked