The Huge Microsoft Excel Training Bundle – Beginner to VBA

6 Courses in 1! Beginner to advanced Excel training from the Excel experts - Simon Sez IT

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• How to get started using Microsoft Excel as a complete beginner
• How create, save, and open a workbook.
• How to use Mathematic Functions (SUM, AVERAGE, MIN, MAX)
• Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
• The basics of entering and editing data in a workbook.
• Discover how to format dates and numbers.
• How to use Logical Functions (IF, COUNTIF, SUMIF)
• Effectively use autofill and flashfill so you are more productive.
• Discover the essentials of using fomulas and functions.
• How to use Lookup Functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX MATCH)
• How to rename, insert, move, and reference an Excel worksheet.
• Discover how to create charts and graphs
• Learn practical methods to sort and filter your data
• How to protect and secure your Excel data
• How to Clean and Prepare your Data in Excel
• How to create Pivot Tables
• Using the Fields pane and adding Fields and Calculated Fields
• How to create Pivot Charts and add sparklines and slicers
• Selecting the right Chart to present your data
• Adding Slicers and Timelines and how to apply on multiple tables
• How to combine data from multiple worksheets for a PivotTable
• All about GETPIVOTDATA
• How to use 3D Maps from a PivotTable
• Adding new Data to the original source dataset
• How to update your data in a PivotTable and Pivot Chart
• All about Conditional Formatting in a PivotTable
• Learn to unlock advanced Excel formulas
• Create multi-dependent dynamic drop-down lists in Excel
• Perform a 2-way lookup in Excel
• Automate repetitive tasks in Excel using Macros
• How to edit Macros in the VBA Editor
• How to write your own macro from scratch

Requirements

• Microsoft Excel 365, 2021, 2019, 2016 or 2013 desktop version for Windows installed on your computer.
• No existing knowledge of Microsoft Excel is needed. You will learn everything you need to know.

Target audience

• Those new to using Microsoft Excel.
• No previous knowledge of Excel required. This course is created for absolute beginners.
• If you want to refresh your memory and understanding of Excel.
• People looking to perform Data Analysis using Excel
• Beginner Excel users who want to learn how to use Pivot Tables