This course is designed to teach participants intermediate skills of working within Microsoft Excel. Topics covered in the course include, but are not limited to:

•Finding & Replacing Data
•Using Block Names
•Working with Dates
•Advanced Functions
•Creating a Database
•Sorting Records within a Database
•Filtering Data
•Working with Tables
•Creating an Array
•Linking Files
•Protecting your Data
•Freezing Columns & Rows
•Splitting the Screen
•Hiding Columns
•Working with Multiple Sheets
•Inserting Chart Sheets
•Inserting a Hyperlink
•Sharing Workbooks
•Working with Comments
•Conditional Formatting
•Formatting Shortcuts
•Custom Formatting

Recommended: A laptop computer is recommended with Microsoft Excel preloaded onto the system. You are encouraged to bring your own laptop. The TEEX COAST Program has laptops for use during the course on a first-come, first-served basis. All requests for use of the TEEX COAST laptops must be made in advance of the course to [email protected].