Buying Options
Office 2007: The Missing Manual (Video Tutorials)
Description
The Missing Manual series
(www.missingmanuals.com)
presents a collection of tutorials to guide you through some popular features in Microsoft Office 2007. Covering topics from simple text formatting in Word all the way to creating a custom query in Access, each video is designed to get you up and running in under 10 minutes, perfect for the learner on the go.
Table of Contents
-
1.
Formatting Text (Free Preview)
6 minutesFormatting text in Word 2007 is an easy way to make your document effective and attractive. By using different formatting techniques, like changing the color or the size of your text, your document becomes more unique and easier to read and understand. This tutorial will guide you through the different ways of formatting individual characters and words, selecting fonts and making characters bold, italicized, underlined and capitalized. -
2.
Formatting Paragraphs (Free Preview)
9 minutesFormatting your paragraphs in Word 2007 can help to create a much more readable document. In this tutorial, you'll learn how to align text, indent paragraphs, change the spacing between paragraphs and lines, and insert page and line breaks. -
3.
Setting Tabs
8 minutesThe lowly Tab key in Word 2007 contains more power than you may think. In this tutorial you'll learn some tab basics and then learn how to set the different types of tabs in your document. -
4.
Fast Formatting with Format Painter and Formatting with Styles
6 minutesWord 2007's Format Painter allows you to copy multiple settings from a template in just a few steps, so you don't have to waste tons of time trying to copy formatting from one paragraph to another. This tutorial will teach you how to use Format Painter to copy the formatting of a word, heading or paragraph onto something else. -
5.
Working with Multiple Columns
4 minutesWord 2007 makes it easy to structure your page into newspaper-style columns. In this tutorial, you'll learn how to insert column guidelines and customize columns in your document. -
6.
Formatting Cell Values
9 minutesCell value formatting controls the way Excel 2007 displays numbers, dates, and times. In many ways, cell value formatting is more significant than cell appearance, because it can actually change the meaning of your data. In this tutorial, you'll learn how to format cell values, format numbers, and format dates and times. -
7.
Zooming and Panes
8 minutesAs you become an Excel 2007 wizard, you'll start to notice how your rows are beginning to grow into the hundreds with dozens of columns. You may begin to feel a little overwhelmed. In this tutorial you'll learn about the basic tools you can use to view your data, along with a few tips for managing large worksheets. -
8.
Custom Views and Hiding Data
6 minutesWhen your worksheets seem like they're getting too big to manage, or you need to exit the program in the middle of an important task, Excel 2007 provides features to keep you from getting lost. Custom Views and Hiding data are easy ways to keep your data organized. In this tutorial you'll learn how to hide and unhide data in your spreadsheet, and how to create and save custom views. -
9.
Formula Basics
7 minutesExcel 2007 comes pre-programmed to compute tons of numbers into neat subtotals and averages, and provides a variety of different ways to build formulas. In this tutorial, we'll help you take the first steps toward using Excel to its full capacity, by creating a basic formula. -
10.
Using Functions in Formulas
5 minutesA good deal of Excel 2007's popularity is due to the collection of functions it provides. Functions work like miniature computer programs -- you supply the data, and the function performs a calculation and gives you the result. In this tutorial, you'll learn how to build and use functions. -
11.
Charting 101
6 minutesEven though Excel 2007 gives you an overwhelming number of chart types to choose from, all of them share a few common characteristics. In this tutorial, you'll learn about the different types of charts, how to create a chart, how to use the chart tools on the ribbon, and how to print your chart. -
12.
Beginning a New Presentation and Working with Templates
8 minutesPowerPoint 2007, the leader in presentation programs, helps you quickly build attractive multimedia presentations, kiosk presentations, and printed documents. In this tutorial, you'll learn how to start a presentation from scratch and also how to build a new presentation from an existing template. -
13.
Themes
6 minutesPowerPoint 2007's themes save you the trouble of having to pick a color scheme, fonts, and paragraph styles by hand, so that you can give your presentation a polished look with just a few clicks. In this tutorial you'll learn how choose one of PowerPoint's predefined themes for your presentation, and how to add your own unique text. -
14.
Changing Slide Layout
6 minutesCoordinating your slide's layout with its purpose helps give your PowerPoint 2007 presentation the maximum effect. In this tutorial, you'll learn how to apply canned layouts to your slides, change the page orientation, and reposition text boxes. -
15.
Creating Charts
5 minutesYou can talk numbers until you're blue in the face, but when you really want to get your audience's attention -- and get your point across in the shortest time possible -- you need a chart to visually represent those numbers. Thanks to PowerPoint 2007, creating charts, tables and graphs is better and easier than ever. In this tutorial, you'll learn how to create & customize charts in your presentations. -
16.
Creating Diagrams
6 minutesPowerPoint 2007 lets you create more types of diagrams than ever before, and they're snazzier, easier to create, and simple to update. In this tutorial, you'll learn how to create, stylize and tweak diagrams in your presentations. -
17.
Tables
9 minutesAccess 2007 can be a dizzying--but there's no question that this database software can make record-keeping easier, and keep your records more organized than if you tried to do it by hand. In this tutorial, you'll learn how to get your database started in Access, how to create and understand simple tables, and how to edit a table. -
18.
Design Queries and Filter Expressions
8 minutesIn a typical Access 2007 database, with thousands or millions of records, finding the information you need can become a chore in itself. Queries are ready-made search routines that you store in your database, and they're a staple of database design. In this tutorial, you'll learn to design and fine-tune the most common type of query -- a select query, including adding sorts and filter expressions to narrow your results. -
19.
Report Basics and Printing
9 minutesAn Access 2007 "report" allows you to create a fine-tuned blueprint that tells Access exactly how it should prepare your data for the printer. In this tutorial you'll learn the report basics as well as how to fine tune and actually print out your own specialized report. -
20.
Importing Data
8 minutesAn Access 2007 database is like a carefully built fort: It takes strictly organized and error-tested information, and locks it up tight. Sometimes it can be difficult to transfer information into Access from another program without running into problems, however it can be done and can be very useful at times. In this tutorial you'll learn how to import and export data into and out of Access.
You may also need:
Print: $34.99
Ebook: $27.99
Product Details
- Title:
- Office 2007: The Missing Manual (Video Tutorials)
- By:
- Chris Grover, Matthew MacDonald, E. A. Vander Veer
- Publisher:
- O'Reilly Media / Pogue Press
- Formats:
-
- Safari Books Online
- Video
- Video Release:
- March 2009
- Run time:
- 2 hours 27 minutes
Customer Reviews
