MICROSOFT OFFICE PRO 2016 DELUXE Training Tutorial with 7 Quick Reference Guides. Mastering Microsoft Made Easy DELUXE Edition. Versions Covered: 2016 & 2013 Course Length: 42 Hours Video Lessons: 809 Instruction Manuals: 15 (PDF) Included Courses: Access, Excel, OneNote, Outlook, PowerPoint, Publisher, Word Practice Exams: Included Final Exams: Included Certificates of Completion: Included Product Type: Deluxe. Learn Microsoft Office 2016 through 2013 with this comprehensive course from TeachUcomp, Inc. Mastering Microsoft Office Made Easy. Features 809 video lessons with over 42 hours of introductory through advanced instruction on both DVD-ROM to play on your PC or Mac and. Via online for one year (with enclosed Online Key Code) to view the course on your computer or mobile device. In addition, youll get our seven Introductory Quick Reference Guides- printed, laminated guides with step-by-step instructions in the most critical functions (24 pages and 375 topics). Pop in the DVD-ROM or launch the online version to watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our twelve printable classroom instruction manuals in PDF (Introductory, Intermediate, and Advanced), additional images and practice exercises. This complete Microsoft Office course covers the same curriculum as our classroom trainings and was designed to provide a solid foundation in Office. This package also includes an optional practice exam with evaluative feedback, an optional final exam and a Certificate of Completion when you pass the final exam- for each of the seven courses included. Test your knowledge after completing the course and demonstrate your proficiency. Whether you are completely new to Microsoft Office or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Getting Acquainted with Access 1. Creating a New Database 2. Overview of a Database 3. The Access Interface 4. Viewing Database Objects in the Navigation Pane 6. Opening and Closing Databases. Creating Relational Database Tables 1. The “Flat File” Method of Data Storage 2. The Relational Model of Data Storage 3. Tips for Creating a Relational Database 4. Creating Relational Database Tables 5. Assigning a Primary Key to a Table. Using Datasheet View 2. Navigating in Datasheet View 3. Adding Records in Database View 4. Editing and Deleting Records in Datasheet View 5. Inserting New Fields 6. Setting Field Properties 2. The’Field Size’ Property 3. The’Format’ Property for Date/Time Fields 4. The’Format’ Property for Logical Fields 5. Setting Default Values for Fields 6. Setting Input Masks 7. Setting Up Validation Rules and Responses 8. Requiring Field Input 9. Allowing Zero Length Entries. Joining Tables in a Database 1. The Relationships Window 2. Enforcing Referential Integrity 3. Using the Simple Query Wizard 2. Joining Tables in a Query 4. Adding Criteria to the QBE Grid 5. Running A Query 6. How is Using the QBE Grid Writing SQL Code? Sorting Query Results 8. Hiding Fields in a Query 9. Using Comparison Operators 10. Using’AND’ and’OR’ Conditions. Using Wildcard Characters in Criteria 3. Creating a Calculated Field 4. Creating’Top Value’ Queries 5. Advanced Query Types 1. The’Find Duplicates’ Query 7. The’Find Unmatched’ Query. The Form Wizard 3. Form and Report Layout View 6. Form and Report Design View 7. Viewing the Ruler and Gridlines 8. The’Snap to Grid’ Feature 9. Creating a Form in Design View 10. Modifying Form Sections in Design View. Form & Report Controls 1. Moving and Resizing Controls 4. Sizing Controls’To Fit’ 5. Aligning, Spacing and Sizing Controls 7. The Controls Group 2. Adding Label Controls 3. Adding Logos and Image Controls 4. Adding Line and Rectangle Controls 5. Adding Combo Box Controls 6. Adding List Box Controls 7. Using the Subform/Subreport Control. Using the Report Wizard 2. Using Basic Reports 3. Creating a Report in Design View 4. Sorting and Grouping Data in Reports 5. Creating a Standalone Macro 2. Assigning Macros to a Command Button 3. Using Program Flow with Macros 4. Creating Autoexec Macros 5. Creating Data Macros 6. Editing Named Data Macros 7. Renaming and Deleting Named Data Macros. Switchboard and Navigation Forms 1. Creating a Switchboard Form 2. Creating a Navigation Form 3. Getting External Data 2. Setting a Database Password. Using Access Help 2. The Tell Me Bar- 2016 Only. Getting Acquainted with Excel 1. The Excel Environment 3. The Title Bar 4. The “File” Tab and Backstage View 6. The Quick Access Toolbar 8. The Formula Bar 10. The Workbook Window 11. The Status Bar 12. The Workbook View Buttons 13. The Zoom Slider 14. The Mini Toolbar 15. Keyboard Shortcuts File Management 1. Creating New Workbooks 2. Recovering Unsaved Workbooks 6. Opening a Workbook in a New Window 7. Arranging Open Workbook Windows 8. Hiding and Unhiding Workbook Windows 11. Comparing Open Workbooks 12. Switching Open Workbooks 13. Switching to Full Screen View 14. Working With Excel File Formats Data Entry 1. Entering Text into Cells 3. Entering Numbers into Cells 4. Pick from Drop-Down List 6. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Editing a Range 7. Function Compatibility Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Coloring Worksheet Tabs 6. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. Opening The Page Setup Dialog Box 4. Creating Headers and Footers 7. Sheet Settings Printing Spreadsheets 1. Previewing and Printing Worksheets Helping Yourself 1. Using Excel Help 2. The Tell Me Bar- 2016 Only 3. The Smart Lookup and Insights- 2016 Only Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Deleting Named Ranges Conditional Formatting and Cell Styles 1. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special 1. Using Paste Special 2. Pasting Linked Formulas Sharing Workbooks 1. About Sharing Workbooks 2. Simplified Workbook Sharing in Excel 2016 3. Traditional Workbook Sharing 4. Compare and Merge Workbooks Auditing Worksheets 1. Tracing Precedent and Dependent Cells 3. Using the Watch Window 6. Applying and Removing Outlines Consolidating Worksheets 1. Consolidating Data Tables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and Fields. Custom Sort Orders Filtering Data 1. Using the Top 10 AutoFilter 3. Using a Custom AutoFilter 4. Creating Advanced Filters 5. Applying Multiple Criteria 6. Using Complex Criteria 7. Copying Filter Results to a New Location 8. Using Database Functions Using What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal Seek 4. Forecast Sheets- 2016 Only Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions Sparklines 1. Inserting and Deleting Sparklines 2. Modifying Sparklines Creating Charts In Excel 1. Selecting Charts and Chart Elements 3. Adding Chart Elements 4. Moving and Resizing Charts 5. Changing the Chart Type 6. Changing the Data Range 7. Switching Column and Row Data 8. Choosing a Chart Layout 9. Choosing a Chart Style 10. Changing Color Schemes 11. Deleting Charts Formatting Charts in Excel 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Formatting Axis Titles 5. Formatting a Chart Title 6. Formatting Data Labels 7. Formatting a Data Table 8. Formatting Error Bars 9. Formatting a Legend 11. Formatting Drop and High-Low Lines 12. Formatting Up/Down Bars 14. Formatting the Chart and Plot Areas 15. Applying Shape Styles 17. Applying WordArt Styles 18. Saving Custom Chart Templates Data Models 1. Creating a Data Model from External Relational Data 2. Creating a Data Model from Excel Tables 3. Relating Tables in a Data Model 4. Managing a Data Model PivotTables and PivotCharts 1. Creating Recommended PivotTables 2. Manually Creating a PivotTable 3. Creating a PivotChart 4. Manipulating a PivotTable or PivotChart 5. Changing Calculated Value Fields 6. Setting PivotTable Options 9. Sorting and Filtering Using Field Headers PowerPivot 1. Managing the Data Model 3. Calculated Columns and Fields 4. Creating and Managing Perspectives 7. PowerPivot PivotTables and PivotCharts Power View 1. Starting Power View 2. Adding Report Visualizations 3. Changing the Layout of Report Visualizations 4. Using Undo and Redo in Power View 5. Formatting the Power View Sheet 6. Creating Multiples in a Chart 7. Filtering Power View Using the Filter Data 8. Cross-Filtering Visualizations Slicers and Timelines 1. Inserting and Deleting Slicers 2. Inserting and Deleting Timelines 4. Modifying Timelines Security Features 1. Password Protecting Excel Files Making Macros 1. Running and Deleting Recorded Macros 3. The Personal Macro Workbook. Getting Acquainted with OneNote 1. The OneNote Environment 2. The Title Bar 3. The “File” Tab and Backstage View 5. The Quick Access Toolbar 6. The Scroll Bars 7. Opening, Saving and Closing Notebooks 2. Creating New Notebooks 3. Creating, Moving and Deleting Sections and Pages 4. Creating, Moving and Deleting Subpages. Creating a Basic Note 2. Copying and Pasting Content 4. Adding Audio & Video Files 7. Inserting Online Video 8. Recording Audio & Video Files 9. Adding Other Types of Files 10. Embedding an Excel Spreadsheet or Visio Diagram 11. Adding Mathematical Equations 12. Quick Filing – Sending Information to OneNote. Basic Text Formatting 2. Bullets and Numbering 3. Setting Default Proofing Options. Working with Microsoft Outlook 1. Inserting Outlook Meetings 2. Sending Notebook Pages via Microsoft Outlook 3. Working with Microsoft Outlook Tasks. Working with Columns and Rows 3. Formatting Tables and Table Data 4. Moving Tables and Table Data. Formatting Written Notes & Drawings 3. Converting Handwriting to Type. Viewing and Organizing Information 1. Organizing the OneNote Interface 2. Creating New Windows 3. Searching Content in a Notebook 4. Working with Sections 7. Stationery and Templates 1. Applying Templates and Stationery 2. Choosing a Default Template. Defining Paper Size and Margins 2. Formatting Page Backgrounds 3. Adding a Background Graphic. Sharing Notebooks & Collaborating 1. Saving and Exporting Notebooks to Share 2. Creating a Shared Notebook and Inviting Others to Share 3. Sharing Notes in an Outlook Meeting Invitation 4. Sending Pages in Various Formats 6. Finding Newly Added Content with Highlighting 8. The Notebook Recycle Bin. Researching with OneNote 1. The Research Pane 3. Translating Text with the Mini Translator. Changing OneNote Options 1. Customizing the Quick Access Toolbar and Ribbon 2. Getting Acquainted with Outlook 1. The Outlook Environment 2. The Quick Access Toolbar 5. The Navigation Bar, Reading Pane, and To-Do Bar 7. What’s New in Outlook 2016. The People Folder 2. Customizing the Contacts Folder View 3. Basic Contact Management 5. Creating Contact Groups 7. Searching for Contacts 9. Mapping a Contact’s Address. Using the Inbox 2. Changing the Inbox View 3. Searching for Messages 5. Creating, Addressing, and Sending Messages 6. Checking Message Spelling 7. Setting Message Options 8. Replying to Messages 11. Sharing a OneDrive File as an Attachment 14. The Sent Items Folder 1. The Sent Items Folder 2. The Outbox Folder 1. Using the Calendar 1. The Calendar Window 2. Switching the Calendar View 3. Navigating the Calendar 4. Appointments, Meetings and Events 5. Manipulating Calendar Objects 6. Setting an Appointment 7. Scheduling a Meeting 8. Checking Meeting Attendance Status 9. Responding to Meeting Requests 10. Scheduling an Event 11. Printing the Calendar 13. Join Skype Meeting in Outlook 2016 14. Printing the Tasks 3. Creating a Task 4. Setting Task Recurrence 5. Creating a Task Request 6. Responding to Task Requests 7. Sending Status Reports 8. The Deleted Items Folder 2. Permanently Deleting Items 3. Recovering Deleted Items 4. Recovering and Purging Permanently Deleted Items. Creating a New Group 3. Adding Members to Groups 4. Contributing to Groups 5. Managing Files in Groups 6. Accessing the Group Calendar 7. Subscribing to and Unsubscribing from Groups 8. Editing, Managing and Deleting Groups. The Journal Folder 1. The Journal Folder 2. Switching the Journal View 3. Recording Journal Items 4. Recording Journal Items Manually 5. Opening Journal Entries and Documents 6. Creating Public Folders 2. Personal and Private Folders 1. Creating a Personal Folder 2. Setting AutoArchiving for Folders 3. Creating Private Folders 4. Creating and Using Notes. Advanced Mailbox Options 1. Creating Mailbox Rules 2. Creating Custom Mailbox Views 3. Adding Additional Profiles 3. Adding Additional Services 4. Creating a Delegate 2. Acting as a Delegate 3. Getting Acquainted with PowerPoint 1. The PowerPoint Environment 2. The File Tab and Backstage View 5. The Scroll Bars 8. The Presentation View Buttons 9. The Zoom Slider 10. The Status Bar 11. The Mini Toolbar 12. What’s New in PowerPoint 2016. Creating Basic Presentations 1. Creating New Presentations 4. Recovering Unsaved Presentations 6. Inserting New Slides 7. Applying Slide Layouts 8. Working with PowerPoint File Formats. Using Presentation Views 1. Slide Sorter View 4. Notes Page View 5. Slide Show View 6. Adding Text to Slides 2. Basic Object Manipulation 3. Applying Custom Bullets and Numbering 6. Setting Text Options 8. Inserting Pictures Saved Locally 2. Inserting Online Pictures 3. Basic Graphic Manipulation 4. Using Picture Tools 5. Using the Format Picture Task Pane 6. Fill & Line Settings 7. Size & Properties Settings 9. Inserting and Manipulating SmartArt 2. Using Slide Show View 1. Running a Slide Show 2. Printing Your Presentation 1. Changing Slide Size 2. Setting the Slide Header and Footer 3. Previewing and Printing Presentations. Using PowerPoint Help 2. The Tell Me Bar 3. Smart Lookup and Insights. Adding Slide Transition Animation 2. Inserting Video and Sound 1. Animating Multimedia Playback 4. Recording a Sound 5. Creating Custom Color Schemes 3. Creating Custom Font Schemes 4. Customizing the Slide Background. Using Presentation Masters 1. Using Slide Masters and Slide Layouts 2. Using the Notes Master 3. Using the Handout Master 4. Saving a Presentation Template. Setting Up the Presentation 1. Setting Up the Slide Show 2. Inserting Charts, Tables, and Objects 1. Setting PowerPoint Options 1. Getting Acquainted with Publisher 1. The Publisher Environment 2. The Page Layout View Buttons 9. The Zoom Slider and Zoom Button 10. Keyboard Shortcuts Creating Basic Publications 1. Creating New Publications 2. Changing the Publication Template 3. Using Business Information 4. Inserting New Pages 8. Moving Pages Basic Skills 1. Inserting Text Boxes 2. Adding Text to Shapes 4. Inserting Pictures Saved Locally 5. Inserting Online Pictures 6. Inserting Picture Placeholders 7. Using the Scratch Area 8. Moving, Resizing, and Rotating Objects 9. Using Find and Replace 11. Inserting WordArt Formatting Objects 1. Formatting Pictures Using Building Blocks 1. Creating Basic Building Blocks 2. Using Building Blocks Master Pages 1. Creating a Custom Color Scheme 2. Creating a Custom Font Scheme 3. Customizing Page Backgrounds Using Tables 1. Creating and Deleting Tables 2. Selecting Table Elements 3. Inserting and Deleting Columns and Rows 4. Merging Text in Table Cells 5. Modifying Text in Table Cells 6. Formatting Tables Page Setup and Layouts 1. Using Page Setup 2. Using Layout Guides 3. Using the Rulers Mailings 1. Creating a Data Source 4. Inserting and Deleting Merge Fields 6. Previewing a Merge 7. Detaching the Data Source 8. Merging a Catalog Printing 1. Previewing and Printing 2. Using the Pack and Go Feature 3. Sharing and Exporting Publications Helping Yourself 1. Getting Acquainted with Word 1. The Word Environment 3. The Quick Access Toolbar 7. The Scroll Bars 10. The Document View Buttons 11. The Zoom Slider 12. The Status Bar 13. The Mini Toolbar 14. Creating Basic Documents 1. Creating New Documents 4. Recovering Unsaved Documents 6. Moving through Text 8. Changing Document Views 2. Showing and Hiding the Ruler 3. Showing and Hiding Gridlines 4. Showing and Hiding the Navigation Pane 5. Zooming the Document 6. Opening a Copy of a Document in a New Window 7. Arranging Open Document Windows 8. Comparing Open Documents 10. Switching Open Documents 11. Switching to Full Screen View 12. Working with Word File Formats. Basic Editing Skills 1. Cutting, Copying, and Pasting 3. Undoing and Redoing Actions 4. Finding and Replacing Text 5. Selecting Text and Objects. Basic Proofing Tools 1. The Spelling and Grammar Tool 2. Setting Default Proofing Options 3. Using the Thesaurus 4. Finding the Word Count 5. The Font Dialog Box 3. The Format Painter 4. Applying Styles to Text 5. Removing Styles from Text. Line Spacing and Paragraph Spacing. About Documents and Sections 2. Setting Page and Section Breaks 3. Creating Columns in a Document 4. Creating Column Breaks 5. Using Headers and Footers 6. The Page Setup Dialog Box 7. Adding Line Numbers 11. Previewing and Printing Documents. Using Word Help 2. Smart Lookup and Insights- 2016 Only. Working with Tabs 1. Using Tab Stops 2. Using the Tabs Dialog Box. Pictures and Media 1. Inserting Online Pictures 2. Inserting Your Own Pictures 3. Using Picture Tools 4. Using the Format Picture Task Pane 5. Fill & Line Settings 6. Layout & Properties Settings 8. Inserting Screen Clippings 11. Inserting Text Boxes 4. The Format Shape Task Pane 6. Design and Format SmartArt 8. Using Building Blocks 1. Creating Buildings Blocks 2. Bullets and Numbering 1. Applying Bullets and Numbering 2. Formatting Bullets and Numbering 3. Applying a Multilevel List 4. Modifying a Multilevel List. Showing Headings in the Navigation Pane 4. The Styles Task Pane 5. Clearing Styles from Text 6. Creating a New Style 7. Modifying an Existing Style 8. Selecting All Instances of a Style in a Document 9. Deleting Custom Styles 11. Using the Style Inspector Pane 12. Using the Reveal Formatting Pane. Themes and Style Sets 1. Applying a Theme 2. Applying a Style Set 3. Customizing Theme Colors 4. Customizing Theme Fonts 5. Creating Custom Watermarks 3. Selecting a Page Background Color or Fill Effect 5. Applying Bullets and Number 2. Modifying a Multilevel List Style. Selecting Table Objects 4. Inserting and Deleting Columns and Rows 5. Deleting Cells and Tables 6. Merging and Splitting Cells 7. Adjusting Cell Size 8. Aligning Text in Table Cells 9. Converting a Table into Text 10. Inserting Table Formulas 2. Recalculating Word Formulas 3. Inserting a Microsoft Excel Worksheet. Inserting Page Elements 1. Inserting Drop Caps 2. Inserting Ink Equations 4. Using Outline View 2. Promoting and Demoting Outline Text 3. Moving Selected Outline Text 4. Collapsing and Expanding Outline Text. Detaching a Data Source 8. Simplified Document Sharing in Word 2016 2. Posting to a Blog 6. Saving as a PDF or XPS File 7. Saving as a Different File Type. Creating a Table of Contents 1. Creating a Table of Contents 2. Customizing a Table of Contents 3. Updating a Table of Contents 4. Deleting a Table of Contents. Creating an Index 1. Creating an Index 2. Customizing an Index 3. Citations and Bibliography 1. Select a Citation Style 2. Insert a Citation 3. Insert a Citation Placeholder 4. Inserting a Table of Figures 3. Inserting a Cross-reference 4. Updating a Table of Figures. Displaying the Developer Tab 2. Creating a Form 3. Repeating Section Content Control 5. Adding Instructional Text 6. Setting Word Options 2. Setting Document Properties 3. Applying Password Protection to a Document 2. Removing Password Protection from a Document 3. Restrict Editing within a Document 4. Removing Editing Restrictions from a Document. 1 GHz Intel Pentium Processor or equivalent. 256 color SVGA capable of 1024×768 resolution. Any physical product you return must be in the same condition you received it and in the original sealed packaging. This assures that we receive your message. We’re always happy to answer questions. Listing and template services provided by inkFrog. The item “MICROSOFT OFFICE PRO 2016 DELUXE Training Tutorial with 7 Quick Reference Guides” is in sale since Monday, May 11, 2020. This item is in the category “Computers/Tablets & Networking\Software\Office & Business”. The seller is “teachucomp” and is located in East Lansing, Michigan. This item can be shipped worldwide.
- Brand: TeachUcomp, Inc.
- Type: Software Training/IT Tutorials
- MPN: TUMSDELCPEP01
- UPC: 815474012813