horizon -

Desktop Office Skills

    Need to brush up on your spreadsheet or PowerPoint skills? Want to learn how to use Microsoft’s latest operating system: Windows 7? Want to know what’s different in MS Office 2010? This course might be what you’re looking for. It covers some of the most widely used office applications which make it ideal for office workers or anyone wishing to learn how to use these programs.

    Our Desktop Office Skills training package covers the entire Microsoft Office 2007 suite, plus a module on the newly released Microsoft Office 2010. It also has dedicated modules in Excel (spreadsheets), Access (databases), and PowerPoint (Presentations). There is even an advanced module in Excel for anyone needing in depth training in spreadsheets. This is ideal for people working in accounting, bookkeeping, finance or sales.

    The Desktop Office Skills package also contains training on the highly popular Adobe Acrobat program. This is used by businesses to convert and send documents in PDF (Portable Document Format). With its widespread use across the business field, learning how to use Adobe Acrobat is a must.

    Our Desktop Office Skills package is part of our total training series – designed as a rich learning experience which includes full video presentations, sound, and interactive tasks. You can pause a lesson, rewind, fast-forward and jump to another stage. The system will even record your progress and scores when taking a test. Best of all, because the course is online, you can do it anywhere in the world, anytime of the day as long as you have an internet connection. It’s the total training you’re looking for.

    Call us if you would like more information on this course.

    This is an online Total Training (TT) Series course package.  Read our FAQs for more details.

    Adobe Acrobat 9 Pro: Essentials

    Category: Business Productivity
    Presenter: James Lockman
    Platform: Windows & MAC OS
    Format: Online
    Running Time: 5 Hrs
    Level: Beginner to Advanced
    Project Files: Included

    Description

    This series will open your eyes to all the essential features available in Acrobat 9 and will show you just how easy using Acrobat in your workflow can be. During the series, you’ll discover the Acrobat interface and learn about how to create, manage and use PDF in ways you’ve probably never considered. You’ll also learn about how to use Acrobat to collaborate with co-workers, no matter where they are. This training is just what you need to increase your productivity and improve your skills when working with Acrobat 9.

    Course Outline

    Chapter 1: Introduction to the Interface

    1. Acrobat Preferences
    2. Toolbars & the Navigation Panel
    3. Common Toolbar Options
    4. Page View Modes & the Help System

    Chapter 2: Navigating PDF’s

    1. Using the Menu Bar & the Pages Panel to Navigate
    2. Selecting & Copying Content, Rulers & Guides
    3. Entering Form Data
    4. Creating & Managing Bookmarks
    5. Hyperlinks & Searching
    6. Saving & Exporting PDFs in Different Formats

    Chapter 3: Creating PDF’s

    1. Direct Export & Distill a PDF
    2. Editing Standard PDF Settings
    3. Image Settings
    4. Font Settings
    5. Color & Advanced Settings
    6. Printing to PDF
    7. Combining Files into a Single PDF
    8. Creating PDF Portfolios
    9. Building a PDF from a Web Page

    Chapter 4: Windows – Only PDF Creation Features

    1. Using Acrobat PDFMaker in Microsoft® Word
    2. Using Acrobat PDFMaker in Microsoft PowerPoint
    3. Using Acrobat PDFMaker in Microsoft Publisher
    4. Using Acrobat PDFMaker in Microsoft Excel®
    5. Creating a PDF from Windows Explorer

    Chapter 5: Manipulating PDFs

    1. Inserting, Deleting & Replacing Pages
    2. Adding Headers & Footers
    3. Adding Watermarks & Background Images
    4. Comparing Two PDFs
    5. Adding Multimedia
    6. Adding Hyperlinks

    Chapter 6: Creating PDF Forms

    1. Creating a New Form
    2. Adding a Reset Button
    3. Distributing a Form to Collect Data
    4. Collect Data & Export the Results
    5. Building a Form from a Scanned Document

    Chapter 7: Optimising PDFs

    1. Reducing File Size
    2. PDF Optimizer

    Chapter 8: Exploring Optical Character Recognition

    1. Create a New PDF from a Scan & Configure Conversion Settings
    2. Convert a Scan to a Searchable PDF & Run OCR

    Chapter 9: PDF Security

    1. Establishing Identity
    2. Creating Security Policies
    3. Securing the PDF
    4. Removing Security from a PDF

    Chapter 10: PDF Review & Comenting

    1. Using the Commenting Tools
    2. Organizing Comments
    3. Commenting on Video
    4. Sending a Document for an Email-Based Review
    5. Sending a Document for Shared Review
    6. Checking for & Replying to Comments
    7. Using the Review Tracker
    8. Merging, Importing & Summarizing Comments

    Chapter 11: Adding Accessibility to PDFs

    1. Accessibility Setup, Full Check & Report
    2. Adjust Language Settings & Tag PDF for Accessibility
    3. The Acrobat Read Out Loud Options

    Chapter 12: Automated Document Processing

    1. Indexing
    2. Creating a New Batch Sequence

    Chapter 13: Exploring Collaboration Options

    1. Using Acrobat.com
    2. Using Collaborate Live
    3. Using ConnectNow
    4. Using Buzzword

    Chapter 14: Tips & Tricks

    1. 3D
    2. Preflight
    3. Attaching a PDF to an Email
    4. The Typewriter Tool
    5. Enabling Usage Rights in Adobe Reader®
    6. Digital Signatures
    7. Redaction
    8. Organizer
    9. Screen Capture on Mac
    10. Final Comments & Credits

    Microsoft Office 2007: Getting Up to Speed

    Category: Business Productivity
    Presenter: Geoff Blake
    Platform: Windows
    Format: Online
    Running Time: 6 Hrs
    Level: Beginner to Intermediate
    Project Files: Included

    Description

    These tutorials make all programs in Microsoft Office 2007 a breeze to use. You are introduced to the new interfaces and taught how to use each application’s key features. This includes how to save time creating shortcuts for formatting Word documents, spreadsheets, and presentations. Plus, see how to manage your email, calendar, and list of contacts. Learn how to use Office 2007 efficiently and effectively with minimal effort now!

    Course Outline

    Chapter 1: Getting Started with Word

    1. Touring the New Office 2007 Interface
    2. Formatting Basic Text
    3. Applying Formatting to a Paragraph
    4. Creating Bulleted & Numbered Lists
    5. Working with Styles
    6. Making Changes to the Styles
    7. Saving & Removing Formatting
    8. Changing Style Sets
    9. Proofing Your Work

    Chapter 2: Refining Word Documents

    1. Adding Headers & Footers
    2. Inserting Watermarks
    3. Formatting the Overall Document
    4. Inserting Graphical Elements
    5. Inserting Clip Art
    6. Using SmartArt
    7. Inserting Tables
    8. Formatting Tables
    9. Creating a Cover Page with Themes
    10. Saving a Document
    11. Outputting to PDF

    Chapter 3: Exploring Excel

    1. Touring the Excel Interface
    2. Inserting, Moving & Selecting Content
    3. Format Numerical Data & Reference Cells
    4. Building a Table & Using AutoFill
    5. Inserting & Deleting Rows & Columns
    6. Introducing Formulas
    7. Introducing Functions
    8. Using the Insert Function Dialog Box
    9. Using Statistical Functions & the Status Bar
    10. Using Auditing Commands
    11. Exploring Absolute Cell Referencing
    12. Naming Cell Ranges & Using Name Manager
    13. Pasting Data & Using the Clipboard

    Chapter 4: Formatting & Styling in Excel®

    1. Formatting Cells
    2. Using Format Painter
    3. Number Formatting
    4. Using Cell Styles
    5. Creating Cell Styles
    6. Changing Styles
    7. Using & Creating Table Styles
    8. Filtering a Table Layout
    9. Using Conditional Formatting
    10. Formatting Worksheets with Themes
    11. Inserting Graphical Elements
    12. Managing Multiple Worksheets
    13. Outputting a Document
    14. Saving a Document

    Chapter 5: Powering up with Powerpoint

    1. Touring the PowerPoint Interface
    2. Formatting Text
    3. Changing the Slide Layout
    4. Adding Additional Slides
    5. Creating a Slide Design
    6. Customizing Slides
    7. Inserting Objects
    8. Using SmartArt
    9. Creating & Formatting Charts
    10. Using WordArt Styles
    11. Changing Chart Types
    12. Applying Themes
    13. Setting Animation Effects
    14. Working with Different Views
    15. Setting Up a Slide Show
    16. Running a Slide Show
    17. Outputting a Presentation

    Chapter 6: Staying Connected in Outlook

    1. Touring the Outlook Interface
    2. Using E-mail
    3. Creating Signatures & New Folders
    4. Using a Calendar & Adding Events
    5. Working with Multiple Calendars
    6. Sharing Calendars
    7. Adding & Viewing Contacts
    8. Creating, Viewing & Flagging Tasks

    Chapter 7: Managing Data with Access

    1. Introducing Access & Touring the Interface
    2. Adding & Deleting Contacts
    3. Filtering Data
    4. Creating & Exporting Forms
    5. Creating Reports
    6. Exporting Data

    Chapter 8: A Seamless Office 2007 Workflow

    1. Formatting & Sorting Data
    2. Using Freeze Panes
    3. Grouping Data into Outlines
    4. Creating Charts in Excel
    5. Sharing Workbooks
    6. Using Excel with Word
    7. Protecting a Document
    8. Using Cross-References
    9. Inserting Objects
    10. Using Excel with PowerPoint
    11. Publishing Handouts to Word
    12. Going from Word to Outlook
    13. Sending Invites with Outlook
    14. Sending Meeting Requests
    15. Final Comments & Credits

    Microsoft Access 2007: Essentials

    Category: Business Productivity
    Presenter: Jeff Conrad
    Platform: Windows & MAX OS
    Format: Online
    Running Time: 6.6 Hrs
    Level: Beginner to Intermediate
    Project Files: Included

    Description

    Explore the endless capabilities of Access 2007. These lessons, hosted by Jeff Conrad begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases. Once you’re up to speed on the intricacies of Access, Jeff walks you through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.

    Course Outline

    Part 1

    1. Introducing Access 2007

    1. Defining a Database
    2. Knowing When to Use Access
    3. Working with Database Objects
    4. Converting Older Databases

    2. Exploring the New User Interface

    1. Exploring the Getting Started Screen
    2. Opening a Microsoft Template
    3. Using the Navigation Pane
    4. Using the Home Tab, Part 1
    5. Using the Home Tab, Part 2
    6. Using the Create Tab
    7. Using the External Data Tab
    8. Using the Database Tools Tab
    9. Using the Once Menu
    10. Explaining the Access Options
    11. Using the Quick Access Toolbar
    12. Adding Custom Commands to the Quick Access Toolbar
    13. Using the Help Menu
    14. Understanding the Message Bar
    15. Creating Trusted Locations
    16. Working in the Object Window

    3. Working in the Navigation Pane

    1. Displaying Categories
    2. Showing Views
    3. Sorting the Objects
    4. Searching for Objects
    5. Collapsing Groups
    6. Creating Custom Groups
    7. Adding Object Shortcuts
    8. Hiding Custom Groups
    9. Changing the Interface Mode
    10. Final Comments & Credits

    Part 2

    1. Creating Tables

    1. Explaining the Datasheet Tab
    2. Entering Data in a New Table
    3. Using a Table Template
    4. Identifying the Entities
    5. Working with Design View
    6. Creating DataTypes
    7. Using Field Validation Rules
    8. Defining Primary Keys
    9. Adding Indexes
    10. Working with Table Relationships
    11. Creating Table Relationships
    12. Defining Multi-Value Field Lookups

    2. Creating Queries

    1. Creating a Select Query
    2. Using Expressions in a Query
    3. Sorting Data
    4. Searching for Data
    5. Selecting Data from Many Tables
    6. Working in Layout View
    7. Working in SQL View
    8. Creating a Crosstab Query
    9. Running Action Queries
    10. Running Update Queries
    11. Using the Query Wizard

    3. Creating Forms

    1. Using Quick Create Commands
    2. Exploring Form Types
    3. Navigating within Forms
    4. Using the Form Wizard
    5. Creating a Form from Scratch
    6. Working in Layout View
    7. Working in Design View
    8. Setting Form Properties
    9. Using Form Controls
    10. Using Control Layouts
    11. Applying AutoFormats
    12. Understanding Subforms

    4. Creating Reports

    1. Using the Report Command
    2. Running the Report Wizard
    3. Exploring Report Views
    4. Creating a Report from Scratch
    5. Using Conditional Formatting
    6. Grouping & Sorting
    7. Setting Report Properties
    8. Detailing Your Report
    9. Applying AutoFormats
    10. Adding Subreports
    11. Alternating Record Colors
    12. Filtering in Report View
    13. Creating Labels

    5. Creating Macros

    1. Working in Macro Design Mode
    2. Assigning Macro Actions
    3. Setting Macro Arguments
    4. Running an AutoExec Macro
    5. Creating Embedded Macros
    6. Final Comments & Credits

    Microsoft Excel 2007: Essentials

    Category: Business Productivity
    Presenter: Michael Alexander
    Platform: Windows
    Format: Online
    Running Time: 5 Hrs
    Level: Beginner to Intermediate
    Project Files: Included

    Description

    Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!

    Course Outline

    Chapter 1: Working with the User Interface

    1. Introducing the Ribbon User Interface
    2. Introducing Workbooks & Worksheets
    3. Introducing the Formula Bar
    4. Saving with Different File Extensions
    5. Customizing the User Interface

    Chapter 2: Entering & Managing Data

    1. Getting Data into Excel
    2. Importing Text Files
    3. Using the Freeze Panes Functionality
    4. Using the Zoom Functionality
    5. Using Hot Keys
    6. Managing Rows & Columns
    7. Finding Data
    8. Matching Case & Entire Cell Contents
    9. Replacing Data
    10. Finding & Replacing Empty Values
    11. Sorting Data
    12. Sorting Multiple Columns
    13. Filtering Data

    Chapter 3: Using & Formatting Techniques

    1. Formatting Numbers & Dates
    2. Formatting Cells
    3. Setting the Font Type, Colour & Size
    4. Using Borders & Cell Styles
    5. Adding Shapes & Pictures
    6. Creating WordArt

    Chapter 4: Formula Basics

    1. Constants, Formulas & Cell References
    2. Understanding the Order of Operations
    3. Using Formulas with Dates & Text
    4. Linking Cells & Using Comparison Operators
    5. Creating an Absolute Reference
    6. Defining Named Ranges
    7. Exploring the Function Library
    8. Using the AutoSum Function

    Chapter 5: Useful Functions

    1. Using the INT Function
    2. Using the Rounding Function
    3. Using the ABS Function
    4. Using the SUBTotal Function
    5. Using Logical Functions
    6. Using the AND & the OR Function
    7. Using LEFT, RIGHT & MID Functions
    8. Using the UPPER, LOWER, PROPER & TRIM Functions
    9. Using COUNT Functions
    10. Using the VLOOKUP Function

    Chapter 6: Creating Reports

    1. Creating a Subtotal Report
    2. Using Conditional Formatting
    3. Creating & Managing Conditions
    4. Creating a Chart
    5. Refining Charts
    6. Using Basic Chart Types

    Chapter 7: Sharing & Distributing Your Work

    1. Inserting Headers & Footers
    2. Adding Comments
    3. Adjusting Page Layout
    4. Distributing Your Worksheets
    5. Protecting Your Worksheets
    6. Understanding Compatibility

    Chapter 8: Tips & Tricks

    1. Using the Fill Handle
    2. Filling in a Series of Numbers
    3. Typing in Multiple Cells at Once
    4. Leveraging a Custom List & Transposing a Range
    5. Deleting & Inserting Blank Cells
    6. Filling Holes in Your Data
    7. Getting a List of Unique Records & Parsing Text
    8. Rearranging Columns & Linking to Multiple Cells
    9. Using Right Mouse Button Drag Options
    10. Make Format Painter Persist & Paste Special Formats
    11. Formatting Portions of Text & Multiple Sheets
    12. Creating Cell Border Effects & Sorting on Color
    13. Turning Formulas into Hard Data
    14. Copy Formula References & Highlight Formulas
    15. Creating Dynamic Charts & Combination Charts
    16. Add a Secondary Axis, Average Line & Smooth Line
    17. Comparing Data Dynamically with Charts
    18. Final Comments & Credits

    Microsoft Excel 2007: Advanced

    Category: Business Productivity
    Presenter: Bill Jelen
    Platform: Windows
    Format: Online
    Running Time: 6 Hrs
    Level: Intermediate to Advanced
    Project Files: Included

    Description

    Now that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, with our training for Microsoft Excel 2007: Essentials, you’re ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you’ll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.

    Course Outline

    Chapter 1: Summarizing Data

    1. Advanced Subtotals
    2. Formatting the Subtotal Rows
    3. Adding and Copying with Subtotals
    4. Consolidating Data
    5. Introducing the SUMIF Command
    6. Working with the SUMIF Command
    7. Using Array Formulas
    8. Looking at AutoSum Tricks
    9. Utilizing Fill Handle Tricks

    Chapter 2: Working with Pivot Tables

    1. Creating a Pivot Table
    2. Rearranging Fields in a Pivot Table
    3. Explaining the Report Layout Options
    4. Using the Report Filters Feature
    5. Using Top 10 & Date Filters
    6. Handling Blank Cells
    7. Drilling Down in the Pivot Table
    8. Sorting a Pivot Table
    9. Formatting a Pivot Table
    10. Creating Custom Formats
    11. Explaining the Grouping Options
    12. Adding Formulas to a Pivot Table
    13. Changing a Calculation in a Pivot Table
    14. Replicating a Pivot Table
    15. Counting with a Pivot Table
    16. Using Pivot Charts

    Chapter 3: Charting in Excel

    1. Charts Refresher
    2. Moving, Sizing & Copying Charts
    3. Formatting Charts
    4. Formatting a Series
    5. Exploring the Home & Format Ribbons
    6. Deciding What Chart Format to Use
    7. Show a Time Series with Column or Line Charts
    8. Using Combination Charts
    9. Using Line Chart Accessories
    10. Using Bar Charts to Show Comparisons
    11. Using Component Charts
    12. Using Correlation Charts
    13. Exploring Other Charts
    14. Chart Lies Revealed & Advanced Chart Types
    15. Creating a Custom Layout

    Chapter 4: Getting Visual

    1. Using Conditional Formatting
    2. Using Advanced Conditional Formatting
    3. Highlighting, Sorting & Filtering Columns
    4. Using SmartArt Functions
    5. Using Different SmartArt Graphics
    6. Embedding a Formula into a Shape

    Chapter 5: Creating Powerful Formulas

    1. Using Goal Seek to Find an Answer
    2. Auditing Formulas
    3. Shrinking the Formula Bar
    4. Understanding Errors
    5. Joining Text Columns
    6. Using Custom Formatting Codes
    7. Pasting Values
    8. Using Paste Special
    9. Breaking Apart Text
    10. Converting Text to Numbers
    11. Using Date Functions
    12. Using Bizarre Date Functions
    13. Using Exponents
    14. Using the VLOOKUP Function
    15. Using Index Match
    16. Using the Offset Function
    17. Using the Convert Function
    18. Looking at Interesting but Obscure Functions
    19. Using the Rand Function
    20. Working with Regression
    21. Ranking & Sorting Formulas

    Chapter 6: Recording Macros

    1. Displaying the Developer Tab
    2. Recording a Simple Macro
    3. Simplifying the Macro
    4. Recording Using Relative References

    Chapter 7: Tips & Tricks

    1. Showing Off New Tips in Excel 2007
    2. Tips for Handling Worksheets
    3. Using Excel as a Word Processor
    4. Miscellaneous Tips
    5. Validating Data
    6. Changing Text Entry Direction
    7. Using Speak Cells
    8. Final Comments & Credits

    Microsoft Office 2010: Getting Up To Speed: New Features

    Category: Business Productivity
    Presenter: Erin A. Olsen
    Platform: Windows
    Format: Online
    Running Time: 7 Hrs
    Level: Beginner to Intermediate
    Project Files: Included

    Description

    Microsoft Office holds a solid 80% of the productivity software market. That means virtually everyone at one point or another comes into contact with Office files. There were significant changes to the interface in Office 2007 and that paved the way for Office 2010 to focus on features that will bring your work to a whole new level of professionalism and mobility. Because 2010 is not about interface or new applications, many of the features are subtle or hard to recognize at first glance. This course will show you what you need to know to get up to speed and quickly take full advantage of the new features.

    Course Outline

    Chapter 1: Office 2010 First Glance

    1. The Fluent Interface Revisited
    2. The Backstage View
    3. Customizing the Ribbon

    Chapter 2: Office 2010 File Formats

    1. XML in Office
    2. Converting Older Files
    3. Reverting New Files & Prepare for Sharing

    Chapter 3: Office 2010 Shared Features

    1. Using Paste Preview
    2. Capturing Images with the Screenshot Tool
    3. Correcting Images in Office 2010

    Chapter 4: What’s New in Word 2010

    1. Using the Navigation Pane
    2. Text Effects, OpenType Features & Alternative Text
    3. Keeping Safe & Opening Unsaved Documents

    Chapter 5: What’s New in Excel® 2010

    1. Applying Cross Sheet Conditional Formatting
    2. Exploring Data Bar Enhancements
    3. Viewing Data with the Sparkline Tools
    4. Filtering Data with Slicers
    5. Additional Excel Enhancements

    Chapter 6: What’s New in Powerpoint® 2010

    1. Creating Presentation Sections
    2. Exploring Video Format Tools
    3. Exploring Video Playback Tools
    4. Enhanced SmartArt®, Animations & Transitions
    5. Creating Video & Broadcasting Presentations

    Chapter 7: What’s New in Access 2010

    1. Access 2010 at First Glance
    2. Entering Table Data & Saving a Template
    3. Adding Quick Start Field Collections
    4. Empowering Databases with Data Macros
    5. Making Data Look Good
    6. Using the Data Type Gallery
    7. Advanced Access Expressions

    Chapter 8: What’s New in Outlook 2010

    1. Getting Familiar with Interface Updates
    2. Monitoring Conversations
    3. Taking Control of Your Inbox
    4. Simplifying Actions with Quick Steps
    5. Keeping Socially Connected

    Chapter 9: What’s New in OneNote 2010

    1. Creating a OneNote Notebook
    2. Adding Notebook Content
    3. Keeping Side Notes
    4. Searching Your Notes
    5. Sharing Your Notebooks

    Chapter 10: What About Web Apps?

    1. What Are Web Apps?
    2. Windows Live® SkyDrive®, Silverlight & Accessing Web Apps
    3. Accessing Files & the Excel Web App
    4. Creating Files & Using the PowerPoint Web App
    5. Credits

    Microsoft Windows 7

    Category: Business Productivity
    Presenter: Erin Olsen
    Platform: Windows & MAC OS
    Format: Online
    Running Time: 7.8 Hrs
    Level: Beginner to Intermediate
    Project Files: Included

    Description

    Using a computer these days is a requirement. In order to use a PC without it becoming cumbersome and frustrating, you need to know it’s operating system and how to navigate, find, open, use and manage the system including its hardware, software and files. This course will review some of the old standby features and hone in on the numerous enhancements in this version. You’ll learn the tools to increase reliability, efficiency and security that will optimize the user experience as never before. You’ll also find out what jumping, shaking, snapping, streaming and BitLocking are.

    Course Outline

    Chapter 1: Getting Started Using Windows

    1. Introducing Windows 7
    2. A First Look at the Windows Desktop
    3. Working with User Accounts
    4. Users, Passwords & Permissions
    5. Exploring Log O & Power Options

    Chapter 2: Customising the Windows Desktop

    1. Using Icons & Shortcuts
    2. Adding Gadgets
    3. Customizing Backgrounds & Window Appearance
    4. Customizing Sounds, Screensavers & Icons
    5. Changing Screen Resolution

    Chapter 3: Accessing the Start Menu

    1. Using Start Menu Options
    2. Customizing the Start Menu
    3. Finding Programs, Files & Settings

    Chapter 4: Exploring the Revised Task Bar

    1. Customizing the Noti-cation Area
    2. Exploring Buttons on the Taskbar
    3. Taking Advantage of Jump Lists
    4. Setting Taskbar Properties

    Chapter 5: Optimising the Windows User Experience

    1. Moving & Sizing Windows
    2. Window Navigation Using Breadcrumbs
    3. Window Navigation & Customization
    4. Accessing & Con-guring Libraries
    5. Organizing, Rating & Tagging Files
    6. Indexing & Search Options
    7. Searching for Files
    8. Sharing Files & Folders

    Chapter 6: Examining Hardware & Software

    1. Viewing Devices & Printers
    2. The Device Manager, Drivers & Power Management
    3. Setting Default Actions & Programs
    4. Installing & Uninstalling Software
    5. Alternate Hardware & Software Tools: Touch
    6. Speech Recognition
    7. Live Essentials & Services

    Chapter 7: Enjoying Media

    1. Playing Audio & Video Using the Media Player
    2. Ripping CDs & Creating Playlists
    3. Experiencing the Next Level with the Windows Media Center
    4. Tapping into the Windows 7 Gaming Experience

    Chapter 8: Connecting to a Network

    1. Networking Overview
    2. Getting Started with Windows 7 Networking
    3. Working with the Network Adaptor
    4. Viewing the Network Map & Changing the Workgroup
    5. Mapping a Network Drive

    Chapter 9: Maintaining Your System

    1. Optimizing Performance
    2. Using Troubleshooters & the Action Center
    3. Using the Problem Steps Recorder
    4. Keeping Current with Windows Update

    Chapter 10: Securing Your System & Data

    1. Working with System Restore & Shadow Copies
    2. Executing Backup & Restore
    3. Implementing BitLocker & BitLocker To Go
    4. Credits

    Prospective Job Titles: Administrator, Human Resource Person, P.A., Secretary
    Average Salary: Executive Admin Assistant: £15-24k p.a. with experience
    Source: payscale.com
    Previous Experience Required: None
    Related Areas of Employment: General Office Administration, Public Relations, Hotel Concierge, Hospitality, Human Resources, Finance
    Where do I do my exams? Contact us to find this out.