Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Focused View

Simon Sez IT

30:31:33

135 View

1. Excel 2021 Beginner Introduction

1. Course Introduction.mp4

02:19

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Excel 2021 Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Excel 2021 Course Files.zip

4. DOWNLOAD ME Course Instructor Files.html

5. Excel 2021 vs Excel for Microsoft 365.mp4

05:39

6. Section Quiz.html

2. Beginner Getting Started in Excel 2021

1. Launching Excel.mp4

03:38

2. The Start Screen.mp4

10:12

3. Exploring the Interface.mp4

11:39

4. Understanding Ribbons, Tabs and Menus.mp4

08:29

5. The Backstage Area.mp4

04:40

6. Customizing the Quick Access Toolbar.mp4

09:43

7. Useful Keyboard Shortcuts.mp4

09:41

8. Getting Help.mp4

06:36

9. Exercise 01.mp4

02:19

10. Section Quiz.html

3. Beginner Creating You First Excel Spreadsheet

1. Working with Excel Templates.mp4

09:02

2. Working with Workbooks and Worksheets.mp4

07:34

3. Saving Workbooks and Worksheets.mp4

08:07

4. Entering and Editing Data.mp4

09:53

5. Navigating and Selecting Cells, Rows and Columns.mp4

07:21

6. Exercise 02.mp4

05:19

7. Section Quiz.html

4. Beginner Introduction to Excel Formulas and Functions

1. Formulas and Functions Explained.mp4

11:42

2. Performing Calculations with the SUM Function.mp4

07:38

3. Counting Values and Blanks.mp4

07:26

4. Finding the Average with the AVERAGE Function.mp4

04:18

5. Working with the MIN and MAX Functions.mp4

02:24

6. Handling Errors in Formulas.mp4

08:41

7. Absolute vs Relative Referencing.mp4

06:55

8. Autosum and AutoFill.mp4

09:41

9. Flash Fill.mp4

05:02

10. Exercise 03.mp4

05:12

11. Section Quiz.html

5. Beginner Using Named Ranges

1. What are Named Ranges.mp4

04:40

2. Creating Named Ranges.mp4

04:25

3. Managing Named Ranges.mp4

03:49

4. Using Named Ranges in Calculations.mp4

05:19

5. Exercise 04.mp4

04:17

6. Section Quiz.html

6. Beginner Formatting Numbers and Cells

1. Applying Number Formats.mp4

10:02

2. Applying Date and Time Formats.mp4

05:39

3. Formatting Cells, Rows and Columns.mp4

08:38

4. Using Format Painter.mp4

04:39

5. Exercise 05.mp4

04:06

6. Section Quiz.html

7. Beginner Formatting Worksheets

1. Working with Rows and Columns.mp4

08:25

2. Deleting and Clearing Cells.mp4

06:25

3. Aligning Text and Numbers.mp4

11:12

4. Applying Themes and Styles.mp4

07:30

5. Exercise 06.mp4

05:22

6. Section Quiz.html

8. Beginner Working with Excel Lists

1. How to Structure a List.mp4

04:37

2. Sorting a List (Single-Level Sort).mp4

05:06

3. Sorting a List (Multi-Level Sort).mp4

05:06

4. Sorting Using a Custom List (Custom Sort).mp4

08:12

5. Using Autofilter to Filter a List.mp4

06:45

6. Format as a Table.mp4

10:18

7. Creating Subtotals in a List.mp4

07:34

8. Exercise 07.mp4

04:37

9. Section Quiz.html

9. Beginner Moving and Linking to Data

1. Using Cut and Copy.mp4

04:56

2. Paste Options.mp4

07:45

3. Pasting from the Clipboard.mp4

04:32

4. Linking to Other Worksheets and Workbooks.mp4

06:26

5. 3D Referencing.mp4

05:54

6. Inserting Hyperlinks to Worksheets.mp4

09:39

7. Exercise 08.mp4

04:40

8. Section Quiz.html

10. Beginner An Introduction to Intermediate Formulas

1. Looking up Information with VLOOKUP.mp4

10:02

2. VLOOKUP Approximate Match.mp4

05:08

3. Error Handling Functions.mp4

07:10

4. Basic Logical Functions (IF, AND, OR).mp4

12:24

5. Making Decisions with IF Statements.mp4

04:33

6. Cleaning Data using Text Functions.mp4

12:09

7. Working with Time and Date Functions.mp4

11:17

8. Exercise 09.mp4

10:19

9. Section Quiz.html

11. Beginner Analyzing Data with Charts

1. Choosing the Correct Chart Type.mp4

06:34

2. Presenting Data with Charts.mp4

10:01

3. Formatting Charts.mp4

12:51

4. Exercise 10.mp4

03:54

5. Section Quiz.html

12. Beginner Conditional Formatting

1. Highlighting Cell Values.mp4

07:13

2. Data Bars.mp4

05:32

3. Color Scales.mp4

04:55

4. Icon Sets.mp4

07:49

5. Exercise 11.mp4

05:43

6. Section Quiz.html

13. Beginner Inserting Items into a Spreadsheet

1. Inserting Pictures.mp4

10:53

2. Inserting Shapes and Text Boxes.mp4

09:04

3. Inserting Icons and 3D Models.mp4

06:00

4. Creating Diagrams using SmartArt.mp4

10:04

5. Inserting Screenshots.mp4

04:27

6. Inserting Comments.mp4

05:13

7. Exercise 12.mp4

09:16

8. Section Quiz.html

14. Beginner Working with Views and Zoom

1. Workbook Views.mp4

06:22

2. Using Zoom in a Worksheet.mp4

02:56

3. Arranging Workbooks and Worksheets.mp4

05:01

4. Freezing Panes.mp4

04:00

5. Exercise 13.mp4

03:26

6. Section Quiz.html

15. Beginner Page Layout and Print Options

1. Setting Margins and Orientation.mp4

05:05

2. Setting and Clearing the Print Area.mp4

02:50

3. Inserting Page Breaks.mp4

04:32

4. Setting Print Titles and a Background.mp4

04:29

5. Inserting Headers and Footers.mp4

05:42

6. Printing a Workbook.mp4

06:00

7. Exercise 14.mp4

03:06

8. Section Quiz.html

16. Beginner Finalizing the Spreadsheet

1. Protecting Workbooks and Worksheets.mp4

09:02

2. Spell Checking.mp4

03:45

3. Inspecting the Workbook.mp4

07:21

4. Saving the Workbook in Different Formats.mp4

04:21

5. Sharing a Workbook.mp4

05:35

6. Exercise 15.mp4

03:28

7. Section Quiz.html

17. Excel 2021 Beginner Course Close

1. Course Close.mp4

01:06

18. Excel 2021 Intermediate Introduction

1. Course Introduction.mp4

06:16

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Excel 2021 Intermediate Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Excel 2021 Intermediate Course Files.zip

4. DOWNLOAD ME Course Instructor Files.html

5. Section Quiz.html

19. Intermediate Designing Better Spreadsheets

1. The Golden Rules of Spreadsheet Design.mp4

11:54

2. Improving Readability with Cell Styles.mp4

04:58

3. Controlling Data Input.mp4

08:19

4. Adding Navigation Buttons.mp4

08:42

5. Section Quiz.html

20. Intermediate Making Decisions with Logical Functions

1. Logical Functions (AND, OR, IF).mp4

13:18

2. The IF Function.mp4

05:26

3. Nested IFs.mp4

08:01

4. The IFS Function.mp4

06:04

5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF).mp4

06:45

6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS).mp4

07:12

7. Error Handling with IFERROR and IFNA.mp4

06:01

8. Exercise 01.mp4

07:29

9. Section Quiz.html

21. Intermediate Looking Up Information

1. Looking Up Information using VLOOKUP (Exact Match).mp4

10:41

2. Looking Up Information using VLOOKUP (Approx Match).mp4

04:25

3. Looking Up Information Horizontally Using HLOOKUP.mp4

05:38

4. Performing Flexible Lookups With INDEX And MATCH.mp4

10:28

5. Using XLOOKUP and XMATCH.mp4

10:09

6. The OFFSET Function.mp4

10:50

7. The INDIRECT Function.mp4

09:07

8. Exercise 02.mp4

05:03

9. Section Quiz.html

22. Intermediate Advanced Sorting and Filtering

1. Performing Sorts on Multiple Columns.mp4

07:04

2. Sorting Using a Custom List.mp4

03:35

3. The SORT and SORTBY Functions.mp4

10:00

4. Using the Advanced Filter.mp4

06:52

5. Extracting Unique Values - The UNIQUE Function.mp4

05:17

6. The FILTER Function.mp4

09:30

7. Exercise 03.mp4

05:41

8. Section Quiz.html

23. Intermediate Working with Date and Time

1. Understanding How Dates are Stored in Excel.mp4

04:11

2. Applying Custom Date Formats.mp4

07:09

3. Using Date and Time Functions.mp4

08:44

4. Using the WORKDAY and WORKDAY.INT Functions.mp4

03:49

5. Using the NETWORKDAYS and NETWORKDAYS.INT Function.mp4

02:57

6. Tabulate Date Differences with the DATEDIF Function.mp4

06:14

7. Calculate Dates with EDATE and EOMONTH.mp4

07:22

8. Exercise 04.mp4

04:51

9. Section Quiz.html

24. Intermediate Preparing Data for Analysis

1. Importing Data into Excel.mp4

09:40

2. Removing Blank Rows, Cells and Duplicates.mp4

05:20

3. Changing Case and Removing Spaces.mp4

09:03

4. Splitting Data using Text to Columns.mp4

07:03

5. Splitting Data using Text Functions.mp4

08:05

6. Splitting or Combining Cell Data Using Flash fill.mp4

05:00

7. Joining Data using CONCAT.mp4

07:30

8. Formatting Data as a Table.mp4

08:33

9. Exercise 05.mp4

05:41

10. Section Quiz.html

25. Intermediate PivotTables

1. PivotTables Explained.mp4

02:12

2. Creating a PivotTable from Scratch.mp4

04:49

3. Pivoting the PivotTable Fields.mp4

05:31

4. Applying Subtotals and Grand Totals.mp4

03:14

5. Applying Number Formatting to PivotTable Data.mp4

02:57

6. Show Values As and Summarize Values By.mp4

05:51

7. Grouping PivotTable Data.mp4

05:39

8. Formatting Error Values and Empty Cells.mp4

05:02

9. Choosing a Report Layout.mp4

04:35

10. Applying PivotTable Styles.mp4

04:49

11. Exercise 06.mp4

04:05

12. Section Quiz.html

26. Intermediate Pivot Charts

1. Creating a Pivot Chart.mp4

05:04

2. Formatting a Pivot Chart - Part 1.mp4

08:36

3. Formatting a Pivot Chart - Part 2.mp4

09:14

4. Using Map Charts.mp4

05:30

5. Exercise 07.mp4

04:18

6. Section Quiz.html

27. Intermediate Adding Interaction to PivotTables and Charts

1. Inserting and Formatting Slicers.mp4

07:30

2. Inserting Timeline Slicers.mp4

05:08

3. Connecting Slicers to Pivot Charts.mp4

05:01

4. Updating PivotTable Data.mp4

04:25

5. Exercise 08.mp4

06:48

6. Section Quiz.html

28. Intermediate Interactive Dashboards

1. What is a Dashboard.mp4

05:27

2. Assembling a Dashboard - Part 1.mp4

11:25

3. Assembling a Dashboard - Part 2.mp4

10:47

4. Assembling a Dashboard - Part 3.mp4

08:49

5. Exercise 09.mp4

02:27

6. Section Quiz.html

29. Intermediate Formula Auditing

1. Troubleshooting Common Errors.mp4

08:11

2. Tracing Precedents and Formula Auditing.mp4

07:44

3. Exercise 10.mp4

07:30

4. Section Quiz.html

30. Intermediate Data Validation

1. Creating Dynamic Drop-down Lists.mp4

07:27

2. Other Types of Data Validation.mp4

07:06

3. Custom Data Validation.mp4

10:07

4. Exercise 11.mp4

06:53

5. Section Quiz.html

31. Intermediate WhatIf Analysis Tools

1. Goal Seek and the PMT Function.mp4

05:33

2. Using Scenario Manager.mp4

07:28

3. Data Tables One Variable.mp4

04:29

4. Data Tables Two Variables.mp4

04:12

5. Exercise 12.mp4

08:32

6. Section Quiz.html

32. Excel 2021 Intermediate Course Close

1. Course Close.mp4

01:35

33. Excel 2021 Advanced Introduction

1. Course Introduction.mp4

02:46

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Excel 2021 Advanced Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Excel 2021 Advanced Course Files.zip

4. DOWNLOAD ME Course Files.html

5. Exercise 01.mp4

01:47

6. Section Quiz.html

34. Advanced Dynamic Arrays

1. What are Dynamic Arrays.mp4

02:14

2. Introduction to Spills and Arrays.mp4

10:49

3. Extract and Count Unique Entries.mp4

06:14

4. Unique vs Distinct.mp4

03:24

5. Extract Unique Values with Multiple Criteria.mp4

03:11

6. Extract Unique Values by Column.mp4

04:23

7. The SORT Function.mp4

08:53

8. The SORT Function - Horizontal SORT.mp4

06:06

9. The SORTBY Function.mp4

06:10

10. The SORTBY Function - Horizontal SORT.mp4

03:05

11. Simple SEQUENCE and Unstacking Records.mp4

10:10

12. The FILTER Function.mp4

06:51

13. FILTER with Logic + Operator (OR).mp4

04:48

14. FILTER with Logic Operator (AND).mp4

05:39

15. FILTER with Logic = Operator (Both or Neither).mp4

04:11

16. FILTER with Logic - Operator (One or the Other).mp4

04:48

17. Using RANDARRAY and RANDBETWEEN to Randomize Data.mp4

09:44

18. Using XLOOKUP to Perform Complex Lookups.mp4

12:22

19. Using XMATCH.mp4

06:20

20. Exercise 02.mp4

13:09

21. Section Quiz.html

35. Advanced Advanced Lookup and Reference Functions

1. Performing 2-Way Lookups.mp4

08:25

2. Using the CHOOSE Function.mp4

10:02

3. Using the SWITCH Function.mp4

04:31

4. Exercise 03.mp4

07:06

5. Section Quiz.html

36. Advanced Statistical Functions

1. Using MEDIAN, MODE.SNGL and MODE.MULT.mp4

06:16

2. Using LARGE and SMALL.mp4

07:27

3. Ranking Data with Sorting using RANK.EQ and RANK.AVG.mp4

07:41

4. The COUNTBLANK Function.mp4

04:45

5. Exercise 04.mp4

07:05

6. Section Quiz.html

37. Advanced Math Functions

1. Rounding Values using ROUND, ROUNDUP and ROUNDDOWN.mp4

06:59

2. Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH).mp4

04:30

3. Using the AGGREGATE Function.mp4

04:32

4. Exercise 05.mp4

05:52

5. Section Quiz.html

38. Advanced New Functions - LET and LAMBDA

1. The LET Function.mp4

15:07

2. The LAMBDA Function.mp4

14:13

3. Exercise 06.mp4

11:49

4. Section Quiz.html

39. Advanced Advanced PivotTables and Pivot Charts

1. Creating a Custom PivotTable Style.mp4

09:48

2. Applying Custom Number Formatting.mp4

10:01

3. Sorting Using Custom Lists.mp4

04:38

4. Applying Multiple Filters to Data.mp4

05:06

5. Adjusting Slicer Settings.mp4

12:02

6. Locking Workbooks but not Slicers.mp4

03:18

7. Creating a Calculated Field.mp4

08:01

8. Creating a Calculated Item.mp4

06:30

9. Solve Order.mp4

08:11

10. GETPIVOTDATA.mp4

11:57

11. Using GETPIVOTDATA - Dependent Data Validation Lists.mp4

08:37

12. Creating a Dynamic Pivot Chart Title.mp4

10:41

13. Adding a Dynamic Series to a Pivot Chart.mp4

12:47

14. Adding Totals to a Stacked Column Chart.mp4

05:52

15. Exercise 07.mp4

10:10

16. Section Quiz.html

40. Advanced Form Controls

1. Introduction to Form Controls.mp4

04:14

2. Combo Box - Select from a List.mp4

07:21

3. Check Box - CheckUncheck Option.mp4

06:48

4. Option Button - Choose an Option.mp4

06:30

5. Spin Button - Move Up and Down a List.mp4

05:54

6. List Box - Select from a List of Items.mp4

04:59

7. Scroll Bar - Scroll Through a List.mp4

05:01

8. Exercise 08.mp4

05:57

9. Section Quiz.html

41. Advanced Working with Power Query

1. Power Query Overview.mp4

01:35

2. Importing Data Using Get and Transform.mp4

07:09

3. The Power Query Editor.mp4

04:45

4. Combining Files.mp4

04:52

5. Transforming Files.mp4

09:30

6. Loading Files into Excel.mp4

04:02

7. Exercise 09.mp4

05:54

8. Section Quiz.html

42. Advanced Forecasting

1. Getting Forecast Data with FRED.mp4

05:34

2. Creating a Linear Sales Forecast.mp4

08:21

3. Creating a Sales Forecast with Seasonality.mp4

05:02

4. Adding Confidence Levels.mp4

06:58

5. Using Forecast Sheets.mp4

07:16

6. Exercise 10.mp4

02:21

7. Section Quiz.html

43. Advanced Macros and VBA

1. Using Macros to Automate Tasks.mp4

06:40

2. Recording, Saving and Running Macros.mp4

10:00

3. Recording a Macro with Relative Referencing.mp4

06:58

4. Multi-step Macros.mp4

07:09

5. The VBA Editor.mp4

07:55

6. Assigning Macros to Buttons.mp4

06:43

7. Creating a Custom Macro Ribbon.mp4

06:34

8. Exercise 11.mp4

05:30

9. Section Quiz.html

44. Advanced Practical Excel - Advanced Formulas

1. Finding the Last Occurrence of a Value.mp4

07:48

2. Finding the Closest Value.mp4

06:15

3. Extract Data from the Middle of a String.mp4

08:53

4. Exercise 12.mp4

05:45

5. Section Quiz.html

45. Excel 2021 Advanced Course Close

1. Course Close.mp4

03:24

Description

Become a Microsoft Excel 2021/365 expert with this three-course bundle

What You'll 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 is this for?

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

What You Need to Know?

Microsoft Excel 2021/365 desktop version for Windows installed and ready to use on your computer.

More details

Description
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 files to follow along
Certificate of completion
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.