HARTMANN software group

Microsoft Office Excel 2013: Level 3 Training in Jefferson City

Enroll in or hire us to teach our Microsoft Office Excel 2013: Level 3 class in Jefferson City, Missouri by calling us @303.377.6176. Like all HSG classes, Microsoft Office Excel 2013: Level 3 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Excel 2013: Level 3 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

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]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
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.