Lab Video Highlights
Online Essentials (Chapter 1)
The Internet and Social Media
- Web Browsing with Google Chrome
- Navigate to Websites
- Performing Web Searches
- Using Bookmarks
- Clearing a Browser's Cache
- Configure Pop-up Blocker
Digital Communication
- Send and Receive Outlook Email Messages
- Formatting Messages
- Add and Remove File Attachments
- Forward and Reply to Messages
- Insert Hyperlinks
Online Safety and Security
- Modify Privacy
- Configure Windows Firewall
- Configure Privacy Settings in Google Chrome
- Clear the Browser Cache
- Respond to Social Engineering Attacks
- Configure Google Chrome Pop-ups
Computer Essentials (Chapter 2)
Computer Hardware
- Connect a Monitor
- Set Up a Computer
- Install USB Device
- Connect a Printer
System Software
- Explore Windows 10 Features
- Change Display Settings
- Connect to a Printer
- Share a Printer
- Configure Windows Update
File Management
- Manage and Share Files in Windows
- Manage Files
- Copy Files from a USB Thumb Drive
- Use Shared Storage
- Use OneDrive Storage
Application Software
- Use Desktop Applications
- Run Desktop Applications
- Open and Print a Document in Word
Networking and User Accounts
- Configure Networking and User Accounts
- Create and Remove a User
- Connect to a Wireless Network
- Connect to a public WiFi Network
Databases
- Open Microsoft Access Database Objects
- Enter and Delete Data
- Edit Records
Common Office Features (Chapter 3)
Getting Started with Office
- Create, Open, and Save Files
- Perform Basic Commands within Office Applications
- Modify a Word Document
- Save Files in Various Formats and Locations
- Create New Word Document
Customizing Views and Options
- Switching Document Views
- Changing Zoom Level
- Customizing the Quick Access Toolbar and Ribbon
- Splitting the Window
Printing Files
- Change Print Orientation
- Print on Both Sides
- Change Margins
Navigating Files
- Create Bookmarks
- Add and Remove Hyperlinks
- Use the Go To Feature
Working with Objects
- Insert Pictures, Textboxes, and Shapes
- Apply colors and Styles
- Position Objects on a Slide
Microsoft Word (Chapter 4)
Creating Documents and Using the Clipboard
- Create Documents
- Open Existing Documents
- Enter and Delete Text
- Use the Clipboard
- Insert Text from another Document
- Undo actions
- Prepare a Business Memo
- Reorganize Class Notes
Modifying Fonts
- Font Size
- Font Style
- Font Case
- Font Color
- Subscript
- Superscript
- Prepare a Resume
- Format a Math Worksheet
Formatting Paragraphs
- Aligning
- Indenting
- Shading
- Borders
- Modify Paragraph Spacing
- Add Bulleted Lists
- Observe Paragraph Formatting Marks
- Format a Research Paper
- Format Lists
Formatting Pages
- Adding Watermarks
- Adding Page Borders
- Create and Format Columns
- Insert and Modify Tab Stops
- Change Page Margins
- Change Page Orientation
- Align Text Vertically
- Insert Page and Column Breaks
- Format a Report Draft
- Format a Music Program
Editing Documents
- Find and Replace
- Spell Check and Grammar Check
- Thesaurus
- Change AutoCorrect Options
- Add New AutoCorrect Entries
- Edit an Essay
- Edit a Newspaper Article
Inserting Illustrations and Other Elements
- Inserting Pictures from a File
- Insert Pictures from the Internet
- Resize and Align Pictures
- Modify Text Wrap Settings
- Insert Symbols and Shapes
- Insert Current Date
- Insert Images for a Poster
- Insert Images for a Flyer
Creating and Formatting Tables
- Inserting Tables
- Adding Rows
- Adding Columns
- Formatting Data within Tables
- Format a Calendar
- Format Tables for a Sales Report
Using Themes, Styles, and Templates
- Create Document Based on a Template
- Apply Different Themes
- Apply Heading Styles to Paragraphs
- Modify Existing Styles and Style Sets
- Create a Certificate Using a Template
- Format a Newsletter
Managing References
- Create Citation Sources
- Insert and Edit Citations
- Insert a Bibliography
- Insert Footnotes
- Insert Endnotes
- Manage Essay References
- Add References to a Research Report
Managing Headers, Footers, and Sections
- Insert Page Numbers
- Insert Content into Headers and Footers
- Format Page Numbers and Insert Section Breaks
- Format a Research Paper with Sections
- Format a Survey Report
Using Office Collaboration Features
- Modify Track Changes Options
- Accept Tracked Changes
- Reject Tracked Changes
- Protect a Document
- Inspect a Document
- Check for Accessibility Issues
- Check for Compatibility Issues
- Prepare a Business Memo for Distribution
- Prepare an Online Resume
Word Live Projects
- Create an Event Flyer
- Format a Sales Report
- Format and Add Citations for a White Paper
Microsoft Excel (Chapter 5)
Creating and Managing Workbooks
- Create New Workbooks
- Open Existing Workbooks
- Add Worksheets
- Delete Worksheets
- Navigate Between Worksheets
- Rename Worksheets
- Reorder Worksheets
- Copy Worksheets
- Import Data from a Text File
- Organize a Budget Worksheet
- Import and Organize Research Data
Organizing and Entering Data
- Select Cells
- Enter Titles for Worksheets
- Working with Columns and Rows
- Freezing Columns, Rows, and Panes
- Entering Text into Cells
- Copy and Paste Cell Data
- Insert, Delete, and Hide Rows and Columns
- Undo Actions
- Enter Survey Results Data
- Organize Sales Data
Changing Properties and Printing Worksheets
- Edit Workbook Properties
- Lock Cells
- Unlock Cells
- Protect Worksheet
- Modify Print Settings
- Add Information to Worksheet Headers and Footers
- Prepare and Print Sales Data
- Protect a Budget Worksheet
Formatting Cells
- Add Borders to Cells
- Clear Cell Formatting
- Apply Number Formatting
- Merge Cells Together
- Adjust Column Width
- Adjust Row Height
- Change Font
- Change Font Color
- Chang Background Color
- Apply Preset Styles
- Create a Spreadsheet for a Camping Equipment Store
- Format a Directory
Entering Simple Formulas
- Use SUM, MIN, MAX, AVERAGE, and COUNT
- Use Text Functions
- Use Arithmetic Operators in Formulas
- Use AutoSum
- Copy Formulas with Fill Handle
- Reference Cells in Formulas
- Edit a Spreadsheet for a Cheese Shop
- Edit a Gradebook
Using Advanced Functions
- Use the IF Function
- Use SUMIF, COUNTIF, and AVERAGEIF
- Use Absolute References
- Use Relative References
- Analyze Data at a County Fair
- Review a Toy Company's Sales Data
Displaying Data in Charts
- Create a Chart Based on a Data Range
- Use Different Types of Charts
- Move Charts to Chart Worksheets
- Resize Charts
- Customize Chart Colors, Labels, and Titles
- Update Charts to Include New Data
- Create a Chart for a Stock Portfolio
- Modify an Election Results Chart
Organizing Data Tables
- Format a Data Range as a Table
- Add Rows and Columns to a Table
- Remove Duplicate Records
- Adjust Table Style Options
- Create Conditional Formatting Rules
- Edit Conditional Formatting Rules
- Add Data Bars to a Cell
- Format Sales Data for a Pizza Chain
- Format a Table for Baseball Statistics
Summarizing Complex Data
- Create and Modify Outlines
- Use VLOOKUP Function
- Work With PivotTables
- Improve Data Analytics for a Muffin Café
- Create a Pivot Table for a Hardware Store
Excel Live Projects
- Modify an Expense Report
- Analyze Sales Data
- Analyze Sales Transactions
Microsoft PowerPoint (Chapter 6)
Creating and Managing Presentations
- Create a New Presentation
- Delete Slides
- Reorder Slides
- Hide Slides
- Duplicate Slides
- Save a Presentation in Various Formats
- Create New Slides
- Reorganize Presentation Slides
- Create a New Presentation Using a Template
Format Textual Content
- Modify List Levels and Styles
- Insert Textboxes
- Change Font
- Change Paragraph Style
- Insert Text into Headers and Footers
- Format Text for a Sales Presentation
- Format a Class Report
Designing Slides
- Modify Theme Font
- Modify Theme Color
- Change the Size and Background of Slides
- Modify Slide Layout
- Design a Business Plan Presentation
- Design a Class Presentation
Using Slide Master
- Insert New Slide Masters and Layouts
- Insert and Modify Placeholders
- Add Graphics
- Chose Master Layout Elements
- Edit the Slide Master Theme
- Modify Slide Backgrounds
- Insert Header and Footer Information
- Create a New Slide Master Layout
- Customize a Slide Master Layout
Formatting SmartArt and Shapes
- Format SmartArt Shapes and WordArt
- Copy and Paste Slide Elements
- Align Shapes
- Distribute Shapes
- Group Shapes
- Stack Shapes
- Format Elements in a Class Presentation
- Format a Business Presentation with SmartArt
Formatting Tables and Charts
- Insert Tables and Charts
- Apply Styles and Style Options
- Insert New Data
- Modify other Elements
- Modify a PowerPoint Table
- Prepare a Sales Presentation
Formatting Pictures and Other Media
- Insert Pictures
- Insert Video
- Insert Audio
- Resize and Apply Styles to Pictures
- Modify Video Playback Options
- Insert Hyperlinks
- Format a Class Presentation on Confucius
- Format a Class Presentation on Plato
Applying Animations and Transitions
- Apply Entrance, Exit, Emphasis, and Motion Path Animations to both Text and Objects
- Change Timing and Direction of an Animation
- Apply Various Transitions to Slides
- Change Timing and Duration of Transitions
- Remove both Animations and Transitions
- Add Transitions to a Presentation on Ethics
- Add Animations to an Astronomy Presentation
Delivering Presentations
- Use Spell Checker
- Use Thesaurus
- Add Speaker Notes
- Navigate through a Slideshow
- Use Presenter View
- Print Slides, Handouts, and Speaker Notes
- Prepare for a Presentation on Ethics
- Deliver a PowerPoint Lecture on Solar Eclipses
PowerPoint Live Projects
- Format a Sales Training Presentation
- Format a Sales Report Presentation
- Format a Marketing Campaign Presentation
Microsoft Access (Chapter 7)
Managing Databases
- Open Database Objects
- Enter Data
- Delete Data
- Edit Records
Designing and Creating Tables
- Create New Tables
- Change Field Properties
- Import Data into Tables
- Create Relationships
- Make Lookup Fields
- Create a Student Database
- Create a Library Database
Using Simple Queries
- Create New Queries
- Add Fields to Existing Queries
- Use Text, Numeric and Date Criteria
- Add Totals to Queries
- Add Grouping to Queries
- Create Queries for a School
- Create Queries for a Library
Creating Forms
- Make Forms Based on Tables
- Add Buttons to Forms
- Delete Fields and Labels
- Add Logos
- Apply Themes
- Create Forms for a School
- Create Forms for a Library
Creating Reports
- Use a Report Wizard
- Apply Themes and Logos to a Report
- Adjust Cosmetic Formatting
- Create Reports for a School
- Create Reports for a Library
Microsoft Outlook (Chapter 8)
Sending and Receiving Messages
- Format Messages
- Add and Remove File Attachments
- Forward and Reply to Messages
- Use Tracking Options
- Create and Send a Message to a Sales Manager
- Reply to a Colleague
Managing Messages
- Create Rules
- Create Automatic Replies
- Configure Junk Email Settings
- Sort and Organize Messages
- Configure Basic Auto Archive Settings
- Manage Rules and Replies for Vacation
- Organize and Filter Your Messages
Working with the Calendar
- Schedule Meetings
- Schedule Personal Appointments
- Create Calendars
- Forward Calendars
- Respond to Meeting Invitations
- Modify Calendar Items
- Schedule Calendar Items at Work
- Review and Respond to Calendar Items at Work
Managing Contacts and Groups
- Create and Edit Contacts and Groups
- Import Contacts from External Sources
- Attach Images to Contacts
- Share Contacts
- Create and Modify Contacts at Work
- Create Contact Groups at Work
Technology Demos
Within TestOut Pro Certified: Microsoft Word® we use video lessons to introduce many features and explain why we need them. We also provide demo videos that show how to perform required tasks in our skill labs.