YoVDO

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Aggregate Functions Courses INDEX function Courses MATCH function Courses

Course Description

Overview

Learn essential Excel formula basics in this comprehensive 59-minute video tutorial. Review the Excel Golden Rule, formula elements, math and comparative operators, and types of formulas. Understand how formulas calculate using Excel's order of precedence, and explore number formatting and default alignment. Practice with 16 formula examples covering various elements and types. Master advanced techniques like using LARGE, ROWS, SMALL, COLUMNS, and AGGREGATE functions with expandable ranges to extract top and bottom values. Dive into 10 examples of INDEX and MATCH functions, learn SUMIFS for multi-criteria addition, and discover the advantages of formulas over other Excel features. Perfect for Excel users looking to enhance their formula skills and efficiency.

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 Econometrics
University 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