- 分享
- 0
- 人气
- 0
- 主题
- 49
- 帖子
- 4178
- UID
- 185285
- 积分
- 7812
- 阅读权限
- 23
- 注册时间
- 2008-12-11
- 最后登录
- 2020-5-4
- 在线时间
- 3693 小时
|
Zuncker21 发表于 2014-6-24 11:01 AM
想问一下OFFICE IT 8 IN 1(基本办公电脑课程)和ADVANCED OFFICE IT(高阶办公电脑课程)的课程里有什么差 ...
MICROSOFT EXCEL
Chapter 1: Entering Text and Numbers
Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This Chapter will introduce you to the Excel window. You use the window to interact with Excel.
• The Microsoft Excel Window
• The Microsoft Office Button
• The Quick Access Toolbar
• The Title Bar
• The Ribbon
• Worksheets
• The Formula Bar
• The Status Bar
• Move Around a Worksheet
• Go To Cells Quickly
• Select Cells
• Enter Data
• Edit a Cell
• Wrap Text
• Delete a Cell Entry
• Save a File
• Close Excel
Chapter 2: Entering Excel Formulas and Formatting Data
Chapter 1 familiarized you with the Excel 2010 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this Chapter, you learn how to perform basic mathematical calculations and how to format text and numerical data.
• Set the Enter Key Direction
• Perform Mathematical Calculations
• AutoSum
• Perform Automatic Calculations
• Align Cell Entries
• Perform Advanced Mathematical Calculations
• Copy, Cut, Paste, and Cell Addressing
• Insert and Delete Columns and Rows
• Create Borders
• Merge and Center
• Add Background Color
• Change the Font, Font Size, and Font Color
• Move to a New Worksheet
• Bold, Italicize, and Underline
• Work with Long Text
• Change a Column's Width
• Format Numbers
Chapter 3: Creating Excel Functions, Filling Cells, and Printing
By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series. For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.
A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excelworksheet, you may want to print it. This Chapter teaches you how to use functions, how to create a series, how to create headers and footers, and how to print.
• Using Reference Operators
• Understanding Functions
• Fill Cells Automatically
• Create Headers and Footers
• Set Print Options
• Print
Chapter 4: Creating Charts
In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. This Chapter teaches you how to create a chart in Excel.
• Create a Chart
• Apply A Chart Layout
• Add Labels
• Switch Data
• Change the Style of a Chart
• Change the Size and Position of a Chart
• Move A Chart to a Chart Sheet
• Change the Chart Type
MICROSOFT WORD
Chapter 1: Getting Familiar with Microsoft Word 2010 for Windows
Microsoft Word is a word processing software package. You can use it to type letters, reports, and other documents. It gives you the ability to use your home computer as well as your business computer for desktop publishing. This tutorial teaches Microsoft Word 2010 basics. Although this tutorial was created for the computer novice, because Microsoft Word 2010 is so different from previous versions of Microsoft Word, even experienced users may find it useful. This Chapter will introduce you to the Word window. You use this window to interact with Word.
• The Microsoft Office Button
• The Quick Access Toolbar
• The Title Bar
• The Ribbon
• The Ruler
• The Text Area
• The Vertical and Horizontal Scroll Bars
• The Status Bar
• Understanding Document Views
• Click
• Understanding Nonprinting Characters
• Create Sample Data and Select Text
• Place the Cursor
• Execute Commands with Keyboard Shortcuts
• Start a New Paragraph
• Exit Word
Chapter 2: Microsoft Word 2010 Basic Features
Chapter 1 familiarized you with the Microsoft Word window. You are now ready to learn how to create a Word document. This Chapter covers typing, using the Backspace key, using the Delete key, inserting text, bolding, underlining, and italicizing.
• Type, Backspace, and Delete
• Insert and Overtype
• Bold, Italicize, and Underline
• Save a File and Close Word
Chapter 3: More Basic Features
The features in Word 2010 can make your work easier, make your documents more attractive, and/or enable you to work more efficiently. This Microsoft Word Chapter teaches you how to open a file, cut, copy, paste, use AutoText, use spell check, use Find and Replace, and change fonts. All of these features either make your work easier or make your document more attractive.
• Open a File
• Cut and Paste
• Copy and Paste
• Use the Clipboard
• Create AutoText
• Use Spell Check
• Find and Replace
• Change the Font Size
• Change the Font
• Save Your File
Chapter 4: Formatting Paragraphs and Working with Styles
When you type information into Microsoft Word, each time you press the Enter key Word creates a new paragraph. You can format paragraphs. For example, you can indent the first line of a paragraph, you can set the amount of space that separates paragraphs, and you can align a paragraph left, right, center, or flush with both margins. Styles are a set of formats you can quickly apply to a paragraph. For example, by applying a style, you can set the font, set the font size, and align a paragraph all at once. In this Chapter, you will learn about the various formats you can apply to a paragraph and about styles.
• Open a Blank Document
• Add Sample Text
• Add Space Before or After Paragraphs
• Change Line Spacing
• Create a First-Line Indent
• Indent Paragraphs
• Align Paragraphs
• Create a Hanging Indent
• Choose a Style Set
• Apply a Style
• Change Style Sets
Chapter 5: Adding Bullets and Numbers, Undoing and Redoing, Setting Page Layouts and Printing Documents
If you have lists of data, you may want to bullet or number them. When using Microsoft Word, bulleting and numbering are easy. The first part of this Chapter teaches you to bullet and number. After you have completed your document, you may want to share it with others. One way to share your document is to print and distribute it. However, before you print you may want to add page numbers and tell Word such things as the page orientation, the paper size, and the margin setting you want to use. In this Chapter you will learn how to layout and how to print your documents.
• Add Bullets and Numbers
• Undo and Redo
• Set the Orientation
• Set the Page Size
• Set the Margins
• Add Page Numbers
• Insert Page Breaks
• Preview and Print Documents
MICROSOFT POWER POINT
Chapter 1: The PowerPoint Window
PowerPoint is a presentation software package. With PowerPoint, you can easily create slide shows. Trainers and other presenters use slide shows to illustrate their presentations. This tutorial teaches PowerPoint basics. This Chapter introduces you to the PowerPoint window. You use the window to interact with PowerPoint.
• The Microsoft Office Button
• The Quick Access Toolbar
• The Title Bar
• The Ribbon
• Rulers
• Slides, Placeholders, and Notes
• Status Bar, Tabs, View Buttons, and More
Chapter 2: Creating Your First PowerPoint Presentation
You create your PowerPoint presentation on slides. You use layouts to organize the content on each slide. PowerPoint has several slide layouts from which to choose. Themes are sets of colors, fonts, and special effects. Backgrounds add a colored background to your slides. You can add themes and backgrounds to your slides. After you complete your slides, you can run your presentation. In this Chapter you learn how to create slides, makes changes to slides, apply a theme and run a slide show.
• Create a Title Slide
• Create New Slides
• Make Changes to Your Slides
• Apply a Theme
• Run Your PowerPoint Slide Show
Chapter 3: Animations, Transitions, Spell Check, Outline Tab, Slides Tabs, Sorter View, and Printing
Animations control how objects move onto, off of, and around your slides. Transitions control how your presentation moves from one slide to the next. In this Chapter you learn how to create animations and transitions. You also learn how to spell-check your document, how to use the Outline and Slides tabs, how to use Sorter view, and how to print.
• Add Animations
• Add Transitions
• Spell Check
• Use the Outline and Slides Tabs
• Use Slide Sorter View
• Print
|
|