Skip to body

ITS Training

Excel: Charts & Tables

Type: Professional development.

Delivery method:  Hands-on training Hands-on icon

Experience level:  Intermediate; for those with some experience Intermediate iconIntermediate icon

Length: Two hours (break-time included).

Description:  Many CWU offices use Excel for budgets and other financial applications.  There are additional features in Excel that can make you more productive.  Excel charts can display data from your spreadsheet graphically, which is helpful for presentations.  Excel can also perform basic database functions which may be easier for people to manipulate than an Access database. Excel calls these databases "tables" or "lists" and allow you to organize and analyze information that you already have in a spreadsheet. Separate classes will be held for the Mac and PC versions of Excel as the two are too different to be taught in conjunction.

Prerequisites: Understand the basics of Excel.

Online optionsMicrosoft provides free online training for Excel 2010 (PC) here: http://office.microsoft.com/en-us/excel-help/excel-help-and-how-to-FX101814052.aspx?CTT=97 and Excel 2011 (Mac) here: http://mac2.microsoft.com/help/office/14/en-us/excel/ with videos and courses. For Excel 2013, (PC) go to: http://office.microsoft.com/en-us/excel-help/training-courses-for-excel-2013-HA104032083.aspx. You can also view the new features of Excel 2013 with hands-on examples by opening the program and then clicking on the Take a tour icon in the right-hand pane of the window.

All CWU faculty, staff and students also have access to free online training from Microsoft through our campus licensing agreement. Just log into MyCWU with your CWU credentials and click on the link for the Microsoft IT Academy under the Main Menu, My CWU Links. Follow the instructions there for setting up an account and accessing the online training.

You can register for any technical training classes through MyCWU - Main Menu - Human Resources - Self Service - Learning and Development - Request Training Enrollment. For detailed enrollment instructions, please visit http://www.cwu.edu/hr/register-professional-development-online.

Page last updated 03/24/14.