Video description
Visual QuickStart Guides are now even more visual: Building
on the success of the top-selling Visual QuickStart Guide books,
Peachpit now offers Video QuickStarts. As a companion to Microsoft
Office 2011 for Macintosh: Visual QuickStart Guide, Peachpit offers
more than an hour of short, task-based videos that will help you
master Office 2011 for Mac top features and techniques; instead of
just reading about how to use a tool, you can watch it in action.
It’s a great way to learn all the basics and some of the newer or
more complex features of the program. This Video QuickStart guides
you through the basics and new features of Word 2011 and Excel
2011. Veteran best-selling author and presenter Steve Schwartz
provides in-depth instructions on many of the new features and
changes introduced in Office 2011. Coverage of each application is
jam-packed with information and tips that not only explain HOW to
perform a task, but WHY you need this procedure and WHEN it's best
to use it.
Table of Contents
Launching Office Applications, Using Galleries
00:05:55
Opening Saved Documents, Saving Your Work
00:04:11
Issuing Commands
00:03:56
Undoing and Redoing Commands, Setting Magnification
00:03:23
Managing Windows, Customizing Office, Getting Help, Quitting an Office Application
00:05:06
Adding Images and Objects, Inserting Photos and Pictures, Resizing, Moving, and Rotating Objects, Setting Text Wrap
00:04:18
Image Editing, Adjusting Brightness, Contrast or Sharpness, To Crop a Photo Manually, To Add a Border or Frame to a Photo, To Re
00:05:03
The Word Interface, To Change Views, To Find Text Using the Search Box, Proofing Your Work
00:04:59
Paper Size and Orientation, Margins
00:03:10
Headers and Footers, Page Numbers, Inserting Page Breaks
00:04:58
Character Formatting, Paragraph Formatting
00:08:04
Creating a Basic Table, Entering Data
00:03:53
Aligning Table Data, Working with Numeric Data, Adding Rows and Columns, Borders and Cell Shading
00:03:43
Outline View
00:01:57
Full Screen View
00:05:11
The Excel Interface, Worksheet Navigation
00:04:48
Entering Data, Editing Cell Data
00:03:21
Working with Workbooks
00:04:24
Setting Column and Row Sizes, Reorganizing a Worksheet
00:06:05
Worksheet Formatting, Working with Large Sheets
00:05:01
Formula Basics, To Create a Simple Formula
00:04:02
Using Functions, Copying a Formula to Adjacent Cells
00:05:09
About Tables, Creating a Table, Entering and Editing Data, Changing a Table’s Size, Calculated Columns
00:06:06
Filtering a Table, Sorting a Table, Adding a Total Row
00:02:20
Creating a Chart, Modifying Charts
00:06:00
Creating Sparklines
00:03:25
Protecting Your Data, To Protect a workbook or Worksheet, To password-protect an Excel file, To open a pass-word protected files
00:03:24
Emailing Office Documents, To email an Office document
00:02:30
Working with SkyDrive, To access SkyDrive using a browser, To add files to a folder
00:02:19
To Delete Files on SkyDrive, About the Office Web Apps, Using the Office Web Apps, Office Documents and SkyDrive
00:04:00