Microsoft Excel: Advanced Excel Formulas & Functions

Master 75+ Excel Formula & Functions with Hands-On Demos

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. Upon completion of this course, and all courses included in the bundle, you'll also receive a certification of completion validating your new skills! This is especially useful for including in your portfolio or resume, so future employers can feel confident in your skill set.

Chris 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.

Microsoft Excel: Data Visualization, Excel Charts & Graphs

Master 20+ Charts & Graphs in Excel 2016 with Hands-On Demos

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.

Access 49 lectures & 4.5 hours of content 24/7

Explore each of the 20+ chart types that Excel 2016 has to offer

Dive into a series of 12+ advanced Excel demos guaranteed to turn you into a data visualization pro

Chris 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.

Microsoft Excel: Intro to Power Query, Power Pivot & DAX

Get Up & Running with Excel's Data Modeling & Business Intelligence Tools

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.

Access 86 lectures & 7 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

Chris 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.

Details & Requirements

Length of time users can access this course: lifetime

Access options: web streaming, mobile streaming

Certification of completion not included

Redemption deadline: redeem your code within 30 days of purchase

Experience level required: all levels

You need 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.)

Microsoft Excel: Data Analysis with Excel Pivot Tables

Master Excel Pivot Tables & Pivot Charts with Hands-On Demos

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to explore and analyze raw data quickly, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing marketing tactics, or wonder how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

Access 82 lectures & 6 hours of content 24/7

Cover raw data structure, table layouts & styles

Explore design & formatting options

Understand sorting, filtering, & grouping tools

Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more

Chris 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.

Details & Requirements

Length of time users can access this course: lifetime

Access options: web streaming, mobile streaming

Certification of completion not included

Redemption deadline: redeem your code within 30 days of purchase

Experience level required: all levels

You need 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.)

Master Microsoft Excel Macros and Excel VBA

Use 6 Simple Projects to Become a Master Working with Excel Macros & VBA

During this course, you will build a foundation of working with Excel Macros and VBA. You'll engage in several projects that will build upon one another as you progress through the basic building blocks of automating tasks within Excel. Soon you'll be ready to enter the world of Excel VBA, where you will experience a more dynamic, robust experience for yourself and your peers.

Access 57 lectures & 3.5 hours of content 24/7

Automate placing & formatting a title on a worksheet

Interact w/ the users of your Macros through input & message boxes

Clean up multiple Excel worksheets & prepare the data to be reported on

Create a report based on multiple sets of data found within multiple Excel worksheets

Automate the creation of Excel Formulas to SUM data up in your report

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013

Excel, Word, PowerPoint, Outlook, Access and Visio

SharePoint End-User 2007, 2010, 2013

VBA (Excel and Access)

Adobe Suite

Photoshop, Illustrator, InDesign

Maya (Modeling and Animation)

Unity3d (Game Design)

HTML, CSS and JavaScript

Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Microsoft Excel from Beginner to Advanced

The Complete "How-To" Excel Crash Course

More than 750 million people have Excel installed on their computer but 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.

Access 80 lectures & 6.5 hours of content 24/7

Get downloadable Excel workbooks which you can use to follow along

Learn how to install Microsoft Excel & work w/ formulas and functions

Calculate w/ the IF Function & apply conditional formatting

Use the PMT Function to explore monthly & yearly compounding

Use Google Drive to collect data

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 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.