Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) Course Outline
*** This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase.
About This Course
This Online On-Demand (self-study) training course includes expert lectures, PowerPoint visuals, and demonstrations. You will be able to follow along and successfully complete the course by completing the quizzes and exams. You do not need to own the software for the course and will be able to access the course from any device, provided you have internet access.
When you purchase this On-Demand course from ONLC you will receive a printed Learning Guide with access to downloadable practice files to supplement your learning. You must have the software (purchased version or free trial) to access the practice files. (Note: printed materials are not provided when you purchase the Office On-Demand Comprehensive bundle or when Office On-Demand is included with the All You Can Learn offer.)
Prefer a Live, Instructor-led Class?
If you don't feel On-Demand is right for you, consider our live, instructor-led format (ILT). For more details on the ILT option, click on the link below:
Microsoft Excel Training Classes
Duration
You have 24/7 access for 180-days to this digital course that includes 12h 04m of video presentation. As a traditional course it would be a 3-4 day class.
Course Outline
Microsoft Office Excel 2019: Part 1
Chapter 01 - Getting Started with Microsoft Office Excel 2019
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
Chapter 02 - Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Chapter 03 - Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Chapter 04 - Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
Chapter 05 - Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Chapter 06 - Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties
Chapter 07 - Adding Borders and Colors to Worksheets
Topic A: Add Borders and Colors to Worksheets
Chapter 08 - Basic Excel Customization
Topic A: Customize General Options and the Excel UI
Microsoft Office Excel 2019: Part 2
Chapter 01 - Working with Functions
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions
Chapter 02 - Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data
Chapter 03 - Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
Chapter 04 - Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Chapter 05 - Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers
Chapter 06 - Working with Graphical Objects
Topic A: Insert Graphical Objects
Topic B: Modify Graphical Objects
Topic C: Work with SmartArt
Chapter 07 - Using Array Formulas
Topic A: Use Array Formulas
Microsoft Office Excel 2019: Part 3
Chapter 01 - Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
Chapter 02 - Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Chapter 03 - Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Chapter 04 - Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas
Chapter 05 - Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends
Chapter 06 - Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data
Chapter 07 - Importing and Exporting Data
Topic A: Import and Export Data
Chapter 08 - Internationalizing Workbooks
Topic A: Internationalize Workbooks
Chapter 09 - Working with Power Pivot
Topic A: Work with Power Pivot
Chapter 10 - Advanced Customization Options
Topic A: Customize Advanced Options
Chapter 11 - Working with Forms and Controls
Topic A: Work with Forms and Controls
View outline in Word
GEXZ19
Facebook
LinkedIn