课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

COMBIN COMBINA

COMBIN COMBINA

课程: Excel: Advanced Formulas and Functions

开始一个月试用 购买团队方案

COMBIN COMBINA

“

- [Narrator] 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 column B. Going from banana ginger, down to marshmallow tangerine. Hmm. Now don't tune out on me. Start thinking about cupcakes and whatnot. We're talking about Excel here, all right? Now, our little popup, 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 8. So, you can get 8 banana…

内容