Deals

MacTrast Deals: The 2022 Complete Microsoft Excel Expert Bundle

The 2022 Complete Microsoft Excel Expert Bundle includes 12 courses with 600+ video lessons for 70 hours of training.

The 2022 Complete Microsoft Excel Expert Bundle: 12 Courses with 600+ Video Lessons & 70+ Hours of Training! Be a Master at Sorting, Analyzing, and Visualizing Datasets on Microsoft Excel – Just $34.99!

Microsoft Excel 2021/365: Beginners Course

Sharpen Your Skills & Upgrade from an Older Version of Excel

Excel 2021 is the latest stand-alone release from Microsoft and includes many of the features and functionalities currently available only in the subscription-based Excel 365. If you have no Excel experience whatsoever, then this course is the perfect starting point for you. Perhaps you have some basic Excel knowledge, and you want to upgrade from an older version of Excel or sharpen your skills. Well, this training will get you up to speed. The course is 11 hours, with 100 individual video lessons and exercises. It includes downloadable course files and exercise files, so you can follow along with the instructor and then practice what you have learned at the end of each section.

4.43/5 average rating: ★ ★ ★ ★ ★★

  • Access 100 lectures & 11 hours of content 24/7
  • Know what’s new in Excel 2021
  • Navigate the Excel 2021 interface
  • Learn useful keyboard shortcuts to increase pro
  • Effectively apply formatting to cells & use conditional formatting
  • Work efficiently by using the cut, copy, & amp;paste options
  • Analyze data using charts

Note: Software NOT included.<

Advanced Formulas in Excel

Perform Complex Tasks & Analysis with Advanced Excel Formulas, Functions, and Tools

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this Advanced Formulas in Excel course, you’ll focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analyses. The course will look at how to filter a dataset and sort using formulas. After that, you’ll learn how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles, and so much more! We end by looking at how to use XLOOKUP.

4.4/5 average rating: ★ ★ ★ ★ ★★

  • Access 12 lectures & 2.5 hours of content 24/7
  • Filter a dataset using a formula
  • Sort a dataset using formulas & defined variables
  • Create multi-dependent dynamic drop-down lists
  • Perform a 2-way lookup
  • Make decisions with complex logical calculations
  • Extract parts of a text string
  • Create a dynamic chart title
  • Find the last occurrence of a value in a list
  • Look up information with XLOOKUP
  • Find the closest match to a value

Note: Software NOT included.

Intermediate VBA

Become the Office VBA for Excel Expert & a Master of Productivity

This professionally produced video course shows anyone with some VBA experience how to supercharge Excel. You will learn more advanced procedures for automating tough and time-consuming Excel jobs with advanced micros. This course gives you a lot more power to fully customize VBA to do some pretty miraculous things. This is the training you need to improve your abilities with VBA. Make yourself more valuable at work or use these concepts for your own business or personal needs.

  • Access 37 lectures & 4.5 hours of content 24/7
  • Understand more advanced VBA language
  • Learn advanced tools for doing just about anything you need with VBA
  • Know how to use References & Libraries
  • Practice what you’ve learned with included exercises & quiz

Note: Software NOT included.

VBA for Beginners

Use VBA Macros in Excel to Automate Tasks & Operations Performed Frequently

The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently. Through 4 hours of video lectures, exercise files, and an optional quiz, you’ll learn the essentials you need to know to create powerful macros using VBA for Excel. When you complete this course, you’ll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently.

4.36/5 average rating: ★ ★ ★ ★ ★★

  • Access 32 lectures & 4 hours of content 24/7
  • Find out how to use the VBA editor, VBA syntax, keywords, & comments
  • Discover how to define & manage variables, set up subroutines, and create functions
  • Also, find out how to use input boxes & message boxes to interact with end users
  • Learn practical methods for using macro errors to improve your VBA code

Note: Software NOT included.

Advanced PivotTables in Excel

Master PivotTables & Easily Perform Data Analysis Tasks

In this Advanced PivotTables in Excel course, you’ll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You’ll get a PivotTable refresher and move on to some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

4.7/5 average rating: ★ ★ ★ ★ ★★

  • Access 49 lectures & 7.5 hours of content 24/7
  • Do a PivotTable (a quick refresher)
  • Combine data from multiple worksheets for a PivotTable
  • Group, ungroup & deal with errors
  • Format a PivotTable, including adjusting styles
  • Use the Value Field Settings
  • Learn Advanced Sorting & Filtering in PivotTables
  • Use Slicers, Timelines on multiple tables
  • Create a Calculated Field
  • Learn all about GETPIVOTDATA
  • Create a Pivot Chart & add sparklines and slicers
  • Use 3D Maps from a PivotTable
  • Update your data in a PivotTable & Pivot Chart
  • Learn all about Conditional Formatting in a PivotTable
  • Create a basic macro to refresh PivotTable data

Note: Software NOT included.

Power Pivot, Power Query & DAX in Excel

Analyze Data at Scale with These Advanced Excel Functions

This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This Excel function suite allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. You’ll first learn how to bring your data together, merge, and clean it using Power Query. You’ll then perform calculations on your data model using DAX, and finally, look at displaying your analysis using PivotTables and PivotCharts. This course also includes practice exercises and follow-along files to build your data models as you learn.

4.2/5 average rating: ★ ★ ★ ★ ★★

  • Access 44 lectures & 3.5 hours of content 24/7
  • Get started with Power Query
  • Connect Excel to multiple workbooks
  • Merge & append queries using Power Query
  • Set up & manage relationships in a data model
  • Create a PivotTable to display your data
  • Use functions such as CALCULATE, DIVIDE, DATESYTD in DAX

Note: Software NOT included.

Excel for Business Analysts

All the Functions & Formulas You Need to Perform Detailed Data Analysis

Microsoft Excel remains one of the best tools for Data Analysis. In this course, you’ll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You’ll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises to immediately put into practice the new data analysis techniques that you learn.

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

  • Access 55 lectures & 7 hours of content 24/7
  • Merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, & XLOOKUP
  • Use IF, IFS, IFERROR, SUMIF, & COUNTIF to apply logic to your analysis
  • Split data using text functions SEARCH, LEFT, RIGHT, MID
  • Standardize & clean data ready for analysis
  • Use the PivotTable function to perform data analysis
  • Use slicers to draw out information
  • Display your analysis using Pivot Charts
  • Learn about forecasting & using the Forecast Sheets
  • Conduct a Linear Forecast & Forecast Smoothing
  • Use Conditional Formatting to highlight areas of your data
  • Use Goal Seek, Scenario Manager, & Solver to fill data gaps

Note: Software NOT included.

Microsoft Excel 2019: Advanced Course

Delve Into High-Level Consolidation, Analysis & Financial Reporting

Get beyond the basics and supercharge your current skill level in Excel. With this expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

4.29/5 average rating: ★ ★ ★ ★ ★★

  • Access 57 lectures & 8 hours of content 24/7
  • Learn what’s new/different in Excel 2019
  • Understand advanced charting & graphing in Excel
  • Discover how to use detailed formatting tools
  • Discuss financial functions including calculating interest & depreciation
  • Connect to other workbooks & datasets outside of Excel
  • Create awesome visualizations using sparklines & data bars

Note: Software NOT included.

Microsoft Excel 2019 for Mac: Beginners

Go from Zero to Excel for Mac Hero with This Training

Ever tried learning Excel on a Mac with a course designed for a PC? Well, it looks completely different. Luckily Stream Skill’s got you covered. If you’ve used Excel before but never on a Mac, then this comprehensive Beginners Excel for Mac course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course was recorded using Excel for Mac 2019 but much of what is taught is still relevant if you’re using a different version.

4.68/5 average rating: ★ ★ ★ ★ ★★

  • Access 57 lectures & 5 hours of content 24/7
  • Create, open & save new workbooks in Excel Mac
  • Understand the basics of how Excel for Mac works including relative references & order of operations
  • Set up workbooks & print the right thing in Excel
  • Move data around in Excel for Mac
  • Know basic formulas & functions work

Note: Software NOT included.

Microsoft Excel 2021/365: Intermediate Course

Experience All the New Functions & Features Available in Excel 2021

This course will build on the skills learned in the beginners’ course and expand their essential Excel toolkit. Students will learn how to create intermediate-level formulas, clean and analyze data using PivotTables and Pivot Charts, control data input with validation rules, make decisions with WhatIf analysis tools as well as learn the golden rules of spreadsheet design. That’s just scratching the surface! Students will also get to experience all the new functions and features available in Excel 2021, the latest standalone version of Excel from Microsoft.

Excel 2021 Intermediate is designed for students who have a beginner-level knowledge of Excel and are looking to build on those skills. It’s also perfect for students who have beginner to intermediate level skills in an older version of Excel and are looking to update their skills.

  • Access 84 lectures & 9.5 hours of content 24/7
  • Design better spreadsheets & control user input
  • Use logical functions to make better business decisions
  • Construct functional & flexible lookup formulas
  • Use Excel tables to structure data & make it easy to update
  • Extract unique values from a list
  • Explore the exciting world of dynamic array functions & learn how to use XLOOKUP, XMATCH, FILTER and so much more

Note: Software NOT included.

Microsoft Excel 2019: Beginners Course

Learn the Essentials of Microsoft Excel 2019/365 & Work with More Confidence Using Spreadsheets

This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

  • Access 95 lectures & 7.5 hours of content 24/7
  • Know what’s new in Excel 2019
  • Enter text, numbers & working w/ dates
  • Create & navigate workbooks
  • Understand basic functions & formulas
  • Know basic formatting in Excel

Note: Software NOT included.

Macros & VBA for Beginners

Automate Excel Using Macros & VBA

This course teaches you how to create your first Macros and edit them using the Excel programming language, VBA (Visual Basic for Applications). It starts by giving an overview of Marcos. After that, you’ll move on to some VBA basics and how to edit and debug Macros. Finally, you’ll look at creating a Macro from scratch using VBA and how to create a custom Macro ribbon. This course includes follow-along instructor files so you can immediately practice what you learn. This is an advanced level Excel course, an intermediate knowledge of Excel is required to get the most from this course.

4.4/5 average rating: ★ ★ ★ ★ ★★

  • Access 15 lectures & 2 hours of content 24/7
  • See examples of Excel Macros
  • Know what is VBA
  • Record your first macro
  • Record a macro using relative references
  • Record a complex, multi-step macro, & assign it to a button
  • Set up the VBA Editor
  • Learn all about VBA Code
  • Edit Macros in the VBA Editor
  • Fix issues with macros using debugging tools
  • Write your own macro from scratch
  • Create a custom Macro ribbon & add all the Macros you’ve created

Note: Software NOT included.

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

The 2022 Complete Microsoft Excel Expert Bundle: 12 Courses with 600+ Video Lessons & 70+ Hours of Training! Be a Master at Sorting, Analyzing, and Visualizing Datasets on Microsoft Excel – Just $34.99!
Chris Hauk

Chris is a Senior Editor at Mactrast. He lives somewhere in the deep Southern part of America, and yes, he has to pump in both sunshine and the Internet.

Share
3 years ago