Course Details Location: PST, Application Classroom Length: 1 day Times: 9:00 AM – 4:30 PM Price: $175 Lessons: 5 view details 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 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