Description

This video course will help you learn all the basic and advanced concepts of Microsoft Excel 2019. You'll start with Excel basics and slowly move to the advanced concepts in Excel. Each section is accompanied by an exercise at the end to practice what you have learned.

Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly will improve your productivity drastically. This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities. We'll start with the basic topics and see what's new in Excel 2019. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. We'll also cover some advanced charts such as Surface, Radar, Bubble, and Stock Charts. By the end of this course, you'll become proficient in using Microsoft Excel for your professional and personal needs. All the resources for this course are available at https://github.com/PacktPublishing/The-Complete-Excel-Guide-Beginners-to-Advanced

What You Will Learn

Grasp techniques to back up and recover your Excel spreadsheets
Discover the essentials of using formulas and functions in Excel
Discover what's new or different in Excel 2019
Learn to effectively use autofill and flashfill
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data in Excel

Audience

This course is designed for anyone who is interested in mastering Microsoft Excel 2019 and becoming an expert in Microsoft Excel. To get started with this course, you need to have basic computer skills and Microsoft Office installed on your computer.

Approach

With the help of simple narration, interesting exercises, and engaging activities, this video course will make you well-versed in Microsoft Excel 2019.

Key Features

Gain a solid understanding of Microsoft Excel 2019 * Uncover amazing Microsoft Excel suite techniques and shortcuts to make your job easy * Learn how to add life to your Excel spreadsheets by creating stunning charts and graphs

Github Repo

https://github.com/PacktPublishing/The-Complete-Excel-Guide-Beginners-to-Advanced

About the Author

Simon Sez IT

Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

Course Outline

1. Excel 2019: Introduction

1. Introduction to Excel

An introduction to Excel.

2. What's New in Excel 2019

Let's see what's new in Excel 2019.

3. Course Overview

A quick overview of the course.

4. Overview of the Excel Window

Let's explore the Excel window.

5. Mouse Features

Let's explore the mouse features available in Excel.

6. Backstage View

Let's see what is the backstage view.

2. Excel 2019 Beginner: Creating Workbooks

1. Entering Text and Numbers

Learn how to enter text and numbers.

2. Creating Basic Formulas

Learn how to create basic formulas.

3. Relative References

Learn about the relative references.

4. Order of Operations

Learn about the order of operations.

5. Working with Ranges

Learn how to work with ranges.

6. Module 2 - Practice Exercise

Let's do a practice exercise.

3. Excel 2019 Beginner: Saving Workbooks

1. Working with the Save and Save As Commands

Let's explore the Save and Save As Commands.

2. File Extensions, Share, Export, and Publish Files

Understand file extensions, share, export, and publish files.

3. Module 3 - Practice Exercise

Let's do a practice exercise.

4. Excel 2019 Beginner: Navigating Workbooks

1. Opening a File

Let's open a file.

2. Working with Larger Files

Let us see how to manage larger files in Excel.

3. Freeze Panes Option

Let's explore the Freeze Panes option.

4. Split Screen Option

Let's explore the Split Screen option.

5. Module 4 - Practice Exercise

Let's do a practice exercise.

5. Excel 2019 Beginner: Page Setup and Print Options

1. Headers and Footers

This video aims to explain headers and footers.

2. Print Titles

This video aims to explain Print Titles.

3. Comments

This video aims to explain comments.

4. Page Setup Options

This video aims to explain page setup options.

5. Fit to Print on One Page

This video aims to explain how to fit to print on one page.

6. Printing Workbooks

This video aims to explain how to print workbooks.

7. Module 5 - Practice Exercise

Let's do a practice exercise.

6. Excel 2019 Beginners: Working with Rows, Columns, and Cells

1. Adding and Deleting Rows, Columns, and Cells

Learn how to add and delete rows, columns, and cells.

2. Changing Column and Row Widths

Let's learn how to change column and row widths.

3. Module 6 - Practice Exercise

Let's do a practice exercise.

7. Excel 2019 Beginners: Moving Data

1. Cut, Copy, and Paste

Learn and explore the cut, copy, and paste options.

2. Copying Formulas

Let's learn how to copy formulas.

3. Module 7 - Practice Exercise

Let's do a practice exercise.

8. Excel 2019 Beginners: Formulas and Functions

1. Overview of Formulas

In this video, let's take a quick overview of formulas.

2. Create Formulas Using Functions: Part 1

Learn how to create formulas using functions.

3. Create Formulas Using Functions: Part 2

Let's continue to learn how to create formulas using functions.

4. Absolute Values

Let's understand what are absolute values.

5. Module 8 - Practice Exercise

Let's do a practice exercise.

9. Excel 2019 Beginners: Working with Sheets

1. Adding, Deleting, and Renaming Sheets

Learn how to add, delete, and rename sheets.

2. Additional Sheet Tab Options

We will explore the additional sheet tab options.

3. Dimensional Formulas

Let's explore dimensional formulas.

4. Module 9 - Practice Exercise

Let's do a practice exercise.

10. Excel 2019 Beginners: Formatting Worksheets

1. Formatting Cells: Part 1

In this video, let's learn how to format cells.

2. Formatting Cells: Part 2

Continue with formatting cells.

3. Formatting Numbers

In this video, let's learn how to format numbers.

4. Borders and Shading

Let's learn borders and shading.

5. Format as Table

The aim of this video is to explore how to format as table.

6. Using Styles

The aim of this video is to explore how to use styles.

7. Using Format Painter

The aim of this video is to explore how to use format painter.

8. Protecting Sheets

The aim of this video is to explore how to protect sheets.

9. Fill Handle and Custom Lists

The aim of this video is to explore how to work with fill handle and custom lists.

10. Module 10 - Practice Exercise

Let's do a practice exercise.

11. Excel 2019 Beginners: Charts

1. Creating Charts

The aim of this video is to explore creating charts.

2. Types of Charts

The aim of this video is to explore types of charts.

3. Editing Charts: Part 1

The aim of this video is to explore how to edit charts.

4. Editing Charts: Part 2

The aim of this video is to further explore how to edit charts.

5. Using Graphics to Enhance Charts

The aim of this video is to explore how to use graphics to enhance charts.

6. Linking Chart Titles

The aim of this video is to explore how to link chart titles.

7. Module 11 - Practice Exercise

Let's do a practice exercise.

12. Excel 2019 Beginners: Working with Names

1. Creating Range Names

The aim of this video is to explore how to create range names.

2. Managing Names

The aim of this video is to explore how to manage names.

3. Using Names in Formulas

The aim of this video is to explore how to use names in formulas.

4. Module 12 - Practice Exercise

Let's do a practice exercise.

13. Excel 2019 Beginners: Sorting and Filtering

1. Remove Duplicates

The aim of this video is to explore how to remove duplicates.

2. Sort Data

The aim of this video is to explore how to sort data.

3. Filter Data

The aim of this video is to explore how to filter data.

4. Advanced Filters

The aim of this video is to explore how to apply advanced filters.

5. Module 13 - Practice Exercise

Let's do a practice exercise.

14. Excel 2019 Beginners: Outlining and Subtotaling

1. Creating an Outline

The aim of this video is to explore how to create an outline.

2. Subtotals

The aim of this video is to explore subtotals.

3. Module 14 - Practice Exercise

Let's do a practice exercise.

15. Excel 2019 Beginners: Working with Views

1. Arranging Files

The aim of this video is to explore how to arrange files.

2. New Window Option

The aim of this video is to explore the new window option.

3. Custom Views

The aim of this video is to explore the custom views option.

4. Module 15 - Practice Exercise

Let's do a practice exercise.

16. Excel 2019 Beginners: Linking Files

1. Creating Formulas Between Files

The aim of this video is to explore how to create formulas between files.

2. Working with Links

The aim of this video is to explore how to work with links.

3. Consolidating Data

The aim of this video is to explore how to consolidate data.

4. Module 16 - Practice Exercise

Let's do a practice exercise.

17. Excel 2019 Beginners: Advanced Formula Creation

1. If Statements

The aim of this video is to understand the If statements.

2. VLOOKUPS

The aim of this video is to explore how VLOOKUPS works.

3. Data Validation

The aim of this video is to explore how data validation works.

4. Formula Auditing

The aim of this video is to explore formula auditing.

5. Module 17 - Practice Exercise

Let's do a practice exercise.

18. Excel 2019 Beginners: PivotTables

1. PivotTables

The aim of this video is to explore PivotTables.

2. Pivot Charts

The aim of this video is to explore pivot charts.

3. Module 18 - Practice Exercise

Let's do a practice exercise.

19. Excel 2019 Beginners: Additional Excel Features

1. Slicers

The aim of this video is to explore slicers.

2. Goal Seeker

The aim of this video is to explore goal seeker.

3. Text to Columns

The aim of this video is to explore how to convert text to columns.

4. Watch Window

The aim of this video is to explore Watch Window.

5. Customizing Ribbons and Tabs

The aim of this video is to explore how to customize ribbons and tabs

6. Module 19 - Practice Exercise

Let's do a practice exercise.

20. Excel 2019 Beginners: Shortcuts

1. Excel Shortcuts Every User Should Know

The aim of this video is to explore how to use Excel shortcuts.

21. Excel 2019 Beginners: Closing

1. Summary

Let's summarize what we have learnt so far.

22. Excel 2019 Advanced: Introduction to Advanced Course

1. Introduction

Let's start with advanced Excel.

2. Course Structure

The aim of this video is to explain the course structure for advanced Excel.

23. Excel 2019 Advanced: Functions

1. Functions - Part 1

What are the functions?

2. Functions - Part 2

Let's continue with the functions.

3. Autosum

The aim of this video is to explore the Autosum function.

24. Excel 2019 Advanced: Date and Time Functions

1. How Date and Time Works

The aim of this video is to explore how date and time works.

2. Basic Date and Time Functions

The aim of this video is to explore the basic dates and time functions.

3. Complex Date and Time Functions

The aim of this video is to explore the complex dates and time functions.

25. Excel 2019 Advanced: Text Functions

1. Using Text Functions - Part 1

The aim of this video is to explore how to use text functions.

2. Using Text Functions - Part 2

The aim of this video is to explore how to use text functions.

26. Excel 2019 Advanced: Logical Functions

1. Logical Functions

The aim of this video is to explore logical functions.

2. Exercise 01

Let's do a practice exercise.

27. Excel 2019 Advanced: Lookup Functions

1. Lookup Functions - Part 1

The aim of this video is to explore lookup functions.

2. Lookup Functions - Part 2

The aim of this video is to further explore lookup functions.

3. Exercise 02

Let us do a practice exercise.

28. Excel 2019 Advanced: Financial Functions

1. Financial Functions and Terminology

The aim of this video is to explore financial functions and terminology.

2. Personal Financial Functions

The aim of this video is to explore personal financial functions.

3. Principal and Interest Payments

The aim of this video is to explore principal and interest payments.

4. Depreciation

The aim of this video is to explore depreciation.

5. Exercise 03

Let us do a practice exercise.

29. Excel 2019 Advanced: Statistical Functions

1. Statistical Functions for Description - Part 1

The aim of this video is to explore statistical functions for description.

2. Statistical Functions for Description - Part 2

The aim of this video is to further explore statistical functions for description.

3. Statistical Functions for Forecasting - Part 1

The aim of this video is to explore statistical functions for forecasting.

4. Statistical Functions for Forecasting - Part 2

The aim of this video is to explore more statistical functions for forecasting.

5. Exercise 04

Let us do a practice exercise.

6. One Click Forecasting

The aim of this video is to explore one click forecasting.

7. Statistical Functions for Inference

The aim of this video is to explore statistical functions for inference.

30. Excel 2019 Advanced: Connecting to External Data

1. Connecting to Other Workbooks

The aim of this video is to explore how to connect to other workbooks.

2. Connecting to Access Databases

The aim of this video is to explore how to connect to access databases.

3. Connecting Web Data Sources

The aim of this video is to explore how to connect to web data sources.

4. Get and Transform

The aim of this video is to explore get and transform.

5. Exercise 05

Let us do a practice exercise.

31. Excel 2019 Advanced: Tables

1. Introduction to Tables

Let's start with tables.

2. Working with Tables

The aim of this video is to explore how to work with tables.

3. Table References

The aim of this video is to explore what are table references.

4. Table Styles

The aim of this video is to explore table styles.

5. Exercise 6

Let us do a practice exercise.

32. Excel 2019 Advanced: PivotTables

1. Introduction to PivotTables

The aim of this video is to explore PivotTables.

2. Working with PivotTables

The aim of this video is to explore how to work with PivotTables.

3. Filters and Slicers

The aim of this video is to explore filters and slicers.

4. Pivot and Charts

The aim of this video is to explore pivots and charts.

5. Exercise 07

Let us do a practice exercise.

33. Excel 2019 Advanced: Data Analysis

1. What If Analysis

The aim of this video is to explore What If analysis.

2. Scenario Manager

The aim of this video is to explore the scenario manager.

3. Goal Seek

The aim of this video is to explore goal seek.

4. Solver

The aim of this video is to explore Solver.

5. Exercise 08

Let us do a practice exercise.

34. Excel 2019 Advanced: Graphs and Charts

1. Area Charts

The aim of this video is to explore area charts.

2. Surface Charts

The aim of this video is to explore surface charts.

3. Radar Charts

The aim of this video is to explore radar charts.

4. Bubble Charts

The aim of this video is to explore bubble charts.

5. Sparklines

The aim of this video is to explore sparklines.

6. Stock Charts

The aim of this video is to explore stock charts.

7. Exercise 9

Let us do a practice exercise.

35. Excel 2019 Advanced: Excel Web App

1. Web App - Part 1

Let's look and understand web app.

2. Web App - Part 2

Let's continue with web app.

36. Excel 2019 Advanced: Course Conclusion

1. Summary

Let's summarize what we have learnt about Excel 2019.

Course Images

The Complete Excel Guide: Beginners to Advanced

By Packt

Booking options

Highlights

Description

Course Content

About The Provider

Tags

Reviews