Description
CONTENTS:Basic Tasks and Introductions
In these first few chapters, I'll introduce tasks that are common to all applications, such as collective features of the Ribbon and tabs, the File Menu, and configuring options. Once the reader is familiar with the interface, they will create a new document in various applications, type text, input data, insert pictures, and explore various view. With that complete, the reader will learn to save, print, and share data. These are things that are very similar across applications and, once grasped, will allow the reader to move forward quickly. I will encourage readers to read these chapters in order, and then skip to the section or chapter that interests them.
Chapter 1. Getting Started with Microsoft Office
a. What is Microsoft Office?
b. Start any Microsoft Office Application
c. Create a shortcut to an application
d. Explore the Ribbon and Tabs
e. Understand the File menu
f. Explore Office Options
Chapter 2. Work with Documents and Text
a. Create a new document in any application
b. Type text
c. Format text (basic - more in chapters for each application as applicable to it)
d. Use the mini toolbar
e. Check spelling and grammar
f. Insert a picture
g. Edit a picture
h. Insert clip art
i. Insert a table
j. Input data into a cell or table
k. Create a new document from a template
l. Replace data with your own
m. Use Zoom
n. Explore views
Chapter 3. Save, Share, and Print
a. Understand where files are saved
b. Save a file
c. Open and edit a file
d. Organize files
i. Create subfolders
ii. Move files
iii. Rename files
iv. Delete a file
e. Email a file
f. Use Print Preview
g. Choose paper size and orientation
h. Print a file
i. Explore additional Save and Send options
i. Send as fax
ii. Save to SharePoint
iii. Office Live Workspace
Word
In this section, readers will learn how to format text in Word, including applying themes, bulleted and numbered lists, using Find and Replace, and similar Word-related tasks. Then, I'll focus on creating things, like family newsletters, blogs, flyers, and the like.
Chapter 4. Word Basics
a. Explore the Word interface
b. Move around in a document
c. Select and replace text
i. Include Find and Replace
d. Create bulleted and numbered lists
e. Apply styles and style sets
f. Use the Format Painter
g. Set margins and tab stops
h. Align and indent paragraphs
i. Explore templates:
i. Resumes
&nbsnbsp; ii. Awar iii. Calendars
iv. Invitations
v. Business Cards
vi. Invoices
vii. Greeting Cards
Chapter 5. Create a Flyer, Brochure, or For Sale Sign
a. Input and align text
b. Create columns of text
c. Work with pictures and clip art
i. Resize
ii. Add special picture elements
iii. Wrap text around a picture or clip art
d. Add a page border
e. Apply a background to a page
f. Use Print Preview
Chapter 6. Create a Booklet, Newsletter, or Novel
a. Insert a date and time
b. Input special text and data
c. Input a table
d. Format a table
e. Insert additional pages
f. Number pages
g. Create headers and footers
h. Create a Table of Contents
Chapter 7. Share and Print
a. Create a Mail Merge
b. Print labels
c. Print envelopes
d. Post to a blog
e. Create a PDF document
Excel
In this section, readers will learn how to enter data in Excel, format cells, select a range, and insert rows and columns. Then they'll learn about formulas, sorting and structuring data, and then how to apply their knowledge to plan budgets,create invoices, use financial formulas, and more. They'll also learn how to keep address lists and other important information in an Excel database.
Chapter 8. Excel Basics
a. Explore the Excel interface
b. Move around in a worksheet
c. Edit data
d. Format cells
e. Format the entire spreadsheet
f. Insert rows and columns
g. Explore templates:
i. Budgets
ii. Expense Reports
iii. Invoices
iv. Planners
v. Lists
&nbsbsp; vi.  ceipts
vii. Schedules
viii. Stationary
Chapter 9. Formulas, Tables, Charts, and Databases
a. Select a range
b. Apply a sum
c. Apply an average
d. Learn how formulas are structured
i. Order of operations
ii. Create your own formula
iii. Use the format painter
e. Explore basic functions
f. Explore financial functions
g. Create a basic chart
h. Format a chart
i. Create a basic table
j. Format a table
k. Create a database of names and addresses
Chapter 10. Create a Budget, Invoice, Label Sheet, Time Sheet, and more
a. Templates are the best
b. Personalize a template
c. Input your own data
d. Input your own headings
e. Tweak a formula
f. Format a table or chart
Chapter 11. Share and Print
a. Create a PDF
b. Protect your workbook
c. Explore previous versions
d. Print a page
e. Print a workbook
Outlook
Outlook can be a bit overwhelming at first, so in this section I'll first detail how to set up and use an email account, and then I'll spend a chapter detailing the interface and various applications in it, including Calendar, Tasks, Contacts, and Notes. With that done, the remaining chapter will focus on staying organized, using the Calendar, and creating to-do lists and notes.
Chapter 12. Outlook and Email
a. Set up an email account
b. Troubleshoot set up problems
c. Explore the Outlook Interface
d. Receive, read, reply, and forward email
e. Print an email
f. Open, view, and save attachments
g. Sidebar: Avoid scams, fraud, and viruses
h. Compose a new message
i. Use Contacts
ii. Add and format text
iii. Insert a picture or clip art
iv. Attach a file
i. Change settings
i. How often Outlook check for mail
ii. Check spelling
iii. Customize the Ribbon
p; ivsp; Explore junk email options
j. Explore views
Chapter 13. Contacts, Calendar, Notes, and Tasks
a. Explore the Contacts interface
b. Add a contact
c. View and edit contacts
d. Explore the Calendar interface
e. Explore Calendar views
f. Add an appointment
g. Email your Calendar
h. Explore the Notes interface
i. Add a note
j. Manage notes
k. Share a note
l. Explore the Tasks interface
m. Add a task
n. Manage tasks
o. Share tasks
Chapter 14. Stay Organized and Be Efficient
a. Create an email group
b. Keep your Inbox clean
i. Create subfolders
ii. Move mail into subfolders
c. Use the Folder view
d. Flag email and add a reminder
e. Explore Outlook Today
f. Change your Outlook View
g. Create yearly reminders
h. Organize Notes in color categories
i. Use Search Folders
j. Maintain Outlook
PowerPoint
In this chapter the reader will learn their way around PowerPoint and how to create slideshows with photos, animation, and sound, among other things.
Chapter 15. PowerPoint Basics
a. Explore the PowerPoint interface
b. Create a new slide
c. Change the slide layout
d. Move and resize content
e. Select, edit, and format text
f. Apply a theme
g. Insert pictures and clip art
h. Add transitions
i. Add animations
j. Add music
k. Move around in a presentation
l. Explore Templates:
i. Content and design slides
ii. Award Certificates
iii. Presentations
iv. Calendars
v. Flyers
vi. Forms
vii. Stationary
Chapter 16. Create a Photo Album Presentation
a. Select photos
b. Create slides
c. Order slides
d. Choose music
e. Repeat and shuffle?
f. Play the photo presentation
Chapter 17. Create a presentation for a retirement party, club, birthday, wedding, or anniversary
a. Choose a theme
b. Sketch out length and content
c. Create your first slide
d. Scan or acquire photos and music
e. Insert pictures and music
f. Review your show
g. Reorder and edit slides
h. Play your show
Chapter 18. Share and Print
a. Display a presentation
b. Use presentation tools
c. Print copies of a presentation
d. Print handouts
e. Save a presentation to a CD
f. Email a presentation
Published
28 Mar 2011
Publisher
PRENTICE-HALL
ISBN
9780273745723
Pages
279
Static Book Details Index Page - Click Here to go to Computer Manuals Website