
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
Learning Modules
301A: Tables and the SUBTOTAL Function, Part 1
301B: Tables and the SUBTOTAL Function, Part 2
302: Financial Functions

303A: What-If Analysis Tools, Goal Seek
303B: What-If Analysis Tools, Scenario Manager
304A: PivotTables, Part 1
305: Worksheet Protection and Finishing Touches

Available Services
The following services are available to ensure your learners' success!
* Skill Builders are included in all hands-on training sessions
* User Forums are included with all hands-on training sessions
Online Delivery Options
Let us help you choose the right delivery option to optimize your time and money.
Technical Information
In our Training Portal, learners access DJL Training laptops for live online hands-on training.

Dual Screens
For the best learning experience in our instructor-led training portal, we recommend learners use two screens for training.
- On the Remote Lab screen, learners will complete training exercises under the watchful eye of their instructor.
- On the Virtual Classroom screen, learners will see and hear their instructor as they follow the instructor's step-by-step directions. The virtual classroom screen can be a big screen in a conference room or a learner's second monitor.

Training Manual
Recommended book - EXC19 Level 3 (LL)