Book description
The smart way to learn Microsoft Office Professional 2013—one step at a time!
Experience learning made easy—and quickly teach yourself how to get more done with Microsoft Word, PowerPoint, Excel, Outlook, OneNote, Access, and Publisher. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them!
Determine the best Office tool for specific tasks
Use Office efficiently on touch-enabled devices
Create attractive documents, publications, and presentations
Manage your e-mail, calendar, meetings, and communications
Put your business data to work with Excel and Access
Organize and share your notes and ideas with OneNote
Table of contents
- Microsoft Office Professional 2013
- Dedication
- Introduction
-
I. Office Professional 2013 Fundamentals
- 1. Getting comfortable in Office Professional 2013
- 2. Using shared Office features
- 3. Sharing and collaborating
- 4. Using touch in Office
-
II. Word 2013
- 5. Getting comfortable in Word 2013
- 6. Navigating and reading documents
- 7. Editing and composing documents
- 8. Formatting documents
- 9. Presenting information
- 10. Finalizing documents
-
III. PowerPoint 2013
- 11. Getting comfortable in PowerPoint 2013
-
12. Designing and creating presentations
- Creating a new presentation based on a theme or template
- Applying a theme to an existing presentation
- Customizing your file with colors, fonts, and effects
- Applying theme effects to your presentation
- Adding graphics to the slide master and layouts
- Creating a custom slide layout
- Changing your presentation from a 16:9 to a 4:3 format
- Key points
- 13. Creating on-slide content
- 14. Creating Office graphics
- 15. Adding animation and multimedia
- 16. Finalizing and presenting
-
IV. Excel 2013
- 17. Getting comfortable in Excel 2013
-
18. Creating and editing worksheets
- Entering and organizing data
- Changing column widths
- Using formatting to alter the appearance of data
- Extending a series with AutoFill
- Selecting and naming cell ranges
- Using column headers to define names
- Moving around in the worksheet
- Moving and adjusting cells
- Moving and copying rows and columns
- Copying one or more cells to many
- Key points
-
19. Manipulating numbers and text
- Creating, editing, and copying formulas
- Using functions
- Working with text in Excel
- Restricting cell entries
- Key points
- 20. Analyzing data
- 21. Formatting worksheets
-
22. Manipulating workbooks and worksheets
- Inserting rows and columns
- Inserting and deleting cells
- Working with panes and page layout options
- Printing row and column labels on every page
- Adjusting page breaks
- Creating a multisheet workbook
- Manipulating sheets
- Summarizing a multisheet workbook
- Working with sheet references
- Managing multiple workbooks
- Key points
- 23. Creating charts and graphics
-
V. Outlook 2013
- 24. Getting comfortable in Outlook 2013
- 25. Using mail
- 26. Staying on schedule
- 27. Working with tasks
- 28. Managing contacts and people
-
29. Saving time with Outlook
- Flagging and reviewing important messages
- Using the Calendar peek to plan your schedule
- Planning ahead with the Weather bar
- Organizing your mail with Folder Favorites
- Searching for related messages
- Finding messages from a specific sender
- Conducting quick searches
- Using Search Folders to view today’s mail
- Creating items quickly
- Creating contextual appointments, contacts, and tasks from email messages
- Key points
-
VI. OneNote 2013
- 30. Getting comfortable in OneNote 2013
- 31. Working with notebooks, sections, and pages
-
32. Using organizational tools
- Using tags
- Creating and customizing tags
- Using styles to format your notes
- Connecting OneNote to Outlook
- Connecting OneNote tasks to Outlook
- Using hyperlinks to tie your notes together
- Creating custom hyperlinks to other pages
- Creating and organizing tables
- Using the Insert Table feature
- Searching your notes to find information quickly
- Changing your search scope
- Key points
- 33. Sharing notes with others
- 34. Using OneNote everywhere
- 35. Saving time with OneNote
-
VII. Access 2013
- 36. Getting comfortable in Access 2013
- 37. Understanding Access 2013 databases
- 38. Creating basic tables and queries
- 39. Designing forms and reports
-
40. Creating and sharing a Web App
- Signing in to Office 365
- Creating a blank Web App
- Opening an existing Web App
- Importing data from a spreadsheet
- Importing data from an Access desktop database
- Navigating a Web App with the table selector
- Navigating a Web App with the Navigation pane
- Launching a Web App
- Opening a database in Access from Team Site
- Working with views
- Working with a Datasheet view
- Working with a List Details view
- Adding a new blank table
- Creating a lookup
- Creating a summary view
- Creating a Web App from a template
- Key points
-
VIII. Publisher 2013
- 41. Getting comfortable in Publisher 2013
-
42. Creating publications
- Using templates to create publications
- Adding elements into your publications
- Adding business information to publications
- Customizing the page design of a publication
- Customizing text font, color, and style
- Working with WordArt, text effects, and stylistic sets
- Using picture placeholders and captions
- Importing, swapping, and formatting pictures
- Working with rulers, guides, baselines, and other tools
- Importing Word documents into Publisher
- Key points
- 43. Saving, sharing, and exporting publications
- A. About the authors
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft Office Professional 2013
- Author(s):
- Release date: May 2013
- Publisher(s): Microsoft Press
- ISBN: 9780735671775
You might also like
book
How to Do Everything: Microsoft Office Online
Master Microsoft Office Online and OneDrive How to Do Everything: Microsoft Office Online shows you how …
book
Microsoft Office Excel 2007 On Demand
How to use • Create workbooks more efficiently using a new results-oriented interface • Use data-analysis …
book
Microsoft® Office 2013 QuickSteps, 3rd Edition
Full-color, step-by-step guide to the new release of the world’s most popular productivity suite of applications …
book
Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours
For readers who are new to Excel 11 and want to get up and running quickly, …