## Microsoft Office Excel 2013: Level 3 Training

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]

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.