AGI Creative Team, AGI Training Team. Microsoft Office 2010. Digital Classroom

Wiley Publishing, Inc., 2011. — 430 p. — ISBN: 0470577770.AGI Training Team, AGI Creative Team - Office 2010 Digital Classroom includes 27 lessons that will teach you the new features of Microsoft Office 2010. Each lesson includes step-by-step instructions and files that complement the learning material. The book shows you how to use Microsoft Office 2010, the new version of Microsoft's office suite, which is available in standard 32-bit and now also 64-bit.
The complete book-and-video training package for Office 2010!
This terrific Office 2010 book-and-video training package-from the same professional training experts who also create many training materials for Adobe Systems-is like having your own personal instructor guiding you through each lesson, but you work at your own pace! The full-color book includes 27 lessons that teach you the new features and quirks of Microsoft Office 2010. Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This jam-packed training package takes you well beyond the basics in a series of easy-to-absorb, five-minute lessons.Starting Up
About Microsoft Office 2010 Digital Classroom.Prerequisites.System requirements.
Fonts used in this book.
Loading lesson files.Microsoft Word 2010 Jumpstart
Starting up.
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.Getting Started with Microsoft Word 2010
Starting up.
Understanding Microsoft Word.
Creating a new document from template.
Customizing the workspace.
Formatting using the Ribbon.
Using the View options.
Getting help.
Converting Word documents from prior versions to Word 2010.
Self study.
Review.Editing the Document
Starting up.
Opening and editing an existing document.
Working with text.
Viewing documents.
Selecting text.
Copying and pasting.
Paste options.
Clipboard options.
Working with fonts.
Reducing font size.
Changing the case.
Emphasizing text.
Character Formatting tools.
Protecting a document from editing.
Protect Document options.
Self study.
Review.Formatting Paragraphs
Starting up.
Working with paragraphs.
Applying paragraph alignment.
Changing line spacing.
Creating lists.
Displaying formatting marks and rulers.
Display formatting marks.
Display rulers.
Indenting paragraphs.
Setting tabs.
Adding paragraph borders.
Self study.
Review.Working with Pages
Starting up.
Introducing the page tools.
Setting the page size.
Choosing a layout.
Setting margins.
Working with columns.
Inserting column breaks.
Adding a page border.
Adding headers and footers.
Adding a background color.
Adding a watermark.
Adding pages and page numbers.
Inserting a section break.
Controlling text flow.
Self study.
Review.Working with Styles and Themes
Starting up.
Understanding styles.
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.
Modifying a style.
Assigning a style shortcut key.
Customizing the Quick Styles Gallery.
Applying a document theme.
Customizing a theme.
Self study.
Review.Working with Tables
Starting up.
Introducing the table tools.
Creating a table.
Moving around in a table.
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.
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.Working with Graphics
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.
Adding a picture eff ect to a graphic.
Working with diagrams.
Self study.
Review.Microsoft Excel 2010 Jumpstart
Starting up.
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.Getting Started with Microsoft Excel 2010.
Starting up.
What Is Excel?
How can you use Excel?
Exploring the Excel workspace.
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.Editing Cells
Starting up.
Generating a new workbook from an existing one.
Selecting cells.
Deleting data or cells.
Using the Clear command.
Entering data.
Copying and pasting within Excel.
Copying from Word and pasting into Excel.
Formatting cells for numbers.
Self study.
Review.Formatting Cell Ranges
Starting up.
Working with 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.EBuilding 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.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.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.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 fi les.
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.Microsoft PowerPoint 2010 Jumpstart
Starting up.
Creating a presentation from an existing fi le.
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.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.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.
Review.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.Microsoft Access 2010 Jumpstart
Starting up.
What Is Access?
How can you use Access?
Database basics.
Basic database terminology.
Database design tips.
Quick tour of Access 2010.
Access 2010 components.
Exploring a database.
Working with records.
Searching for a record.
Sorting records.
Adding and deleting records.
Customizing the Quick Access Toolbar.
Getting help.
Ending an Access session.
Self study.
Review.Getting Started with Microsoft Access 2010
Starting up.
Access 2010 database types.
Creating a simple database.
Creating a database using a template.
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.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.Getting Started with Microsoft OneNote 2010
Starting up.
Managing Notebooks.
Managing Sections.
Grouping Sections.
Saving a Notebook.
Managing Pages.
Adding content.
Direct text entry (typing).
Copying and pasting.
Creating a drawing using a mouse, touchpad, or electronic pen.
Adding audio and video notes.
Inserting web content.
Self study.
Review.Microsoft Publisher 2010 Jumpstart
Starting up.
What is Publisher?
How can you use Publisher?
Publication basics.
Quick tour of Publisher 2010.
Opening a publication.
Changing your view.
Saving a publication.
Customizing the Quick Access Toolbar.
Closing a Publisher session.
Self study.
Review.Getting Started with Microsoft Publisher 2010
Starting up.
Creating a blank publication.
Working with pages.
Setting page margins.
Changing page orientation.
Changing page sizes.
Inserting a text box.
Formatting text.
Flowing text.
Inserting and modifying images.
Printing your publication.
Using Pack and Go.
Sending a publication using e-mail.
E-mail preview.
Self study.
Review.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.
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.