Office 2010 adds some terrific new features in Word, Excel, PowerPoint, and Access, and fully integrates the Ribbon interface in Outlook, Publisher, and OneNote. As a result, even experienced Office users can.
Syllabus
Page 1
Welcome to Microsoft Office 2010
Learning about Office Applications
Taking Advantage of Other Office Applications
Starting an Application
Closing an Application
Finding Files
Getting Help
Navigating in Office
Discoverability
The “Results-Oriented” User Interface
Ribbons and Thing
Go Backstage with File
Options
Working with Dialog Boxes
Mastering Fundamental Operations
Working with Files
Printing a File
Working with Multiple Windows
Moving and Copying Information
Finding and Replacing
Spell Checking
AutoCorrect, AutoFormat, and Actions
Styles and LivePreview
Making a Document
Creating a Blank File
Creating a File from a Template
Saving and File Formats
Compatibility with Previous Versions of Word
docx versus .docm
Understanding .docx
Navigation Tips and Tricks
Views
Formatting : Font/Character Formatting
The Big Picture
Styles and Character/Font Formatting
Character Formatting
Formatting Techniques
The Font Group
The Font Dialog Box
The Mini Toolbar
Paragraph Formatting
Styles and Paragraph Formatting
When to Use Styles
What Exactly Is a Paragraph, Anyway?
Structural Formatting
Paragraph Decoration
Styles
Styles Group
Styles Task Pane
Page Setup and Sections
Page Setup Basics
Page Borders
The Header and Footer Layer
Header and Footer Navigation and Design
Adding Header and Footer Material
Themes
Tables and Graphics
Quick Start
Table Basics
Table Layout and Design
Inserting Pictures from Files
Pictures from the Clipboard and Internet
Inserting Clip Art
SmartArt
Data Documents and Mail Merge
Understanding Data Sources
Choosing the Type of Data Document
Attaching a Data Source
Assembling a Data Document
Mail Merge Task Pane/Wizard
Security, Tracking, and Comments
Protection Types
Comments and Tracked Changes
Reviewing Comments and Changes
Protecting Documents for Review
Page 2
Using Excel Worksheets and Workbooks
What’s New in Excel 2010?
Understanding Workbooks and Worksheets
Moving around a Worksheet
Introducing Excel’s Ribbon Tabs
Creating Your First Excel Worksheet
Entering and Editing Worksheet Data
Exploring the Types of Data You Can Use
Entering Text and Values into Your Worksheets
Entering Dates and Times into Your Worksheets
Modifying Cell Contents
Applying Number Formatting
Essential Worksheet and Cell Range Operations
Learning the Fundamentals of Excel Worksheets
Controlling the Worksheet View
Working with Rows and Columns
Understanding Cells and Ranges
Copying or Moving Ranges
Using Names to Work with Ranges
Adding Comments to Cells.
Introducing Formulas and Functions
Understanding Formula Basics
Entering Formulas into Your Worksheets
Editing Formulas
Using Cell References in Formulas
Using Formulas in Tables
Correcting Common Formula Errors
Tips for Working with Formulas
Working with Dates and Times
How Excel Handles Dates and Times
Date-Related Worksheet Functions
Time-Related Functions
Creating Formulas That Count and Sum
Counting and Summing Worksheet Cells
Basic Counting Formulas
Advanced Counting Formulas
Summing Formulas
Getting Started Making Charts
What Is a Chart?
Hands On: Creating and Customizing a Chart
Working with Charts
Understanding Chart Types
A First Look at PowerPoint 2010
What’s New in PowerPoint 2010?
Learning Your Way around PowerPoint
Changing the View
Zooming In and Out
Enabling Optional Display Elements .
Opening a New Display Window
Creating a Presentation, Slides, and Text
Starting a New Presentation
Saving Your Work
Setting Passwords for File Protection
Closing and Reopening Presentations
Creating New Slides
Inserting Content from External Sources
Managing Slides
Using Content Placeholders
Creating Text Boxes Manually
Working with Text Boxes
Page 3
Working with Layouts, Themes, and Masters
Understanding Layouts and Themes
Changing a Slide’s Layout .
Applying a Theme
Changing Colors, Fonts, and Effects
Creating and Managing Custom Color and Font Themes
Changing the Background
Working with Placeholders
Customizing and Creating Layouts
Managing Slide Masters
Managing Themes
Working with Tables and Charts
Creating a New Table
Moving Around in a Table
Selecting Rows, Columns, and Cells
Editing a Table’s Structure
Applying Table Styles
Formatting Table Cells
Understanding Charts
Starting a New Chart .
Working with Chart Data
Chart Types and Chart Layout Presets
Working with Labels
Controlling the Axes
Formatting a Chart
Rotating a 3-D Chart
Using SmartArt Diagrams, Clip Art, and Pictures
Understanding SmartArt Types and Their Uses
Editing SmartArt Text
Modifying SmartArt Structure
Modifying a Hierarchy Diagram Structure
Formatting a Diagram
Saving a SmartArt Diagram as a Picture
Choosing Appropriate Clip Art
About the Clip Organizer
Inserting Clip Art on a Slide
Clip Art Search Methods
Working with Clip Art Collections
Understanding Raster Graphics
Importing Image Files into PowerPoint
Sizing and Cropping Photos
Compressing Images
Building Animation Effects, Transitions, and Support Materials
Understanding Animation and Transitions
Assigning Transitions to Slides
Animating Slide Content
The When and How of Handouts
Creating Handouts
Creating Speaker Notes
Printing an Outline
Printing Slides
Preparing and Delivering a Live Presentation
Starting and Ending a Show
Using the Onscreen Show Controls
Using the Onscreen Pen
Hiding Slides for Backup Use
Using Custom Shows
Giving a Presentation on a Different Computer
Working with Audiovisual Equipment
Fundamentals of E-mail
Setting Up Your E-mail Accounts
Modifying Account Settings
Using Outlook Profiles
Composing and Sending Messages
Reading and Replying to Messages
Understanding the Inbox Display
Understanding Files and Folders
Outlook Data Files
Working with Outlook Folders
Page 4
Deleting Items and Using the Deleted Items Folder
Setting Options for an Individual E-mail Message
Setting Global E-mail Options
Processing and Securing E-mail
Understanding Junk E-mail Filtering
Setting Junk E-mail Options
Blocking and Allowing Specific Addresses
Understanding E-mail Rule Basics
Creating a New Rule
Some Rule Examples
Managing Rules
Protecting against Viruses
Dealing with Attachments
Using Certificates and Digital Signatures
Working with Contacts
Understanding Outlook Contacts
The Contacts Window
Adding Contacts
Sending an E-mail to a Contact or Group
More about Contacts
Performing a Mail Merge from Your Contacts
Working with Multiple Address Books
Setting Contact Options
Many More.....
0 comments:
Post a Comment