Microsoft Excel 2016 - Intermediate: Instructor Guide (Color)

Courseware, EZ-Ref

ISBN 10: 154404187X ISBN 13: 9781544041872

Publisher: CreateSpace Independent Publishing Platform, 2015

Synopsis

Note: This is the color version of the instructor guide designed for instructor-led classroom training and is meant to be used with our companion student training manuals for Microsoft Excel 2016: Intermediate.

For the black and white instructor guide, search for ISBN-13: 978-1544041742
For the color instructor guide, search for ISBN-13: 978-1544041872
For the color student manual, search for ISBN-13: 978-1544041629
For the black and white student manual, search for ISBN-13: 978-1544041711

To download the exercise files that accompany this title, please visit http://www.ezref.com/exercise-files/

For information regarding unlimited printing with the ability to customize our courseware, please visit our website: www.ezref.com

Topics covered in Microsoft Excel 2016 - Intermediate (6-8 hours)

• Find/Replace
• Using Block Names
• Working With Dates
• Advanced Functions
• Creating a Database
• Sorting Records
• AutoFilter & Custom Filters
• Working with Tables
• Creating an Array Formula
• Linking Files
• Creating a Workspace
• Protecting Blocks/Worksheets
• Freezing Panes
• Splitting the Screen
• Hiding Columns/Blocks
• Multiple Worksheets & Tabs
• Working with Chart Sheets
• Hyperlinks
• Sharing Workbooks
• Tracking Changes
• Adding Cell Comments
• Conditional Formatting
• Formatting Shortcuts
• Custom Formats

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2015
• Language: English
• ISBN 10: 154404187X
• ISBN 13: 9781544041872
• Number of pages: 128