Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics
Offered By: ExcelIsFun via YouTube
Course Description
Overview
Syllabus
min) Excel's Golden Rule..
min) Formula Elements..
min) Math Operators..
min) Comparative Operators..
min) Types of Formulas..
min) How Formulas Calculate: Order of Precedence in Excel..
min)Number Formatting is a Façade..
min) Default Alignment in Excel..
min)16 formula examples of formula elements and formula types..
min) LARGE and ROWS functions and 'expandable range' to extract Top ..
min) SMALL and COLUMNS functions and 'expandable range' to extract bottom 3..
min) AGGREGATE and ROWS functions and 'expandable range' to extract bottom 3..
min) 10 Examples of INDEX and MATCH functions..
min) SUMIFS to add with two criteria..
min) Advantage of formulas over other Excel features such as Filter and PivotTables..
Taught by
ExcelIsFun
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard