From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

COMBIN COMBINA

COMBIN COMBINA

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

COMBIN COMBINA

“

Here's something that's pretty sophisticated to understand and I'm not going to go too deep into it. I'm just wanting to show you more of Excel. What I'm going to show you is in a fairly robust section of functions. Let's look formulas and more functions statistical. Okay, there's average, average ifs, beta distribution. Count A. Covariance. Max-ifs. Median. Percentile. A lot of stuff here. All right, so let's look at this challenge. We got five flavors here in Columbia, going from banana ginger down to marshmallow tangerine. Now don't tune out on me. Start thinking about cupcakes and whatnot. We're talking about Excel here all right now our little pop-up we have two options that people can take a sampler box of three and all three must be different so you can't get a sampler box that's all cotton candy habanero no no the other option is a box of any eight So, you can get eight banana gingers, four mango cumin, four banana ginger, three cotton candy habanero, five marshmallow…

Contents