_Banner_Advanced_Formulas_Functions-Red.webp)
Chapter 5
Power Functions
Tabulating Data using a Single Criterion
Chapter 5
Power Functions
Tabulating Data using Multiple Criteria
Chapter 5
Power Functions
Using MAXIFS and MINIFS
Chapter 5
Power Functions
Preventing Double Counting
Chapter 6
Statistical Functions
Finding Middle Value with MEDIAN & Most Common Value with MODE
Chapter 6
Statistical Functions
Ranking Data Without Sorting with RANK & RANK.EQ
Chapter 6
Statistical Functions
Finding Largest & Smallest Values with LARGE & SMALL Functions
Chapter 6
Statistical Functions
Tabulating Blank Cells with COUNTBLANK Function
Chapter 6
Statistical Functions
Using COUNT, COUNTA, and Status Bar
Chapter 7
Math Functions
Working the ROUND, ROUNDUP & ROUNDDOWN Functions
Chapter 7
Math Functions
Working with MROUND, CEILING & FLOOR for Specialized Rounding
Chapter 7
Math Functions
Using INT & TRUNC Functions to Extract Integer Data
Chapter 7
Math Functions
Find Remainder with MOD & Using MOD with Conditional Formatting
Chapter 7
Math Functions
Exploring Practical uses for RAND & RANDBETWEEN Functions
Chapter 7
Math Functions
Converting a Value between Measurement Systems with CONVERT
Chapter 7
Math Functions
Use Powerful AGGREGATE Function to Bypass Errors & Hidden Data
Chapter 7
Math Functions
Using ROMAN & ARABIC Functions to Display Different Number Systems
Chapter 8
Date and Time Functions
Understanding Date & Time Capabilities in Formulas
Chapter 8
Date and Time Functions
Using DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE & SECOND Functions
Chapter 8
Date and Time Functions
Use the TODAY & NOW Functions for Dynamic Date & Time Entry
Chapter 8
Date and Time Functions
Identifying Day of the Week with WEEKDAY Function
Chapter 8
Date and Time Functions
Counting Working Days with the NETWORKDAYS Function
Chapter 8
Date and Time Functions
Determining a Completion Date with WORKDAY Function
Chapter 8
Date and Time Functions
Tabulating Date Differences with DATEDIF Function
Chapter 8
Date and Time Functions
Calculating End-of-Month & Future & Past Dates with EDATE & EOMONTH
Chapter 9
Array Formulas and Functions
Extending Formula Capabilities with Array Formulas
Chapter 9
Array Formulas and Functions
Counting Unique Entries in a Range with an Array Formula
Chapter 9
Array Formulas and Functions
Determining Frequency Distributions with FREQUENCY Function
Chapter 9
Array Formulas and Functions
Flipping Row & Column Orientation with TRANSPOSE
Chapter 9
Array Formulas and Functions
Building Analysis via Regression Techniques with TREND & GROWTH
Chapter 9
Array Formulas and Functions
Use Array Formulas & MATCH Function for Complex Lookups
Chapter 10
Reference Functions
Getting Data from Remote Cells with OFFSET Function
Chapter 10
Reference Functions
Returning References with INDIRECT Function
Chapter 10
Reference Functions
Use INDIRECT with Data Validation for Two-Tiered Pick List Scenarios
