Microsoft Excel 2016 - Intermediate Level: Student Manual (Color)

Note: This is the color version of the Student reference manual designed for instructor-led computer training. Can also be used as a self-paced tutorial for learning the intermediate concepts of Microsoft Excel 2016.

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

EZ-REF Courseware was started by two instructors back in 1993 and was the first company to offer editable courseware that could be customized by clients. Over the past two decades, EZ-REF has written hundreds of titles that have been sold worldwide to clients ranging from government agencies to universities and school districts to corporations to independent contractors.

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

• Designed by Instructors for Instructors
• One Time Licensing Fee (No Yearly Renewals)
• Unlimited Copies
• Not Controlled by a Scripted Schedule
• EZ to Customize – Just Cut & Paste
• Skill Levels Surveys, Exercise Files and EZ-Reference Cards
• Add Your Own Company Logo
• Everything Needed to Train Today!