Microsoft office professional 2013 : step by step /
Beth Melton (et. al..)
- Delhi: PHI Learning Private Limited, 2013.
- xxv, 1184 pages: ill; 23 cm.
include index.
Part 1 : Office Professional 2013 fundamentals. 1. Getting comfortable in Office Professional 2013 : Exploring the Office environment ; Working with Office files ; Recovering unsaved files and versions ; Customizing the user interface ; Customizing the ribbon ; Choosing the right application for the task at hand 2. Using shared Office features : Identifying new shared features in Office Professional 2013 ; Applying Office themes ; Inserting graphics, videos, charts, and diagrams ; Searching for online templates ; Presenting Office documents online 3. Sharing and collaborating : Defining the term cloud service ; Signing in and managing your Office account ; Connecting cloud services to your Office account ; Syncing files with SkyDrive for offline use ; Getting started with co-authoring 4. Using touch in Office : Getting comfortable with Office on a tablet ; Using touch mode ; Selecting content with touch ; Working with ink in Office. Part 2 : Word 2013. 5. Getting comfortable in Word 2013 : Exploring the Word 2013 user interface ; Modifying your document view ; Changing other view options ; Discovering what's new in Word 2013 6. Navigating and reading documents : Navigating a document by scrolling and using keyboard shortcuts ; Searching and navigating a document by using the Navigation pane ; Collapsing and expanding document content ; Working with documents in a new Read mode ; Exploring research tools in Read Mode 7. Editing and composing documents : Moving the cursor by using keyboard shortcuts ; Selecting text by using the keyboard and mouse ; Using formatting marks during document composition ; Inserting symbols, international characters, and other special characters ; Using AutoCorrect ; Composing documents faster by using building blocks 8. Formatting documents : Formatting documents more effectively ; Setting default document formatting for your documents ; Setting section formatting ; Using styles for paragraph and character formats ; Exploring other paragraph formats ; Exploring other character formats ; Managing pagination through formatting 9. Presenting information : Formatting simple lists by using bullets and numbering ; Creating tabbed lists ; Inserting tables ; Enhancing tables 10. Finalizing documents : Correcting proofing errors ; Inspecting documents before publishing ; Marking documents as final ; Creating PDF files in Word ; Printing documents. Part 3 : PowerPoint 2013. 11. Getting comfortable in PowerPoint 2013 : Getting started working with PowerPoint 2013 ; Exploring the PowerPoint 2013 tools ; Discovering the new features 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 13. Creating on-slide content : Choosing a slide layout and adding text in placeholders ; Adding manual text boxes ; Adding and formatting a table ; Inserting and formatting charts ; Creating and formatting SmartArt diagrams ; Reusing slides and keeping their source formatting 14. Creating Office graphics : Adding and formatting shapes ; Applying enhanced fills and effects ; Creating your own shapes ; Inserting, cropping, and formatting pictures 15. Adding animation and multimedia : Adding animation to text and shapes ; Editing video and applying transitions ; Inserting and playing online video ; Saving your presentation as a video 16. Finalizing and presenting : Adding and renaming sections ; Inserting comments ; Printing slides and notes ; Finalizing your presentation ; Delivering a presentation ; Practicing with Presenter view. Part 4 : Excel 2013. 17. Getting comfortable in Excel 2013 : Starting Excel 2013 ; Identifying what's new 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 19. Manipulating numbers and text : Creating, editing, and copying formulas ; Using functions ; Working with text in Excel ; Restricting cell entries 20. Analyzing data : Exploring a built-in template ; Performing what-if analyses ; Using the Quick Analysis tools ; Formatting conditionally ; Analyzing data from another source ; Filtering data with tables ; Adding data to tables ; Sorting data ; Creating a custom sort list ; Creating a PivotTable 21. Formatting worksheets : Applying number formatting ; Formatting with styles ; Creating custom themes ; Formatting in cells ; Working with custom number formats ; Working with percentage formats ; Working with fraction formats ; Working with date formats ; Protecting worksheets ; Setting view options ; Storing formats in templates 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 23. Creating charts and graphics : Creating and modifying a chart ; Adding a slicer to a PivotChart ; Adding a timeline to a chart ; Manipulating objects ; Creating and sharing graphics. Part 5 : Outlook 2013. 24. Getting comfortable in Outlook 2013 : Setting up an email account in Outlook ; Navigating the Outlook interface ; Discovering what's new in Outlook 2013 25. Using mail : Creating and sending messages ; Attaching files to messages ; Viewing messages and message attachments ; Configuring Reading pane behavior ; Responding to messages 26. Staying on schedule : Scheduling and changing appointments ; Scheduling and changing meetings ; Responding to meeting requests ; Displaying different views of a calendar ; Using the Date Navigator 27. Working with tasks : Creating tasks from scratch ; Setting task options ; Creating tasks from Outlook items ; Updating tasks ; Removing tasks and items from task lists ; Managing task assignments ; Reclaiming an assigned task ; Dealing with tasks other people assign to you 28. Managing contacts and people : Viewing contacts ; Using inline editing ; Managing linked contacts ; Configuring a social network account ; Viewing social network updates 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. Part 6 : OneNote 2013. 30. Getting comfortable in OneNote 2013 : Getting started with OneNote 2013 ; Exploring the OneNote interface ; Identifying new and improved features in OneNote 2013 31. Working with notebooks, sections, and pages : Creating a notebook ; Creating and organizing sections ; Creating and organizing pages ; Working with ink and shapes ; Recovering deleted sections or 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 33. Sharing notes with others : Creating a new notebook on SkyDrive ; Moving a notebook to SkyDrive ; Using a file server to share notes ; Sharing notes via SharePoint ; Sharing notes with others during a meeting ; Sending notes via email ; Exporting to other formats 34. Using OneNote everywhere : Syncing your notes by using SkyDrive ; Accessing your notes in a web browser ; Using OneNote on your phone or tablet ; Using OneNote on an iPhone or iPad ; Using OneNote Mobile for Android ; Using OneNote Mobile on a Windows phone ; Using OneNote with a Windows 8 tablet 35. Saving time with OneNote : Finding tags ; Recording audio ; Using Quick Notes ; Using screen clipping ; Using linked notes ; Searching your images ; Inserting a spreadsheet ; Using the Napkin Math feature ; Formatting with templates. Part 7 : Access 2013. 36. Getting comfortable in Access 2013 : Starting Access 2013 ; Looking at the desktop database window ; Exploring the Web App window ; Displaying results in a browser ; Discovering what's new in Access 2013 37. Understanding Access 2013 databases : Creating a desktop database ; Importing and exporting data ; Navigating the user interface ; Working with data in a database ; Copying and pasting from a datasheet ; Configuring Access options ; Linking access to external data ; Compacting, repairing, and encrypting a database 38. Creating basic tables and queries : Creating tables for your data ; Adding validation and calculated fields to your tables ; Linking tables together with relationships ; Creating a select query ; Working with query criteria ; Adding parameters to queries ; Working with totals and crosstab queries 39. Designing forms and reports : Creating a continuous form ; Creating a single record form ; Creating a parent/child form ; Tying your forms together with a navigation form ; Creating a single record report ; Creating a tabular report with grouping ; Creating a parent/child report 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. Part 8 : Publisher 2013. 41. Getting comfortable in Publisher 2013 : Exploring the Publisher 2013 user interface ; Discovering what's new in Publisher 2013 ; 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 43. Saving, sharing, and exporting publications : Saving your publications ; Sharing publications via email ; Printing your publications ; Saving for photo printing or commercial printing ; Exporting publications to PDF or XPS format
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!