- This event has passed.
Excel O365 L2 – SYST-0004
July 15, 2021 @ 8:30 am - 4:00 pm$195.00
Excel Level 2
Course Length: 1 day
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.
- Work with multiple worksheets and workbooks.
- Use Lookup functions and formula auditing
- Share and protect workbooks.
- Automate workbook functionality.
- Create sparklines and map data.
- Forecast data.
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 O365 Exam 77-727
Appendix B: Microsoft Office Excel O365 Expert Exam 77–728
Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts
Appendix D: Financial Functions
Appendix E: Working with Graphical Objects
Appendix F: Using Array Formulas
This event ticket will close at 12:00 pm the day before the event.