Excel 2016 Intermediate

pplying Formatting Techniques

• Accessing Quick Analysis Tools
• Using Worksheet
• Comments
• Creating and Modifying Styles
• Using Special Number Formats
• Developing Custom Number Formats
• Creating Custom Themes

Organizing Worksheet and Table Data

• Hiding Windows and Sheet Tabs
• Creating Custom AutoFills
• Creating Tables
• Formatting with Table Styles
• Sorting and Filtering Table Data
• Using a Custom Sort
• Removing Duplicate Records
• Converting a Table to a Cell Range

Using Multiple Pages, Worksheets and Workbooks

• Selecting Multiple Worksheets
• Viewing and Arranging Multiple Workbook Windows
• Linking Data Between Worksheets
• Linking Worksheets with Formulas
• Linking Workbooks

Inserting Graphic Objects

• Inserting Pictures
• Modifying Pictures
• Drawing and Modifying Shapes
• Using SmartArt Graphics
• Layering and Grouping Graphic Objects
• Using the Screenshot Tool

Creating Charts

• Charting Consecutive Data
• Charting Non-Consecutive Data
• Moving, Resizing and Deleting Charts and Objects
• Adding Chart Titles and Legends
• Changing the Chart Type and Colors
• Displaying the Data Table
• Using Charting Tools like Sparkline’s and Slicers
• Printing Charts
• Saving the Chart Template for Later Use

Utilizing Formulas

• Using Absolute and Relative Cell References
• Using the IF Function
• Using the VLOOKUP Function
• Creating Nested Functions
• Auditing Worksheets
• Utilizing the Watch Window

Finishing Details before the Workbook is Complete

• Printing Titles on Each Page
• Setting the Print Area
• Adding Headers and Footers to Printed Pages
• Hyperlinking to Other Locations
• Saving the Workbook as a Template
• Changing Excel Properties