Part 3 | DJL Training, Inc

Microsoft Excel 2019

Our Excel 2019 courses will give learners a comprehensive understanding of the features and uses of Excel 2019. We offer Excel training for everyone from novices to power users.

Catalog > Microsoft > E xcel

Part 3 of 8

Excel 2019 Part 3

Excel 2019 Part 3 is intended for experienced Excel 2019 users who have a desire or need to advance their skills in working with some of the more advanced Excel features. This course will cover working with tables and subtotals, financial functions, what-if analysis tools, PivotTables and PivotCharts, and finishing touches.

To ensure success in this course, learners should have completed Excel 2019 Part 1 or have equivalent knowledge and experience. Excel 2019 Part 2 is helpful. Learners should also:

Be familiar with using personal computers
Have experience using a mouse and keyboard
Be comfortable working in Windows

Know how to open and close applications
Know how to navigate basic file structures
Know how to manage files and folders

12 hours

Course ID: EXC19-P3

Request Training

Excel 2019 Part 3 is eligible for

Community Outreach

Modules

Available Services

Delivery Options

Technical Info

Modules

Learning Modules

301A: Tables and the SUBTOTAL Function, Part 1

For learners who wish to learn how to use Excel's Table features and the SUBTOTAL function. In this module, learners will learn how to convert a range to a table to simplify the process of calculating totals, formatting data, and sorting and filtering data.

301B: Tables and the SUBTOTAL Function, Part 2

For learners who know how to convert a range to a table and perform calculations. In this module, learners will learn how to add and delete table rows and columns, and create a calculated column, view structured references, and display subtotals.

302: Financial Functions

For learners who wish to learn how to use Excel's financial functions to create a loan analysis sheet. Learners should be comfortable reading and writing formulas in Excel. In this module, learners will create multiple formulas and learn how to use the PMT and FV functions to find the monthly payment and future value of a loan.

303A: What-If Analysis Tools, Goal Seek

For learners who wish to learn how to use Excel's What-If Analysis tools which provide better ways to look at different scenarios than simply typing in the new arguments. In this module, learners will learn how to use Goal Seek.

303B: What-If Analysis Tools, Scenario Manager

303C: What-If Analysis Tools, Solver

304A: PivotTables, Part 1

For learners who need to summarize complex information using PivotTables. In this module, learners will be introduced to PivotTables and learn how to summarize large amounts of worksheet data dynamically by creating a simple PivotTable.

304B: PivotTables, Part 2

For learners who know how to create simple PivotTables and need to modify existing PivotTables. In this module, learners will learn how to change PivotTable settings, add calculations and create PivotCharts.

305: Worksheet Protection and Finishing Touches

For learners who wish edit document properties, inspect a workbook for hidden properties or personal information, and protect some aspects of their data from being changed - either accidentally or intentionally. In this module, learners will learn how to Editing Document Properties, Inspecting Hidden Properties, Locking a Cell, Hiding Formulas, Protecting a Worksheet and Protecting a Workbook.

Available Services

The following services are available to ensure your learners' success!

Before Training