Be sure to bookmark the Master Training Calendar http://www.orgdev.gatech.edu/training/?page=mastcal for a complete list of available training courses.
October 2, 2009
Excel 2007 - Level 1
Instructor: New Horizons
Savant Building Room 203
9:00 am - 4:00 pm
Cost: $150
Overview: In this course, students create and edit basic Microsoft Office Excel 2007 worksheets and workbooks. (Second Edition)
Who Should Attend: This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
At Course Completion: Upon successful completion of this course, students will be able to: - Explore the Microsoft Office Excel 2007 environment and create a basic worksheet. - Perform calculations. - Modify a worksheet. - Format a worksheet. - Print workbook contents. - Manage large workbooks.
October 29 and 30, 2009
Access 2007 - Level 1 (2 day)
Instructor: New Horizons
Savant Building Room 203
9:00 am - 4:00 pm
Cost: $300
Overview: In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Access™ 2007 with other applications. (Second Edition)
Who Should Attend: This course is designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The first part of the course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. The second part of the course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.
At Course Completion: Upon successful completion of this course, students will be able to: - examine the basic database concepts and explore the Microsoft Office Access 2007 environment. - design a simple database. - build a new database with related tables. - manage the data in a table. - query a database using different methods. - design forms. - generate reports. - modify the design and field properties of a table to streamline data entry and maintain data integrity. - retrieve data from tables using joins. - create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries. - enhance the capabilities of a form. - customize reports to organize the displayed information and produce specific print layouts. - share Access data across other applications.
November 2, 2009
Excel 2007 - Level 2
Instructor: New Horizons
Savant Building Room 203
9:00 am - 4:00 pm
Cost: $150
Overview: In this course, students use Excel® 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats. (Second Edition)
Who Should Attend: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
At Course Completion: Upon successful completion of this course, students will be able to: - calculate with advanced formulas. - organize worksheet and table data using various techniques. - create and modify charts. - analyze data using PivotTables and PivotCharts. - insert graphic objects. - customize and enhance workbooks and the Microsoft® Office Excel® environment.
11/13/2009
Excel 2007 - Level 3
Instructor: New Horizons
Savant Building Room 308
9:00 am - 4:00 pm
Cost: $150
Overview: In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. (Second Edition)
Who Should Attend: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
At Course Completion: Upon successful completion of this course, students will be able to: - increase productivity and improve efficiency by streamlining your workflow. - collaborate with others using workbooks. - audit worksheets. - analyze data. - work with multiple workbooks. - import and export data. - use Excel with the web. - structure workbooks with XML.
Posts
No comments:
Post a Comment