Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Table Of Contents
Table Of Contents
Title Page
Starting Up
About Microsoft Office 2010 Digital Classroom
Prerequisites
System requirements
Fonts used in this book
Loading lesson files
Video tutorials
Additional resources
Word Lesson 1
Starting up
The project
Creating a new document
Customizing the Quick Access Toolbar
Applying Styles
Applying a theme
Adding and positioning a graphic
Changing background color and margins
Deleting a blank page
Inserting additional pages
Inserting a blank page
Inserting a cover page
Adding page numbers
Protecting the document
Self study
Review
Word Lesson 2
Starting up
Understanding Microsoft Word
Creating a new document from template
Customizing the workspace
Status bar
Quick Access Toolbar
To customize the Quick Access Toolbar:
Ribbon
Formatting using the Ribbon
Using the View options
Getting help
Converting Word documents from prior versions to Word 2010
Self study
Review
Word Lesson 3
Starting up
Opening and editing an existing document
Working with text
Viewing documents
Selecting text
A word about selecting
Copying and pasting
Paste options
ICON OPTION NAME DESCRIPTION
Clipboard options
Copy and Paste feature
Working with fonts
Reducing font size
Changing the case
Emphasizing text
Character Formatting tools
Icon Tool Shortcut Example
Protecting a document from editing
Protect Document options
Option Description
Self study
Review
Word Lesson 4
Starting up
Working with paragraphs
Applying paragraph alignment
Changing line spacing
Within a paragraph
Options for line spacing
Between paragraphs
Creating lists
Numbered and bulleted
Multilevel lists
Displaying formatting marks and rulers
Display formatting marks
Formatting marks
Word displays…
When you press…
Display rulers
Indenting paragraphs
Special Indentation options
Option Description
Setting tabs
Tab types
Icon Type Description
Adding paragraph borders
Self study
Review
Word Lesson 5
Starting up
Introducing the page tools
Setting the page size
To open the document you need for this lesson:
Choosing a layout
Setting margins
Working with columns
Inserting column breaks
Adding a page border
Adding headers and footers
To add a header:
To add a footer:
Adding a background color
Adding a watermark
Adding pages and page numbers
To insert a Word file:
To add page numbers:
Inserting a section break
Controlling text flow
Self study
Review
Word Lesson 6
Starting up
Style type
Definition
Introducing the styles tools
Applying a style
Understanding heading styles
Switching between style sets
Identifying the current style
Removing a style
Creating a new style
Deleting a style
To delete a style:
Modifying a style
Assigning a style shortcut key
Customizing the Quick Styles Gallery
To add a style to the Quick Styles Gallery:
Applying a document theme
Customizing a theme
Self study
Review
Word Lesson 7
Starting up
Introducing the table tools
Creating a table
Moving around in a table
Key(s)
Function
Formatting a table and adding text
Selecting cells within a table
Showing and hiding gridlines
Changing the row height or column width
Resizing a table
Moving a table
Adding and deleting rows
Adding and deleting columns
Enlarging a table
AutoFit Options
Combining and splitting cells
Splitting a table
Aligning text in cells
Adding shading to cells
Formatting a table
Adding a formula to a table
Self Study
Review
Word Lesson 8
Starting up
Introducing the graphics tools
Adding WordArt
Adding a picture
Cropping a picture
Cropping with a special shape
Adding a screenshot
Adding a caption
Inserting a clip art image
Adding a shape
Wrapping text around an image
Wrapping Style Icon Description
Adding a picture effect to a graphic
Working with diagrams
Self study
Review
Excel Lesson 1
Lesson 1: Microsoft Excel 2010 Jumpstart
Starting up
The project
Inserting rows and columns into a worksheet
Merging and formatting cells
Adjusting cell width and increasing font size
Copying and pasting to a range of cells
Adding a column of numbers
Adding a fill
Self study
Review
Excel Lesson 2
Lesson 2: Getting Started with Microsoft Excel 2010
Starting up
What Is Excel?
How can you use Excel?
Exploring the Excel workspace
Working in Backstage view
Setting and removing a password requirement
Removing security restrictions
Worksheet basics: a quick tour of Microsoft Excel
Exploring worksheets
The Excel user interface
Customizing the Quick Access Toolbar
Removing buttons from the Quick Access Toolbar
Using the Zoom and Page View options
Naming a worksheet
Naming and saving workbooks
Changing page setup options
Shading cells and changing Font Color
Working within a workbook
Understanding the worksheet area
Convert Excel documents from prior versions to Excel 2010
Getting help
Self study
Review
Excel Lesson 3
Lesson 3: Editing Cells
Starting up
Generating a new workbook from an existing one
Selecting cells
Deleting data or cells
Deleting an entire column
Using the Clear command
Entering data
To enter data:
Copying and pasting within Excel
Copying from Word and pasting into Excel
Paste Options
Formatting cells for numbers
Self study
Review
Excel Lesson 4
Lesson 4: Formatting Cell Ranges
Starting up
Working with fonts
Changing Fonts
Aligning cell data
Formatting text
Using the format painter
Adding borders and shading
Adding columns and rows
Resizing columns and rows
Assigning Number Formats
Finding the sum of a column
Self study
Review
Excel Lesson 5
Lesson 5: Building Formulas and Functions
Starting up
Understanding Excel formulas
Operator precedence
Building a formula
Understanding Excel functions
Adding a function to a formula
Adding a row or column of numbers
Building an AutoSum formula
Copying a formula
Defining and using range names in formulas
Self study
Review
Excel Lesson 6
Lesson 6: Displaying Data with Charts
Starting up
Exploring chart elements
Understanding chart types
Creating a chart
Adjusting and moving the chart
Adding chart titles
Adding a horizontal axis title
Adding a vertical axis title
Positioning a chart legend
Displaying gridlines
Displaying a data table
Changing the chart layout and style
Formatting chart elements
Customizing a chart background
Changing a chart type
Editing a chart element
Applying a style to a chart element
Adding Sparkline graphics to a worksheet
Self study
Review
Excel Lesson 7
Lesson 7: Analyzing Excel Data
Starting up
Understanding data lists
Sorting a range
Sorting data on a single field
Sorting data on multiple fields
Filtering a range
Setting data validation rules
Converting a range to a table
Creating a data table
Summarizing data with subtotals
Exporting Excel data to Word
Exporting data
Exporting data and tools
Creating a PivotTable
Creating a PivotChart
Self study
Review
Excel Lesson 8
Lesson 8: Adding Graphic Objects
Starting up
Manipulating graphics
Moving graphic objects to a new layer
Aligning graphics
Grouping graphics
Importing and adjusting graphics
Importing clip art
Importing picture files
Formatting clip art and imported pictures
Adjusting images
Working with shapes
Working with text boxes
Adding a text box
Resizing and formatting a text box
Inserting WordArt
Inserting SmartArt graphics
Adding a screenshot
Adding a theme
Self study
Review
PowerPoint Lesson 1
Lesson 1: Microsoft PowerPoint 2010 Jumpstart
Starting up
The project
Creating a presentation from an existing file
Saving and converting a presentation from prior versions
Applying a theme and changing colors
Changing the slide layout and aligning text
Adding pictures and text to the slide
Adding a style to a picture
Applying slide transitions
Adding effects and animating text
Applying animation to pictures and text boxes
Self study
Review
PowerPoint Lesson 2
Lesson 2: Getting Started with Microsoft PowerPoint 2010
Starting up
Understanding Microsoft PowerPoint
Presentation basics
Creating a new presentation
Powerpoint’s user interface
Customizing the Quick Access Toolbar
Applying a theme
Adding a slide and related notes
Using the Notes pane
Adding a shaped text box
Adding a text box
Adding a picture
Getting help
Self study
Review
PowerPoint Lesson 3
Lesson 3: Working with Tables and Charts
Starting up
Table basics
Creating a table
Adding text to a table
Selecting table elements
Adding rows and columns
Aligning text within columns and rows
Working with table styles and shading
Merging cells
Working with charts
Choosing the right chart
Creating a chart
Changing the chart type
Self study
Power Point Lesson 4
Lesson 4: Working with Graphic Elements
Starting up
Using the drawing tools
Inserting a graphic as a background
Working with shape styles
Inserting a picture and applying effects
Aligning graphics
Ungrouping and regrouping graphic elements
Creating a diagram
Customizing and saving a theme
Self study
Review
Access Lesson 1
Starting up
What Is Access?
How can you use Access?
Database basics
Basic database terminology
Database design tips
Quick tour of Access 2010
The Ribbon
Backstage view
Navigation Panel
Exploring a database
To search for an object:
To arrange the appearance of the objects in the Navigation panel:
To manage objects in the Navigation panel:
Working with records
Searching for a record
Sorting records
Adding and deleting records
Adding a record
Deleting a record
Getting help
Ending an Access session
Self study
Review
Access Lesson 2
Starting up
Access 2010 database types
Creating a simple database
Creating a database using a template
To create a database from scratch:
Tables, views, and data types
Creating a table in Datasheet view
Creating a Table in Design View
Adding fields to a table
Importing data from a Microsoft Excel spreadsheet
Self study
Review
OneNote Lesson 1
Lesson 1: Microsoft OneNote 2010 Jumpstart
Starting up
Discovering OneNote
Working with OneNote
Exploring the OneNote environment
Notebook view
Working in Backstage view
Searching OneNote
Sharing a Notebook
Customizing OneNote
Getting help
Ending a OneNote session
Self study
Review
OneNote Lesson 2
Lesson 2: Getting Started with Microsoft OneNote 2010
Starting up
Managing Notebooks
Managing Sections
To create a Section:
To rename a Section:
Grouping Sections
Saving a Notebook
Managing Pages
To create and name a Page:
To rename a Page:
Adding content
Direct text entry (typing)
Copying and pasting
Creating a drawing using a mouse, touchpad, or electronic pen
Adding audio and video notes
To record video:
Inserting web content
To insert an entire web page:
Self study
Review
Publisher Lesson 1
Lesson 1: Microsoft Publisher 2010 Jumpstart
Starting up
What is Publisher?
How can you use Publisher?
Publication basics
Quick tour of Publisher 2010
Publisher 2010 components
The Ribbon
Navigation pane
Opening a publication
To open an existing publication:
Changing your view
Saving a publication
Customizing the Quick Access Toolbar
Getting help
Closing a Publisher session
Self study
Review
Publisher Lesson 2
Lesson 2: Getting Started with Microsoft Publisher 2010
Starting up
Creating a blank publication
Working with pages
To insert one or more pages:
To delete, rename, or move a page:
Setting page margins
Changing page orientation
Changing page sizes
Inserting a text box
To insert a text box:
Formatting text
Flowing text
Inserting and modifying images
To insert an image:
Printing your publication
Using Pack and Go
Sending a publication using e-mail
E-mail preview
To preview an e-mail:
Self study
Review
Outlook Lesson 1
Lesson 1: Microsoft Outlook Essentials
Starting up
What is Outlook?
Setting up Outlook
Using more than one email account
Composing email, Adding recipients, and sending messages
Adding attachments to email messages
Adding signatures
Receiving email
Organizing email
Using folders
Avoiding Junk email, SPAM, and phishing
Archiving old messages
Contacts and the Address Book
Adding contacts
Finding contacts
Creating groups
Calendar
Appointments and meetings
Creating appointments and setting-up reminders
Setting-up meetings and inviting attendees
Using tasks
Self study
Review
About The Authors
About the Authors
Acknowledgments
Credits
Copyright
← Prev
Back
Next →
← Prev
Back
Next →