课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

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

Dynamic arrays introduction

Dynamic arrays introduction

课程: Excel: Advanced Formulas and Functions

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

Dynamic arrays introduction

“

- Let's talk about the new calculation engine that's behind Excel and the new dynamic array functions. We're not going to go into depth, in this course, with the dynamic arrays because they are worthy of entire courses. And in fact, I have a course on dynamic arrays in the LinkedIn Learning Library, as do other authors. So check 'em out. Go deep on this because they are so powerful. But first, let's take a look at the new calculation engine, and then we'll look at specific functions. Okay, let's look at this. Some basic thing that we often need to do. We want to calculate the days between the start and end dates. So here we go. Equals, I'm going to highlight the entire End, and then minus the Start, Enter. Oh, we got a spill error. That means there's not enough free space for Excel to show us the full results. So go back to the formula. Look, the dashed blue line is saying, "This is how much room I need in order…

内容