This course teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

Course Date: Thursday, June 12, 2014

This course builds on the skills and concepts taught in Excel 2010: Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts.

Course Date: Tuesday, June 17, 2014

This course builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

Course Date: Thursday, June 19, 2014

Project 2010 (click here for a course flyer)

Regardless of job title, most of us have at one time or another performed the tasks of a project manager. If you have ever been responsible for coordinating a variety of tasks that had to be completed within a specific time frame for a set amount of money, you have acted as a project manager. Microsoft Project 2010 can assist you in managing your projects by storing project information, calculating and maintaining the project schedule, tracking project costs, and analyzing and communicating project data.

Course Dates: Friday, March 21 and April 11, 2014

Time: 8:30 a.m. to 4:30 p.m.

Location: Daytona State College, Bergengren Hall (Bldg. 110, Rm. 249), 1200 W. International Speedway Blvd., Daytona Beach

Fee: $195