This course can be purchased as part of the
Personal Development
bundle. Enquire here!
Personal Development

Pick Columns from a Dataset with CHOOSECOLS in Excel

This course is in the base subscription pack
Category
Personal Development
Bundle - Sub Category
Course Duration
0:05
Subject Matter Expert
Deb Ashby
Provider
Assemble You

Explore the CHOOSECOLS function in Microsoft 365 to streamline the extraction of specific columns from large datasets. Using a dataset of New York marathon winners, this guide demonstrates how to efficiently select and display only the relevant columns—such as year, name, and time—without manual copying and pasting. This function simplifies data management and enhances the ability to analyse data with precision.

Target Audience

Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.

Learning Outcomes

Learn how to use the CHOOSECOLS function in Microsoft 365 to extract and display specific columns from a larger dataset, enabling more focused data analysis and streamlined data management.