Microsoft Office 2002, 2003, 2007 and 2010 Half-Day Computer Training Descriptions and Registration Information

(1)

Microsoft Office 2002, 2003, 2007 and 2010

Half-Day Computer Training Descriptions

and Registration Information

Office of Human Resources

Training and Organizational Development

240-777-5116

(2)

Microsoft Office 2007 and 2010

A

CCESS

2007

–

F

ORMS

:

D

ESIGN

,

E

DIT

&

F

ILL

-O

UT

(3

H

OURS

)

Description

Access users may be working on a database that they did not design, but want to develop new forms. This class starts with creating a basic form and then building on the basic form by adding controls to the data fields and controlling the overall layout of the form.

Prerequisites

This course is not for the novice user! You should be comfortable in the Access database application and able to use basic features like the navigation pane and design views. Students should have attended an introduction class or have equivalent knowledge.

Objectives

At the completion of this course, participants will be able to perform the following tasks:

CREATING BASIC FORMS

 Using Forms, Using the Form Button  Adding a Record using a Form  Using the Calendar for Date Picking

 Using the Form Wizard, Viewing Records in a Form  Printing Records in a Form, Basing a Form on a Query

USING CONTROLS AND LAYOUTS  Switching Views, Using Controls

 Using Control Layouts, Using a Stacked Layout

 Using a Tabular Layout, Removing a Control from a Layout  Moving Controls, Viewing the Properties of an Object  Changing a Control Property

MANIPULATING FORM CONTROLS IN DESIGN VIEW

 Selecting Non-adjacent Controls, Selecting Adjacent Controls  Deleting Controls

 Sizing a Control by Dragging, Sizing Controls Automatically  Setting Control Margins

 Setting Control Padding  Hiding the Ruler

 Disabling the Snap to Grid Feature  Displaying the Field List

 Adding a Field

 Adding a Field from Another Table  Moving Part of a Paired Control  Aligning Controls

(3)

 Spacing Controls

E

XCEL

2007/2010

–

D

ATA

&

L

IST

M

ANAGEMENT

(3

H

OURS

)

Description

Begin with learning basic formulas and progress to Advanced Functions. Learn to use the Lookup functions which allow you to refer to a particular range of data that might be located in various worksheets. Learn about using the IF function and then incorporating the operators AND and OR. The functions will further allow you to view the data results you wish to achieve.

Analyze your data by learning how to create and modify Pivot Tables. This is a great Excel feature and will allow you to look at your data many different ways – without having to touch the original data source. Turn your Pivot Table into a chart for visual clarity.

Students practice Exporting and Importing data into various locations and consolidating multiple cells into one cell for a result.

Prerequisites

Students should be comfortable with using a Mouse and Windows. This is an Advanced level Excel class. Attendees should have attended an introduction and intermediate level course or have equivalent experience.

Next Steps

Attendees will benefit from taking Access 2007 Introduction and some of the other Office courses.

Objectives

USING ADVANCED FUNCTIONS

 Using Lookup Functions, Using the VLOOKUP Function  Using the HLOOKUP Function, Using the IF Function  Using Nested IF Functions, Using the ISERROR Function  Using an AND Condition with IF, Using an OR Condition with IF  Using the ROUND Function, Limiting the Precision of Numbers

CREATING/REVISING PIVOTTABLES

 Creating a PivotTable Report , Adding PivotTable Report Fields  Selecting a Report Filter Field Item , Refreshing a PivotTable Report

 Changing the Summary Function , Adding New Fields to a PivotTable Report  Moving PivotTable Report Fields, Using Expand and Collapse Buttons  Hiding/Unhiding PivotTable Report Items, Deleting PivotTable Report Fields  Creating Report Filter Pages, Formatting a PivotTable Report

 Creating a PivotChart Report, Publishing PivotTable Reports to the Web

EXPORTING AND IMPORTING DATA

 Exporting Data to Other Applications, Importing Data from Access  Importing Data from Text Files, Changing External Data Range Properties  Importing Data from Other Applications, Removing the Query Definition  Importing Dynamic Data from the Web, Copying a Table from a Web Page

WORKING WITH OUTLINES  Applying an Outline

 Collapsing/Expanding an Outline  Modifying Outline Settings  Using Auto Outline  Clearing an Outline  Creating Subtotals in a List

(4)

 Removing Subtotals from a List

E

XCEL

2007/2010–

F

ORMULAS AND

F

UNCTIONS

C

RASH

C

OURSE

(½

D

AY

)

Description

Functions and formulas automate many of the calculations performed in Excel. This course will teach students the basics of creating simple formulas and shortcuts to make calculations faster. Learn to use functions to calculate with dates and lookup information that may be stored in other worksheets. Create formula’s where you use an IF function to answer a True or False question. .

Next Steps

This is the one course in the Excel Workshop series. Students will benefit from taking any additionally offered Excel 2007 workshops such as Excel 2007 – Power Charts

Prerequisites

This course is not for the novice user! You should be comfortable in the Windows environment and able to use Windows to manage information on your computer. Additionally, students should have either taken or have equivalent knowledge of:

• Excel 2007 Introduction (1 or 2 Days)

Objectives

CREATING SIMPLE FORMULAS  Using Formulas

 Entering Formulas  Using Functions

 Using the AutoSum Button  Using the AutoSum List  Entering Basic Functions  Inserting Functions in Formulas  Editing Functions

 Using the AutoCalculate Feature

 Using Range Borders to Modify Formulas  Checking Errors

WORKING WITH LABELS IN FORMULAS  Using Labels in Formulas

 Using Labels to Define a Range  Using Multiple Stacked Headings  Referring to Individual Cells

USING OTHER FUNCTIONS  Using Function Arguments  Using Financial Functions  Using Logical Functions  Using Date Functions  Formatting Dates  Revising Formulas

USING ADVANCED FUNCTIONS  Using Lookup Functions  Using the VLOOKUP Function  Using the HLOOKUP Function  Using the IF Function

(5)

 Using Nested IF Functions

E

XCEL

2007/2010

W

ORKSHOP

–

P

OWER

C

HARTS

(3

H

OURS

)

Description

It’s not enough to just know how to make a chart – it needs to look good too! This class gets you started with the basics and how to best layout your data for effective charts. You’ll learn all different types of formatting techniques and ways to enhance the chart to make it pop! Our instructor will show you how to insert your chart into a document or slide.

Next Steps

This is the last course in this series. However, students will benefit from taking any additionally offered courses such as Excel 2007/2010 – Building Reports for the Office Environment.

Prerequisites

This course is not for the novice user! You should be comfortable in the Windows environment and able to use Windows to manage information on your computer. Additionally, students are to have either taken or have equivalent knowledge of:

• Excel 2007 Introduction (1 or 2 Days)

Objectives

CREATING CHARTS  Using Charts

 Creating Charts with the Chart Wizard  Moving and Resizing Charts

 Identifying Chart Objects  Changing the Chart Type

 Changing the Chart Type and Sub-type  Changing the Plot Direction

 Removing/Adding a Legend  Moving the Legend

 Charting Non-adjacent Ranges  Changing the Chart Range  Changing the Data Source  Changing the Chart Location  Printing a Chart

FORMATTING CHARTS  Formatting Charts  Adding Chart Titles  Formatting Chart Objects  Changing the Text Orientation  Adding a Data Table

 Creating an Exploded Pie Chart  Adjusting the 3-D View  Deleting a Chart

EDITING CHARTS MODIFYING CHARTS ADVANCED CHARTING

(6)

E

XCEL

2007/2010:

W

ORKSHEETS

(3

H

OURS

)

Description

Students begin with creating simple worksheet tasks and move into calculating formulas between multiple worksheets. Learn tips for working with many worksheets at one time. Attendees will also learn the benefits of using Freeze Panes to display top rows of data while scrolling down into your worksheet. Apply worksheet protection to your worksheets and control how your worksheets are edited.

Prerequisites

Students should have attended an introductory level Excel or had equivalent experience with the application.

Next Steps

Students should consider taking the Excel 2007/2010 Advanced class.

Objectives

MANAGING WORKSHEETS  Copying Worksheets  Moving Worksheets  Using Grouped Worksheets  Moving Data between Worksheets  Copying Data between Worksheets  Creating 3-D Formulas

 Using 3-D Ranges in Functions

WORKING WITH MULTIPLE WORKSHEETS  Use multiple worksheets

 Navigate between worksheets  Select worksheets

 Rename worksheets  Select multiple worksheets  Color worksheet tabs  Insert worksheets  Delete worksheets  Print selected worksheets

USING LARGE WORKSHEETS  Increase the magnification  Decrease the magnification

 Change the magnification of a range  Switch to Full Screen view

 Split the window  Remove split windows  Freeze Panes

 Unfreeze the panes

USING WORKSHEET PROTECTION  Unlock cells in a worksheet  Protect a worksheet  Unprotect a worksheet  Create allow-editing ranges  Delete allow-editing ranges  Protect workbook windows

(7)

O

FFICE

2007/2010

O

VERVIEW WITH

TIPS

AND

TRICKS

N

EW

F

EATURES

(1/2

DAY

)

Description

This class focuses on new and enhanced features of Outlook, Excel & Word 2010. Students will set up Outlook to display messages and folders in a preferred layout. See how search folders can find keywords in messages and how you are notified and the new desktop alert feature when you have new mail.

Students will learn about new and enhanced features in Excel including new filtering capabilities, Sparklines which are mini charts, conditional formatting and how to save a file as a PDF.

The Word portion will focus on using a variety of galleries with Styles and Tables, to name a few. Use Live Preview to see how your formatting changes appear before actually applying changes. Learn how to customize your word options and create your own customized Tab/Ribbon.

Prerequisites

Students should be comfortable with using a Mouse and Windows. This is an upgraded course and students should have previous experience using Word, Excel and Outlook.

Next Steps

Attendees will benefit from taking PowerPoint 2010 Overview and some of the other Office courses.

Objectives

OUTLOOK 2010 EXPLORING OUTLOOK

 Use the Outlook interface  Use Tabs and Ribbons  Use the Navigation pane  Customize the Navigation pane  Use the Folder list

 Use the File Tab

 Use the Quick Access Toolbar  Use the To-Do Bar

 Use the Outlook Today Page SENDING AND RECEIVING MESSAGES

 Use a Desktop Alert to open a message  Change the Reading Pane layout  Use the Unread Mail Search Folder EXCEL 2010

MANAGING FILES

 Changing Workbook Properties  Inspecting a Document

 Saving to a PDF Format

 Using the Compatibility Checker  Converting a File to 2010 Format USING SPARKLINES

(8)

 Working with Sparklines  Formatting a Sparkline USING CONDITIONAL FORMATTING

 Applying Conditional Formats  Using Data Bars

 Deleting a Conditional Format WORD 2010

WORKING WITH DOCUMENT VIEWS  Changing Document Magnification  Displaying/Hiding the Rulers

 Viewing/Hiding the Formatting Marks  Comparing Side by Side Documents  Using Synchronous Scrolling CUSTOMIZING WORD OPTIONS

 Changing the Default Font Attributes  Changing the Default Page Settings  Setting Word Options

 Customizing the Quick Access Toolbar  Creating a Custom Tab/Ribbon

USING STYLES

 Using the Quick Styles Gallery  Creating a Style

 Adding a Style to the Quick Styles Gallery WORKING WITH TABLES

 Creating a Table  Using Table Styles

 Hiding and Showing Gridlines USING THE NAVIGATION PANE

 Use the Navigation Pane to Search a Document  Using Advanced Find

(9)

O

UTLOOK

2007/2010

C

ALENDAR

M

ANAGEMENT

:

Y

OURS

,

M

INE

&

O

URS

(3

H

OURS

)

Description

WORKING WITH FOLDERS AND FORMS  Using Folder Properties

 Setting Home Page Properties  Setting Permissions Properties  Accessing Another User's Folder  Opening a Folder in its Own Window  Setting Up Public Folders

 Posting a Discussion Item to a Folder

Prerequisites

Students should be comfortable with using a Mouse and navigating in Windows.

Next Steps

Attendees will benefit from taking Outlook Advanced and some of the other Office courses.

Objectives

SCHEDULING WITH THE CALENDAR

 Using the Calendar Pane, Navigating the Calendar  Scheduling a New Appointment, Scheduling an Event  Working with the Daily Task List, Editing Calendar Items  Using Calendar Views, Setting a Calendar Item as Recurring  Moving Calendar Items, Viewing Side by Side Calendars

 Using Calendar Overlay Mode, E-mailing your Calendar as a Snapshot  Viewing a Calendar Snapshot, Printing Calendar Information

 Deleting Calendar Items, Scheduling with the Calendar

MANAGING MEETINGS

 Scheduling a Meeting, Scheduling a Resource for a Meeting

 Accepting/Declining Meeting Requests, Proposing a New Meeting Time  Responding to a New Time Proposal, Tracking Meeting Responses  Updating a Meeting, Canceling a Meeting

 Creating Group Calendars, Managing Meetings

SETTING OTHER OUTLOOK OPTIONS

 Customizing the Outlook Today Page, Using the Notification Area Menu  Setting Calendar Options, Setting Tasks Options

 Setting Notes Options, Setting General Options  Setting Reminder Options, Setting Spelling Options  Setting Delegates Options, Setting Manage Forms Options

WORKING WITH FOLDERS AND FORMS

 Using Folder Properties, Setting Home Page Properties

 Setting Permissions Properties, Accessing Another User's Folder  Opening a Folder in its Own Window, Setting Up Public Folders  Posting a Discussion Item to a Folder

WORKING WITH RULES  Using Rules

(10)

T

IME

M

ANAGEMENT

U

SING

O

UTLOOK

/2007/2010

(1/2

D

AY

)

Description

Take command of your time by leveraging Outlook’s time management tools. This powerful

application is typically underutilized and students will find that Outlook can be used to organize many more aspects of their day than just e-mail.

The day starts by challenging students to consider how they current spend and organize their time. Time is spent thinking about every day time wasters and getting a handle on managing commitments and obligations.

Students will learn to use the Outlook Calendar and Task features to stay organized. This class focuses on the features within Outlook that will have the most immediate impact on your time.

Prerequisites

Attendees should be Windows users and comfortable with using a mouse. This is not a basic course; students should have experience using Outlook before attending.

Next Steps

Students may wish to take some of the other Outlook seminars that OFFICEPRO offers such as, Scheduling Meetings with Outlook or Email Management.

Objectives

PRACTICAL TIME MANAGEMENT -CONCEPTS &TOOLS  Time Stress Hurts All Of Us

 Benefits of Better Time Utilization  Definition of Time Management  Self-Assessment

 Save Up To 10 Hours A Week  Pricing Your Time

 Planning Your Time

 Who/ What Controls Your Time

 What Are You Responsible For Accomplishing  5 Tips For Effective Time Management  Setting Objectives and Priorities  Steps for Planning Your Day

 Delegation – Working Through Others  Why Do People Fail To Delegate  How to Delegate

 Planning – Key To Achievement  Coping With Common Time Wasters  Applying What You’ve Learned  Resources for Time Management

SCHEDULING WITH THE CALENDAR  Using the Calendar Pane  Navigating the Calendar  Scheduling a New Appointment  Scheduling an Event and more topics….

WORKING WITH TASKS AND THE TO DO BAR  Using the Tasks Pane

 Adding a Task

(11)

P

OWER

P

OINT

2007:

D

ESIGNING

S

LIDES

(3

H

OURS

)

Description

This course is focused on making your slides clean, crisp and elegant. So often, presentations are given with text and bullets and the presenter reading from the screen. Create beautiful slides that have impact and will leave your audience remembering what was said by the image you used to relay this message. Learn to avoid Death by PowerPoint and instead make the most of your presentation time with relevant content.

Prerequisites

This class is an intermediate level PowerPoint class. Students should have attended an introductory level training or have equivalent experience.

Next Steps

This is the last course in this series although students would benefit from taking other courses offered by OFFICEPRO like Adobe InDesign.

Objectives

PLANNING THE DESIGN  The Written Process  Brainstorming Images  Using Quotes

 Applying SmartArt

 Using Fonts, Text and Color Rules  Template Designs

 Projectors

EDITING PRESENTATION MASTERS  Working with the Slide Master  Formatting the Slide Master

 Adding Header and Footer Information  Formatting the Title Master

 Inserting a New Slide Master  Inserting a New Design Master  Applying Multiple Masters  Preserving a Slide Master

 Changing a Font for a Presentation

CUSTOMIZING PRESENTATIONS

 Working with Custom Presentations  Applying a Color Scheme

 Customizing a Color Scheme  Applying a Scheme to All Slides  Customizing the Slide Background  Saving a Custom Template  Deleting a Custom Template  Applying an Existing Template

USING TABLES FOR LAYOUT  Inserting a Word Table  Entering Data into Table Cells

(12)

W

ORD

2007/2010

W

ORKSHOP

–

M

AIL

M

ERGE

(½

D

AY

)

Description

Students enrolling in this course will learn the mail merge features using Microsoft Word 2007. After taking this course, students will be able to create and edit mail merge documents and data sources.

Next Steps

This is the only course in this series, however, students will benefit from taking any additionally offered Word 2007/2010 workshops such as Word 2007/2010 Workshop – Long Documents.

Prerequisites

Students should have taken the following class, or have an equivalent knowledge level:

• Introduction to MS Word 2007

Objectives

USING MAIL MERGE

 Working with Mail Merge  Starting Mail Merge

 Identifying the Main Document  Creating a Data Source

 Adding Fields to a Data Source  Removing Fields from a Data Source  Rearranging Fields in a Data Source  Saving a Data Source

 Entering Records into a Data Source  Setting View Options for Merging  Inserting Merge Fields into a Document  Previewing Merged Data

 Merging to a New Document  Sorting Records to be Merged  Merging to the Printer  Using Mail Merge

MERGING MAILING LABELS AND DIRECTORIES  Using Mailing Labels

 Creating Mailing Labels  Selecting Label Options  Attaching a Data Source  Inserting Label Merge Fields  Merging Labels to a New Document  Merging with an Outlook Data Source  Merging Mailing Labels and Directories

SORTING TABLE DATA

 Designing a Table to be Sorted  Sorting a Table Alphabetically  Sorting a Table Numerically  Sorting a Table by Date

 Sorting a Table by Multiple Columns  Sorting Table Data

(13)

W

ORD

2007/2010:

F

INISHING

T

OUCHES

(3

H

OURS

)

Description

This class focuses on some of the final elements of a document. We will show you the details around creating a Table of Contents and how to apply the formatting to make it show up in outline form. Students will enjoy learning how to create an index for reference in your files. There are different settings to apply to have your marked items indexed and also cross references. Do you need a footnote or an endnote? What if they need formatting? We can show you how to use this feature so your notes are working as expected. This targeted class is focused on these tasks specifically.

Prerequisites

This class is for Intermediate to Advanced level Word users. Students should have attended an introductory level class or have equivalent experience.

Next Steps

Students will benefit from taking any additionally offered Office 2007 workshops such as Word 2007 Use a Table for That! or Excel 2007 Data and List Management.

Objectives

CREATING A TABLE OF CONTENTS  Use a table of contents  Generate a table of contents  Remove a table of contents  Use custom styles

 View the TOC field code  Update a table of contents  Insert TC field codes  Use TC fields  Use outline levels

CREATING AN INDEX  Use an index

 Create main index entries  Create index subentries  Type index entries

 Cross-reference index entries  Generate an index

 View the INDEX field code  Update an index

USING FOOTNOTES AND ENDNOTES  Use notes

 Insert notes  Set note options  View notes  Browse notes  Move and copy notes  Delete a note

(14)

Microsoft Office 2003

Access 2003 Fundamentals -Working with Tables, Forms, Reports, and Simple Queries*

Course Description

The Access 2003 Fundamentals class will provide participants with the basic skills needed to

plan, create, design, and use Access 2003 databases, tables, forms, and simple queries. The

course will offer instruction in the fundamentals of using the Access design views and tools and

the Access AutoReport, AutoForm, and Query Wizards. Participants will learn how to delete,

add, and insert new records in tables and forms, apply conditions in the QueryByExample grid

and create and print reports and queries.

Topic Covered

Topics covered will include:



Basic Access database, table, and form design terminology



Methods to save, open, close and edit databases, tables, forms, and queries



Use of techniques to design tables and format and add and delete table and records



Basic table, form, and report design terminology



The use of AutoForm and AutoReport Wizards to create forms and reports



Application of the Report and Form properties menu to create special effects and colors



The use of the Query grid to select fields and criteria to run simple queries

Learning Objectives

After taking this course, the user should be able to:



Plan and design a database and identify the type of data to be stored in tables, forms, and

reports



Create and modify a database, table, form, report, and query



Apply basic techniques to add or delete records in a table, form, and report



Use the AutoForm and AutoReport Wizards to create forms and reports



Use the QueryByExample grid to select fields and apply criteria to product records that

meet specific criteria



Add, delete, and edit data and insert new records using the table and form view



Create, and modify tables, forms, report, and queries in design view

(15)

Excel 2003: Basic Formulas and Spreadsheet Formats Course Description

This course will introduce the use of Excel’s most commonly used formulas (functions) that perform essential calculations - sum, average, minimum, maximum, and count. Participants will be introduced to function “syntax rules” governing the use of all Excel functions and the application of the AutoSum feature. These essential statistical skills will then be followed by an introduction to spreadsheet formatting methods that will enhance the professional look of spreadsheets. The course will cover formatting

methods to enhance the color, size, position, and look of text and numbers. The use of the Excel

AutoFormat Wizard to produce pre-defined combinations of text and number formatting, borders, colors, and shading, the use of the “conditional formatting” feature, and page set up and printing methods will round out this course.

Topic Covered

Topics covered will include:

 Use of the AutoSum, Average, Minimum, and Maximum functions and AutoFormats to enhance the look of spreadsheets

 Moving and copying formulas and use of relative and absolute references in functions  Methods to change the font and size of text and format of numbers

 The use of the Conditional Formatting feature

 The use of the Find and Replace dialog box to search for and replace formats

 Printing and page set-up options to change page orientation, control margins, create headers and footers, and display gridlines in spreadsheet printouts.

Learning Objectives

After taking this course, the user should be able to:

 Enter function arguments in sum, average, minimum, maximum, and count formulas  Move and copy formulas using relative and absolute cell referencing

 Use the Formatting Toolbar and Format Cells dialog box to format text and numbers  Change column width and row height and alignment of text and numbers within a cell  Apply borders around cells and ranges using the border tab in the Format Cells dialog box  Access the Conditional Formatting feature to change the format of a number that meets a specific

cell value

 Use the AutoFormats dialog box to format a spreadsheet or specific cell range

(16)

Excel 2003 Getting Started with Spreadsheets and Charts

Course Description

The class is designed to teach participants the basics used to store, organize, manipulate, and

illustrate data in Excel spreadsheets. The class will cover the essential skills needed to create a

basic Excel spreadsheet and simple chart. The course will include instruction in entering, editing,

and formatting labels and numbers. The use of basic formulas and functions to analyze and

manipulate spreadsheet data will be taught to include the application of basic charting techniques

to illustrate spreadsheet data.

Topic Covered

Topics covered will include:



Basic spreadsheet terminology and spreadsheet navigation techniques



Methods to save and open workbooks (files) and spreadsheets



Use of entering, editing, and formatting techniques to insert and delete spreadsheet labels,

numbers, rows, and columns



Techniques used to copy, move, and insert (paste) data in spreadsheets



Manipulation of data using Excel formulas and functions



Basic charting techniques used to illustrate data

Learning Objectives

After taking this course, the user should be able to:



Work comfortably in the Excel environment



Enter, format, and delete labels, numbers, rows, and columns in worksheets



Create and use basic formulas and functions



Copy, paste, move, insert, and delete data



Open and save workbooks and print spreadsheets



Create and print simple Excel charts

(17)

Excel 2003 Pivot Tables and Other Decision Making Functions*

Course Description

The Excel 2002 “Pivot Tables and Other Decision Making Function” class is designed to teach

participants how to use Excel decision-making functions. These functions include the application of Pivot tables to rapidly analyze, manipulate, and graphically display data using the PivotTable Wizard, the PivotChartWizard, and the Pivot Format feature. The creation of range names and their use in other advanced decision making functions will be covered in the course. These advanced functions will include the use of the IF and nested IF formulas, the SUMIF and SubTotal and DataBase functions such as DSUM and DCOUNT, subtotal features, and multivariable data base tables using financial functions. Topic Covered

Topics covered will include:

 Basic pivot table navigation techniques

 Rearranging pivot table data and fields to display different data views and summaries  Application of the Format Report feature to enhance the appearance of the pivot table  Creation and modification of PivotCharts to illustrate pivot table data

 Use of range names in advanced IF and IF nested functions, SUMIF functions, and financial functions and tables

 The structure and use of database DSUM and DCOUNT functions Learning Objectives

After taking this course, the user should be able to:

 Identify and name the field components of a pivot table and pivot chart

 Manipulate pivot table data by rearranging fields, columns, and rows to display different column, row, and page views of data

 Display different data details in the pivot table by hiding and displaying row and column fields and create and modify PivotCharts to illustrate pivot table data

 Use IF and nested IF functions to perform calculations based on multiple decision-making conditions, use of financial functions that rely upon multiple values to reach fiscal determinations and apply database criteria to perform statistical analysis

(18)

PowerPoint Slide Creation, Formatting and Slide Show Presentation

Course Description

The course is designed to teach participants the basics used to create and present a PowerPoint

slide presentation. Participants will learn the basic skills needed to use the PowerPoint menus to

add, edit, delete, format, and rearrange slides. The course will include instruction in the use of

the AutoContent wizard to prepare presentations and enter text and graphics in placeholders.

Instruction will also include the use of styles, slide show formatting and presentation techniques

including running slide show methods involving application of transition special effects and

automated slide presentations.

Topic Covered

Topics covered will include:



Basic PowerPoint terminology and slide navigation techniques to include use of the

PowerPoint Help menu



Methods to save and open Presentations and navigate between slides.



The use of AutoContent, outline, slide sorter, and normal view methods to create

presentations and slides.



Use of entering, editing, and style formatting techniques to enter text and graphics in

slide placeholders



Selecting and setting slide transition effects and slide show presentation methods

Learning Objectives

After taking this course, the user should be able to:



Work comfortably in the PowerPoint environment



Enter, format, and delete Presentations and Slides



Use the AutoContent Wizard to create presentations and slides and the Help menu to

respond to usage questions.



Work in the slide sorter, outline, and normal view to copy, paste, move, insert, and delete

slides and select and apply transition features used in slide show presentations



Run a slideshow and rehearse and set timings for an automated slide show



Use templates to format slides

(19)

HOW TO REGISTER

Employees only – with user name and password*

• Log-in to your Employee Self-Service at this link www.montgomerycountymd.gov/eportal

▬ Select Oracle Self-Service > Learner Self-Service > Learner Home

▬ This will bring you to your personal Learner Home Page

• To Search for a specific class, use the Search window on the top left of the screen. Be sure to

change the criteria from “course” to “class”.

• For additional help, go to the Quick Start Guides on TransformMCG

▬ *If an employee does not have a username and password, should follow instructions under “Partners” below.

Partners

A “Partner” is anyone employed by an organization which partners with MCG, such as HOC, Montgomery College, and MCPS; it also includes MCG temporary employees, contractors, volunteers, and student interns.

All Partners must setup a profile and request access to OLM through AccessMCG in order to register in a class.

 Requesting Access

• Step 1: Get instructions by at the OHR Training Website: Instructions for Non-Employees – How to Request Access to MCG Training Catalogs

• Step 2: Set up a profile through AccessMCG. This is a County-wide app which gives the

public the opportunity to request access to certain County databases.

• Step 3: Request access to the appropriate Catalog through AccessMCG.

▬ MCG currently has three (3) catalogs:

▬ Human Resources, Health and Human Services, and Libraries. Once you have made your request, you will receive an email from OHR advising you that you may now access OLM and register for classes.

▬ If you don’t know which catalog to request, contact the OHR Training Team at [email protected] or call 240-777-5116?  Register for Classes

• Log-in to AccessMCG by clicking this link.

(20)

▬ Select Human Resources Services > County Learning Services > County Learning Area (click the blackboard icon)

▬ This will open up Oracle

 Select MCG External Learner Self-Service > Learner Home  This will bring you to your personal Learner Home Page

• To Search for a specific class, use the Search window on the top left of the screen. Be sure to

change the criteria from “course” to “class”.