The Ultimate Microsoft Excel Mastery Bundle – 8 Courses

Master Microsoft Excel with this huge-value beginner to advanced eight-course bundle and become an Excel power user!

Created by: Simon Sez IT
890,000+ Students, 260+ Courses, Learners in 180+ Countries

What Will I Learn?

• Become familiar with what’s new in Excel 2021 and navigate the Excel 2021 interface
• Create your first Excel spreadsheet and use basic and intermediate Excel formulas and functions
• Utilize useful keyboard shortcuts to increase productivity
• Linking to other worksheets & workbooks and protecting & sharing workbooks
• How to use logical functions to make better business decisions
• Creating an interactive dashboard to present high-level metrics
• Using the NEW dynamic array functions to perform tasks
• Recording and running macros to automate repetitive tasks
• Predicting future values using forecast functions and forecast sheets
• Using statistical functions to rank data and to calculate the MEDIAN and MODE
• Understanding and making minor edits to VBA code
• How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
• How to standardize and clean data ready for analysis in Excel
• Conducting a Linear Forecast and Forecast Smoothing in Excel
• All about Histograms and Regression in Excel
• How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel
• Learn to unlock advanced Excel tools Power Query and Power Pivot
• Analyze huge buckets of data to make informed business decisions
• How to create PivotTables
• Grouping and ungrouping PivotTable data and dealing with errors
• Creating PivotCharts and adding sparklines and slicers
• Adding slicers and timelines and applying them to multiple tables
• Combining data from multiple worksheets for a PivotTable
• All about the GETPIVOTDATA function
• How to use 3D maps from a PivotTable
• Updating your data in a PivotTable and PivotChart
• About Dashboard architecture and inspiration
• How to prepare data for analysis (cleaning data)
• Useful formulas for creating dashboards in Excel
• How to create and edit Pivot Tables in Excel
• How to create Pivot Charts from Pivot Tables
• Advanced chart techniques in Excel
• How to add interactive elements (form controls) into your dashboards
• How to create a Sales Dashboard from scratch
• How to create an HR Dashboard from scratch

Requirements

• Microsoft Excel 2021/365 desktop version for Windows for the Excel 2021 courses
• You'll need a copy of Microsoft Excel that is compatible with the Power Pivot tool for the Power Pivot, Power Query & DAX course
• The PivotTable courses were created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

Target audience

• Suitable for learners of all levels
• Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments
• Business analysts or those looking to perform Data Analysis using Excel
• Beginner Excel users who want to learn how to use Pivot Tables
• Advanced Excel users who want to learn Power Pivot and Power Query
• Those wanting to create visually appealing dashboards in Excel