课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Dynamic Arrays: TOCOL, dropdowns, and conditional formatting

Dynamic Arrays: TOCOL, dropdowns, and conditional formatting - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Dynamic Arrays: TOCOL, dropdowns, and conditional formatting

“

- [Instructor] Now what I'm about to show you is exciting so hopefully you're sitting down and relaxed. We are going to weave together several Excel features and functions to build a bit of a tracker. The center is going to be dynamic arrays, and the TOCOL function. This function is not even a year old but it was like having a birthday. It was exciting when this came out, because so many of us wanted this in Excel. Let's look at this data. We have a list of conference rooms and we're trying to get everything filled in. We've got the days going across and you can see Gonzalo teaching Tuesday in the Anchovy room. We've got Al teaching Wednesday in the Parrotfish room. So we want to drop down list in C2 and a count in C3. Here we go. Equals TOCOL or to column, I'm going to slide over a bit. What is the array? We want this array to be turned into a single column. Comma, do we want to keep all values?, that's the default,…

内容