MICROSOFT EXCEL

Excel is an excellent program for organizing, formatting, and calculating numeric data. Excel is well suited for working with numeric data for accounting, scientific research, statistical recording or any other situation that can benefit from organizing data in a table like format. For more information on this course, please email contact@pctkamloops.com

PREREQUISITES: 19 years of age or under with parental consent Grade 12 or equivalent Basic knowledge of Windows 98, Windows 2000 or XP Course Length: 20 Hours
Program Components:
Understand how to link workbooks together Consolidate information from different worksheets Create and modify data maps Create a database Search for data in the database Create and use PivotTables Use the Goal Seek and Solve functions to calculate optimum values Use data table Use scenarios Create and run Macros Use pick lists and data validation Add comments to worksheet cells Share your worksheets with others concurrently Merge workbooks Use audit tools on workbooks to identify errors Create worksheet forms with controls Import and export data with other applications