Computer Skills
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.
Units
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
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
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
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
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
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 table
- 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
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
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
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
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
- Start PowerPoint
- Apply a slide layout
- Use the PowerPoint screen
- Use shortcut menus
- Use slide design templates
- Use placeholdersshow an audience the main topics or to illustrate items with charts
or tables.
In this unit the student will learn to:
- 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
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
Slide masters and transitions
- 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
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.
Getting started
- 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
Using templates and importing data
- Topic A: Working with templates
- Topic B: Creating projects from other programs
Managing a project
- Topic A: Setting baselines
- Topic B: Updating an active project
- Topic C: Monitoring progress
Analyzing and adjusting the plan
- Topic A: Analyzing the plan
- Topic B: Delays and conflicts
- Topic C: Team Planner view
Working with reports
- Topic A: Standard reports
- Topic B: Visual reports
Customizing Project
- Topic A: Custom views
- Topic B: Macros
- Topic C: Gantt chart formatting
- Topic D: Custom fields
Managing multiple projects
- Topic A: Consolidating and sharing projects
- Topic B: Sharing resources among projects
Exchanging project information
- Topic A: Collaboration
- Topic B: Hyperlinks
- Topic C: Exporting to Office applications