Course Details Location: PST, Application Classroom Length: 1 day Times: 9:00 AM – 4:30 PM Price: $175 Lessons: 6 view details 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. Lesson 1: Working with Multiple Worksheets and Workbooks Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data Lesson 2: Using Lookup Functions and Formula Auditing Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas Lesson 3: Sharing and Protecting Workbooks Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks Lesson 4: Automating Workbook Functionality Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros Lesson 5: Creating Sparklines and Mapping Data Topic A: Create Sparklines Topic B: Map Data Lesson 6: 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: Forecasting Data Trends Appendix A: Microsoft Office Excel 2016 Exam 77-727 Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728 Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts Appendix D: Cube Functions Appendix E: Importing and Export Data Appendix F: Internationalizing Workbooks Appendix G: Working with Power Pivot Appendix H: Advanced Customization Options Appendix I: Working with Forms and Controls Registration Fill in the fields below to register for courseChoose the option that best describes the student: *selectCorporate ParticipantFederal/MilitaryWIOAState and Local Government Employees RSFHAdditional RegistrantName *FirstLastCompany *Email *Phone *NameRegister