The Ultimate Microsoft Excel Training Bundle

3 Reviews
341 Enrolled
7 Courses & 43 Hours
Deal Price$29.00
Suggested Price
$199.00
You save 85%
The Ultimate Microsoft Excel Training Bundle
3 Reviews
$29.00$199.0085% OFF

What's Included

Microsoft Excel: Dynamic Array Functions
  • Experience level required: Beginner
  • Access 27 lectures & 2 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

27 Lessons (2h)

  • Your First Program

  • Intro to Dynamic Arrays

    Intro & Compatibility3:13
    DOWNLOAD: Course Resources
    Project Intro: Maven Recruiters2:12
    Legacy vs. "Dynamic" Excel7:47
    Spill Range Properties6:58
    PRO TIP: Growing Source Data11:08

  • Dynamic Array Functions

    Common Dynamic Array Functions1:31
    The SORT Function7:44
    The SORTBY Function5:03
    The FILTER Function14:54
    The UNIQUE Function4:51
    PRO TIP: Drop-Down Lists with SORT & UNIQUE4:13
    Combining SORT, FILTER & UNIQUE3:51
    Referencing Spill Ranges in Calculations5:18
    Conditional Formatting with Dynamic Arrays4:32
    PRO TIP: Creating Charts from Dynamic Arrays5:55
    The SEQUENCE Function1:47
    PRO TIP: Top N Calculations with SEQUENCE & LARGE8:55
    The RANDARRAY Function2:35
    PRO TIP: Creating Random Top N Lists9:55
    The FREQUENCY Function9:22
    The TRANSPOSE Function8:43
    PRO TIP: Joining Dynamic Arrays with CHOOSE8:11
    PRO TIP: Declaring Variables with LET11:14

  • Course Quiz & Assignment

    QUIZ: Dynamic Array Formulas
    ASSIGNMENT: Dynamic Array Formulas

  • More from Maven Analytics

    More from Maven Analytics

Microsoft Excel: Dynamic Array 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

In this comprehensive course, you'll learn how to unleash the full potential of Microsoft Excel with dynamic array functions. These functions make it easy to manipulate and analyze data, allowing you to quickly sort, filter, and extract unique values from large datasets. You'll also learn how to use sequence and array functions to automate tasks and generate random data. With hands-on projects and expert guidance, you'll master these powerful tools and take your Excel skills to the next level.

  • Access 27 lectures & 2 hours of content 24/7
  • Create more advanced formulas
  • Convert, sort, filter & manage lists
  • Insert & modify illustrations in a worksheet
  • Learn to use conditional formatting & styles

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
  • Experience level required: beginner
  • Updates included
  • Certificate of Completion ONLY
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Office 365 or Excel 2021
  • Experience with basic Excel formulas is strongly recommended

Terms

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

Clayton Bussiere

Verified Buyer

I got this on a whim because I moved from maintenance work to planning and database management. It was a huge change and involves lots of programs that are new to me. This bundle was a steal and literally within 2 weeks of starting the Microsoft: Beginner to Advanced course, I was blowing away my bosses! I'm onto Power Query now and it's incredible! Do NOT pass up this course package!

Jan 4, 2024
Krystian Staal profile picture

Krystian Staal

Verified Buyer

The amount of excel information at your disposal is insane. Lessons are well put together and easy to understand. Everything is easy to access and return to. And the price for what you get absolutely can not be beat. I took a full semester excel class that wasn't nearly as comprehensive as this bundle.

Dec 30, 2023
JW

Jay Williams

Verified Buyer

Very comprehensive yet easy to understand. The instruction is great and the exercises are a wonderful reinforcement of the material. Thank you.

Jun 27, 2023
Your Cart
Your cart is empty. Continue Shopping!
Processing order...