Microsoft Office Productivity Courses

Microsoft Office Productivity Courses

Our students accomplish more than just learn the latest technologies. The success of our students is realized through training classes, but the foundation of New Horizons is based on inspiring students and companies to become more productive and successful in their daily activities. Microsoft Office training from New Horizons is enhanced by engaging the student in real work – life situations, and we see the results on our students’ faces every day. It’s in the confidence that comes from learning, knowing and applying. Over 98% of New Horizons students indicate higher on the job productivity levels versus those students who received training elsewhere.

Courses

1. Access
2. Excel
3. Word
4. Powerpoint
5. Outlook


accessMicrosoft Access – Part 1

Microsoft Access continues to be the database of choice for small to medium size businesses and individual database projects with powerful reporting capabilities.

Enquire For Price & Details

Overview

In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Who Should Attend

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Duration

Classroom Learning – 2 Day(s)
Online LIVE – 2 Day(s)
Mentored Learning – Flexible

Course Outline

Lesson 1: Getting Started with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access

Lesson 2: Working with Table Data

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

Lesson 3: Querying a Database

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data

Lesson 5: Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Lesson 6: Customizing the Access Environment

  • The Access Options Dialog Box

Lesson 7: Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Lesson 8: Joining Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

Lesson 9: Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Lesson 10: Sharing Data Across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Lesson 11: Advanced Reporting

  • Organize Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

 

Microsoft Access 2013 – Part 2

Overview

In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Who Should Attend

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills. This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

Duration

Classroom Learning – 2 Day(s)
Online LIVE – 2 Day(s)
Mentored Learning – Flexible

Course Outline

Lesson 1: Implementing Advanced Form Design

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting

Lesson 2: Using Data Validation

  • Field and Record Validation
  • Form Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options
Enquire For Price & Details

 

 excelMicrosoft Excel 2013: Part 1

Learn all the powerful features of Excel including in-cell charts, spark lines, pivot tables, data manipulation, charting functions and much more.

Enquire For Price & Details

Overview

In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.

Who Should Attend

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Prerequisite(s) or Equivalent Knowledge

Using Microsoft Windows 8

At Course Completion

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:

Get started with Microsoft Office Excel 2013.

  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Course Outline

Lesson 1: Getting Started with Microsoft Office Excel 2013

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

Lesson 2: Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Lesson 5: Printing Workbooks

  • Preview and Print a Workbook
  • Define the Page Layout

Lesson 6: Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

 

excelMicrosoft Excel 2013: Part 2

Enquire For Price & Details

Overview

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

Who Should Attend

This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Prerequisite(s) or Equivalent Knowledge

Excel 2013 – Part 1

At Course Completion

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:

  • Customize the Excel environment.
  • Create advanced formulas.
  • Analyze data by using functions and conditional formatting.
  • Organize and analyze datasets and tables.
  • Visualize data by using basic charts.
  • Analyze data by using PivotTables, slicers, and PivotCharts.

Course Outline

Lesson 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

 

excelMicrosoft Excel 2013: Part 3

Enquire For Price & Details

Overview

In this course, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.

Who Should Attend

This course is intended for a student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

At Course Completion

At course completion, students will: • Automate worksheet functions. • Audit worksheets. • Analyze data. • Work with multiple workbooks. • Import and export data.

Course Outline

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros

Lesson 4: Applying Conditional Logic

  • Use Lookup Functions
  • Combine Functions
  • Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

  • Use Advanced Chart Features
  • Create Sparklines

 

 wordMicrosoft Word 2013: Part 1

Learn beginning to advanced features of Microsoft Word, including time-saving tips to make you more productive.

Enquire For Price & Details

Overview

In this course, you’ll learn how to use Word 2013 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

Who Should Attend

This course is intended for students who want to learn basic Word 2013 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Prerequisite(s) or Equivalent Knowledge

Using Microsoft Windows 8

Course Outline

Lesson 1: Getting Started with Word

  • Identify the Components of the Word Interface
  • Create a Word Document
  • Help

Lesson 2: Editing a Document

  • Navigate and Select Text
  • Modify Text
  • Find and Replace Text

Lesson 3: Formatting Text and Paragraphs

  • Apply Character Formatting
  • Align Text Using Tabs
  • Display Text as List Items
  • Control Paragraph Layout
  • Apply Borders and Shading
  • Apply Styles
  • Manage Formatting

Lesson 4: Adding Tables

  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table

Lesson 5: Managing Lists

  • Sort a List
  • Renumber a List
  • Customize a List

Lesson 6: Inserting Graphic Objects

  • Insert Symbols and Special Characters
  • Add Images to a Document

Lesson 7: Controlling Page Appearance

  • Apply a Page Border and Color
  • Add a Watermark
  • Add Headers and Footers
  • Control Page Layout

Lesson 8: Proofing a Document

  • Check Spelling and Grammar
  • Other Proofing Tools

Lesson 9: Customizing the Word Environment

  • Customize the Word Interface
  • Additional Save Options

 

Microsoft Word 2013: Part 2

Enquire For Price & Details

Overview

Students will learn to use Word more efficiently by automating some tasks and creating complex documents that include lists, tables, charts, graphics, and newsletter layouts and will merge data to personalize correspondence and labels.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Prerequisite(s) or Equivalent Knowledge

Word 2013 – Part 1 

At Course Completion

After successful course completion, students will:

  • Work with tables and charts.
  • Customize formats using styles and themes.
  • Use images in a document.
  • Create custom graphic elements.
  • Insert content using Quick Parts.
  • Use templates.
  • Use mail merge.
  • Use macros.

Course Outline

Lesson 1: Working with Tables and Charts

  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart

Lesson 2: Customizing Formats Using Styles and Themes

  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes

Lesson 3: Using Images in a Document

  • Resize an Image
  • Adjust Image Appearance
  • Integrate Pictures and Text
  • Insert and Format Screenshots
  • Insert Video

Lesson 4: Creating Custom Graphic Elements

  • Create Text Boxes and Pull Quotes
  • Draw Shapes
  • Add WordArt and Other Text Effects
  • Create Complex Illustrations with SmartArt

Lesson 5: Inserting Content Using Quick Parts

  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts

Lesson 6: Controlling Text Flow

  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow

Lesson 7: Using Templates

  • Create a Document Using a Template
  • Create a Template

Lesson 8: Using Mail Merge

  • The Mail Merge Features
  • Merge Envelopes and Labels
  • Create a Data Source Using Word

Lesson 9: Using Macros

  • Automate Tasks Using Macros
  • Create a Macro

 

Word 2013: Part 3

Enquire For Price & Details

Overview

In Microsoft® Word 2013: Part 3, the student will gain advanced skills to work with lengthy documents, collaborate with others, and create forms, as well as revise, manage, and secure business documents.

Who Should Attend

This course is intended for students who create and work with lengthy documents, collaborate with others on documents, and create forms in Microsoft Word.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Prerequisite(s) or Equivalent Knowledge

Word 2013 – Part 1
Word 2013 – Part 2

Course Outline

Lesson 1: Collaborating on Documents

  • Modify User Information
  • Share a Document
  • Compare Document Changes
  • Review a Document
  • Merge Document Changes
  • Review Tracked Changes
  • Coauthor Documents

Lesson 2: Adding Reference Marks and Notes

  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations and a Bibliography

Lesson 3: Simplifying and Managing Long Documents

  • Insert Blank and Cover Pages
  • Insert an Index
  • Insert a Table of Contents
  • Insert an Ancillary Table
  • Manage Outlines
  • Create a Master Document

Lesson 4: Securing a Document

  • Suppress Information
  • Set Formatting and Editing Restrictions
  • Add a Digital Signature to a Document
  • Restrict Document Access

Lesson 5: Forms

  • Create Forms
  • Manipulate

 

 pptMicrosoft Powerpoint 2013: Part 1

Microsoft PowerPoint is the de facto standard for presentation software. Create your presentations with flare.

Enquire For Price & Details

Overview

In this course, you will use PowerPoint 2013 to begin creating engaging, dynamic multimedia presentations.

Who Should Attend

This course is designed for students who wish to gain the foundational understanding of Microsoft Office PowerPoint 2013 that is necessary to create and develop engaging multimedia presentations.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Course Outline

Lesson 1: Getting Started with PowerPoint®

  • Navigate the PowerPoint Environment
  • Create and Save a PowerPoint Presentation
  • Use Help

Lesson 2: Developing a PowerPoint® Presentation

  • Select a Presentation Type
  • View and Navigate a Presentation
  • Edit Text
  • Build a Presentation

Lesson 3: Performing Advanced Text Editing

  • Format Characters
  • Format Paragraphs
  • Format Text Boxes

Lesson 4: Adding Graphical Elements to Your Presentation

  • Insert Clip Art and Images
  • Insert Shapes

Lesson 5: Modifying Objects in Your Presentation

  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects

Lesson 6: Adding Tables to Your Presentation

  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications

Lesson 7: Adding Charts to Your Presentation

  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver Your Presentation

  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation

 

Microsoft Powerpoint 2013: Part 2

Enquire For Price & Details

Overview

PowerPoint® 2013 Part 2 provides the student with advanced tools that can help in delivering presentations in nearly any situation, while saving time and effort.

Who Should Attend

This course is intended for students who have a foundational working knowledge of PowerPoint 2013, who wish to take advantage of the application’s higher-level usability, security, collaboration, and distribution functionality.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)

Prerequisite(s) or Equivalent Knowledge

PowerPoint 2013 – Part 1

Course Outline

Lesson 1: Modifying the PowerPoint Environment

  • Customize the User Interface
  • Set PowerPoint 2013 Options

Lesson 2: Customizing Design Templates

  • Modify Slide Masters and Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master and the Handout Master

Lesson 3: Adding SmartArt to a Presentation

  • Create SmartArt
  • Modify SmartArt

Lesson 4: Working with Media and Animations

  • Add Audio to a Presentation
  • Add Video to a Presentation
  • Customize Animations and Transitions

Lesson 5: Collaborating on a Presentation

  • Review a Presentation
  • Store and Share Presentations on the Web

Lesson 6: Customizing a Slide Show

  • Annotate a Presentation
  • Set Up a Slide Show
  • Create a Custom Slide Show
  • Add Hyperlinks and Action Buttons
  • Record a Presentation

Lesson 7: Securing and Distributing a Presentation

  • Secure a Presentation
  • Broadcast a Slide Show
  • Create a Video or a CD

 

 Outlook 2013: Part 1

Enquire For Price & Details

Microsoft Outlook is the ultimate tool for Office collaboration and organization.

Overview

Students will learn the basic skills needed to start using Outlook 2013 to manage email communications, calendar events, contact information, tasks, and notes.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)
Mentored Learning – Flexible

Course Outline

Lesson 1: Getting Started With Outlook 2013

  • Navigate the Outlook Interface
  • Perform Basic Email Functions
  • Use Outlook Help

Lesson 2: Composing Messages

  • Create an Email Message
  • Check Spelling and Grammar
  • Format Message Content
  • Attach Files and Items
  • Enhance an Email Message
  • Manage Automatic Message Content

Lesson 3: Reading and Responding to Messages

  • Customize Reading Options
  • Work with Attachments
  • Manage Your Message Responses

Lesson 4: Managing Your Messages

  • Manage Messages Using Tags, Flags, and Commands
  • Organize Messages Using Folders

Lesson 5: Managing Your Calendar

  • View the Calendar
  • Manage Appointments
  • Manage Meetings
  • Print Your Calendar

Lesson 6: Managing Your Contacts

  • Create and Update Contacts
  • View and Organize Contacts

Lesson 7: Working With Tasks and Notes

  • Manage Tasks
  • Manage Notes

Lesson 8: Customizing the Outlook Environment

  • Customize the Outlook Interface
  • Create and Manage Quick Steps

 

Outlook 2013: Part 2

Enquire For Price & Details

Overview

Students will explore the advanced features provided with the Outlook interface, such as advanced message, calendar, and contacts management.

Who Should Attend

This course is intended for people who have a basic understanding of Microsoft® Windows® and Microsoft Office Outlook 2013 and want or need to know how to perform more advanced tasks in Outlook.

Duration

Classroom Learning – 1 Day(s)
Online LIVE – 1 Day(s)
Mentored Learning – Flexible

Prerequisite(s) or Equivalent Knowledge

Microsfot Outlook Part 1

Course Outline

Lesson 1: Configure Advanced Message Options

  • Insert Advanced Characters and Objects
  • Modify Message Settings, Properties, and Options
  • Use Automatic Replies

Lesson 2: Advanced Message Management

  • Sort Messages
  • Filter Messages
  • Organize Messages
  • Search Messages
  • Manage Junk Mail
  • Manage Your Mailbox

Lesson 3: Advanced Calendar Management

  • Manage Advanced Calendar Options
  • Create Calendar Groups
  • Manage Meeting Responses

Lesson 4: Advanced Contact Management

  • Edit an Electronic Business Card
  • Manage Advanced Contacts Options
  • Forward Contacts
  • Export Contacts

Lesson 5: Managing Activities by Using Tasks and Journal Entries

  • Assign and Manage Tasks
  • Record and Modify Journal Entries

Lesson 6: Sharing Workspaces with Others

  • Delegate Access to Mail Folders
  • Share Your Calendar
  • Share Your Contacts

Lesson 7: Managing Outlook Data Files

  • Back Up Outlook Items
  • Change Data File Settings