DAYTONA BEACH, FL (Dec. 1, 2011) - The Center for Business and Industry at Daytona State College in the new year will offer a series of one-day Microsoft 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 will save workbooks in various formats. Students also will 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 will be held on the Daytona Beach Campus on Tuesday, Jan. 24, or Tuesday, Jan. 31.
Excel 2010, Basic - This introductory training class is designed for students who desire to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2010 worksheets. Students will create and edit basic worksheets and workbooks. This course will be held on the Daytona Beach Campus on Thursday, Jan. 26.
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 will start working with more advanced formatting options, including styles, themes, backgrounds and watermarks. They also will 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 workbooks as a PDF files. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates. This course will be held on the Daytona Beach Campus on Thursday, Feb. 2 or Tuesday, Feb. 7.
Excel 2010, Intermediate - 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 will start working with more advanced formatting options, including styles, themes and backgrounds. They also will 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. This course will be held on the Daytona Beach Campus on Thursday, Feb. 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 will be held on the Daytona Beach Campus on Tuesday, Feb. 14.
Excel 2010, Advanced - 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. This course will be held on the Daytona Beach Campus on Thursday, Feb. 16.
Word 2007, Basic - This course covers the basic functions and features of Word 2007. Students will learn how to enter and edit text, and save and browse documents. They will learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, manage document revisions, and work with Web features. This course will be held on the Daytona Beach Campus on Tuesday, Feb. 21.
Access 2007, Basic - This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, forms and reports. This course will be held on the Daytona Beach Campus on Wednesday, Feb. 22.
Word 2007, Intermediate - This course builds on the skills and concepts taught in Word 2007: Basic. Students will work with styles, sections and columns. They will format tables, print labels and envelopes, and work with graphics. They also will use document templates, manage document revisions and work with Web features. This course will be held on the Daytona Beach Campus on Tuesday, Feb. 28.
Access 2007, Intermediate - This course builds on the skills and concepts taught in Access 2007: Basic. Students will learn how to normalize data; work with Lookup fields and sub-datasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. This course will be held on the Daytona Beach Campus, on Wednesday, Feb. 29.
Word 2007, Advanced - This course builds on the skills and concepts taught in Word 2007: Intermediate. Students will perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references and Web frames. They also will create macros, customize the Quick Access toolbar and keyboard shortcuts, and work with XML documents. This course will be held on the Daytona Beach Campus on Tuesday, March 6.
Access 2007, Advanced - This course builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter and action queries; create macros; import, export and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. This course will be held on the Daytona Beach Campus on Wednesday, March 7.
PowerPoint 2007, Basic - This course covers the basic functions and features of PowerPoint 2007. Students will create new presentations that include text, graphics, WordArt, tables, charts and diagrams. They will also edit and format slide content and apply transition effects. This course will be held on the Daytona Beach Campus on Thursday, March 22.
PowerPoint 2007, Advanced - This course builds on the skills and concepts taught in PowerPoint 2007: Basic. Students will customize PowerPoint by modifying the Quick Access Toolbar and creating macros. They also will apply themes and templates and will work with SmartArt graphics and tables. Students will add multimedia content and interactive elements to slides and will learn about presentation distribution options, including PDF and HTML. Finally, students will integrate PowerPoint with Word and Excel. This course will be held on the Daytona Beach Campus on Thursday, March 29.
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 email 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
Marketing & Communications, (386) 506-4588, marketing@DaytonaState.edu
A Member of the Florida College System
Daytona State College prohibits discrimination and assures equal opportunity in employment and education services to all individuals without regard to age, ancestry, belief, color, disability, ethnicity, genetic information, gender, marital status, national origin, political affiliation, race, religion, sex, and veteran status. For more details, read Our Policy.
 |
 |
 |
|
||
 |
|
 |
|
||
