BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

CHOOSE Function - Beginner to Advanced Examples

ExcelIsFun via YouTube

Start learning Write review

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
India: 75% Off World: 40% Off
This course teaches learners how to utilize the CHOOSE function in Excel for various purposes such as selecting names, survey results, quarters, formulas, functions, cell references, ranges, defined names, and array constants. The course covers 12 examples demonstrating the application of CHOOSE in different scenarios. By the end of the course, students will have the skills to effectively use the CHOOSE function in Excel for advanced data manipulation and analysis. The course is suitable for individuals looking to enhance their Excel skills and proficiency in data management and analysis.

Syllabus

1. Randomly CHOOSE names where value is "text" in quotes min
2. Use CHOOSE for Survey Results text Choose rounds down number to integer min
3. Use CHOOSE to select Quarters select numbers from Serial Dates min
4. Use CHOOSE to formula for Match Teacher template min
5. Use CHOOSE with Form Combo Box to select Average Formula min
6. Use CHOOSE to select function min
7. Use CHOOSE to select the correct MATCH function for an "OR" lookup situation min
8. Use CHOOSE to select Cell Reference min
9. Select Table for VLOOKUP with CHOOSE, where the values are ranges min
10. Select Table for VLOOKUP with CHOOSE, where the values are defined names min
11. Use CHOOSE to select array constant that tells MID function multiple starting points for text extraction, all in order to calculate the "Net Cost Equivalent" for a Series Discount. min
12. Use CHOOSE with Array constants entered into index_num argument to choose more than one thing at once: "mash" columns together to form a lookup table inside formula. min

Taught by

ExcelIsFun

Reviews

Start your review of CHOOSE Function - Beginner to Advanced Examples

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.