GETTING WORK DONE WITH MS EXCEL 2007 – USING FUNCTIONS AND FORMULAS

Overview/Description
Excel 2007 provides many functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course teaches how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.

Target Audience
End users seeking competency in the use of Microsoft Excel 2007.

Prerequisites
Getting Started with MS Excel 2007 or one year experience using MS Excel.

Expected Duration
1.5 hours

Lesson Objectives
Basics of Formulas and References in Excel 2007
•    Identify the parts of a formula
•    Identify the default order in which calculations occur
•    Match absolute, relative, mixed, and 3-D references with examples
Insert Formulas in Excel 2007
•    Insert an Excel 2007 formula
•    Use names to clarify formulas
•    Edit formulas
•    Entering a Formula with References in Excel 2007
Perform AutoCalculate Functions in Excel 2007
•    Use the AutoCalculate feature to perform basic functions
Logical, Financial, and Date Functions in Excel 2007
•    Use a logical function
•    Use a financial function
•    Use a date function

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS EXCEL 2007 – MANAGING DATA 
 

Overview/Description
Excel 2007 provides improved tools and new features that allow you to improve the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and changing workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered.
 

Target Audience
End users seeking competency in the use of Microsoft Excel 2007.
 

Prerequisites
Getting Started with MS Excel 2007 or one year experience using MS Excel.
 

Expected Duration
1.5 hours
 

Lesson Objectives
Copy and Move Data in Excel 2007
•    Copy or move data in given scenarios
Change Rows and Columns in Excel 2007
•    Add, delete, or resize rows and columns in a given scenario
•    Change rows and columns to view specific sections of the worksheet
Insert and Modify Worksheets in Excel 2007
•    Format workbooks in given scenarios
•    Insert and delete a worksheet
•    Rename a worksheet and format the tab color
•    Copy or move worksheets
Working with Data and Workbooks in Excel 2007
Copying and Moving Data and Worksheets
Format Data in Excel 2007
•    Apply basic data formatting
•    Format a data range as a table
•    Change the position of data in a cell in a given scenario
•    Identify the functions of alignment commands
Format Data as a Table in Excel 2007
•    Work with tables in Excel 2007
•    Format a data range as a table
•    Change an Excel table
Format Numbers in Excel 2007
•    Apply number formats in a given scenario
•    Identify the number formatting choices available in excel 2007
Conditional Formatting in Excel 2007
•    Apply basic conditional formatting rules in a given scenario
•    Recognize when conditional formatting is suitable
Formatting Data in Excel 2007
Formatting Workbooks in Excel 2007

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS EXCEL 2007 – USING PIVOT TABLES AND CHARTS
 

Overview/Description
Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve needed results from formulas by finding out the data the formula needs. You can also use added what-if analysis items, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis features, such as PivotTable and PivotChart reports, Goal Seek, Solver, scenarios, data tables, and OLAP.

Target Audience
End users

Prerequisites
Getting Started with MS Excel 2007 or one year working with Excel.

Expected Duration
2.5 hours

Lesson Objectives
PivotTable Reports in Excel 2007
•    Create a pivottable report
•    Rearrange pivottable data
Excel 2007's PivotTable Tools
•    Customize pivottable reports
•    Change the look and feel of a pivottable report
PivotChart Reports in Excel 2007
•    Create a pivotchart report
•    Change a pivotchart report
Calculations in Excel 2007 PivotTables Reports
•    Perform calculations in pivottables reports
•    Recognize when to use each calculation type
Creating PivotTable Reports in Excel 2007
Creating PivotChart Reports for Data Analysis
Work with Goal Seek and Solver in Excel 2007
•    Use Goal Seek to perform data analysis
•    Use Solver to perform data analysis
Create Scenarios in Excel 2007
•    Create scenarios for what-if analysis
•    Use the scenario manager to modify scenarios
Create a Data Table and Project Values in Excel 2007
•    Create a one-variable data table for data analysis
•    Create a two-variable data table for data analysis
•    Project values in a series
Use Advanced Functions in Excel 2007
•    Perform advanced functions
•    Match advanced functions with examples of when you would use them
•    Consolidate data from different workbooks using a summary function
Performing Advanced Data Analysis in Excel 2007

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS OUTLOOK 2007 – USING ALERTS AND RULES

Overview/Description
Microsoft Outlook 2007 provides you with the tools you need to manage your e-mail messages. By using predefined or custom rules and alerts, you can organize your messages by moving, deleting, and forwarding them correctly, and you can even choose to send an automatic reply to incoming e-mail.  This course teaches how to configure rules and alerts to help organize e-mail messages.

Target Audience
End users seeking competency in the use of Microsoft Office Outlook 2007.

Prerequisites
The Microsoft Office 2007: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet

Expected Duration
1.5 hours

Lesson Objectives
Filtering E-mail Using Rules in Outlook 2007
•    Create a rule from a template in a given scenario
•    Create a rule from a message in a given scenario
•    Run a rule manually in a given scenario
•    Change a rule in a given scenario
Out of Office Assistant and Public Folder Rules
•    Create a rule for the Out of Office Assistant in a given scenario
•    Add a rule to a public folder in a given scenario
Using Alerts in Outlook 2007
•    Switch on desktop alerts in a given scenario
•    Extend the on-screen duration of a desktop alert in a given scenario
•    Set up an alert for a sharepoint library in a given scenario

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS POWERPOINT 2007 – USING THEMES, GRAPHICS AND CHARTS

Overview/Description
Microsoft PowerPoint 2007 is a useful application for creating dynamic slide show presentations. This course teaches how to create visually appealing presentations using PowerPoint's design templates and setting up new Microsoft Office 2007 themes. The course also introduces SmartArt in PowerPoint 2007, a feature that allows you to add some glamour to your presentations by using colors and shapes to highlight text and data. Also covered are the various ways of incorporating diagrams, tables, and charts to increase your presentations' appeal.

Target Audience
End User seeks added competency in PowerPoint 2007.

Prerequisites
Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
1.5 hours

Lesson Objectives
Using Themes in PowerPoint 2007
•    Apply a theme to a presentation in powerpoint 2007
•    Customize a theme in a powerpoint 2007 presentation
•    Inserting Objects in powerpoint 2007
•    Insert objects in powerpoint presentations
SmartArt graphics in PowerPoint 2007
•    Change the appearance of powerpoint slides using smartart graphics
Using Themes and SmartArt in PowerPoint 2007
Creating Charts and Tables in PowerPoint 2007
•    Add a chart or a table in powerpoint
•    Change the data in an embedded chart
Formatting Charts and Tables in PowerPoint 2007
•    Change the appearance of a powerpoint chart
•    Change the appearance of a powerpoint table

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS POWERPOINT 2007 – ADDING MULTIMEDIA

Overview/Description
Microsoft’s PowerPoint 2007 is one of the world’s most widely used applications for creating presentations. Powerful, high-impact slide shows come to life with the addition of multimedia to your presentations. Engage your audience by keeping things lively and interactive with movie and sound clips, animated slide content, and slide transitions. This course will help you to make the most of all these features.

Target Audience
End User seeking to gain added competency in PowerPoint 2007

Prerequisites
Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
1.5 hours

Lesson Objectives
Inserting Multimedia in PowerPoint 2007
•    Insert a multimedia clip in a presentation
•    Insert a sound clip in powerpoint
Animating Slide Content in PowerPoint 2007
•    Animate an object in powerpoint
Creating an Animated PowerPoint 2007 presentation
Specifying Slide Transitions in PowerPoint 2007
•    Specify a transition for a slide in powerpoint
•    Recognize the choices for transitioning between slides in a presentation
Adding Navigation Elements in PowerPoint 2007
•    Identify the ways to improve navigation in a powerpoint presentation
•    Add a hyperlink to a slide
•    Add an action button to a slide
Adding Transitions and Navigating in PowerPoint 2007

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS WORD 2007 – GET THE PICTURE:  USING TABLES, CHARTS, AND GRAPHS

Overview/Description
By using the table and charting capabilities of Microsoft Office Word 2007, you can format, sort, and analyze data with ease. In Word 2007, you can insert a table by selecting its layout from a list of preformatted tables, or by selecting the number of columns and rows that you need. You can insert a table into your regular document layout, or you can nest it within another table for increased complexity. There may also be times when you need to insert Excel data or charts into a Word document, and Word 2007 enables you to do so with a few simple steps. This course shows how to create, format, and change Word 2007 tables, including inserting and deleting table elements, resizing tables, merging and splitting cells, sorting data, using simple formulas, as well as converting a table to text. Methods of inserting, linking, and embedding Excel objects in Word documents are explained in this course, as well as inserting and formatting charts.

Target Audience
End users seeking to gain competency in Word 2007

Prerequisites
Getting Started with MS Word 2007 and some experience of using Microsoft Office or one year experience using Microsoft Word
 

Expected Duration
1.5 hours

Lesson Objectives
Create and Formatting Tables
•    Insert a table
•    Create a table
Formatting Tables
•    Format a table
•    Display or hide gridlines
•    Convert text to a table or vice versa
Change Table Structure in Word 2007
•    Add a cell, row, or column to a table
•    Merge cells in a table
Sort Table Data in Word 2007
•    Sort table contents
Create Word 2007 Tables from Excel
•    Embed a selection from an Excel worksheet in a Word document
•    Distinguish between linked and embedded objects
•    Link to an Excel worksheet in a Word document
Working with Charts in Word 2007
•    Insert a chart into a Word document
•    Paste an Excel chart into Word

Click here to check class availability on the registration page.

GETTING WORK DONE WITH MS WORD 2007 – BUILDING FORMS AND MAIL MERGE

Overview/Description
Word 2007 enables you to create forms quickly and easily, so they can be used by other users of Word 2007. Forms contain form fields that you can link to external data sources, and Word 2007 contains security features to protect forms from tampering by other users. Inserting fields has been simplified in Word 2007 with built-in commands and content controls. The mail merge feature is also improved and simplified in Word 2007, enabling users to merge content into letters, e-mail messages, envelopes, and labels easily.
The course teaches how to add, change, and update form fields, as well as walking through the mail merge process.

Target Audience
Advanced end users seeking to gain competence in Word 2007.

Prerequisites
Getting started with MS Word 2007; some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of data sources such as MS Excel and Access.

Expected Duration
1.5 hours

Lesson Objectives
Use Forms in Word 2007
•    Add form controls
•    Match the form type with its proper use
•    Add protection to content controls in a form
•    Protect a form document
Use Fields in Word 2007
•    Create a field
•    Change a field
Use Mail Merge features in Word 2007
•    Create a form letter using mail merge
•    Print envelopes or labels

Click here to check class availability on the registration page.