Excel Formulas - Basics and Beyond

ExcelIsFun via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Duration & workload

15 hours 45 minutes
Sessions

On-Demand
Level

Intermediate

Found in

Learn the fundamentals and advanced techniques of Excel formula creation through this comprehensive 15-hour 45-minute course. Master formula elements including references, operators, and functions while exploring different formula types such as calculating, text, logical, and array formulas. Discover the eight types of cell references and develop skills in error tracking and troubleshooting. Gain proficiency with essential functions including SUMIFS, SUMPRODUCT, and VLOOKUP, and understand table formula nomenclature with structured references. Practice with over 40 hands-on examples covering mixed cell references, conditional calculations, worksheet and workbook references, defined names, and aggregate functions. Explore logical functions like IF, AND, and OR for multiple criteria testing, rounding functions, and array formulas for advanced data manipulation. Learn modern Excel features including dynamic arrays, XLOOKUP, FILTER functions, and Power Query integration for data transformation. Develop expertise in lookup techniques, text manipulation with TEXTJOIN and ARRAYTOTEXT, conditional formatting with formulas, and model documentation strategies for professional spreadsheet development.

Syllabus

Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples
Excel & Business Math 03: Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models
Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!
Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!
Excel & Business Math 06: All About Excel Formulas (17 Examples) for Business Math Class
Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!
Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria
Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples)
Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples
Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel
Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References
Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models
Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions
Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.
Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests)
Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs
Highline Excel 2013 Class Video 16: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more...
Highline Excel 2013 Class Video 17: Introduction To SUMPRODUCT Function
Highline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP
Office 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions
Highline Excel 2013 Class Video 32: Introduction To Array Formulas and Array Functions
Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)
Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons
Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!
Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.
Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636
Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634
OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645
Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683.
Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.
Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715
Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716
Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731
Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741
Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742
OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751
Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753
VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800
UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805
Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810
Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts
Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts
Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819