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
