Excel Level 3 Home / Courses / Excel Level 3 PST, Application Classroom Length: 1 day Times: 9:00 AM – 4:30 PM View Course Outline 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 COURSE DESCRIPTION: This advanced course introduces participants to high-end features in Excel in order to build skills and tackle more complex data analysis. Participants will increase their competence in data analysis, helping them to meet targets more efficiently and also preparing them to move on to more advanced courses such as Excel Pivot Tables, Excel Power Pivot, and Excel VBA. This course covers Pivot Tables, charts, collaborating with others, and the automation of complex and/or repetitive tasks. We will also focus on developing the skills to use conditional logic in order to construct and apply elaborate functions and formulas; enhancing participants' ability to become more productive and efficient in working with large amounts of data. Additional topics covered include advanced functions, What If analysis, Scenarios and Goal Seeker, VLOOKUPS, data imports, and Macros and forms. IDEAL CANDIDATES: This course is designed for anyone who has completed the Excel Level 2 course or possesses intermediate knowledge of Excel and is looking to build a more advanced skill set and knowledge of the application – in particular, anyone looking to learn the foundations of working with Pivot Tables and basic Macros. If you work with Excel extensively, this course will benefit you. RELATED COURSES: Excel Level 1, Excel Level 2, Excel Pivot Tables, Excel Power Pivot, Excel VBA, Microsoft Power BI Access Level 1, Access Level 2, Access Level 3, Office 365, Outlook Level 1, Outlook Level 2, PowerPoint Level 1, PowerPoint Level 2, Project Level 1, Project Level 2, Publisher, SharePoint Site Administrator, SharePoint Site Owner, SharePoint Site User, Visio Level 1, Visio Level 2, Word Level 1, Word Level 2, Word Level 3