Microsoft Excel 2016 Intermediate

What Will You Learn?

• After completing this course, participants will have learned to:
• Create advanced formulas
• Analyze Data with Logical and Lookup Functions
• Create and Modify Tables
• Sort and Filter Data
• Use Subtotal and Database Functions to Calculate Data
• Visualize Data with Charts
• Create Advanced Charts
• Create a PivotTable
• Filter Data by Using Slicers
• Analyse Data with Pivot Charts
• Insert and Modify Graphic Objects
• Layer and Group Graphic Objects
• Customise Workbooks
• Manage Themes
• Create and Use Templates
• Protect Files
• Preparing a Workbook for Multiple Audiences