The Ultimate Microsoft Excel 2019 Bundle

The Ultimate Microsoft Excel 2019 Bundle: Eight Courses, One Amazing Bundle

We've combined eight of our best Microsoft Excel 2019 courses to create this extensive Ultimate Excel 2019 bundle. In this massive value combo, you get full access to:

• Excel 2019 Beginners
• Excel 2019 Advanced
• Excel 2019 Mac
• Power Pivot, Power Query & DAX
• PivotTables for Beginners
• Advanced PivotTables
• Advanced Formulas in Excel
• Macros and VBA for Beginners

Included in this bundle are downloadable, follow-along exercises and testing to help you retain what you've learned. Upon completion, you'll receive a certificate of completion for each course. Master these Office essentials and watch your productivity soar.

The Courses

Microsoft Excel 2019 - Beginners

What you'll learn:

• What's new in Excel 2019
• Create workbooks
• Enter text and numbers, and work with dates
• Navigate workbooks
• Page setup and print options
• Work with rows, columns and cells
• Cut, copy and paste
• Introduction to functions and formulas
• Formatting in Excel, including formatting cells and numbers
• Create charts and graphs
• Sort and filter
• Introduction to PivotTables
• Logical and lookup formulas - the basics

Microsoft Excel 2019 - Advanced

What you'll learn:

• What's new/different in Excel 2019
• Advanced charting and graphing
• Use detailed formatting tools
• Lookup and advanced lookup functions
• Financial functions, including calculating interest and depreciation
• Statistical functions
• Connect to other workbooks and datasets outside of Excel, e.g., MS Access and the web
• Create awesome visualizations using sparklines and data bars
• Master PivotTables and Pivot Charts
• Scenario manager, goal seek and solver
• Advanced charts such as surface, radar, bubble and stock charts

Excel 2019 for Mac

What you'll learn:

• Create, open, and save new workbooks
• Basics of how Excel for Mac works, including relative references and order of operations
• Set up your workbooks and print the right thing
• Use freeze panes and split screens
• Move data around
• Basic formulas and functions work
• Format your spreadsheets correctly
• Create some fantastic looking charts and graphs
• Sort and filter your data

PivotTables for Beginners

What you'll learn:

• Clean and prepare your data
• Create a basic pivot table
• Use the pivot table fields pane
• Add fields and pivot the fields
• Format numbers
• Different ways to summarize data
• Group data
• Use multiple fields and dimensions
• Methods of aggregation
• Choose and lock the report layout
• Apply styles
• Sort data and use filters
• Create pivot charts based on data
• Select the right chart for your data
• Apply conditional formatting
• Add slicers and timelines to your dashboards
• Add new data to the original source dataset
• Update pivot tables and charts

What you'll learn:

• Get started with Power Query
• Connect Excel to multiple workbooks
• Get data from the web and other sources
• Merge and append queries using Power Query
• How the Power Pivot window works
• Set up and manage relationships in a data model
• Create a PivotTable to display your data from the Power Pivot data model
• Add calculated columns using DAX
• Use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
• All about creating Pivot Charts and PivotTables and using your data model
• Use slicers to adjust the data you display

• Quick refresher on how to do a PivotTable
• Combine data from multiple worksheets
• Grouping, ungrouping and dealing with errors
• Format a PivotTable, including adjusting styles
• Use the value field settings
• Advanced sorting and filtering
• Use slicers, timelines on multiple tables
• Create a calculated field
• All about GETPIVOTDATA
• Create a pivot chart and add sparklines and slicers
• Use 3D maps from a PivotTable
• Update your data
• Conditional formatting
• Create a basic macro to refresh data

What you'll learn:

• Filter a dataset using a formula
• Sort a dataset using formulas and 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

Course Format

• This is a video-led course. You can preview some videos below.
• This course includes practice exercises.
• This course is aimed at PC Excel users.

Course Certificate Included

Each course includes an optional online quiz that will generate a course certificate upon completion.

Why Trust Us?

Part of the Simon Sez IT family, Stream Skill has taught over 1 million students since its start in 2008. We’ve created over 130 software training courses, 8,000+ video tutorials, and helped thousands of people across the world learn how to use Microsoft Office. Additionally, we’ve created courses for the last five versions of Microsoft Excel and continue to help people master this essential tool.