Custom Excel 2016 - Level 2

This course is intended for intermediate Microsoft Excel 2016 users. Learning Objectives:

• Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box.
• Organize, protect, and display data using various tools.
• Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources.
• Create and modify charts to present data effectively; customize charts to enhance their appearance.
• Create, apply and modify styles to format worksheets consistently and quickly; use comments, text boxes to annotate worksheets, and sparklines to highlight and explain data.

Data Download