Microsoft office 2013 : Illustrated, first course / Beskeen/Cram/Duffy/Friedrichsen/Reding. [print]

WORD 2013 -- Unit E Creating and Formatting Tables -- Unit F Illustrating Documents with Graphics -- Unit G Working with Themes and Building Blocks -- Unit H Merging Word Documents -- Understand Mail Merge -- EXCEL 2013 -- Unit E Analyzing Data Using Formulas -- Unit F: Managing Workbook Data -- Unit G: Managing Data Using Tables -- Unit H Analyzing Table Data -- IndianaTEGRATION 2013 -- Unit D Integrating Word and Excel -- ACCESS 2013 -- Unit E Modifying the Database Structure -- Unit F: Improving Queries -- Unit G Enhancing Forms -- Unit H Analyzing Data with Reports -- IndianaTEGRATION 2013 -- Unit E Integrating Word, Excel, and Access -- POWERPOINT 2013 -- Unit E Working with Advanced Tools and Masters -- Unit F Enhancing Charts -- Unit G Inserting Graphics, Media, and Objects -- Unit H Using Advanced Features -- IndianaTEGRATION 2013 -- Unit F Integrating Word, Excel, Access, and PowerPoint -- CLOUD -- Appendix: Working in the Cloud.

Machine generated contents note: Concepts 2013 -- Unit A Understanding Essential Computer Concepts -- Recognize You Live and Work in the Digital World -- How to be a good online citizen -- Distinguish Types of Computers -- Computers are more personal than ever -- Identify Computer System Components -- About microprocessor speeds -- Compare Types of Memory -- Upgrading RAM -- Summarize Types of Storage Media -- Rewriting on optical storage -- Differentiate Between Input Devices -- Understanding assistive devices -- Explain Output Devices -- About multifunction printers -- Describe Data Communications -- How computers represent and interpret data -- Define Types of Networks -- Understanding telecommunications -- Assess Security Threats -- Protecting information with passwords -- Understand System Software -- Examining Windows 8 hardware requirements -- Describe Types of Application Software -- Practice -- Windows8 -- Unit A Getting Started with Windows 8 -- Start Windows 8 --

Contents note continued: Using touch screens -- Navigate the Start Screen and Desktop -- Point, Click, and Drag -- Using newer touch devices -- Start an App -- Searching for apps and files -- Work with a Window -- Using the Quick Access toolbar -- Manage Multiple Windows -- Use Command Buttons, Menus, and Dialog Boxes -- Get Help -- Finding other ways to get help -- Using right-clicking -- Exit Windows 8 -- Installing updates when you exit Windows -- Practice -- Unit B Understanding File Management -- Understand Files and Folders -- Plan your file organization -- Create and Save a File -- Explore the Files and Folders on Your Computer -- Change File and Folder Views -- Snapping Windows 8 apps -- Open, Edit, and Save Files -- Comparing Save and Save As -- Using cloud storage -- Copy Files -- Copying files using Send to -- Move and Rename Files -- Using Windows 8 libraries -- Search for Files, Folders, and Programs -- Using the Search Tools tab in File Explorer --

Contents note continued: Delete and Restore Files -- More techniques for selecting and moving files -- Practice -- Internet Explorer -- Unit A Getting Started with Internet Explorer 10 -- Understand Web Browsers -- Internet Explorer 10 Metro version -- Explore the Browser -- Understanding the status bar -- View and Navigate Pages -- Setting the home page -- Use Tabbed Browsing -- Understanding URLs -- Save Favorite Web Pages -- Creating and organizing favorites -- Browse Safely -- Phishing and the SmartScreen Filter -- Search for Information -- Blocking pop-ups -- Share Information -- Printing a Web page -- Practice -- Building an international community -- Office 2013 -- Unit A Getting Started with Microsoft Office 2013 -- Understand the Office 2013 Suite -- What is Office 365? -- Start an Office App -- Starting an app using Windows -- Using shortcut keys to move between Office programs -- Using the Office Clipboard -- Identify Office 2013 Screen Elements --

Contents note continued: Using Backstage view -- Create and Save a File -- Saving files to SkyDrive -- Open a File and Save It with a New Name -- Exploring File Open options -- Working in Compatibility Mode -- View and Print Your Work -- Customizing the Quick Access toolbar -- Creating a screen capture -- Get Help, Close a File, and Exit an App -- Enabling touch mode -- Recovering a document -- Practice -- Word 2013 -- Unit A Creating Documents with Word 2013 -- Understand Word Processing Software -- Planning a document -- Explore the Word Window -- Start a Document -- Save a Document -- Microsoft SkyDrive and Microsoft Office Web Apps -- Select Text -- Format Text Using the Mini Toolbar and the Ribbon -- Use a Document Template -- Using the Undo, Redo, and Repeat commands -- Navigate a Document -- Using Word document views -- Practice -- Unit B Editing Documents -- Cut and Paste Text -- Using keyboard shortcuts -- Copy and Paste Text --

Contents note continued: Splitting the document window to copy and move items in a long document -- Use the Office Clipboard -- Copying and moving items between documents -- Find and Replace Text -- Navigating a document using the Navigation pane and the Go To command -- Check Spelling and Grammar -- Inserting text with AutoCorrect -- Research Information -- Publishing a blog directly from Word -- Using a dictionary and other apps for Word -- Add Hyperlinks -- Sharing documents directly from Word, including e-mailing and faxing -- Work with Document Properties -- Viewing and modifying advanced document properties -- Practice -- Unit C Formatting Text and Paragraphs -- Format with Fonts -- Adding a drop cap -- Use the Format Painter -- Underlining text -- Change Line and Paragraph Spacing -- Formatting with Quick Styles -- Align Paragraphs -- Formatting a document using themes -- Work with Tabs -- Work with Indents -- Applying text effects and clearing formatting --

Contents note continued: Add Bullets and Numbering -- Creating multilevel lists -- Add Borders and Shading -- Highlighting text in a document -- Insert Online Pictures -- Practice -- Unit D Formatting Documents -- Set Document Margins -- Changing orientation, margin settings, and paper size -- Create Sections and Columns -- Changing page layout settings for a section -- Insert Page Breaks -- Controlling automatic pagination -- Insert Page Numbers -- Moving around in a long document -- Inserting Quick Parts -- Add Headers and Footers -- Adding a custom header or footer to the gallery -- Insert a Table -- Add Footnotes and Endnotes -- Customizing the layout and formatting of footnotes and endnotes -- Insert Citations -- Manage Sources and Create a Bibliography -- Working with Web sources -- Practice -- Excel 2013 -- Unit A Getting Started with Excel 2013 -- Understand Spreadsheet Software -- Identify Excel 2013 Window Components -- Using SkyDrive and Web Apps --

Contents note continued: Understand Formulas -- Enter Labels and Values and Use the AutoSum Button -- Navigating a worksheet -- Edit Cell Entries -- Recovering unsaved changes to a workbook file -- Enter and Edit a Simple Formula -- Understanding named ranges -- Switch Worksheet Views -- Choose Print Options -- Printing worksheet formulas -- Scaling to fit -- Practice -- Unit B Working with Formulas and Functions -- Create a Complex Formula -- Using Apps for Office to improve worksheet functionality -- Reviewing the order of precedence -- Insert a Function -- Type a Function -- Using the Count and Counta functions -- Copy and Move Cell Entries -- Inserting and deleting selected cells -- Understand Relative and Absolute Cell References -- Using a mixed reference -- Copy Formulas with Relative Cell References -- Using Paste Preview -- Using Auto Fill options -- Copy Formulas with Absolute Cell References -- Using the fill handle for sequential text or values --

Contents note continued: Round a Value with a Function -- Creating a new workbook using a template -- Practice -- Unit C Formatting a Worksheet -- Format Values -- Formatting as a table -- Change Font and Font Size -- Inserting and adjusting online pictures and other images -- Change Font Styles and Alignment -- Rotating and indenting cell entries -- Adjust the Column Width -- Changing row height -- Insert and Delete Rows and Columns -- Hiding and unhiding columns and rows -- Adding and editing comments -- Apply Colors, Patterns, and Borders -- Working with themes and cell styles -- Apply Conditional Formatting -- Managing conditional formatting rules -- Rename and Move a Worksheet -- Copying, Adding, and Deleting worksheets -- Check Spelling -- Emailing a workbook -- Practice -- Unit D Working with Charts -- Plan a Chart -- Create a Chart -- Creating sparklines -- Move and Resize a Chart -- Moving an embedded chart to a sheet -- Change the Chart Design --

Contents note continued: Creating a combination chart -- Working with a 3-D chart -- Change the Chart Format -- Adding data labels to a chart -- Format a Chart -- Previewing a chart -- Changing alignment and angle in axis labels and titles -- Annotate and Draw on a Chart -- Adding SmartArt graphics -- Create a Pie Chart -- Practice -- Integration 2013 -- Unit A Integrating Word and Excel -- Integrate Data Between Word and Excel -- Understanding object linking and embedding (OLE) -- Copy Data from Excel to Word -- Copy a Chart from Excel to Word -- Create Linked Objects -- Opening linked files and reestablishing links to charts -- Embed a Word File in Excel -- Practice -- Access 2013 -- Unit A Getting Started with Access 2013 -- Understand Relational Databases -- Explore a Database -- Create a Database -- Create a Table -- Creating a table in Datasheet View -- Create Primary Keys -- Learning about field properties -- Relate Two Tables -- Enter Data --

Contents note continued: Changing from Navigation mode to Edit mode -- Cloud computing -- Edit Data -- Resizing and moving datasheet columns -- Practice -- Unit B Building and Using Queries -- Use the Query Wizard -- Work with Data in a Query -- Hiding and unhiding fields in a datasheet -- Freezing and unfreezing fields in a datasheet -- Use Query Design View -- Adding or deleting a table in a query -- Sort and Find Data -- Filter Data -- Using wildcard characters -- Apply And Criteria -- Searching for blank fields -- Apply Or Criteria -- Format a Datasheet -- Practice -- Unit C Using Forms -- Use the Form Wizard -- Create a Split Form -- Use Form Layout View -- Table layouts -- Add Fields to a Form -- Bound versus unbound controls -- Modify Form Controls -- Create Calculations -- Modify Tab Order -- Layout positioning -- Insert an Image -- Applying a background image -- Practice -- Unit D Using Reports -- Use the Report Wizard -- Changing page orientation --

Contents note continued: Use Report Layout View -- Review Report Sections -- Apply Group and Sort Orders -- Add Subtotals and Counts -- Resize and Align Controls -- Precisely moving and resizing controls -- Format a Report -- Create Mailing Labels -- Practice -- Integration 2013 -- Unit B Integrating Word, Excel, and Access -- Integrate Data Among Word, Excel, and Access -- Import an Excel Worksheet into Access -- Copy a Word Table to Access -- Link an Access Table to Excel and Word -- Link an Access Table to Word -- Opening linked files and enabling content -- Practice -- PowerPoint 2013 -- Unit A Creating a Presentation in PowerPoint 2013 -- Define Presentation Software -- Using PowerPoint on a touch screen -- Plan an Effective Presentation -- Understanding copyright -- Examine the PowerPoint Window -- Viewing your presentation in gray scale or black and white -- Enter Slide Text -- Saving fonts with your presentation -- Add a New Slide -- Entering and printing notes --

Contents note continued: Apply a Design Theme -- Customizing themes -- Compare Presentation Views -- Print a PowerPoint Presentation -- Microsoft Office Web Apps -- Practice -- Unit B Modifying a Presentation -- Enter Text in Outline View -- Using proofing tools for other languages -- Format Text -- Replacing text and fonts -- Convert Text to SmartArt -- Choosing SmartArt graphics -- Insert and Modify Shapes -- Use the Eyedropper to match colors -- Rearrange and Merge Shapes -- Changing the size and position of shapes -- Edit and Duplicate Shapes -- Editing points of a shape -- Align and Group Objects -- Distributing objects -- Add Slide Footers -- Creating superscript and subscript text -- Practice -- Unit C Inserting Objects into a Presentation -- Insert Text from Microsoft Word -- Sending a presentation using email -- Insert and Style a Picture -- Saving slides as graphics -- Insert a Text Box -- Changing text box defaults -- Insert a Chart -- Enter and Edit Chart Data --

Contents note continued: Adding a hyperlink to a chart -- Insert Slides from Other Presentations -- Working with multiple windows -- Insert a Table -- Drawing tables -- Insert and Format WordArt -- Saving a presentation as a video -- Practice -- Unit D Finishing a Presentation -- Modify Masters -- Create custom slide layouts -- Customize the Background and Theme -- Use Slide Show Commands -- Set Slide Transitions and Timings -- Rehearsing slide show timings -- Animate Objects -- Attaching a sound to an animation -- Use Proofing and Language Tools -- Checking spelling as you type -- Inspect a Presentation -- Digitally sign a presentation -- Evaluate a Presentation -- Setting permissions -- Practice -- Integration 2013 -- Unit C Integrating Word, Excel, Access, and PowerPoint -- Integrate Data Among Word, Excel, Access, and PowerPoint -- Import a Word Outline into PowerPoint -- Embed an Excel Worksheet in PowerPoint -- Link Access and Excel Objects to PowerPoint -- Manage Links --

Contents note continued: Practice -- Outlook 2013 -- Unit A Getting Started with Email -- Communicate with Email -- Use Email Addresses -- Create and Send Emails -- Understanding message headers in emails you receive -- Understand Email Folders -- Managing your email -- Receive and Reply to Emails -- Setting up vacation responses -- Forward Emails -- Controlling your message -- Flagging or labeling messages -- Send Email Attachments -- Reviewing options when sending messages -- Employ Good Email Practices -- Creating distribution lists -- Practice -- Unit B Managing Information Using Outlook -- Describe Outlook -- Weather in Calendar view -- Organize Email -- Manage Your Contacts -- Manage Your Calendar -- Sending electronic business cards -- Manage Tasks -- Create Notes -- Customizing Outlook Today -- Integrate Social Connectors -- Apply Categories -- Coordinating calendars -- Practice -- Cloud -- Appendix: Working in the Cloud -- Understand Office 2013 in the Cloud --

Contents note continued: Work Online -- Getting a Microsoft account -- Explore SkyDrive -- How to disable default saving to Skydrive -- Manage Files on SkyDrive -- Share Files -- Co-authoring documents -- Explore Office Web Apps -- Exploring other Office Web Apps -- Team Project -- Capstone Projects -- Word 2013 Capstone Project 1 -- Word 2013 Capstone Project 2 -- Excel 2013 Capstone Project 1 -- Excel 2013 Capstone Project 2 -- Access 2013 Capstone Project 1 -- Access 2013 Capstone Project 2 -- PowerPoint 2013 Capstone Project 1 -- PowerPoint 2013 Capstone Project 2 -- Integration Capstone Project 1 -- Integration Capstone Project 2.

COPYRIGHT NOT covered - Click this link to request copyright permission: