My Daytona State

Microsoft Courses

 

To Register Contact:
Joanne Parker
Daytona State College
1200 W. International Speedway Blvd.
Daytona Beach, FL 32114
Building 110, Suite 236
P: (386) 506-4224
E: ParkerJ@DaytonaState.edu

Time:  8:00 a.m. - 5:00 p.m.
Location:  Daytona State College, Bergengren Hall (Bldg. 110, Rm. 249), 1200 W. International Speedway Blvd., Daytona Beach or our New Smyrna Beach Campus, Bldg. 2 Rm. 102, 940 10th St., New Smyrna Beach, FL, 32168
Fee:  $85 (includes a student workbook with a CD-ROM containing the lab files used in class)
Deadline: The deadline to register for eacerh course is one week prior to the course date. Courses fill quickly!
We accept checks, credit card (Mastercard, Visa), purchase order or company billing for payment.

Daytona State College reserves the right to cancel classes that do not meet minimum enrollment.

Click here for a course flyer

Excel 2010, Basic

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: Tuesday, September 9 or Tuesday, September 23, 2014

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 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, September 30, 2014

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.

Course Date: Tuesday, October 7, 2014

Word 2010, Basic

This course covers the basic functions and features of Word 2010. After an introduction to Word's window components, students will learn how to use the Help system and navigate documents. Then they will enter and edit text, create and save documents, and 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, and insert graphics.

Course Date: Tuesday, October 14, 2014

Word 2010, Intermediate

This course builds on the skills and concepts taught in Word 2010: Basic. Students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features.

Course Date: Tuesday, October 21, 2014

Word 2010, Advanced

This course builds on the skills and concepts taught in Word 2010: 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 will also create macros, customize the ribbon and Quick Access toolbar, and work with XML documents.

Course Date: Tuesday, October 28, 2014

PowerPoint 2010, Basic

This course covers the basic functions and features of PowerPoint 2010. After an introduction to PowerPoint's window components and Help system, students will learn to create, save, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will then learn to use templates and themes, slide masters, and transition effects. Finally, students will learn to proof, run, and print presentations.

Course Date: Tuesday, November 4, 2014

PowerPoint 2010, Advanced

This course builds on the skills and concepts taught in PowerPoint 2010: Basic. Students will customize PowerPoint by modifying the Ribbon and changing application settings. They will also apply themes and templates, and they will work with SmartArt graphics and tables. Students will add multimedia content and interactive elements to slides, and they will learn about presentation distribution options including PDF, HTML, and online broadcasts. Finally, students will integrate PowerPoint with Word and Excel.

Course Date: Tuesday, November 11, 2014

Access 2010, Basic

This course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

Course Date: Wednesday, November 19, 2014

Access 2010, Intermediate

This course builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Course Date: Wednesday, December 3, 2014

Access 2010, Advanced

This course builds on the skills and concepts taught in Access 2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

Course Date: Wednesday, December 10, 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

Learn More About Other Workforce and Continuing Education Programs

Center for Online Public Safety Training | Community Training Center | Cosmetology  | Institute of Child Care Training Programs | Institute of EMS Education | Institute for Health Services | Occupational Apprenticeships | Police and Corrections In-Service Training | Small Business Development Center | Work Force Careers

Daytona State College Facebook Daytona State College Twitter Daytona State College Youtube Daytona State College Linkedin Daytona State College RSS

Daytona State College 1200 W. International Speedway Blvd., Daytona Beach, Florida 32114 (386) 506-3000

Daytona State College is an equal opportunity institution.

Last updated: 2014-08-20T19:30:45.611Z