Excel Level 2 Home / Courses / Excel Level 2 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 leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work with Text Functions Lesson 2: Working with Lists Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data Lesson 3: Analyzing Data Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting Lesson 4: Visualizing Data with Charts Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features Lesson 5: Using PivotTables and PivotCharts Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers 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: Financial Functions Appendix E: Working with Graphical Objects Appendix F: Using Array Formulas COURSE DESCRIPTION: In this intermediate course, participants will discover new ways to analyze information, sort and filter data, explore more advanced formulas, and turn numbers into eye-catching charts. Upon successful completion of this course, participants will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational spreadsheets and workbooks. IDEAL CANDIDATES: This course is designed for people who have either completed our Excel Level 1 course, or already possess foundational knowledge and skills in Excel and wish to begin taking advantage of some of the higher-level functionality to analyze and present data. RELATED COURSES: Excel Level 1, Excel Level 3, 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