- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Core Tech
Using Excel 2019
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 charts and objects.
Content in this path
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.
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.
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.
- 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
- No prerequisite knowledge needed.
- Microsoft Office