Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

CHOOSE

Excel and Budgeting

By Jeff Lenning | May 19, 2020 |

I recently wrote an article for the Minnesota Society of CPAs about a technique that helps you create budgets faster. Even if you don’t prepare budgets, the underlying features and functions used can be applied elsewhere. In summary, we use a data validation drop-down to provide several Budget Methods. Once you select a budget method…

Read More

CHOOSE or SWITCH

By Jeff Lenning | June 3, 2019 |

For decades, Excel users have had the CHOOSE function and it has been able to power some wonderful formulas. But recently, we received the SWITCH function which provides much more flexibility. From a high level, both functions enable us to analyze a value and then return various results based on that value. But, SWITCH offers…

Read More

Pick the Math with Excel’s CHOOSE Function

By Jeff Lenning | August 8, 2013 |

Have you ever wanted to allow the workbook user to pick the math that a formula should use?  This post explores the CHOOSE function, which, among other things, enables us to allow the user to pick the math. CHOOSE Before jumping right into the function’s syntax, let’s get a little context.  Let’s say that we…

Read More