Excel Tips & Tricks: Sheet Tab and File Linking, Macros & Data Protection a...
Event Information
Description
This interactive, hands-on Excel Tips and Tricks class will teach you time-saving techniques that will boost your performance in accomplishing your Excel projects.
You will learn how to:
* AutoFilter - filter a database quickly for specific information criteria
* Linking - link sheet tabs of information and link Excel files to create interactive summary reports
* Data Protection - protect your data from being overwritten when requesting data entry assistance from others
* Remove Duplicates - efficiently identify and remove duplicate entries from your database
* Subtotal feature - instantly create subtotal lines in your database
* Custom Sorting - effectively sort data and create a custom sort based on months of the year or cell color
* Macros - and automate repetetive tasks by recording a simple Macro
* Time-saving Keyboard Shortcuts to increase productivity
By the end of this class, you will have learned powerful interactive techniques that will help you complete your Excel projects more efficiently and productively.
SPECIAL NOTE: Students are required to bring a laptop computer to class and a separate mouse if possible.
Space is limited. Please register early!
Class Registration closes on Thursday, 1/24/19 at 5pm.