Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Huge Microsoft Excel Training Bundle - Beginner to VBA

Name: The Huge Microsoft Excel Training Bundle - Beginner to VBA
Rating: 4.7 (126 reviews)

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

Created bySimon Sez IT

Last updated 3/2024

English

English [Auto],

What you'll 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

Course content

68 sections • 310 lectures • 34h 13m total length

Intro to Excel1:00
WATCH ME: Essential Information for a Successful Training Experience2:03
Watch this essential guide to maximize your Excel training, detailing downloadable exercise files, which files to open per exercise, how to download and unzip them, and playback options.
DOWNLOAD ME: Course Exercise Files0:23
Downloadable course transcripts0:15
Free Keyboard Shortcut Guides0:18
What's New In Excel 20197:52
Explore what's new in Excel 2019, including multi-range selection with control, the accessibility checker, translate feature, and the new cat function that replaces concatenate, with practical examples.
Course Overview1:16
Learn the Excel interface from scratch, master workbook and sheet terminology, set up a workbook, format and print borders, and build basic formulas to perform calculations.
Overview of the Excel window8:25
Explore the Excel window from the quick access toolbar to the ribbon. Identify the workbook with sheets, active cell, cell address, and basic views.
Mouse-Features3:12
Back Stage View2:37
Section Quiz

Entering Text and Numbers4:32
Navigate a new blank workbook by entering text and numbers, create a basic layout with column and row headings and a header area, and learn simple formulas in Excel.
Creating Basic Formulas6:49
learn to create basic formulas in excel using the equals sign and cell references to add numbers and calculate profits by subtracting expenses from sales; understand relative references.
Relative References3:01
Learn how relative references adjust when copying formulas across columns and rows with the fill handle, and how Excel updates references to keep formulas correct, with absolute references coming later.
Order of Operations4:48
Working with Ranges4:14
Learn to work with ranges by selecting adjacent cells, applying formatting and formulas, and using range notation like B2:C4 to calculate sums.
Module 2 - Practice Exercise1:35
Section Quiz

Working with the Save and Save As Commands4:34
Save your workbook using save and save as, name it, and choose a location; back it up to OneDrive or your PC and manage save prompts and extensions.
File Extensions, Share, Export and Publish Files3:44
Learn how to save, share, export, and publish Excel workbooks, handle extensions like .xlsx, CSV, and PDF, and explore Power BI publishing for collaborative reports.
Module 3 - Practice Exercise0:59
Section Quiz

Opening a File5:33
Open and manage multiple Excel workbooks with backstage view, recent files, pinning, and folder browsing. Create cross-sheet links using formulas that reference cells across sheets.
Working with Larger Files5:34
Learn to navigate large Excel workbooks with scroll, home/end navigation, name box jumps, advanced find and replace, and freeze panes to keep headers visible.
Freeze Panes Option3:16
Learn to use the freeze panes feature in Excel to lock rows and columns so headings stay visible while you scroll; turn on unfreeze and explore the split screen option.
Split Screen Option3:22
Module 4 - Practice Exercise2:50
Navigate workbooks by opening Lone Workbook, review terms of loan and the five year loan details, link C9 to D3, then freeze panes and use split view.
Section Quiz

Headers and Footers7:23
Learn how to set up headers and footers in Excel, adjust page layout for printing, and customize left, center, and right sections with file name, date, and page numbers.
Print Titles2:52
Set up print titles in Excel to repeat selected rows at the top on every page, using the Page Layout tab, print titles, and print preview.
Comments5:23
Learn how to add, edit, and manage cell comments in Excel, including printing comments and navigating multiple notes, with practical tips on sizing and display options.
Page Setup Options7:30
Master Excel's page setup options, including margins, orientation, size, print area, breaks, and scaling, to configure grid lines, headings, and page order.
Fit to Print on One Page3:59
Learn to fit all workbook data on one page by using page break preview, adjusting scaling, and choosing portrait or landscape orientation in Excel.
Printing Workbooks3:55
Discover how to print Excel workbooks using the backstage print options, page setup, and print preview, including scaling, margins, paper size, orientation, and targeted printing.
Module 5 - Practice Exercise1:53
Practice page setup and print options: add date to header, place your name in footer, add a comment in c9, set one-inch margins, repeat rows 4-7 on print.
Section Quiz

Adding and deleting rows columns and cells6:12
Learn to add and delete rows, columns, and cells in Excel, insert sheet rows or columns, shift cells, and manage layout in real-world tables like regional sales data.
Changing Column and-Row Widths3:45
Learn how to adjust column and row widths in Excel to prevent # symbols and truncated text; use drag or double-click to auto-fit based on content.
Module 6 - Practice Exercise1:11
Section Quiz

Overview of Formulas2:48
Explore formulas and functions in Excel, learning how simple sums become powerful calculations across worksheets and workbooks, including data on separate sheets or files, and starting with an equal sign.
Create Formulas Using Functions Part 110:04
Master how to create formulas using functions in Excel, use auto sum to add ranges, compute average and max, and join data with concatenate while exploring the insert function.
Create Formulas Using Functions Part 25:24
Explore building Excel formulas using functions, from concatenate and count to if, max, min, and sum, with arguments, relative references, and absolute values discussed.
Absolute Values5:16
Master absolute values in Excel by converting relative references to absolute ones (G3) and applying a 15% commission to totals, preventing shifts when copying formulas.
Module 8 - Practice Exercise1:20
Section Quiz

Adding Deleting and Renaming Sheets4:09
Learn to add, delete, rename, and move sheet tabs in a workbook, and understand how sheet order affects three-dimensional formulas across multiple sheets.
Additional Sheet Tab Options5:19
Master the full range of sheet tab options in Excel, from inserting, renaming, moving, and copying tabs to protecting, hiding, changing colors, and applying changes to all sheets.
3 Dimensional Formulas5:28
Module 9 - Practice Exercise1:31
Rename the first five sheets to divisions like Australia and Europe, insert and delete a sheet for practice, and create a three-dimensional formula across sheets to sum on sheet five.
Section Quiz

Formatting Cells Part 110:04
Explore formatting cells and numbers in Excel, including borders, shading, fonts, font sizes, colors, and alignment, to highlight headings and key values.
Formatting Cells Part 23:38
Explore advanced cell formatting in this module, including wrap text, merge and center across selected cells, shrink to fit, and precise text orientation with rotation controls.
Formatting Numbers9:24
Learn to format numbers in Excel with currency, decimals, percentages, dates, times, fractions, and custom formats, including special formats like phone numbers, and understand display versus actual values.
Borders and Shading7:08
Apply borders and shading to worksheets to enhance readability, including printing grid lines, using outside borders, various border styles, and fill effects or patterns to color cells.
Format as Table6:07
Using Styles3:49
Using Format Painter4:29
Use the format painter in Excel to copy formatting from one range to another, including colors and fonts; double-click to keep painting across regions, ensuring identical rows and columns.
Protecting Sheets9:01
Protect sheets, cells, and workbooks in Excel by unlocking editable cells, then applying protection to preserve formulas and data.
Fill Handle and Custom Lists7:17
Module 10 - Practice Exercise1:10
Section Quiz

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.

Description

***Exercise and demo files included***

Excel has always been the go-to software for data organization and financial analysis. Even in the age of Big Data, Excel remains indispensable and relevant, thus almost everyone should at least have some basic Excel skills. If you are brand-new to Excel, then this huge course bundle is perfect for you!

This BIG Excel bundle includes not just two, not three, but six full courses to bring you from Excel newbie to Data Analyst quick! Okay, maybe not that quick, as this bundle gives you 32+ hours of tutorials including more than 300 individual video lectures!

With the Excel 2019/365 beginner course, you’ll gain a fantastic grounding in Microsoft Excel. The course will teach you how to understand spreadsheet basics, including creating your first workbook and how to navigate Excel, an introduction to formulas and functions, how to create amazing-looking charts and graphs, and much more.

Excel PivotTables is an interactive way of quickly summarizing large amounts of data. It is ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. The beginner and advanced PivotTables courses will discuss the importance of cleaning your data before you can create your first Pivot Table. You will also learn how to make the most of this powerful data analysis function.

The Excel for Business Analysts course focuses on the specific functions, formulas, and tools that Excel has that can help conduct business or data analysis. We take you on a no-nonsense journey to teach you how to use them. In this course, you’ll learn several tools and functions that can be used for analysis and visualization, plus some more advanced techniques designed to aid in forecasting.

We finish by taking you through our favorite and most-useful advanced Excel functions before moving on to teaching you how to use basic Macros and VBA to automate and supercharge your spreadsheets.

This is the only Excel course you are ever going to need!

Excel 2019/365 for Beginners

What you will learn:

What's new in Excel 2019
Creating workbooks
Entering text, numbers and working with dates
Navigating workbooks
Page setup and print options
Working with rows, columns, and cells
Cut, Copy and Paste
Introduction to functions and formulas
Formatting in Excel, including formatting cells and numbers
Creating charts and graphs
Sorting and Filtering
Introduction to PivotTables
Logical and lookup formulas - the basics

PivotTables for Beginners

What you will learn:

How to Clean and Prepare your Data
How to create a Basic Pivot Table
How to use the Pivot Table Fields pane
How to Add Fields and Pivoting the Fields
How to Format Numbers in Pivot Table
Different ways to Summarize Data
How to Group Pivot Table Data
How to use Multiple Fields and Dimension
The Methods of Aggregation
How to Choose and Lock the Report Layout
How to apply Pivot Table Styles
How to Sort Data and use Filters
How to create Pivot Charts based on Pivot Table data
How to Select the right Chart for your data
How to apply Conditional Formatting
How to add Slicers and Timelines to your dashboards
How to Add New Data to the original source dataset
How to Update Pivot Tables and Charts

Advanced PivotTables in Excel

What you will learn:

How to do a PivotTable (a quick refresher)
How to combine data from multiple worksheets for a PivotTable
Grouping, ungrouping, and dealing with errors
How to format a PivotTable, including adjusting styles
How to use the Value Field Settings
Advanced Sorting and Filtering in PivotTables
How to use Slicers, Timelines on multiple tables
How to create a Calculated Field
All about GETPIVOTDATA
How to create a Pivot Chart and add sparklines and slicers
How to use 3D Maps from a PivotTable
How to update your data in a PivotTable and Pivot Chart
All about Conditional Formatting in a PivotTable
How to create amazing looking dashboards

Excel for Business Analysts

What you will learn:

How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
How to split data using text functions SEARCH, LEFT, RIGHT, MID
How to standardize and clean data ready for analysis
About using the PivotTable function to perform data analysis
How to use slicers to draw out information
How to display your analysis using Pivot Charts
All about forecasting and using the Forecast Sheets
Conducting a Linear Forecast and Forecast Smoothing
How to use Conditional Formatting to highlight areas of your data
All about Histograms and Regression
How to use Goal Seek, Scenario Manager, and Solver to fill data gaps

Advanced Formulas and Functions in Excel

You will learn to:

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

Macros and VBA for Beginners

What you will learn:

What is VBA?
How to record your first macro
How to record a macro using relative references
How to record a complex, multi-step macro and assign it to a button
How to set up the VBA Editor
How to edit Macros in the VBA Editor
How to get started with some basic VBA code
How to fix issues with macros using debugging tools
How to write your own macro from scratch
How to create a custom Macro ribbon and add all the Macros you’ve created

This course bundle includes:

6 Full Courses
32+ hours of video tutorials
300+ individual video lectures
Exercise and Demo files to practice and follow along
Certificate of completion

Who this course is for:

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

The Huge Microsoft Excel Training Bundle - Beginner to VBA

What you'll learn

Explore related topics

Course content

Intro to Excel 201910 lectures • 27min

Creating Workbooks6 lectures • 25min

Saving Workbooks3 lectures • 9min

Navigating Workbooks5 lectures • 21min

Page Setup & Print Options7 lectures • 33min

Working with Rows, Columns and Cells3 lectures • 11min

Moving Data3 lectures • 14min

Formulas & Functions5 lectures • 25min

Working with Sheets4 lectures • 16min

Formatting Worksheets10 lectures • 1hr 2min

Requirements

Description

Who this course is for: