Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course, available at $79.99, has an average rating of 4.45, with 286 lectures, 42 quizzes, based on 138 reviews, and has 673 subscribers.

You will learn about 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 Effectively applying formatting to cells and using conditional formatting Linking to other worksheets & workbooks and protecting & sharing workbooks Designing better spreadsheets and controlling user input How to use logical functions to make better business decisions How to use Excel tables to structure data and make it easy to update Sorting and filtering data using advanced features and new Excel formulas How to control user input with data validation Importing data and cleaning it up before analysis Using WhatIf analysis tools to see how changing inputs affect outcomes Analyzing data using PivotTables and representing data visually with charts and PivotCharts Creating an interactive dashboard to present high-level metrics Auditing formulas and troubleshooting common Excel errors Using the NEW dynamic array functions to perform tasks Using statistical functions to rank data and to calculate the MEDIAN and MODE Importing and cleaning data using Power Query Recording and running macros to automate repetitive tasks Understanding and making minor edits to VBA code Predicting future values using forecast functions and forecast sheets This course is ideal for individuals who are Suitable for learners of all levels or Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge or Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments It is particularly useful for Suitable for learners of all levels or Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge or Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments.

Enroll now: Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Summary

Title: Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Price: $79.99

Average Rating: 4.45

Number of Lectures: 286

Number of Quizzes: 42

Number of Published Lectures: 286

Number of Published Quizzes: 42

Number of Curriculum Items: 328

Number of Published Curriculum Objects: 328

Original Price: $174.99

Quality Status: approved

Status: Live

What You Will 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
Effectively applying formatting to cells and using conditional formatting
Linking to other worksheets & workbooks and protecting & sharing workbooks
Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
How to use Excel tables to structure data and make it easy to update
Sorting and filtering data using advanced features and new Excel formulas
How to control user input with data validation
Importing data and cleaning it up before analysis
Using WhatIf analysis tools to see how changing inputs affect outcomes
Analyzing data using PivotTables and representing data visually with charts and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
Using the NEW dynamic array functions to perform tasks
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Importing and cleaning data using Power Query
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Predicting future values using forecast functions and forecast sheets

Who Should Attend

Suitable for learners of all levels
Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge
Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments

Target Audiences

Suitable for learners of all levels
Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge
Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments

**This bundle includes practice exercises, downloadable files, and LIFETIME access**

Learn all the tools you’ll need to become a Microsoft Excel 2021/365 power user with this great value 3-course training bundle for beginner to advanced users from Simon Sez IT.

Let us take you on a journey from being an Excel novice to an Excel guru. By the end of these training courses, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more!

All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.

This Excel ultimate bundle is designed for students of all levels. If you are brand new to Microsoft Excel or are upgrading from a previous version and want to keep up to date with Excel 2021 developments, then this bundle is for you.

If you already have a good understanding of Excel, you might want to check out the intermediate and advanced sections where our expert instructor will help you take your spreadsheet skills to the next level.

What’s included?

Excel 2021 for Beginners

Become familiar with what’s new in Excel 2021
Navigate the Excel 2021 interface
Utilize useful keyboard shortcuts to increase productivity
Create your first Excel spreadsheet
Use basic and intermediate Excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use Excel lists and master sorting and filtering
Work efficiently by using the cut, copy, and paste options
Link to other worksheets and workbooks
Analyze data using charts
Insert pictures in a spreadsheet
Work with views, zooms, and freezing panes
Set page layout and print options
Protect and share workbooks
Save your workbook in different file formats

Excel 2021 Intermediate

Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
Constructing functional and flexible lookup formulas
How to use Excel tables to structure data and make it easy to update
Extracting unique values from a list
Sorting and filtering data using advanced features and new Excel formulas
Working with date and time functions
Extracting data using text functions
Importing data and cleaning it up before analysis
Analyzing data using PivotTables
Representing data visually with PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to control user input with data validation
Using WhatIf analysis tools to see how changing inputs affect outcomes.

Excel 2021 Advanced

Using the NEW dynamic array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analyzing data with advanced PivotTable and PivotChart hacks
Creating interactive reports and dashboards by incorporating form controls
Importing and cleaning data using Power Query
Predicting future values using forecast functions and forecast sheets
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Combining functions to create practical formulas to complete specific tasks.

This bundle includes:

30+ hours of video tutorials
270+ individual video lectures
Course and exercise filesto follow along
Certificate of completion

Course Curriculum

Chapter 1: Excel 2021 Beginner: Introduction

Lecture 1: Course Introduction

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Course Exercise Files

Lecture 4: DOWNLOAD ME: Course Instructor Files

Lecture 5: Free Keyboard Shortcut Guides

Lecture 6: Excel 2021 vs Excel for Microsoft 365

Chapter 2: Beginner: Getting Started in Excel 2021

Lecture 1: Launching Excel

Lecture 2: The Start Screen

Lecture 3: Exploring the Interface

Lecture 4: Understanding Ribbons, Tabs and Menus

Lecture 5: The Backstage Area

Lecture 6: Customizing the Quick Access Toolbar

Lecture 7: Useful Keyboard Shortcuts

Lecture 8: Getting Help

Lecture 9: Exercise 01

Chapter 3: Beginner: Creating You First Excel Spreadsheet

Lecture 1: Working with Excel Templates

Lecture 2: Working with Workbooks and Worksheets

Lecture 3: Saving Workbooks and Worksheets

Lecture 4: Entering and Editing Data

Lecture 5: Navigating and Selecting Cells, Rows and Columns

Lecture 6: Exercise 02

Chapter 4: Beginner: Introduction to Excel Formulas and Functions

Lecture 1: Formulas and Functions Explained

Lecture 2: Performing Calculations with the SUM Function

Lecture 3: Counting Values and Blanks

Lecture 4: Finding the Average with the AVERAGE Function

Lecture 5: Working with the MIN and MAX Functions

Lecture 6: Handling Errors in Formulas

Lecture 7: Absolute vs Relative Referencing

Lecture 8: Autosum and AutoFill

Lecture 9: Flash Fill

Lecture 10: Exercise 03

Chapter 5: Beginner: Using Named Ranges

Lecture 1: What are Named Ranges?

Lecture 2: Creating Named Ranges

Lecture 3: Managing Named Ranges

Lecture 4: Using Named Ranges in Calculations

Lecture 5: Exercise 04

Chapter 6: Beginner: Formatting Numbers and Cells

Lecture 1: Applying Number Formats

Lecture 2: Applying Date and Time Formats

Lecture 3: Formatting Cells, Rows and Columns

Lecture 4: Using Format Painter

Lecture 5: Exercise 05

Chapter 7: Beginner: Formatting Worksheets

Lecture 1: Working with Rows and Columns

Lecture 2: Deleting and Clearing Cells

Lecture 3: Aligning Text and Numbers

Lecture 4: Applying Themes and Styles

Lecture 5: Exercise 06

Chapter 8: Beginner: Working with Excel Lists

Lecture 1: How to Structure a List

Lecture 2: Sorting a List (Single-Level Sort)

Lecture 3: Sorting a List (Multi-Level Sort)

Lecture 4: Sorting Using a Custom List (Custom Sort)

Lecture 5: Using Autofilter to Filter a List

Lecture 6: Format as a Table

Lecture 7: Creating Subtotals in a List

Lecture 8: Exercise 07

Chapter 9: Beginner: Moving and Linking to Data

Lecture 1: Using Cut and Copy

Lecture 2: Paste Options

Lecture 3: Pasting from the Clipboard

Lecture 4: Linking to Other Worksheets and Workbooks

Lecture 5: 3D Referencing

Lecture 6: Inserting Hyperlinks to Worksheets

Lecture 7: Exercise 08

Chapter 10: Beginner: An Introduction to Intermediate Formulas

Lecture 1: Looking up Information with VLOOKUP

Lecture 2: VLOOKUP Approximate Match

Lecture 3: Error Handling Functions

Lecture 4: Basic Logical Functions (IF, AND, OR)

Lecture 5: Making Decisions with IF Statements

Lecture 6: Cleaning Data using Text Functions

Lecture 7: Working with Time and Date Functions

Lecture 8: Exercise 09

Chapter 11: Beginner: Analyzing Data with Charts

Lecture 1: Choosing the Correct Chart Type

Lecture 2: Presenting Data with Charts

Lecture 3: Formatting Charts

Lecture 4: Exercise 10

Chapter 12: Beginner: Conditional Formatting

Lecture 1: Highlighting Cell Values

Lecture 2: Data Bars

Lecture 3: Color Scales

Lecture 4: Icon Sets

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 1 votes
2 stars: 2 votes
3 stars: 14 votes
4 stars: 52 votes
5 stars: 69 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu