Intermediate Level (B&W) Student training manual designed for instructor-led computer training. Can also be used as a self-paced tutorial for learning the intermediate concepts of Microsoft Excel 2013.
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 - Microsoft Excel 2013 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 over 300 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!