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: