|
|
Excel 2007/2010 Introduction
- Basic Workbook Skills: entering text, numbers, saving
- Working with Ranges: Selecting, auto fill feature
- Creating Simple Formulas
- Copying and Moving
- Data
- Printing
- Using Page Set-up: Margins, centering, orientation, paper size, repeating rows and labels, page breaks, print area, headers and footers
- Formatting numbers: Accounting, percent, comma styles
- Formatting Text: Font, size, color, alignment, rotation, indentation
- Working with Columns and Rows: Selecting, tooltips, width, height, automatic adjustment, inserting a column or row, hiding a column or row
- Formatting cells
- Using Automatic Formatting and Styles
|
Excel 2007/2010 Intermediate
- Using Large Worksheets
- Working with Multiple Worksheets
- Managing Worksheets
- Using Range Names
- Using Functions: Financial, logical, date
- Managing Data: Sorting, finding, replacing
- Using AutoFilter
- Managing Files: Views, document recovery pane, PDF format, compatibility checker converting
- Creating and Formatting Charts
- Drawing an Object
- Using Additional Effects and Objects
- Using Shapes and SmartArt
- Using HTML Files
- Working with Comments
|
| |
|
Excel 2007/2010 Advanced I
- Working with Tables
- Working with Advanced Filters
- Exporting and Importing Data
- Working with Outlines
- Using Advanced Charting Features
- Using Conditional and Custom Formats
- Using Templates
- Using Paste Special
- Excel Preferences
- Worksheet Protection
- Using Multiple Workbooks
- Sharing Workbooks
|
Excel 2007/2010 Advanced II
- Working with Data Series
- Using Advanced Functions: VLOOKUP, HLOOKUP, IF, ISERROR, nested IF, IF AND, IF OR, ROUND
- Creating and Revising PivotTables
- Scenarios and Goal Seeking
- Data Tables
- Consolidating Worksheets
- Solving Problems
- Auditing Tools
- Using Macros: recording, editing
- Macro Buttons
|
|
|
|
Word 2007/2010 Introductory
- Exploring Word: The Word window, new documents, and Word help
- Navigation and selection techniques: Document navigation and selection techniques
- Editing text: Working with text, using the Undo and Redo commands, cutting, copying, and pasting text
- Formatting text: Character formatting, tab setting, paragraph formatting, paragraph spacing and indents, and automatic formatting
- Proofing and printing documents: Checking spelling and grammar, using AutoCorrect, finding and replacing text, and printing documents
- Printing: Previewing a document, multiple copies, envelopes and labels
- Sections Breaks: Next page, continuous, odd/even, automatic
- Using Styles: Quick style gallery, style inspector
- Tabs: Tab stops, Leaders tabs, bar tabs
- Using Numbers and Bullets
- Page layout: Headers and footers, margins, and page breaks
|
Word 2007/2010 Intermediate
- Inserting Dates and Symbols, Special characters
- Using Quick Parts: Document property fields, Building Block organizer
- AutoFormat: As you type and AutoFormat options
- Tables: Navigating, entering text, gridlines, Quick tables
- Editing tables: Components, merging cells, rotating text, table properties
- Borders and Shading: Apply to text, pages, tables
- Drawing Objects: Creating and moving an object, drawing canvas, fill colors, 3-d effects, laying objects and text
- Inserting Graphics: Clip art, pictures, WordArt, watermarks
- Using SmartArt: Colors and graphic styles • Creating Charts: Chart types, inserting from Excel
- AutoCorrect
- Find and Replace
- Research Task Pane
- Templates
- Newsletter-Style Columns
- Outlines
- HTML Features
- Comments and Revisions
- Managing files
|
Word 2007/2010 Advanced
- Mail merge: Form letters, data sources for the recipient list, and mailing labels and envelopes
- Tables: Sorting, formulas
- Working with lists
- Macros: Recording and running macros, and modifying and deleting macros
- Protecting Documents
- Forms: Form fields, form protection, and sharing and securing documents
- Table of Contents
- Creating an Index
- Creating Captions
- Creating Citations and Bibliography
- Creating a Table of Authorities
- Bookmarks
- Footnotes and Endnotes
- Toolbar and Keyboard customization: Customizing the Quick Access toolbar, and customizing keyboard shortcuts
- Long documents: Master documents, tables of contents and figures, indexes, bibliographies, and other references, bookmark and cross-references, and Web frames
|
PowerPoint 2010 Introductory
- The PowerPoint window
- Getting Help
- Creating presentations
- Saving presentations
- Rearranging and deleting slides
- Using slides from other presentation
- Formatting text
- Modifying text
- Formatting paragraphs
- Adding shapes
- Modifying objects
- Using text in objects
- WordArt
- Pictures
- Clip art
- Tables
- Charts
- Diagrams
- Templates and themes
- Slide masters
- Transitions and timings
- Speaker notes
- Slide shows
- Proofing presentations
- Running presentations
- Printing presentations
|
| |
|
PowerPoint 2010 Advanced
- Application settings
- The Ribbon
- Custom themes
- Clip art
- Media clips
- Animations
- Photo albums
- Customizing SmartArt graphics
- Customizing tables
- Working with Chart tools
- Interactive elements
- Custom slide shows
- Equations
- Using comments
- Finishing a presentation
- Distributing presentations
- Broadcasting a slide show online
- Building slides from Word outlines
- Embedding and linking contents
- Working with hyperlinks
|
Access 2007/2010 Introduction
- Exploring Access: Office button, Ribbon, Contextual tabs, Quick access toolbar
- Creating Tables: Designing, datasheet view, field names, data types, field descriptions, primary key
- Working with Tables: Navigating, adding records, selecting records, editing records, saving records, deleting records, total rows in a table
- Editing Tables: Row height, column width, font attributes, cell effects, background colors, moving a column, freezing a column
- Finding and Filtering Data: Sorting records, finding specific records, filter by selection, filter excluding selection, search box, quick filter, AutoFilter
- Printing Data: Page setup, print preview, printing selected records
- Creating Relationships: Related tables, referential integrity, sub datasheets, join lines Simple Queries: Query wizard, design view
- Modifying Query results: Criteria, totals, printing
- Analyzing Tables: Relationships, performance
- Creating Basic Forms: Form button, calendar
- Creating Basic Reports: Report wizard, views, grouping and summarizing
|
| |
|
Access 2007/2010 Intermediate
- Modifying Tables: inserting columns, lookup columns, hyperlink columns
- Setting Field Properties: Size, formats, Yes/No formats, default values, input masks, lookup list
- Using Operators in Queries: Comparison operators, and condition, or condition, between and operator, expression builder, wildcard characters
- Designing Advanced Queries: Top values, calculated fields, total rows, function query, parameter query, concatenation query
- Creating Action Queries: Make-table query, update query, append query, delete query Using Advanced Query Wizards: Crosstab, find duplicates, find unmatched
- Using Advanced Database Features: Importing data, linking data, exporting data, converting files
- Using Controls and Layouts: Control layouts, stacked layout, tabular layout
- Manipulating Form Controls in Design View: Selecting, sizing, setting control margins and padding, snap to grid features
- Using Design View: Adding labels, images, rectangles, lines, controls
- Using Advanced Form Design: Creating combo box, list items, options groups, logic control, tab order, form header and footer
- Using Editing tools: Changing font, size color, format painter, AutoFormat, spelling checker
- Using Advanced Report Design: Report sections, calculated controls, running summary, date/time control, page break, report margins, label wizard
|
Access 2007/2010 Advanced
- Using Charts: Microsoft graph, chart types, data labels
- Using SubForms/SubReports
- Using Other Form Techniques: Split form, command button, saving a form as a report
- Using PivotTables and PivotCharts: creating
- Working with Indexes
- Using Access and the Internet
- Using Access Database Security
- Creating Macros
- Using Macros
- Customizing the Navigation Pane
- Collecting Data by E-Mail
- Exporting Data
|
|
|
| The Business of Listening |
|
|
| |
Objectives: |
|
Part 1: |
| • |
Learn how and why of active listening |
• |
Why Should You Listen? |
| • |
Discover the results of good listening |
• |
What’s in It for You? |
| • |
Improve his or her listening skills |
• |
What’s in it for Your Organization? |
| |
|
• |
What Do You Know About Listening? |
| |
|
• |
The Joy of Small Change |
| |
|
|
|
| |
Part 2: |
|
Part 3: |
| • |
How to Be a Good Listener |
• |
Your Listening Style |
| • |
Four Key Elements of Good Listening |
• |
You Are Unique |
| |
Key Element 1: Hear the Message |
• |
The Promoting Style |
| |
Key Element 2: Interpret the Message |
• |
The Supporting Style |
| |
Key element 3: Evaluate the Message |
• |
The Directive Style |
| |
Key Element 4: Respond to the Message |
• |
The Analytical Style |
| |
Review Lab for Key Elements 1-4 |
|
|
| |
|
|
|
| |
Part 4: |
|
Part 5: |
| • |
What’s Your Listening Attitude? |
• |
Listening Louder |
| • |
A Listening Attitude: Your Key to Success |
• |
Ten Tips to Tip-Top Listening |
| • |
Barriers to Communication |
|
Tip 1: Take Notes |
| • |
Bridges to Communication |
|
Tip 2: Listen Now, Report Later |
| • |
How well Do You Listen? |
|
Tip 3: Want to Listen |
| • |
How to Stomp Bad Listening Habits |
|
Tip 4: Be Present |
| • |
How to Help Someone Listen to You |
|
Tip 5: Anticipate Excellence |
| |
|
|
Tip 6: Become a “Whole Body” Listener |
| |
|
|
Tip 7: Build Rapport by Pacing the Speaker |
| • |
Summary |
|
Tip 8: Control Your Emotional “Hot-buttons” |
| • |
Points to Remember |
|
Tip 9: Control Distractions |
| • |
Develop a Personal Action Plan |
|
Tip 10: Listening Is a Gift, Give Generously |
|
| |
|
| Customer Service |
| • |
The importance of the customer |
| • |
Winning customer loyalty |
| • |
Eliminate customer turn-offs |
| • |
Exceeding customer expectations |
| • |
Seven diseases of customer services |
| • |
What makes us better |
| • |
Attitude |
| • |
Body language |
| • |
Self-examination |
| • |
Listening ability |
| • |
Knowledge |
| |
|
|
| Business Ethics |
| • |
Business Ethics |
| • |
Basics of business ethics |
| • |
Making ethical decisions |
| • |
Whistle-blowing criteria and risks |
| • |
Ethical management |
| • |
Subordinates' ethical issues |
| • |
Recognizing unethical behavior |
| • |
Ending unethical behavior |
| • |
Organizational ethics basics |
| • |
Ethical principles |
| • |
Ethical safeguards |
| • |
Corporate social responsibilities |
| |
|
|
| |
|
| Business Etiquette & Professionalism |
| • |
Cubicle and office etiquette |
| • |
Ethical dilemmas |
| • |
Personal issues in the workplace |
| • |
Introductions |
| • |
Conversations |
| • |
Etiquette in meetings |
| • |
Telephone courtesy |
| • |
E-mail etiquette |
| • |
Writing guidelines |
| • |
Attending business |
| |
|
|
| E-Mail Etiquette |
| • |
E-mail characteristics |
| • |
When to use e-mail |
| • |
Writing an e-mail message |
| • |
Company policies |
| • |
Copyright laws, viruses, and liability |
| • |
Securing e-mail |
| • |
Message headers |
| • |
E-mail message body |
| • |
E-mail recipients |
| • |
Message management |
| • |
Netiquette style |
| • |
Emoticons and abbreviations |
| • |
Online communication |
| • |
Language and punctuation |
| |
|
|
| |
|
| Organizational Skills |
| • |
Managing information |
| • |
The INFO process |
| • |
Managing written information |
| • |
Managing oral information |
| • |
Managing electronic information |
| • |
Managing your memory |
| • |
Fundamentals |
| • |
Modes of sending information |
| • |
Time management |
| • |
Time management problems |
| • |
Getting organized |
| • |
Planning and prioritizing |
| • |
Procrastination |
| • |
Interpersonal communication |
| • |
Office interruptions |
| • |
Effective delegation |
| • |
Managing team time |
| • |
Team communication and planning |
| • |
Effective use of time |
| |
|
|
| Time Management |
| • |
Understanding benefits of time |
| • |
Understanding different personality types |
| • |
Assessing yourself |
| • |
Pricing time |
| • |
Creating a time audit |
| • |
Using Pareto Principle |
| • |
Making a to-do list |
| • |
Identifying goals |
| • |
Setting priorities |
| • |
Identifying time management plan |
| • |
Creating a time management plan |
| • |
Planning obstacles |
| • |
Identifying steps to plan a day |
| • |
Using guidelines to plan a day |
| • |
Technology |
| • |
Time wastage |
| • |
Importance of productivity |
| • |
Personal time wasters |
| • |
Saying "No" |
| • |
Causes of information overload |
| • |
Screening |
| • |
Create files and organize the office |
| • |
Communication |
| |
|
|
| |
|
| Keyboarding A to Z |
| • |
Getting started |
| • |
The keyboard |
| • |
Five key phrases |
| • |
Words & sentences |
| • |
Using the correct fingering |
| • |
Capitalization |
| • |
The number row |
| • |
Punctuation |
| • |
The numeric keypad |
| • |
Improving speed & accuracy |
| • |
Speed drills |
| |
|
|
| Job Search that Works |
| • |
A proven 10 step program |
| • |
Step 1: Job search – It can be easier |
| • |
Step 2: What you need to know |
| • |
Step 3: Skills statement – Opening the door |
| • |
Step 4: Resume – To an employer it's you |
| • |
Step 5: Applications – Filling in the blanks |
| • |
Step 6: Contacting employers – Who and how |
| • |
Step 7: Calls, calls & more calls |
| • |
Step 8: Ready, set, interview |
| • |
Step 9: The interview – Making it work |
| • |
Step 10: Follow up – Forget me not |
| |
|
|
| |
|
| Your First Thirty Days on the Job |
| • |
Positive mindset |
| • |
What to expect |
| • |
Learning the ropes |
| • |
Be a team player |
| • |
Understanding productivity |
| • |
Getting ready checklist |
| • |
Wardrobe & grooming |
| • |
Adjustments |
| • |
Remembering names |
| • |
Telephone tips |
| • |
Quality awareness |
| • |
Improving work habits |
| • |
Coping with skill deficiencies |
| • |
Improving your job skills |
| • |
How to handle embarrassing moments |
| • |
Your communication style |
| • |
Productivity |
| • |
Absenteeism |
| • |
The three C's of office politics |
| • |
Avoiding personal job stress |
| • |
Human relations |
| • |
Consolidating your gains |
| • |
Create a plan for the future |
| • |
Validate the content of your new job |
| |
|
|
| Designing Resumes |
| • |
New challenges in the work world |
| • |
Ten trends affecting jobs |
| • |
Change-Readiness: an adaptive skill |
| • |
Managing your career |
| • |
Resumes in perspective |
| • |
Strategic resumes for competitive edge |
| • |
Define your objective |
| • |
Assess your marketability |
| • |
Select your format |
| • |
Build your base |
| • |
Develop your draft |
| • |
Refine the quality |
| • |
Package with care |
| • |
Run a quality check |
| • |
Strategic job seeking |
| • |
Emphasis on networking |
| • |
Theories on timing |
| • |
Value-adding letters |
| • |
Resume samples |
| |
|
|
| |
|
| Preparing for Your Interview |
| • |
Types of Interviews |
| • |
Research |
| • |
Setting up the interview |
| • |
Who are recruiters |
| • |
Interviewing techniques |
| • |
Body language and dress |
| • |
Negotiating salary |
| • |
Negotiating benefits |
| |
|
|
| Attitude |
| • |
Positive attitude |
| • |
Personality and attitude |
| • |
Attitude adjustments |
| • |
Give your positive attitude to others |
| • |
Look better to yourself |
| • |
Accept the physical connection |
| • |
Attitude and your job |
| • |
Attitude and the work environment |
| • |
The new co-worker mix |
| • |
Attitude and career success |
| • |
Team leadership |
| |
|
|
| |
|
| Telephone Skills from A to Z |
| • |
Be friendly before you know who it is |
| • |
Buffer words |
| • |
Bureaucratic bounce |
| • |
Call centers |
| • |
Cellular phones |
| • |
Company jargon |
| • |
Controlling the conversation |
| • |
Emotional leakage |
| • |
Five forbidden phrases |
| • |
Foreign accents |
| • |
Getting a phone number |
| • |
Internal calls |
| |
|
|
|
| |
|
|
|