Use the most powerful formulas and functions in Excel - Job Skills Training
Excel: Advanced Formulas and Functions Use the most powerful formulas and functions in Excel
Excel: Advanced Formulas and Functions
0% Completed
Introduction
Use the most powerful formulas and functions in Excel
Video - 00:00:37 mins
Chapter 1 : Formula & Function Tips & Shortcuts
Display and highlight formulas
Video - 00:5:00 mins
Use the auditing tools
Video - 00:6:18 mins
Use entire row/column references
Video - 00:3:1 mins
Change formulas to values and update values without formulas
Video - 00:5:55 mins
Simplify debugging formulas with the F9 key
Video - 00:4:7 mins
Enhance readability with range names
Video - 00:5:10 mins
Create 3D formulas to tabulate data from multiple sheets
Video - 00:5:11 mins
Chapter 1 Quiz : Formula & Function Tips & Shortcuts
Quiz
Chapter 2: If & Related Functions
Explore IF logical tests and use relational operators
Video - 00:4:36 mins
Create and expand the use of nested IF statements
Video - 00:4:44 mins
Create compound logical tests with AND, OR, NOT, and IF
Video - 00:5:28 mins
Use IFS for multiple conditions
Video - 00:2:50 mins
Chapter 2 Quiz: If & Related Functions
Quiz
Chapter 3: Lookup & Reference Functions
Explore the VLOOKUP and HLOOKUP functions
Video - 00:3:41 mins
Find approximate matches with VLOOKUP and HLOOKUP
Video - 00:5:2 mins
Use VLOOKUP to find exact matches and search large tables
Video - 00:5:5 mins
Find table-like data within a function using CHOOSE
Video - 00:4:3 mins
Use the SWITCH function for formula-embedded selection
Video - 00:4:45 mins
Locate data with the MATCH function
Video - 00:3:28 mins
Retrieve information by location with the INDEX function
Video - 00:2:47 mins
Use the MATCH and INDEX functions together
Video - 00:4:3 mins
Document formulas with the FORMULATEXT function
Video - 00:2:37 mins
Extract and count unique entries from a list with UNIQUE
Video - 00:4:28 mins
Use the XLOOKUP function
Video - 00:5:7 mins
Chapter 3 Quiz: Lookup & Reference Functions
Quiz
Chapter 4: Power Functions
Tabulate data using a single criterion with COUNTIF, SUMIF, and AVERAGEIF
Video - 00:4:10 mins
Tabulate data using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIF
Video - 00:4:5 mins
Use MAXIFS and MINIFS
Video - 00:2:34 mins
Use the SUBTOTAL function to prevent double counting
Video - 00:4:58 mins
Chapter 4 Quiz: Power Functions
Quiz
Chapter 5: Statistical Functions
Find middle and most common values with MEDIAN and MODE
Video - 00:2:55 mins
Rank data without sorting using RANK and RANK.EQ
Video - 00:4:7 mins
Find the largest and smallest values with LARGE and SMALL
Video - 00:2:5 mins
Tabulate blank cells with the COUNTBLANK function
Video - 00:4:57 mins
Use COUNT, COUNTA, and the status bar
Video - 00:3:41 mins
Chapter 5 Quiz: Statistical Functions
Quiz
Chapter 6: Math Functions
Work with the ROUND, ROUNDUP, and ROUNDDOWN functions
Video - 00:5:43 mins
Use MROUND, CEILING, and FLOOR for specialized rounding
Video - 00:3:10 mins
Use INT, TRUNC, ODD, and EVEN for specialized rounding
Video - 00:3:19 mins
Use MOD to find remainders and apply conditional formatting
Video - 00:5:8 mins
Explore practical uses for RAND, RANDARRAY, and RANDBETWEEN
Video - 00:5:36 mins
Convert a value between measurement systems with CONVERT
Video - 00:3:14 mins
Use the AGGREGATE function to bypass errors and hidden data
Video - 00:4:53 mins
Use ROMAN and ARABIC to display different number systems
Video - 00:3:17 mins
Chapter 6 Quiz: Math Functions
Quiz
Chapter 7: Date & Time Functions
Understand Excel date and time capabilities in formulas
Video - 00:4:49 mins
Use various date and time functions
Video - 00:4:43 mins
Use the TODAY and NOW functions for date and time entry
Video - 00:5:35 mins
Identify weekdays with the WEEKDAY function
Video - 00:3:57 mins
Count working days and completion dates (NETWORKDAYS and WORKDAY)
Video - 00:4:6 mins
Tabulate date differences with the DATEDIF function
Video - 00:5:53 mins
Calculate dates with EDATE and EOMONTH
Video - 00:5:17 mins
Chapter 7 Quiz: Date & Time Functions
Quiz
Chapter 8: Reference Functions
Get data from remote cells with the OFFSET function
Video - 00:4:8 mins
Return references with the INDIRECT function
Video - 00:3:53 mins
Use INDIRECT with Data Validation for multitiered pick lists
Video - 00:5:23 mins
Chapter 8 Quiz: Reference Functions
Quiz
Chapter 9: Text Functions
Locate and extract data with FIND, SEARCH, and MID
Video - 00:5:11 mins
Extract data with the LEFT and RIGHT functions
Video - 00:3:42 mins
Use the TRIM function to remove unwanted spaces in a cell
Video - 00:4:48 mins
Combine data with symbols (&) and CONCATENATE
Video - 00:3:28 mins
Use CONCAT and TEXTJOIN to combine data from different cells
Video - 00:5:4 mins
Adjust alphabetic case with UPPER, LOWER, and PROPER
Video - 00:4:26 mins
Adjust character content with REPLACE and SUBSTITUTE
Video - 00:5:17 mins
Use utility text functions: TEXT, REPT, VALUE, and LEN
Video - 00:5:26 mins
Use the new LET function
Video - 00:5:23 mins
Create custom functions with LAMBDA
Video - 00:5:50 mins
New functions: TEXTBEFORE, TEXTAFTER, and TEXTSPLIT
Video - 00:6:18 mins
Chapter 9 Quiz: Text Functions
Quiz
Chapter 10: Information Functions
Extract information with the CELL and INFO functions
Video - 00:4:52 mins
Explore various information functions
Video - 00:4:36 mins
Use several error-checking functions
Video - 00:5:18 mins
Track and highlight formula cells with ISFORMULA
Video - 00:3:32 mins
Next steps
Next steps
Video - 00:00:34 mins
Announcements Reviews Live Classes Certificate Course Info
PreviousNext
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare
Job Skills Training