We can customise training to meet your needs. From Word to Excel we can give you or your employees the skills that are needed to succeed in todays high paced work enviornment

TRAINING PHILOSOPHY:

Our training is designed with practical, real-world facility and industrial applications in mind. It is unbiased, unaffiliated and non-commercial so you are assured of a real education and not a product sales pitch. It focuses less on theory and more on the actual steps students need to properly maintain equipment or fix specific problems at their own plant or facility. Doing this in just a few days while reinforcing worker safety is a serious challenge. That's why our instructors have the freedom to tweak each session to the specific needs of the students in each class. Our instructors will simplify the subject matter for the novice or go in-depth to answer an engineer's toughest question.

ABOUT OUR INSTRUCTORS:

All instructors are required to have a formal education and real world work experience. They need to be leaders in their field. We don't hire field people without teaching experience, and we don't hire teachers without field experience. They must have both.

TRAINING AT YOUR FACILITY:

We can bring this or any of our other courses directly to your facility for training.

Unit 1:  Introduction to Microsoft Word 2013 (8 hours)

Microsoft Word is the word processing application that is used to create text-based documents such as letter, memos, reports, flyers, and newsletters.  This unit explores how to start the program, create a document, and work in the Word window.

In this unit students will learn to:

• Start Microsoft Word
• Work in the Word window
• Create a new document
• Type in a document
• Move the insertion point in a document
• Check spelling and grammar
• Save a new document
• Close a document

Unit 2:  Intermediate Microsoft Word 2013 (8 hours)

Word is the standard word processing application that allows you to write business letters to clients and suppliers, or to communication with other individuals in your organization. This unit explores how to format documents and includes a short review of Unit 1 skills.

In this unit the student will learn to:

• Open an existing document
• Format a business letter
• Change the font
• Change the margins
• Use tabs
• Edit text
• Use cut and paste
• Use bullets and numbered lists
• Create envelopes and labels
• Print the document
• Print envelopes and labels

Unit 3:  Advanced Microsoft Word 2013 (8 hours)

Trainees will learn to add interactive elements such as forms and content from other applications, and to save a file as a web page. Then they will learn how to use document references such as citations, indexes, and tables of contents. Next, they will learn to work more efficiently in Word by customizing the ribbon, creating macros, using building blocks, and inserting subdocuments. In addition, Trainees will learn to record and copy macros, to create and modify VBA modules, and to control Word objects in the Visual Basic Environment. Finally, Trainees will learn the fundamentals of VBA programming through creating control structures, designing VBA forms, and debugging programs.

Document interactivity
Topic A: Creating forms
Topic B: Inserting objects and charts
Topic C: Web pages

Document references
Topic A: Tables of contents and captions
Topic B: Indexes, bibliographies, and footnotes

Working efficiently
Topic A: Customizing the ribbon
Topic B: Building Blocks
Topic C: Master documents

Macros and VBA fundamentals
Topic A: Simple macros
Topic B: Visual Basic for Applications
Topic C: Modifying and creating macros
Topic D: Word objects

VBA programming
Topic A: Control structures
Topic B: VBA forms
Topic C: Debugging and error handling

Unit 4:  Introduction to Microsoft Excel 2013 – (8 hours)

Excel is the spreadsheet application included in the Microsoft Office suite.  Excel is used to analyze business, personal, or financial data and create reports in a table format consisting of rows and columns.

In this unit students will learn to:

• Start Microsoft Excel
• Work in the Excel window
• Create a new workbook
• Enter information
• Change between worksheets
• Delete cell contents
• Save a new workbook
• Close a workbook

• Open an existing worksheet
• Create numeric labels and values
• Enter dates
• Create a series
• Align data
• Change column widths
• Enter basic formulas

Unit 5:  Intermediate Microsoft Excel 2013 – (10 hours)

Excel group’s cells as a range to copy, move, or erase them, or to quickly apply the same formatting throughout the range.  Calculations can be performed on cell ranges creating sums and averages, and many more functions.  This unit explores how to use ranges, formulas, work with data, and formatting information.

In this unit the student will learn to:

• Use ranges
• Enter a formula
• Format data
• Copy and paste data
• Use fonts
• Create number formats
• Create percent formats
• Create currency format
• Add color to cells
• Use AutoFill
• Use common functions
• Auto Calculate
• Work with worksheets
• Group sheets
• Format sheets
• Insert comments
• Create basic charts
• Print a workbook and charts

Unit 6:  Advanced Microsoft Excel 2013 – (16 hours)

Students will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and Pivot Charts, export and import data, and query external databases.

Advanced functions and formulas
Topic A: Logical functions
Topic B: Conditional functions
Topic C: Financial functions
Topic D: Text functions
Topic E: Date and time functions
Topic F: Array formulas
Topic G: Calculation options

Lookups and data tables
Topic A: Using lookup functions
Topic B: Creating data tables

Advanced data management
Topic A: Validating cell entries
Topic B: Advanced filtering

Advanced charting
Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphical object

PivotTables and Pivot Charts
Topic A: Working with PivotTables
Topic B: Modifying PivotTable data
Topic C: Formatting PivotTables
Topic D: Using Pivot Charts
Topic E: PowerPivot

Exporting and importing data
Topic A: Exporting and importing text files

Analytical tools
Topic A: Goal Seek
Topic B: Scenarios
Topic C: Instant data analysis

Macros and Visual Basic
Topic A: Running and recording a macro
Topic B: Working with VBA code

Accessibility and language features
Topic A: Accessibility considerations
Topic B: Internationalization

Unit 8:  Introduction to Microsoft Outlook 2013– (8 hours)

Explore Outlook modules, Manage scheduling, Manage window elements, Send and receive email messages, Store and access contact information, Track tasks,

In this unit the student will learn to:

• Getting started
•  Topic A: The program window
•  Topic B: Outlook Today

• Email basics
•  Topic A: Reading messages
•  Topic B: Creating and sending messages
•  Topic C: Working with messages
•  Topic D: Handling attachments
•  Topic E : Printing messages and attachments

• Email management
• Topic A: Setting message options
• Topic B: Organizing the Inbox folder
• Topic C : Managing junk email

Unit 9:  Intermediate to Microsoft Outlook 2013– (8 hours)

Students will learn how to manage email messages and attachments, configure message options, and use basic search functions. Students will also learn to manage contacts and contact groups, work with tasks, and create appointments. Finally, they will learn to send and respond to meeting requests.

In this unit the student will learn to:

Contacts

 Topic A: Working with contacts

 Topic B: Address books

 Topic C: Using contact groups

Tasks

 Topic A: Working with tasks

 Topic B: Managing tasks

Appointments and events

 Topic A: Creating and sending appointments

 Topic B: Modifying appointments

 Topic C: Working with events

 Topic D: Using Calendar Views

Meeting requests and responses

 Topic A: Scheduling meetings

 Topic B: Managing meetings

Practice tasks

Unit 9:  Advanced to Microsoft Outlook 2013– (8 hours)

Then students will learn how to set rules for organizing messages and use advanced techniques for managing and maintaining their mailboxes. Trainees will also learn how to search various folders, use filters, and apply categories, as well as how to work with notes and Journal entries. Trainees will learn how to share Outlook calendars and contacts and stay informed with RSS feeds

Customizing Outlook
Topic A: The Outlook environment
Topic B: General options and account settings
Topic C: Quick Steps
Topic D: The Folder pane and Navigation bar

Customizing messages
Topic A: Message appearance
Topic B: Signatures
Topic C: Voting buttons
Topic D: Out-of-office messages

Mailbox organization and management
Topic A: Setting rules
Topic B: Managing your mailbox

Organizing items
Topic A: Folders
Topic B: Searching
Topic C: Advanced filtering
Topic D: Categories

Notes and Journals
Topic A: Recording information with notes
Topic B: Tracking activities with the Journal

 Collaboration
Topic A: Sharing your calendar and contacts
Topic B: Staying informed with RSS

Unit 10:  Introduction to Microsoft PowerPoint 2013 – (8 hours)

PowerPoint is a presentation graphics program that creates a slide show that can be shown with a projector, a computer screen, or as a web page.  PowerPoint can be used to show an audience the main topics or to illustrate items with charts or tables.

In this unit the student will learn to:

• Start PowerPoint
• Apply a slide layout
• Use the PowerPoint screen
• Use shortcut menus
• Use slide design templates
• Use placeholders
• Add text to a presentation
• Add slides to a presentation
• Open an existing presentation
• Changing slide views
• Use spell check
• Change a slide’s layout or design template
• Insert clip art
• Insert pictures
• Use WordArt

Unit 11:  Intermediate Microsoft PowerPoint 2013 – (8 hours)

A PowerPoint presentation contains multiple slides that can be moved, copied, duplicated, hidden, or deleted.  Slides can also be moved from one presentation to another. This unit explores how to organize your presentation, work with text, and how to link to other programs.

In this unit the student will learn to:

• Move, copy, duplicate, hide, and delete slides
• Use the slide sorter view
• Use the outline pane and toolbar
• Link an Excel worksheet
• Select text
• Align text
• Change the appearance of text
• Change the size of text
• Change the slide color scheme
• Change the slide background
• Use the slide master
• Modify the title master
• Insert slide numbers, date and time, and footer text
• Format bullets
• Draw graphic objects
• Group and ungroup objects
• Layer objects
• Add transitions
• Add sound
• Animate text and objects
• Insert video into your presentation

Unit 12:  Advanced to Microsoft PowerPoint 2013– (8 hours)

Topic A: Slide masters
Topic B: Transitions and timings
Topic C: Custom slide shows

Graphics and media
Topic A: Modifying graphics
Topic B: Media clips
Topic C: Animations
Topic D: Photo albums

Customizing slide elements
Topic A: Working with SmartArt graphics
Topic B: Customizing tables
Topic C: Working with charts

Action buttons and equations
Topic A: Action buttons
Topic B: Equations

Integrating Microsoft Office files
Topic A: Applying content from a Word outline
Topic B: Embedding and linking content

Finalizing and distributing presentations
Topic A: Reviewing and finishing
Topic B: Distributing presentations

Unit 13:  Introduction to Microsoft Project 2013– (12 hours)

This Series course teaches the basic commands and features of Microsoft Project 2013. Trainees will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. Trainees will also apply filters and groups, and sort task and resource data. Trainees will learn how to resolve resource conflicts.

Topic A: Project management concepts
Topic B: The Project window
Topic C: Project files

Tasks
Topic A: Creating a task list
Topic B: Modifying a task list
Topic C: The Work Breakdown Structure

Task scheduling
Topic A: Task links
Topic B: Task relationships
Topic C: Task options

Resource management

Topic A: The base calendar
Topic B: Resources and calendars
Topic C: Project costs

Views and tables
Topic A: Working with views
Topic B: Working with tables

Filters, groups, and sorting
Topic A: Filters
Topic B: Groups
Topic C: Sorting tasks and resources

Finalizing the task plan
Topic A: Finalizing schedules
Topic B: Handling resource conflicts

Unit 15:  Advanced Microsoft Project 2013– (16 hours)