Microsoft Office 2010 Digital Classroom by AGI Training Team, AGI Creative Team -- Read -- Imperial Library of Trantor

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 →