Excel 2013: Advanced

Audience	This course is designed for individuals interested in learning the skills necessary to troubleshoot large, complex Microsoft® Office Excel® 2013 workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex functions, and use those functions to perform rigorous analysis of datasets. This course covers Microsoft Office Specialist exam objectives to help individuals prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam.
Description	Upon successful completion of this course, participants will be able to: 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.
Prerequisites	To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft® Windows® experience Microsoft® Office Excel® 2013 Beginning Microsoft® Office Excel® 2013 Intermediate
Suggested Class Size	Minimum 3 Maximum 12
Course Length	Full day
Table of Contents	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

A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459; Marshall.Campbell@brazosport.edu