The 2023 Premiere Microsoft Excel Certification Training Bundle for $44 April 27, 2023 at 02:00AM



Checkout Now

Expires April 27, 2123 23:59 PST
Buy now and get 79% off

Microsoft Excel: Dynamic Array Functions

KEY FEATURES

This course is designed to teach you some of the most powerful dynamic array functions in Excel. The course will introduce dynamic array behavior and spill range properties, then review some of the most common array functions in Excel. From there you'll be able to practice nesting functions to create more advanced formulas, and combine them with other functions like frequency, choose, and let to create dynamic drop-downs, conditional formats, custom charts, and more.

  • Access 27 lectures & 2 hours of content 24/7
  • Learn to populate Arrays several different ways
  • Understand multiple ways to put Array data onto worksheets
  • Store Data in Hidden Locations & manipulate it
  • Return multiple pieces of information from a single function
  • Learn special built-in functions specifically for Arrays as well as custom functions

NOTE: Software NOT included

PRODUCT 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

THE EXPERT

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers. Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

Microsoft Excel: Advanced Formulas & Functions

KEY FEATURES

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.

4.7/5 average rating: ★ ★ ★ ★
  • Access 144 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

PRODUCT 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

  • Any device with basic specifications

THE EXPERT

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers. Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

Microsoft Excel: Data Visualization with Charts & Graphs

KEY FEATURES

Ask people what comes to mind when they think of Excel, and odds are they'll say, "spreadsheets." However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel's latest data visualization tools and techniques. You'll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

4.7/5 average rating: ★ ★ ★ ★
  • Access 62 lectures & 4 hours of content 24/7
  • Understand when, why & how to use 20+ chart types in Excel
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, & more
  • Master unique tips, tools, and case studies that you won't find in any other Excel course
  • Build 10+ Excel projects designed to take your data visualization skills to the next level

NOTE:
  1. Software NOT included
  2. Mac users are welcome, but note that the user experience will be significantly different across platforms

PRODUCT 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

  • Microsoft Excel (ideally 2016 for PC)

THE EXPERT

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers. Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

Excel for Business Intelligence Part 1: Power Query

KEY FEATURES

If you're looking to become a power Excel user and absolutely supercharge your Excel analytics game, this course is the A-Z guide that you're looking for. This course will give you an introduction to the "Power Query" landscape, and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence.

4.7/5 average rating: ★ ★ ★ ★
  • Access 13 lectures & 7 hours of content 24/7
  • Learn how to change data modeling & business intelligence tools
  • Master unique tips, tools & case studies
  • Learn how to use Power Query, Power Pivot & DAX
  • Revolutionize your workflow in Excel
  • Load data into Excel from flat files, folders, databases, API services & more
  • create completely automated loading procedures inside of Excel with only a few clicks

NOTE: Software NOT included

PRODUCT 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

  • Microsoft Office 365 for PC/Windows or Mac, or a version of Excel compatible with Power Query & Power Pivot (2016+)
  • Experience with Excel PivotTables and formulas & functions is strongly recommended

THE EXPERT

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers. Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

Excel for Business Intelligence Part 2: Data Modeling

KEY FEATURES

In this course you'll discover Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and absolutely supercharge your analytics, this course is the A-Z guide that you're looking for. Using sample data from a fictional supermarket chain, you'll get hands-on with Power Query; a tool to extract, transform, and load data from flat files, folders, databases, API services and more. In this course, you will be able to practice shaping, blending and exploring our project files.

  • Access 23 lectures & 1 hour of content 24/7
  • Create completely automated loading procedures with only a few clicks
  • Learn the fundamentals of database design & normalization
  • Explore & analyze different business data model
  • Create & modify table relationships
  • Learn how to connect multiple data tables
  • Define hierrarchies

NOTE:
  1. Software NOT included
  2. Power Pivot is currently unavailable with Excel for Mac

PRODUCT 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

  • A version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)
  • Experience with Excel Pivot Tables & cell formulas and functions is strongly recommended

THE EXPERT

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers. Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

Excel for Business Intelligence Part 3: Power Pivot & DAX

KEY FEATURES

This course will introduce you to Microsoft Excel's powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you're looking for. You'll be introduced to the "Power Excel" landscape and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence. Also, you'll walk through the Excel BI workflow and build an entire Excel data model from scratch.

4.7/5 average rating: ★ ★ ★ ★
  • Access 47 lectures & 3 hours of content 24/7
  • Use sample data from a fictional supermarket chain to get hands-on w/ Power Query
  • Practice shaping, blending, & exploring project files
  • Cover the fundamentals of database design & normalization
  • Explore & analyze your data model using Power Pivot & DAX
  • Cover basic DAX syntax & learn some of the most powerful and commonly used functions

NOTE: Software NOT included

PRODUCT 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

  • Microsoft Excel (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • Basic knowledge with Excel PivotTables, Formulas & Functions

THE EXPERT

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers. Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

The Complete Microsoft Excel Course including How to Program in Excel

KEY FEATURES

In this course, you will learn all of the common functions in Excel and introduce you to programming using Visual Basic for Applications (VBA) & Macros. You will learn the basic skills required to program in Excel, including inserting images and data, creating advanced pivot tables, and working with formulas. With this comprehensive course, you’ll have the knowledge needed to create amazing dashboards and reports.

4.6/5 average rating: ★ ★ ★ ★
  • Access 200+ lectures & 13 hours of content 24/7
  • Discover how to use Excel functions from basic to advanced
  • Understand basic functions & formulas
  • Create Excel charts (from basic to advanced level)
  • Generate Datasets and Data visualizations in Microsoft Excel
  • Learn how to create a pivot table
  • Automate your day-to-day Excel tasks by mastering the power of Macros & VBA
  • Learn how to use & change defined names
  • Learn how to program & insert images

NOTE: Software NOT included

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

Requirements

  • Any device with basic specifications

THE EXPERT

Chris Haroun is an award-winning business school professor, venture capitalist, MBA graduate from Columbia University, and former Goldman Sachs employee. He has raised/managed over $1bn in his career. He also has work experience at hedge fund giant Citadel, consulting firm Accenture, and several firms that he has started, including an investment firm that had a venture capital / private investment in Facebook several years before the Facebook IPO. He is the founder and CEO of Haroun Education Ventures.

Pivot Tables

KEY FEATURES

In this course, you will learn how to make the most of this powerful data analysis function. You will get a deep understanding of what pivot tables are and how they can be used for reporting, analysis and forecasting. Once you've finished this course you'll be able to create any type of Pivot Table using Excel.

4.9/5 average rating: ★ ★ ★ ★
  • Access 9 lectures & 1 hour of content 24/7
  • Learn how to create pivot tables
  • Organise data ready to create pivot tables
  • Add conditional formatting to your pivot table
  • Learn how to use pivot tables
  • Add in pie charts or bar charts with your pivot tables
  • Learn how to add in slicers to your projects

NOTE: Software NOT included

PRODUCT 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

  • Microsoft Excel

THE EXPERT

Kathryn Tilley has been using Microsoft Excel for so many years and now she creates courses to help her students learn all about Excel and to make their lives easier.

Microsoft Excel Basics: Creating a Sales Report

KEY FEATURES

This course is designed to help you learn the basics of using Microsoft Excel. We will start with simple functions and work our way up to creating a sales report. You will also be able to create a sales report that is appealing and easy to follow while showing the data in an organized fashion. After taking this class, you will feel confident in your ability to present financial data in an appealing visual format.

4.6/5 average rating: ★ ★ ★ ★
  • Access 8 lectures & 1 hour of content 24/7
  • Create basic bar charts & line charts
  • Learn to use formulas & functions
  • Convert, sort, filter & manage lists
  • Insert & modify illustrations in a worksheet
  • Manipulate dates, times, text, & arrays

NOTE: Software NOT included

PRODUCT 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

  • Access to Microsoft Excel

THE EXPERT

Learnhoot Professional has a wealth experience in the corporate world & they will teach you professional courses that are project-based and help you focus on real life scenarios. All of their courses have assignments that will let you practice the new skills you have learned during these courses.

Microsoft Excel Intermediate: Creating a Dashboard

KEY FEATURES

If you use Microsoft Excel in your professional life or even personal life then this course will be perfect for you. In this course, you will learn how to create and manage master data in Excel. You will learn about creating data sets, pivot tables, charts, and dashboards. Also, this course will discuss techniques for building spreadsheets that provide better-looking presentations and data visualizations

4.4/5 average rating: ★ ★ ★ ★
  • Access 9 lectures & 1 hour of content 24/7
  • Design your own Sales Dashboard
  • Create Fantastic Gradients
  • Understand the power of Pivot Charts
  • Learn how to automatically refresh a dashboard with basic VBA
  • Learn the basics of pivot charts
  • Learn how to transform a large data set into visually appealing charts

NOTE: Software NOT included

PRODUCT 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

  • Access to Microsoft Excel (ideally Office 365)

THE EXPERT

Learnhoot Professional has a wealth of experience in the corporate world & they will teach you professional courses that are project-based and help you focus on real-life scenarios. All of their courses have assignments that will let you practice the new skills you have learned during these courses.

Microsoft Excel: From Beginner to Advanced 2023

KEY FEATURES

Excel can be the most awkward of all Microsoft programs if not, the most awkward programs of all time! And although 750 million people have Excel installed on their computer, most do not know how to use it! Whatever version of Excel you have, this course will show you how to build and prepare a Workbook good enough for a fortune 500 CEO to a household budget, and everything in between. It's designed to help you get up to speed as fast as possible, you can expect to be at a capable level within the first hour of lectures, then you will have the opportunity to explore more great features, functions, and tools as you progress further through the course.

4.6/5 average rating: ★ ★ ★ ★
  • Access 92 lectures & 8 hours of content 24/7
  • Acquire critical Excel knowledge
  • Create workbooks & spreadsheets everyone will be jealous of
  • Learn all about: tables, charts, formatting, formulas & functions, macros, pivot tables/charts, and much more!
  • Calculate with the IF Function & apply conditional formatting
  • Use the PMT Function to explore monthly & yearly compounding
  • Use Google Drive to collect data

NOTE: Software NOT included.

PRODUCT 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

  • Any version of Excel including Excel in Microsoft Office 365

THE EXPERT

Warrick Klimaytys has spent many years with all kinds of computers in many different situations around the world and is eager to share his knowledge and skills with the StackCommerce community. Around a decade ago Warrick started his professional life in the military where he experienced all kinds of computers and machines. Today, he could be referred to as just a Microsoft "Windows Warrior". As a result of his past experience, he finds it best to deliver lessons in bite-sized chunks.




Checkout Now

Comments

Popular Posts