Excel: Advanced Formulas and Functions
Focused View
Dennis Taylor
4:46:32
392 View
01 - Use the most powerful formulas and functions in Excel.mp4
00:38
01 - Display and highlight formulas.mp4
05:00
02 - Use the auditing tools.mp4
06:18
03 - Use entire rowcolumn references.mp4
03:01
04 - Change formulas to values and update values without formulas.mp4
05:55
05 - Simplify debugging formulas with the F9 key.mp4
04:07
06 - Enhance readability with range names.mp4
05:10
07 - Create 3D formulas to tabulate data from multiple sheets.mp4
05:12
01 - Explore IF logical tests and use relational operators.mp4
04:36
02 - Create and expand the use of nested IF statements.mp4
04:44
03 - Create compound logical tests with AND, OR, NOT, and IF.mp4
05:28
04 - Use IFS for multiple conditions.mp4
02:52
01 - Explore the VLOOKUP and HLOOKUP functions.mp4
03:41
02 - Find approximate matches with VLOOKUP and HLOOKUP.mp4
05:02
03 - Use VLOOKUP to find exact matches and search large tables.mp4
05:05
04 - Find table-like data within a function using CHOOSE.mp4
04:03
05 - Use the SWITCH function for formula-embedded selection.mp4
04:48
06 - Locate data with the MATCH function.mp4
03:28
07 - Retrieve information by location with the INDEX function.mp4
02:47
08 - Use the MATCH and INDEX functions together.mp4
04:03
09 - Document formulas with the FORMULATEXT function.mp4
02:37
10 - Extract and count unique entries from a list with UNIQUE.mp4
04:26
11 - Use the XLOOKUP function.mp4
05:07
01 - Tabulate data using a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mp4
04:10
02 - Tabulate data using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mp4
04:05
03 - Use MAXIFS and MINIFS.mp4
02:36
04 - Use the SUBTOTAL function to prevent double counting.mp4
04:55
01 - Find middle and most common values with MEDIAN and MODE.mp4
02:55
02 - Rank data without sorting using RANK and RANK.EQ.mp4
04:07
03 - Find the largest and smallest values with LARGE and SMALL.mp4
02:08
04 - Tabulate blank cells with the COUNTBLANK function.mp4
04:57
05 - Use COUNT, COUNTA, and the status bar.mp4
03:41
01 - Work with the ROUND, ROUNDUP, and ROUNDDOWN functions.mp4
05:43
02 - Use MROUND, CEILING, and FLOOR for specialized rounding.mp4
03:10
03 - Use INT, TRUNC, ODD, and EVEN for specialized rounding.mp4
03:19
04 - Use MOD to find remainders and apply conditional formatting.mp4
05:08
05 - Explore practical uses for RAND, RANDARRAY, and RANDBETWEEN.mp4
05:36
06 - Convert a value between measurement systems with CONVERT.mp4
03:12
07 - Use the AGGREGATE function to bypass errors and hidden data.mp4
04:53
08 - Use ROMAN and ARABIC to display different number systems.mp4
03:17
01 - Understand Excel date and time capabilities in formulas.mp4
04:49
02 - Use various date and time functions.mp4
04:43
03 - Use the TODAY and NOW functions for date and time entry.mp4
05:37
04 - Identify weekdays with the WEEKDAY function.mp4
03:57
05 - Count working days and completion dates (NETWORKDAYS and WORKDAY).mp4
04:06
06 - Tabulate date differences with the DATEDIF function.mp4
05:53
07 - Calculate dates with EDATE and EOMONTH.mp4
05:17
01 - Get data from remote cells with the OFFSET function.mp4
04:08
02 - Return references with the INDIRECT function.mp4
03:53
03 - Use INDIRECT with Data Validation for multitiered pick lists.mp4
05:23
01 - Locate and extract data with FIND, SEARCH, and MID.mp4
05:11
02 - Extract data with the LEFT and RIGHT functions.mp4
03:42
03 - Use the TRIM function to remove unwanted spaces in a cell.mp4
04:48
04 - Combine data with symbols (&) and CONCATENATE.mp4
03:28
05 - Use CONCAT and TEXTJOIN to combine data from different cells.mp4
05:04
06 - Adjust alphabetic case with UPPER, LOWER, and PROPER.mp4
04:26
07 - Adjust character content with REPLACE and SUBSTITUTE.mp4
05:17
08 - Use utility text functions TEXT, REPT, VALUE, and LEN.mp4
05:26
09 - Use the new LET function.mp4
05:23
10 - NEW Create custom functions with LAMBDA.mp4
05:50
01 - Extract information with the CELL and INFO functions.mp4
04:52
02 - Explore various information functions.mp4
04:36
03 - Use several error-checking functions.mp4
05:18
04 - Track and highlight formula cells with ISFORMULA.mp4
03:32
01 - Next steps.mp4
00:34
01 - Use the XLOOKUP function.mp4
05:19
Ex_Files_Excel_Advanced_Formulas_Functions.zip
Ex_Files_Excel_Advanced_Formulas_Functions_2021.zip
Glossary_Excel_Advanced_Formulas_Functions.zip
Description
Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.
More details
User Reviews
Rating
average 0
Focused display
Category
Dennis Taylor
Instructor's CoursesLeading Excel trainer with more than 200 hours (60+ courses) of online Excel training available on LinkedIn Learning. Presenter of in-person Excel classes and seminars in over 40 states and Canada. To learn more, visit www.excel-train.com.
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 66
- duration 4:46:32
- Release Date 2023/01/04
