Curriculum Tag: Free

Summary This video applies the concept of broadcasting to our example project. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example

Summary This video looks at broadcasting, which is an array behaviour when performing calculations on arrays. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Broadcasting Broadcasting is an array behaviour that occurs where arrays of varying sizes are used in calculation. The smaller array is expanded to the size of the larger array to enable calculation … Read more

Summary This video applies the concept of lifting to our example project. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example

Summary This video looks at the function behaviour of lifting. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Lifting Excel functions are of different types, they expect either single or multiple values. Arguments which expect a single value are known as scalar arguments. Lifting occurs when a scalar argument is provided with multiple values in a … Read more

Summary In this video, we go deeper looking at arrays. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Array & array functions Array separators differ based on your regional settings. Make sure you use the characters for your settings. Spilling occurs when a single formula returns values to multiple cells on the grid. The range created … Read more

Summary In this video, we look at the differences between ranges and arrays. Ranges are a group of cells which exist on the face of Excel’s grid. Each cell has a co-ordinates to show where it exists within the grid. Arrays are a groups of values; they do not need to exist on the grid. … Read more

Summary Welcome to the Modern Excel Formulas course. Excel has change significantly over the last 10 years with new features and a new calculation engine. The purpose of this course is to give you a deep understanding of the basics, so that you can understand how Excel really works. The topics covered in the course … Read more