Microsoft Office Excel 2013: Level 3 Training

Upcoming Instructor Led Online and Public Microsoft Office Excel 2013: Level 3 classes
Microsoft Office Excel 2013: Level 3 Training/Class 8 January, 2020 - 8 January, 2020 $250
HSG Training Center 1624 Market Street, Suite 202
Denver, CO 80202
Hartmann Software Group Training Registration
Microsoft Office Excel 2013: Level 3 Training/Class 12 February, 2020 - 12 February, 2020 $250
HSG Training Center 1624 Market Street, Suite 202
Denver, CO 80202
Hartmann Software Group Training Registration
Microsoft Office Excel 2013: Level 3 Training/Class 11 March, 2020 - 11 March, 2020 $250
HSG Training Center 1624 Market Street, Suite 202
Denver, CO 80202
Hartmann Software Group Training Registration
We offer private customized training for groups of 3 or more attendees.

Course Description

 
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will: Work with multiple worksheets and workbooks simultaneously. Share and protect workbooks. Automate workbook functionality. Apply conditional logic. Audit worksheets. Use automated analysis tools. Present your data visually.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

Students should have some experience creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.

Course Outline

 
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic A: Use 3-D References
Topic B: Use Links and External References
Topic C: Consolidate Data
 
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
 
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls
Topic C: Work with Macros
 
Lesson 4: Applying Conditional Logic
Topic A: Use Lookup Functions
Topic B: Combine Functions
Topic C: Use Formulas and Functions to Apply Conditional Formatting
 
Lesson 5: Auditing Worksheets
Topic A: Trace Cells
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Watch and Evaluate Formulas
 
Lesson 6: Using Automated Analysis Tools
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Activate and Use the Solver Tool
Topic E: Analyze Data with Analysis ToolPak Tools
 
Lesson 7: Presenting Your Data Visually
Topic A: Use Advanced Chart Features
Topic B: Create Sparklines
 
Appendix A: Microsoft Office Excel 2013 Exam 77-420
Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
Appendix C: Cube Functions
Appendix D: Import and Export Data
Appendix E: Internationalize Workbooks
Appendix F: Work with PowerPivot

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.