The Ultimate Microsoft Excel Business Intelligence Certification Bundle

5 Reviews
607 Enrolled
12 Courses & 42 Hours
Deal Price$44.99
Suggested Price
$180.00
You save 75%
🔥 500+ Sold! Selling Fast
The Ultimate Microsoft Excel Business Intelligence Certification Bundle
5 Reviews
$44.99$180.0075% OFF

What's Included

Microsoft Excel: Advanced Formulas & Functions
  • Experience level required: Intermediate
  • Access 114 lectures & 8 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

114 Lessons (8h)

  • Your First Program
  • Getting Started
    Course Structure & Outline1:28
    DOWNLOAD: Course Resources
    Setting Expectations7:12
    Important Note for StackSkills Students
  • Excel Formulas 101
    Introduction1:48
    Formula Syntax11:03
    Fixed & Relative References8:42
    Common Error Types8:47
    Formula Auditing: Trace Precedents & Dependents10:14
    Formula Auditing: Evaluate Formula & Error Checking7:48
    Ctrl Shortcuts7:30
    Function Shortcuts9:44
    Alt Key Tips4:16
    BONUS: Mac Shortcuts
    PRO TIP: Data Validation6:12
    Congrats, You're a Developer!5:07
    QUIZ: Formulas 101
    HOMEWORK: Formulas 1010:46
  • Conditional Statements & Logical Operators
    Introduction1:23
    Anatomy of the IF Statement4:01
    Nested IF Statements4:53
    AND/OR Operators8:47
    NOT (<>) Operators3:17
    Addressing Errors with IFERROR4:03
    Common IS Statements4:00
    QUIZ: Conditional Statements & Logical Operators
    HOMEWORK: Conditional Statements & Logical Operators0:44
  • Statistical Functions
    Introduction1:09
    Basic Stats Functions5:17
    SMALL/LARGE & RANK/PERCENTRANK6:15
    RAND() & RANDBETWEEN2:12
    The SUMPRODUCT Function3:55
    SUMPRODUCT Demo4:57
    COUNTIFS/SUMIFS/AVERAGEIFS4:49
    DEMO: Basic Dashboards with Stats Functions8:09
    Combining COUNTIF & SUMPRODUCT7:57
    PRO TIP: Data Profiling16:06
    QUIZ: Statistical Functions
    HOMEWORK: Statistical Functions0:35
  • Lookup & Reference Functions
    Introduction1:18
    Named Arrays3:30
    ROW/ROWS & COLUMN/COLUMNS3:18
    VLOOKUP & HLOOKUP5:53
    DEMO: Joining Data with VLOOKUP6:23
    Combining IFERROR & VLOOKUP4:30
    VLOOKUP Range Options6:18
    Approximate Match Lookups5:05
    The INDEX Function1:59
    The MATCH Function2:32
    Combining INDEX & MATCH6:08
    Combining MATCH & VLOOKUP4:47
    UPDATE: VLOOKUP Correction5:05
    SNEAK PEEK: XLOOKUP (Office 365 Only)4:29
    DEMO: Building Dashboards with XLOOKUP18:16
    Selecting List Items with CHOOSE13:15
    The OFFSET Function2:05
    Combining OFFSET & COUNTA2:58
    DEMO: Building a Scrolling Chart with OFFSET9:51
    QUIZ: Lookup & Reference Functions
    HOMEWORK: Lookup & Reference Functions0:54
  • Text Functions
    Introduction0:50
    UPPER, LOWER, PROPER & TRIM3:32
    CONCATENATE (&)3:26
    LEFT, MID, RIGHT & LEN3:31
    TEXT & VALUE4:20
    SEARCH & FIND5:04
    Categorizing Data with IF(ISNUMBER(SEARCH))5:39
    Combining RIGHT, LEN & SEARCH5:43
    The SUBSTITUTE Function2:21
    QUIZ: Text Functions
    HOMEWORK: Text Functions0:59
  • Date & Time Functions
    Introduction2:08
    Understanding DATEVALUE5:05
    Date Formatting & Fill Series3:39
    TODAY() & NOW()2:16
    YEAR/MONTH/DAY & HOUR/MINUTE/SECOND3:04
    The EOMONTH Function6:17
    The YEARFRAC Function2:27
    WEEKDAY, WORKDAY & NETWORKDAYS7:22
    The DATEDIF Function4:23
    DEMO: Budget Pacing Tool11:07
    QUIZ: Date & Time Functions
    HOMEWORK: Date & Time Functions0:35
  • Formula-Based Formatting
    Introduction1:26
    Creating and Managing Formula-Based Rules4:39
    DEMO: Highlighting Rows with MOD3:50
    DEMO: Formatting Cells Based on Values3:29
    DEMO: Formatting Cells with Stats Functions5:28
    DEMO: Formatting Cells with Text & Conditional Functions5:08
    QUIZ: Formula-Based Formatting
    HOMEWORK: Formula-Based Formatting0:34
  • Basic Array Formulas
    Introduction1:24
    READ ME: Array Formulas are Changing!
    Rules of Array Formulas3:24
    Pros & Cons of Array Formulas2:15
    Vertical, Horizontal & 2-D Array Constants6:26
    Using Array Constants in Formulas3:38
    Named Array Constants4:31
    The TRANSPOSE Function4:21
    Linking Data: Array vs. Non-Array Comparison2:36
    DEMO: Returning the "X" Largest Values3:09
    DEMO: Counting Characters Across Cells1:52
    DEMO: Creating a "MAX IF" Function (Part 1)3:09
    DEMO: Creating a "MAX IF" Function (Part 2)6:54
    The Double Unary Operator ("--")3:49
    QUIZ: Array Formulas
    HOMEWORK: Array Formulas2:09
  • Extra Bonus Functions
    Introduction1:38
    The INDIRECT Function10:55
    The HYPERLINK Function6:19
    WEBSERVICE & FILTERXML: Weather Underground7:16
    WEBSERVICE & FILTERXML: Open Weather Map9:14
    QUIZ: Badass Bonus Functions
  • Wrapping Up
    More from Maven Analytics

Microsoft Excel: Advanced Formulas & Functions

MA
Maven AnalyticsMaven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

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 of transforming 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 several ways. This is especially useful for including your portfolio or resume so that future employers can feel confident in your skillset.

4.6/5 average rating: ★ ★ ★ ★ ★ ★

  • Access 114 lectures & 8 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

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: intermediate
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007 - 2019 or Office 365

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
5 Reviews
4.6/ 5
All reviews are from verified purchasers collected after purchase.
SD

Sergejs D.

Verified Buyer

At first I couldn’t find this course of lectures in my account, but then I wrote an email and received quick reply with correction. Everything is fine. For a beginner, a good product at an affordable price. I know that there is a platform where the information I need is located and it is structured. Pay once and use it. So far there have been no problems. Great deal.

Nov 26, 2023
CB

Corrine Banach

Verified Buyer

The course was easy to get into and is easy to follow along with. There is a practice component that gives hands on experience, and a reference for later.

Dec 28, 2021
RW

Ron Willing

Verified Buyer

Quality, Price extremely thorough, excellent instructor. I will learn a lot, even though I have been using spreadsheets since the early 80s

Dec 27, 2021
BT

Becky Tarver

Verified Buyer

There was a delay getting access, but I look forward to starting the training. The three programs I purchased hopefully open some doors to generate additional income for our family. I believe there is good potential to apply the information learned.

Sep 28, 2021
NG

Noah Gerlach

Verified Buyer

The instructor is a good speaker. He not only knows what he is talking about, his passion for Excel is visible.

Aug 20, 2021
Your Cart
Your cart is empty. Continue Shopping!
Processing order...