Using Excel 2019

Paths

Using Excel 2019

Author: Bill Kulterman

This skill covers the essential information on how to create and manage worksheets and workbooks, cells and ranges, tables, how to apply formulas and functions, and how to create... Read more

What you will learn

  • Creating and managing worksheets and workbooks
  • Working with cells, rows and columns
  • Using auto functions
  • Inserting and managing tables and objects
  • Creating charts and custom formats
  • Referencing and managing data
  • Using Pivot Tables and PowerQuery
  • Creating and managing macros
  • Finalizing workbooks

Pre-requisites

No prerequisite knowledge needed.

Beginner

In this beginner section we will introduce Excel navigation and teach you how to manage worksheets. We will be selecting and moving data, formatting cells and text, and getting worksheets ready for printing.

Excel 2019 Essentials

by Bill Kulterman

Jan 31, 2019 / 2h 5m

2h 5m

Start Course
Description

Knowing the basics of Excel 2019 can help make you a more well rounded professional. In this course, Excel 2019 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns, and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to begin creating your own spreadsheets (and begin preparation for the Microsoft Office exams.)

Table of contents
  1. Getting to Know Excel 2019
  2. Backstage View
  3. Working with Worksheets and Data
  4. Working with Rows and Columns
  5. Formatting
  6. Totaling Values
  7. Saving a File

Intermediate

In this intermediate section we will sort and filter data and then create tables. We will also manage and format workbooks as well as create basic charts.

Excel 2019 Power Users

by Bill Kulterman

Aug 20, 2019 / 3h 27m

3h 27m

Start Course
Description

Learn more advanced aspects of Excel 2019. In this course, Excel 2019 Power Users, you will take your knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes, and more. Next, you’ll discover how to work with workbooks, worksheets, and data. Then you’ll see more about printing workbooks (in whole or parts). Finally, you’ll explore a few advanced functions. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams.)

Table of contents
  1. Formatting Data
  2. Working with Workbooks and Worksheets
  3. Working with Data
  4. Printing a Workbook
  5. Working with Tables
  6. Working with Advanced Function

Advanced

In this advanced section we will cover creating custom formats and referencing and managing data. We will also cover different functions, Pivot Tables, Pivot Charts and how to use PowerQuery.

Excel 2019 Pro

by Bill Kulterman

Aug 7, 2019 / 5h 21m

5h 21m

Start Course
Description

Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll learn how to format and work with data. Then, you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros, and form controls. When you’re finished with this course, you'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams).

Table of contents
  1. Formatting
  2. Working with Data
  3. Power Query
  4. Text Functions
  5. Logical and Statistical Functions
  6. Expanded Functions
  7. Error Checking
  8. Conditional Formatting
  9. Charts
  10. Pivot Tables
  11. Advanced Options
  12. Finalizing a Workbook
  13. Macros
  14. Form Controls