DAYTONA BEACH, FL (July 12, 2011) - The Center for Business and Industry at Daytona State College, announces a series of one-day Excel 2007 courses from basic through advanced level.
Excel 2007, Basic – this course provides competency in the basic functions and features of Excel 2007. 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. This course is scheduled to be held on the Daytona Beach Campus, Wednesday, Aug. 3 and again, Friday, Aug. 5.
Excel 2007, Intermediate – this course builds on the skills and concepts taught in Excel 2007: 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, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates. This course is scheduled to be held on the Daytona Beach Campus, Tuesday, Aug. 9.
Excel 2007, Advanced – this course builds on the skills and concepts taught in Excel 2007: 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 work with PivotTables and PivotCharts, 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, and sharing Excel data via the Web. This course is scheduled to be held on the Daytona Beach Campus, Thursday, Aug. 18.
Each one-day course begins promptly at 8:30 a.m. and continues through to 4:30 p.m. with a one-hour break for lunch. The Daytona Beach Campus is located at 1200 W. International Speedway Blvd.
The deadline to register for each course is one week prior to the course date. Courses fill quickly! To register for these courses, contact Daytona State College at (386) 506-4224 or via e-mail to parkerj@DaytonaState.edu. We accept checks, credit card (MasterCard, VISA), purchase order or company billing for payment.
The fee for each course is $85 and includes a student workbook with a CD-ROM containing the lab files used in class. These are ‘hands-on’ courses and each participant will have their own computer. Courses may be canceled due to a lack of enrollment. For information about additional courses visit www.thecbi.com
-30-
MEDIA CONTACT
Marketing & Communications, (386) 506-4588, ryana@DaytonaState.edu
A Member of the Florida College System
Daytona State College assures equal opportunity in employment and education services to all individuals without regard to race, sex, color, age, religion, disability, national origin, political affiliation or belief, or marital status.