โครงการอบรม Microsoft Office 2010 สำหรับนักศึกษา ขอเลื่อนเป็นวันที่ 22-25 กุมภาพันธ์ 2554 (ฟรี)

สำนักวิทยบริการและเทคโนโลยีสารสนเทศ ขอเลื่อนการจัดฝึกอบรมหลักสูตร Microsoft Office สำหรับนักศึกษาชั้นปีที่ 4  มทร.พระนคร จำนวน 2 หลักสูตร  เป็นระหว่างวันอังคารที่  22 – 25 กุมภาพันธ์  2554    (สวท. สนับสนุนอาหารกลางวันและเครื่องดื่มสำหรับนักศึกษาผู้เข้าอบรมตลอดหลักสูตร)  นักศึกษาที่ต้องการเข้าร่วมอบรมกรุณาแจ้งรายชื่อที่อาจารย์ที่ปรึกษา หรือสำนักงานเลขานุการคณะทุกคณะ ตั้งแต่บัดนี้เป็นต้นไป หมดเขตรับสมัครวันที่  28  มกราคม 2554 มีรายละเอียดหลักสูตรดังนี้…

1. Microsoft Word 2010 Advanced course is suitable for those with a sound working knowledge of Word who wish to progress to the most complicated functions and features. เป็นหลักสูตร 2 วัน ฝึกอบรมระหว่างวันที่  22-23  กุมภาพันธ์  2554 ณ ศูนย์การเรียนรู้ด้วยตนเอง  เทเวศร์

Tuesday, 22  Feb Course Details
8:45-10:30 Module 1 Introduction to Personal ComputingGetting 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
10:30-12:00 Module3 Paragraph Formatting

  • 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
12:00-13:00 Lunch
13:00-14:30 Module5 Basic Internet

  • 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
14:30-16:30 Module6Email

  • 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
Wednesday 23, Feb Course Details
8:45-10:30 Module7 Spreadsheet Basics

  • 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

10:30-12:00 Module8Charts

  • 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

12:00-13:00 Lunch
13:00-14:30 Module10Introduction

  • 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
14:30-16:30 Module11GraphicsEditing a graphic

  • 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

2. Microsoft Excel 2010 Intermediate/Advanced level computer training materials for delivering training to your students, staff or clients.  A courseware site license allows you to train an unlimited number of people, at your training center using these teaching resources.  เป็นหลักสูตร 3 วัน ฝึกอบรมระหว่างวันที่  24-25 กุมภาพันธ์  2554 ณ ศูนย์การเรียนรู้ด้วยตนเอง เทเวศร์

Thursdsay  24, Feb Course Details
8:45-10:30 Module 1: Creating a Basic Excel Worksheet

  • 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
10:30-12:00 Module 3: Modifying an Excel Worksheet

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

Module 4: Formatting an Excel Worksheet

  • 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
12:00-13:00 Lunch
13:00-14:30 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
14:30-16:30 Module 7: Calculating Data with Advanced Formulas

  • 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
Friday 25, Feb Course Details
8:45-10:30 Module 9: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Module 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts
10:30-12:00 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
12:00 – 13:00 Lunch
13:00-14:30 Module 13: Streamlining Workflow

  • 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
14:30-16:30 Module 15: Auditing Worksheets

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

Module 16: Analyzing Data

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform What-If Analysis
  • Perform Statistical Analysis with the Analysis ToolPak
8:45 – 10:30 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

Module 19: Structuring Workbooks with XML

  • Develop XML Maps
  • Import and Export XML Data

10:30 – 12:00 Module 20: Using Excel with the Web

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

Module 21: Organizing Data

  • Identify the Enhancements to Excel 2010 Spreadsheets
  • Insert Tables
  • Format Tables
12:00 – 13:00 Lunch
13:00-14:30 Module 22: 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

Module 23: Analyzing Data

  • Apply Conditional Formatting
  • Sort Data in a Spreadsheet
  • Filter Data in a Spreadsheet
  • Apply a Formula
14:30-16:30 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