In this two day course, participants will examine basic database concepts, and create and modify databases and their various objects using the Access™ 2007 relational database application. This 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.

• Discuss basic database concepts
• Navigate the Microsoft Office Access 2007 environment
• Explore the Ribbon
• Determine fields and group fields into tables
• Normalize data
• Create a table relationship
• Sort and filter records
• Query a database using different methods
• Design rudimentary forms with the Form wizard
• Generate simple reports with the Report wizard
• Prepare a report for printing

In this two- day course you will learn how to maintain data consistency, how to customize database components, and how to share Access data with other applications. This course is for the individual whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access ™ and other applications.
Audience: completion of the Microsoft Office Access 2007 Level 1 course or equivalent knowledge and experience is recommended.
Upon successful completion of this course you should be able to:

• Restrict data entry using field properties
• Establish patterns for entering Field Values
• Create Query Joins – Join unrelated tables
• Create flexible queries to display specified records
• Enhance the capabilities of a form
• Customize reports to organize the displayed information and produce specific print layouts
• Set Report Control properties
• Create a Subform
• Add a Subreport to an existing report
• Summarize report information
• Import and Export Data

In this course you will learn the skills you need to create and modify Excel ™ 2007 Level 1 worksheets, perform calculations, modify and format worksheet and develop a workbook. Because the book provided with this course is designated as “Approved Courseware” for the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam. For comprehensive certification training, all levels of Excel 2007 should be completed.

Note: The content of this 2-day course is the same as the 1-day course; however, the leisurely pace of this 2-day course allows for more practice time, as well as discussion of the concepts of spreadsheet uses and layout before starting with the specific features of Excel.

Choose this 2-day class if you have no experience with EXCEL, want knowledge about features, and would like more hands-on learning time.

Choose the 1-day class if you have worked with EXCEL and want more knowledge about features without extensive hands-on learning time.

Upon successful completion of this course you should be able to:

• Create, explore, and navigate in a basic Worksheet
• Perform calculations using Formulas and Functions
• Manipulate data, insert and delete cells, columns and rows
• Search for Data in a Worksheet
• Modify, change, and add fonts, borders, color, and styles to Worksheet
• Print Workbook contents, set Print Options and set Page Breaks
• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets

Audience: All interested individuals who have taken a Windows course or equivalent experience.

In this course you will learn the skills you need to create and modify Excel ™ 2007 Level 1 worksheets, perform calculations, modify and format worksheet and develop a workbook. Because the book provided with this course is designated as “Approved Courseware” for the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam. For comprehensive certification training, all levels of Excel 2007 should be completed.

Note: The content of this 2-day course is the same as the 1-day course; however, the leisurely pace of this 2-day course allows for more practice time, as well as discussion of the concepts of spreadsheet uses and layout before starting with the specific features of Excel.

Choose this 2-day class if you have no experience with EXCEL, want knowledge about features, and would like more hands-on learning time.

Choose the 1-day class if you have worked with EXCEL and want more knowledge about features without extensive hands-on learning time.

Upon successful completion of this course you should be able to:

• Create, explore, and navigate in a basic Worksheet
• Perform calculations using Formulas and Functions
• Manipulate data, insert and delete cells, columns and rows
• Search for Data in a Worksheet
• Modify, change, and add fonts, borders, color, and styles to Worksheet
• Print Workbook contents, set Print Options and set Page Breaks
• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets

Audience: All interested individuals who have taken a Windows course or equivalent experience.

In this course you will use Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Audience: Completion of the Microsoft Excel 2007 Level 1 course or equivalent knowledge and experience is recommended.
Upon successful completion of this course you should be able to:

• Calculate data with advanced Formulas
• Analyze data with Logical and Lookup Functions
• Create, modify and format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data Across Worksheets
• Create, modify and format Charts
• Analyze Data using Pivot Tables and PivotCharts
• Insert and modify Pictures and ClipArt
• Illustrate Workflow using SmartArt Graphics
• Manage the View of Large Worksheets

This hands-on course is for experienced Excel users to build on their knowledge and skills. Course will explore advanced formulas, functions, data validation, PivotTables, and PivotCharts, importing and exporting text files and XML data, Macros, and sharing data over the web. Class will also cover functions to make your work life more automated with custom functions, lookup, match, index, and other tools that will make Excel do part of your job for you.
Upon successful completion of this course you should be able to:

• Calculate data with logical and financial functions
• Analyze data with statistical functions
• Use advanced functions of Lookup, Match and Index to automate tasks
• Validate cell entries
• Create, rearrange and format Pivot Tables and Charts
• Export and import text files and XML data
• Query external databases
• Run and record a Macro
• Work with VBA code
• Create custom functions
• Use conditional formatting with graphics, including SmartArt

In this course you will practice using the basic functions and features of Excel 2010. You will navigate worksheets, enter and edit text and values, and save workbooks. You will also move, copy, format, and work with printing.

If you are interested in pursuing Microsoft Office Specialist certification, this course will help you prepare for the Excel 2010 exam.

Upon successful completion of this course, you should be able to:

• Create a basic worksheet by using Microsoft Office Excel 2010
• Perform calculations in an Excel worksheet
• Create a basic formula and use a function
• Modify an Excel worksheet
• Format a worksheet.
• Print the content of an Excel workbook
• Manage an Excel workbook

Prerequisites: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take an introductory Windows course.

In this course you will practice using the basic functions and features of Excel 2010. You will navigate worksheets, enter and edit text and values, and save workbooks. You will also move, copy, format, and work with printing.

If you are interested in pursuing Microsoft Office Specialist certification, this course will help you prepare for the Excel 2010 exam.

Upon successful completion of this course, you should be able to:

• Create a basic worksheet by using Microsoft Office Excel 2010
• Perform calculations in an Excel worksheet
• Create a basic formula and use a function
• Modify an Excel worksheet
• Format a worksheet.
• Print the content of an Excel workbook
• Manage an Excel workbook

Prerequisites: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take an introductory Windows course.

In this course you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

If you want to practice the advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks, this course is for you.

Upon successful completion of this course you should be able to:

• Use advanced formulas.
• Organize worksheet and table data using various techniques.
• Create and modify charts.
• Analyze data using PivotTables, Slicers, and PivotCharts.
• Insert and modify graphic objects in a worksheet.
• Customize and enhance workbooks and the Microsoft Office Excel environment.

Prerequisite: Completion of the Microsoft Excel 2010 Level 1 course or equivalent knowledge and experience is recommended.

If you are an experienced Excel user who wants to build on knowledge and skills, this course is for you. Along with streamlining your workflow, you’ll practice features that help you collaborate with others, audit worksheets, perform data analysis, and integrate data with the Web. You will also cover functions to make your work life more automated and other tools that will make Excel do part of your job for you.

Upon successful completion of this course you should be able to:

• Create and edit macros
• Apply conditional formatting
• Apply data validation criteria
• Protect, share, and merge files
• Set and review revision tracking
• Administer digital signatures
• Trace cells and troubleshoot formula errors
• Audit worksheets using a data list outline
• Analyze data using trendlines, Sparklines, and scenarios
• Perform a what-if analysis
• Use Analysis ToolPak for statistical analysis
• Consolidate data and link workbooks
• Export and import text files and XML data
• Import data from the Web and create a Web query

Audience: Completion of the Microsoft Excel Level 1 & 2 courses or equivalent knowledge and experience is recommended.

If you are an experienced Excel user who wants to build on knowledge and skills, this course is for you. Along with streamlining your workflow, you’ll practice features that help you collaborate with others, audit worksheets, perform data analysis, and integrate data with the Web. You will also cover functions to make your work life more automated and other tools that will make Excel do part of your job for you.

Upon successful completion of this course you should be able to:

• Create and edit macros
• Apply conditional formatting
• Apply data validation criteria
• Protect, share, and merge files
• Set and review revision tracking
• Administer digital signatures
• Trace cells and troubleshoot formula errors
• Audit worksheets using a data list outline
• Analyze data using trendlines, Sparklines, and scenarios
• Perform a what-if analysis
• Use Analysis ToolPak for statistical analysis
• Consolidate data and link workbooks
• Export and import text files and XML data
• Import data from the Web and create a Web query

Audience: Completion of the Microsoft Excel Level 1 & 2 courses or equivalent knowledge and experience is recommended.