The Ultimate Microsoft Excel Certification Training Bundle
106019 Enrolled
6 Courses & 33.5 Hours
$29.99$48.00
Save 37%
What's Included
$8.00 Value
Microsoft Excel: Advanced Excel Formulas & Functions
Excel Maven
93 Lessons (6h)
Lifetime
- Experience level required: All levels
- Access 93 lectures & 6 hours of content 24/7
- Length of time users can access this course: Lifetime
Course Curriculum
93 Lessons (6h)
- Your First Program
- Getting StartedCourse Structure & Outline4:12Downloading the Homework Exercises1:42
- Excel Formulas 101Introduction1:06The Formula Library & Auditing Tools4:37DEMO: Evaluate Formula1:25Basic Formula Syntax3:31Fixed & Relative Cell References4:57Common Errors & IFERROR7:25Function, CTRL & ALT Shortcuts6:36BONUS: Mac Shortcuts2:08Data Validation Rules3:28Fixed vs. Volatile Functions3:21QUIZ: Formulas 101HOMEWORK: Formulas 1010:46
- Conditional Statements & Logical OperatorsIntroduction1:23Anatomy of the IF Statement4:01Nested IF Statements4:53AND/OR Operators8:47NOT () Operators3:17Addressing Errors with IFERROR4:03Common IS Statements4:00QUIZ: Conditional Statements & Logical OperatorsHOMEWORK: Conditional Statements & Logical Operators0:44
- Statistical FunctionsIntroduction1:12Basic Stats Functions5:17SMALL/LARGE & RANK/PERCENTRANK6:19RAND() & RANDBETWEEN2:12The SUMPRODUCT Function3:55COUNTIFS/SUMIFS/AVERAGEIFS4:49DEMO: Basic Dashboards with Stats Functions8:09QUIZ: Statistical FunctionsHOMEWORK: Statistical Functions0:35
- Lookup & Reference FunctionsIntroduction1:23Named Arrays3:30ROW/ROWS & COLUMN/COLUMNS3:18VLOOKUP & HLOOKUP5:54DEMO: Joining Data with VLOOKUP6:23Combining IFERROR & VLOOKUP4:30VLOOKUP Range Options6:18The INDEX Function1:59The MATCH Function2:32Combining INDEX & MATCH6:08Combining MATCH & VLOOKUP4:47UPDATE: VLOOKUP Correction5:05The OFFSET Function2:05Combining OFFSET & COUNTA2:58DEMO: Building a Scrolling Chart with OFFSET9:51QUIZ: Lookup & Reference FunctionsHOMEWORK: Lookup & Reference Functions0:54
- Text FunctionsIntroduction0:57UPPER, LOWER, PROPER & TRIM3:32CONCATENATE (&)3:26LEFT, MID, RIGHT & LEN3:31TEXT & VALUE4:20SEARCH & FIND5:04Categorizing Data with IF(ISNUMBER(SEARCH))5:39Combining RIGHT, LEN & SEARCH5:43The SUBSTITUTE Function2:21QUIZ: Text FunctionsHOMEWORK: Text Functions0:59
- Date & Time FunctionsIntroduction2:13Understanding DATEVALUE5:05Date Formatting & Fill Series3:39TODAY() & NOW()2:16YEAR/MONTH/DAY & HOUR/MINUTE/SECOND3:04The EOMONTH Function6:17The YEARFRAC Function2:27WEEKDAY, WORKDAY & NETWORKDAYS7:24The DATEDIF Function4:23DEMO: Budget Pacing Tool11:07QUIZ: Date & Time FunctionsHOMEWORK: Date & Time Functions0:35
- Formula-Based FormattingIntroduction1:30Creating and Managing Formula-Based Rules4:39DEMO: Highlighting Rows with MOD3:50DEMO: Formatting Cells Based on Values3:29DEMO: Formatting Cells with Stats Functions5:28DEMO: Formatting Cells with Text & Conditional Functions5:08QUIZ: Formula-Based FormattingHOMEWORK: Formula-Based Formatting0:34
- Basic Array FormulasIntroduction1:26Rules of Array Formulas3:24Pros & Cons of Array Formulas2:15Vertical, Horizontal & 2-D Array Constants6:26Using Array Constants in Formulas3:38Named Array Constants4:31The TRANSPOSE Function4:21Linking Data: Array vs. Non-Array Comparison2:36DEMO: Returning the "X" Largest Values3:09DEMO: Counting Characters Across Cells1:52DEMO: Creating a "MAX IF" Function (Part 1)3:09DEMO: Creating a "MAX IF" Function (Part 2)6:54The Double Unary Operator ("--")3:49QUIZ: Array FormulasHOMEWORK: Array Formulas2:09
- Badass Bonus FunctionsIntroduction1:41The INDIRECT Function10:55The HYPERLINK Function6:19Real-Time Data with WEBSERVICE & FILTERXML7:16QUIZ: Badass Bonus Functions
- Wrapping UpResources & Next Steps0:41
Microsoft Excel: Advanced Excel Formulas & Functions
EM
Excel MavenChris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.
He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
Description
It's time to show Excel who's boss! Whether you're starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you'll learn why these formulas are awesome and how they can be applied in a number of ways. This is especially useful for including in your portfolio or resume, so future employers can feel confident in your skill set.
- Access 93 lectures & 6 hours of content 24/7
- Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data
- Go rogue & design your own formula-based formatting rules
- Join datasets from multiple sources in seconds w/ lookup, index, & match functions
- Pull real-time data from APIs directly into Excel
- Manipulate dates, times, text, & arrays
- Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel
Note: Software NOT included.
Specs
Details & Requirements
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
- Microsoft Excel required
- Have questions on how digital purchases work? Learn more here
Compatibility
- Internet required
$8.00 Value
Microsoft Excel: Data Visualization, Excel Charts & Graphs
Excel Maven
49 Lessons (4.5h)
Lifetime
$8.00 Value
Microsoft Excel: Intro to Power Query, Power Pivot & DAX
Excel Maven
86 Lessons (7h)
Lifetime
$8.00 Value
Microsoft Excel: Data Analysis with Excel Pivot Tables
Excel Maven
82 Lessons (6h)
Lifetime
$8.00 Value
Master Microsoft Excel Macros and Excel VBA
Kyle Pew
57 Lessons (3.5h)
Lifetime
$8.00 Value
Microsoft Excel from Beginner to Advanced
Warrick Kilmaytys
80 Lessons (6.5h)
Lifetime
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...