ฝึกอบรมหลักสูตร Microsoft Office 2010 ประจำปี 2554

• Windows Operating System
• Hardware/Software
• Turning on your PC/ Logging on
• The Desktop: Document/Original/Application/Folder icons
• Taskbar
• Start Button/Menu
• Mouse Clicks

Introduction to Personal Computing

• Moving/Copying files and folders
• Creating/Renaming/Deleting a file or folder
• Parts of a Window: Bars/Buttons/Scroll Bars
• Resizing/Moving a window
• Opening/Saving a document
• Editing text/Drag and Drop
• How to type in Arabic
• Getting Help/Shutting Down

Getting Started

• What is Microsoft Word?
• Menu Bar

Viewing or Hiding Toolbars

• Shortcut Menus
• Task Pane/Views
• Normal View
• Web Layout View
• Print Layout View
• Outline View/Reading Layout View

Working with Files

• Create New Documents
• Open Existing Documents
• Save Documents
• Rename Document
• Close Documents

Module2

Working with Text

• Type and Insert Text
• Highlight Text
• Delete Text
• Spelling and Grammar

Formatting Text

• Formatting Toolbar
• Move / Cut Tex
• Copy Text/Paste Text
• Undo and Redo Options

• Paragraph Attributes
• Non-printing characters
• Drop Caps

Text Formatting

• Styles and Formatting
• Reveal Formatting

Tables

• Insert Tables
• Draw Tables
• Nested Tables
• Insert Rows and Columns
• Move and Resize Tables
• Moving the order of the column and/or rows inside a
• Table/Table Properties
• Drawing Canvas/Spelling and Grammar

Page Formatting

• Symbols and Special Characters
• Smart Tags and Other Markers
• Keyboard Shortcuts

Module4

Track Changes

• Track Changes in Print Layout View
• User Information
• Viewing the changes

Accepting / Rejecting Changes

Inserting Comments

• Window Splitter
• Compiling a Table of Contents
• Creating an Index
• Saving a Word Document as a Web Page
• Page Margins and Gutter Margins
• Page Margins/Gutter Margins/Indentations

Setting Tabs

• Changing the default tab stops
• Removing Tabs

• Introduction
• How Does the Internet Work?
• What Kinds of Information are Available?
• How Do People Use the Internet?
• The Sum of Many Parts
• A Quick Tour of a Typical Website

Definitions

• Internet Explorer 7

Getting Started

• To launch Internet Explorer
• To turn on the Menu Bar
• Using Internet Explorer 7 Overview
• Tabbed browsing overview
• To change your home page
• To add a new search provider (search engine)
• To remove a search provider (search engine)
• To restore default settings in order to prevent IE7

Crashes

• Loading and Saving Web pages
• To empty the Temporary Internet Files folder (cache)
• To clear the browsing history
• To save a picture from a webpage
• To save a webpage onto your computer
• To open the webpage that you have saved
• To make webpage load without images or sounds

Bookmarks

• To create bookmarks (favorites)
• To view and use bookmarks (favorites)
• To organize your bookmarks (favorites)
• To import bookmarks (favorites) into Internet Explorer 7
• To export bookmarks (favorites) out of Internet
• Explorer 7/List of shortcut keys

• How to Address Other Internet Users
• E-Mail Etiquette

What is Yahoo! Mail?

• Create A Free Email Account Using Yahoo!
• Using your New Email Account
• How to sign in
• Reading messages
• Replying to a Message
• Sending a Message

Making the Most of Your Yahoo! Mail Home Tab

• To view your favorite top news stories
• To use the Calendar Bar
• To set the page you see when you launch Yahoo! Mail

Introducing Yahoo! Messenger

• Installing Yahoo! Messenger
• Launching Yahoo! Messenger and Signing In
• Connecting With Your Friends

What Is the Messenger List?

Using Instant Messaging

• Messaging a Contact
• Messaging a Contact Who Is Not on Your Messenger
• List/Messaging Multiple Contacts

Managing PC to PC Calls

• Setting Up Your Computer
• Initiating a Call
• Receiving a Call

• Screen Layout
• Title bar
• Menu bar/Standard Toolbar/Other Tools
• Task Pane/Adding and Renaming Worksheets

Modifying Worksheets

• Moving Through Cells
• Adding Worksheets, Rows, Columns, and Cells
• Resizing Rows and Columns
• Selecting Cells
• Moving and Copying Cells
• Deleting Rows, Columns, and Cells
• Freeze Panes

Formatting Cells

• Formatting Toolbar
• Format Cells Dialog Box
• Formatting Worksheet
• Dates and Times
• Format Painter
• AutoFormat

Formulas and Functions

• Formulas
• Linking Worksheets

Relative, Absolute, and Mixed

Referencing

• Basic Functions
• AutoSum

Sorting and Filling

• Basic Sorts
• Complex Sorts
• Auto-fill

Comparing Workbooks

• Compare Side by Side

Page Properties and Printing

• Page Breaks/Page Setup
• Margins/Header/Footer

Sheet/Print Preview/Print

• Chart Wizard/Chart toolbar
• Resizing a chart/Moving a chart
• Deleting a chart
• Copying a chart to Microsoft Office file
• Chart Types
• An Overview on Formatting Charts and Cells

Commonly Used Features

• Comments/Use Go To
• Use Find and Replace
• Increase / Decrease Decimals
• Protecting your files (password to open)

Saving Excel files as Web pages

E-mail an Excel File

• To send by e-mail a single Excel worksheet as a message body
• To send by e-mail a single Excel worksheet as an attachment
• To send by e-mail an Excel workbook as an attachment
• To send by e-mail an Excel workbook for review

Additional Readings

• Tab Color
• Hide / Unhide

Appendix 1: Shortcut Keys

Module9

Functions & Formulas Fundamentals

• Formula Definition/Formula Syntax
• Formula Bar/Function Definition
• Function Syntax/Arguments
• Operators/Operator Order
• Function Wizards/Entering Multiple Formulas All At Once
• Editing & Deleting Formulas

Errors in Formulas

Excel Functions Overview

• Statistical Functions Overview
• Math Functions Overview
• Information Functions Overview
• Overview of Logical Functions

Additional Readings

Text to Speech

• Task Pane

Create a new presentation

• AutoContent Wizard / Design Template
• Blank Presentation / Open an Existing Presentation

PowerPoint screen

• Screen Layout / Views
• Normal View / Slide View / Outline View
• Slide Sorter View / Notes View

Working with slides

• Insert a new slide / Notes
• Slide layout / apply a design template
• Reorder Slides / Hide Slides / Hide Slide text

Add content

• Resize a placeholder or text box
• Move a placeholder or text box
• Delete a placeholder or text box
• Placeholder or Text box properties
• Bulleted and numbered lists
• Adding notes

Work with text

• Add text and edit options
• Format text/Copy text formatting
• Replace fonts/Line spacing
• Change case
• Spelling check/Spelling options

Working with tables

• Adding a table/Entering text
• Deleting a table/Changing row width
• Adding a row/column/Deleting a row/column
• Combining cells/Splitting a cell
• Adding color to cells
• To align text vertically in cells
• To change table borders /Graphics
• Add clip art/Add an image from a file

Save & Print

• Saving your work/Page setup/Print

Tips on Creating Better Presentations

• Presentation basics and shortcuts

• Adding a shadow to an object
• Auto Shapes
• Making an object 3-dimensional:
• Inserting symbols/WordArt

Graphs and charts

• Adding a chart

Changing the type of chart

Master slides

• Slide Master
• Headers and Footers
• Slide Numbers/Date and Time
• Protecting a presentation
• Slide animation

Animating Slides

• Animation Preview
• Slide Transitions
• Creating a Photo Album
• Reordering Slides

Creating Presenter’s Notes

• Normal view
• Notes pages
• Adding Action Buttons
• Using the Pen Tool in a Slide Show
• Adding Sound to a Presentation
• Adding a Recorded Sound
• Adding a sound file from a CD
• Adding a sound file from File
• Adding Narration
• Creating a Summary Slide
• Rehearsing a Slide Show
• Saving a Presentation as a Web page

Module12

Displaying the grid

• Working with a presentation in MS Word
• Adding a comment/E-mail a presentation
• More into other Masters/Cropping pictures
• Editing images/Image control
• Creating a hyperlink
• Creating a custom slide show
• Set up a slide show
• PowerPoint shortcuts

• Identify the Elements of the User Interface
• Customize the Excel Interface
• Work with Cells
• Enter Data in an Excel Workbook
• Obtain Help in Excel

Module 2: Performing Calculations in an Excel Worksheet

• Create Basic Formulas
• Calculate the Cell Values by Using Functions
• Copy Formulas and Functions

Module 3: Modifying an Excel Worksheet

• Manipulate Data
• Modify the Worksheet Elements
• Search for Data in a Worksheet
• Modify Rows and Columns

• Modify Fonts
• Check a Worksheet for Spelling Errors
• Apply Number Formatting
• Add Borders and Colors to Cells
• Align the Content in a Cell
• Apply Cell Styles

Module 5: Printing Excel Workbooks

• Set the Page Layout Options
• Set Page Breaks
• Print a Workbook

Module 6: Managing an Excel Workbook

• Format Worksheet Tabs
• Manage Worksheets
• View Worksheets and Workbooks

• Apply Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

Module 8: Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Use Functions to Calculate Data in a Table or Worksheet

Module 9: Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

• Create a PivotTable Report
• Filter Data Using Slicers
• Analyze Data Using PivotCharts

Module 11: Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Module 12: Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook’s Properties

Module 14: Collaborating with Others

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Module 15: Auditing Worksheets

• Trace Cells
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline

• Create a Trendline
• Create Sparklines
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak

Module 17: Working with Multiple Workbooks

• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Module 18: Importing and Exporting Data

• Export Excel Data
• Import a Delimited Text File

• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

Module 20: Structuring Workbooks with XML

• Develop XML Maps
• Import and Export XML Data

Module 21: Identifying the Elements of the Excel 2010 Environment

• Identify the User Interface Elements
• Identify the Ribbon Components
• Use Contextual Tabs
• Use Excel Galleries
• Customize the Excel Interface

• Identify the Enhancements to Excel 2010 Spreadsheets
• Insert Tables
• Format Tables

Module 23: Analyzing Data

• Apply Conditional Formatting
• Sort Data in a Spreadsheet
• Filter Data in a Spreadsheet
• Apply a Formula

Module 24: Presenting Data

• Create Charts
• Format Charts
• Work with Illustrations
• Create PivotTables and PivotCharts
• Share Excel Charts
• Save Data in Compatible Formats

Module 25: Using Office Web Apps

• Save Excel Spreadsheets to the Web
• Access and Work with Spreadsheets on the Web

• Icebreaker
• Housekeeping items
• Pre-Assignment Review
• Workshop objectives
• Action plans and evaluation forms

Module 2: Opening and Closing PowerPoint

• Opening PowerPoint
• Interface Overview
• Using the Backstage View
• Creating a Blank Presentation
• Closing PowerPoint

• Saving Files
• Opening Files
• Closing Files
• Creating a Presentation from a Template
• Using the Recent List

• Adding Text to a Slide
• Using a Content Placeholder
• Adding Slides
• Using the Slides Tab

Module 5: Working with Text

• Using Cut, Copy, and Paste
• Using the Office Clipboard
• Using Undo and Redo
• Finding and Replacing Tex

• Changing Font Face and Size
• Changing the Font Color
• Changing Character Spacing
• Adding Font Enhancements
• Clearing Formatting
• Using the Font Dialog

• Adding Bullets and Numbering
• Changing Alignment
• Adjusting the Indent
• Using Indents and Tabs
• Changing Line Spacing

Module 8: Advanced Formatting Tasks

• Using the Format Painter
• Changing Slide Design
• Changing Slide Layout
• Changing the Theme
• Changing the Background Design

• Adding a Header or Footer
• Creating a Standard Animation
• Creating a Custom Animation
• Using the Animation Painter
• Adding a Slide Transition
• Setting Slide Advance Options

• Working with Sections
• Using the Set Up Slide Show Dialog
• Recording a Narration
• Timing Your Show
• Hiding Slides

Module 11: Showtime!

• Our Top Five PowerPoint Tips
• Starting a Show
• Navigating through the Show
• Changing Your Pointer
• Switching to a Blank Screen

• Words from the Wise
• Parking Lot
• Action Plans and Evaluations