- 分享
- 0
- 人气
- 0
- 主题
- 49
- 帖子
- 4178
- UID
- 185285
- 积分
- 7812
- 阅读权限
- 23
- 注册时间
- 2008-12-11
- 最后登录
- 2020-5-4
- 在线时间
- 3693 小时
|
Basic Office IT 8 In 1 :
1. Windows 7
2. Ms Word
3. Ms Excel
4. Ms Power Point
5. Internet
6. Email
7. Burning CD/ Data
8. Chinese PRC
Microsoft Windows 7
Course Outline
• Introduction of Microsoft Windows
• Basic Mouse Terminology and Techniques
• Windows Manipulation
• Minimize / Maximize / Close
• Size / Move / Restore
• Taskbar Settings
• Auto Arrange Icons
• Managing Control Panel
• Formatting the Desktop Background
• Customizing Windows Setting
• Changing Screen Saver Setting
• Setting Time & Date
• Changing Screen Colors in Appearance
• Switching between Tasks
• Managing Print Jobs
• Navigating in Windows Explorer
• Copying and Moving Files and Folders
• Renaming Files and Folders
• Deleting Files and Folders
• Undelete Files By Using Recycle Bin
Microsoft Word
• Introduction to Word Processor
• Edit the Document
• Save and Retrieve File
• Document Management
• Format the Document
• Preview and Print Document
• Bullet and Numbering
• Tables Creation
• Columns Creation
• Insert WordArt
• Insert ClipArt
Microsoft Excel
• Introduction to Excel
• Manipulate Rows and Columns
• Editing the worksheet
• Save and Retrieve File
• Function and Formula
• Worksheet Formatting
• Preview and Printing Worksheet
• Business Graphics
Microsoft Power Point
• Introduction to PowerPoint
• Create and Edit Slides
• Typography
• Drawing Tools
• ClipArt
• Bar Chart
• Organization Chart
• Graphics, Slide, Outline
• Electronic Presentation
Internet & Email
• hardware requirements
• Internet Account Sign up
• Create Internet Connection
• Internet Browser
• Internet URL
• Internet Explore Function Button
• Apply Free Email Account
• Usage of email
• Sending E-Cards
Advanced IT Program
1. MS WORD
2. MS EXCEL
3. MS ACCESS
4. OFFICE OLE
Microsoft Word
• AutoCorrect and AutoText Compared
• Inserting Text by using AutoCorrect
• Inserting Text by using AutoText
• AutoSave
• Password Protecting A Document
• Drop Cap
• Change Case
• Newspaper-Style Columns
• Creating Column of Unequal Width
• Modifying Columns
• To create more than two columns of unequal width
• Assembling Documents with Mail Merge
• Creating Mail Merge From Letters
• Creating Data Source
• Merging Data with the Main Document
• Inserting Merge Fields
• What can you do with Macros?
• Recording Macros
• To Assign the Macro to a Toolbar
• To Put a Macro on a Menu
• To Assign the Macro to a Keyboard
• To Play a Macro from the Macro Dialog Box
• To Play a Macro from a Toolbar
• To Play a Macro from a keyboard
• To Play a Macro from the Menu
Microsoft Excel
• AutoFilter
• Advanced Filter
• Creating a Pivot Table
• Change the layout of a Pivot table
• Change a data consolidation
• Consolidate data by Category
• Consolidate data by Position
• Change or Remove a Workbook Password
• Function Wizard - IF
• Function Wizard – Vlookup
• Function Wizard – SumProduct
MS ACCESS
• Creating a New Database
• Creating a Table
• Editing date in table
• Building a Database
• Editing database
• Querying Database
• Creating a Form
• Editing existing form
• Creating a Report
• Printing a Report
Office OLE
• OLE definition
• Office OLE between MS Office
• Import data between Office Software
• Updating data |
|