Computer Training

These computer training seminars are instructor-led in our computer lab. Our course are specifically designed to provide you with a hands-on learning experience of practical application. Each of these courses can also be modified for private training. If you have questions about a specific course or when it will be scheduled please contact us.

Access (End User)

If you're responsible for tracking and managing data for your company, learning how to effectively use Microsoft Access can increase your effectiveness, help you save time, and protect important contact information and records. MTI's Microsoft Access course is designed to provide attendees with the skills they need to properly create and utilize Access databases. Note: Participants must have strong computer skills and a solid background working with Excel to enroll in this class.

Learning Objectives

This course is designed to provide skilled computer users with the training they need to plan and set up a Microsoft Access database, including working with tables, queries, forms, and reports. This two day, hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC.

Topics Covered Include:

  • Creating a Database
  • Organizing Data
  • Entering Data
  • Modifying a Table
  • Relationships Among Tables
  • Queries
  • Filtering Data
  • Forms
  • Reports
  • Importing and Exporting Data
  • Linking from Excel
  • Linking to other Access databases or SQL Server tables
Basic SQL Server

This two day seminar is designed to familiarize students with basic to somewhat advanced select statements (queries) using Microsoft SQL Server. Four sample databases (and stored procedures that  reference them) are provided for discussion and practice.  Unlike many sample databases available, each sample  database has enough complexity to provide useful practice, but is not too complex to be understood by a beginner.

SQL Server Benefits

SQL Server is MUCH MUCH more powerful than either Microsoft Query or Microsoft Access. SQL Server allows for much more  complex manipulations, and the queries are easier to write. SQL can perform very complex manipulations on numerical, datetime, and text data "in bulk". You write the formula  one time, and SQL does the manipulation/calculation for all  selected records.

  • If you use Microsoft Query to pull and manipulate data from MS Excel, you know it is quite limited.
  • If you use MS Access for reporting, you probably have many subqueries that must be joined into a main query (such as qryMonthly_FinalResults, qryMonthly_sub1, qryMonthly_sub2, qryMonthly_sub3, qryMonthly_sub4, qryMonthly_sub5, etc.) SQL Server can consolidate these subqueries into just one stored procedure (query) using either Unions or Correlated  Subqueries. 
  • Union queries are much easier to create in SQL than in  Access. Joins are easier to understand. Table variables (tables created in memory) can be made then updated to manipulate data into very complex information easily.
  • SQL Server's "Case" statement replaces nested If statements, and are incredibly simpler to write.
  • Stored Procedures with input parameters allow the reuse  of a single query for multiple sets of criteria (where salesDate Between @startDate and @endDate), so you can execute the stored procedure at any time with different dates.

Topics include:

  • Creating Tables
  • Primary Keys and Unique Indexes
  • Table Relationships
  • Select Statements
  • Joins - Inner, Left, Right
  • Casting
  • Converting Dates
  • Datepart()
  • Datename()
  • Aliasing
  • Left and Right functions
  • Concatenation
  • And/Or
  • Case statements
  • Parameters
  • Wildcards
  • Stored Procedures
  • Variables
  • Aggregates (SUM, COUNT, MIN, MAX) and Group By
  • Correlated Subqueries
  • IF statements
  • GOTO and RETURN
  • UNION
  • Exists / Not Exists

As time permits, the following topics might be covered:

  • Insert Statements
  • Table Variables
  • Update Statements
  • While Loops

Note: The use of Microsoft Access for linking to SQL Server and linking from Excel will be covered. Making MS Access reports is not covered; regsister for our Microsoft Access user level course to learn that skill. Using SSIS (SQL Server Integration Service) for importing in bulk directly from Excel will also be covered.

Pre-requisite Knowledge

Prospective students should be familiar with the following topics in MS Excel: Data Types (formats), Naming Rules, Data Validation, Naming Cell Ranges

Machine Requirements:

This class is taught in a computer lab with desktop computers. If you want to use your laptop instead of our machines, the following requirements apply:

  • The "Pro" version of your Microsoft operating system. The "Home" version of any OS will not run SQL Server. You will need at least XP Pro.
  • SQL Server 2005 or greater (SQL Server 2005 Express is fine). Both SQL Server 2005 Express and SQL Server 2005 Mangement Studio Express, and directions for installation are available for download on MTI's FTP server. Once you are registered for the course, you will get a username and password.
  • The installation disc for your operating system will be  required to add some features.
  • To add features and programs, you must be an  administrator on the laptop.
Excel Advanced

Need to learn the advanced functions of Excel to create powerful computerized spreadsheets? If you've already mastered the basics of Excel, MTI's hands-on advanced class is exactly what you need!

If you are very well versed in the basics of Excel and are ready to master the advanced functions of this powerful application, this class is designed to meet your needs. Skilled Excel users can fully utilize the functionality of Excel to develop spreadsheets that can effectively be used as management tools in their organizations. This course is recommended only for those who already possess very strong skills in Excel.

Learning Objectives

This course is designed to provide skilled Excel users with advanced training in this powerful software application. This two-day, hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC and can choose to work on Excel version 2007 or 2010.

Topics Covered Include:

  • 3-D References
  • VLookup, HLookup
  • Sorting Data
  • Filtering Data
  • Date and Time Functions
  • If Functions
  • Hide/show formulas/values
  • Images and Drawing Objects
  • Inserting & Formatting Images
  • Group Editing / Collaboration Tools
  • Charts & Tables
  • Pivot Tables
Excel Essentials

Need to learn how to use Excel to create powerful computerized spreadsheets? MTI's hands-on computer class is exactly what you need!

If you're responsible for creating spreadsheets and tracking information for your organization, learning how to effectively use Microsoft Excel can increase your effectiveness, help you save time, and allow you to effectively track critical business information. MTI's Microsoft Excel Essentials course is designed to provide attendees with the skills they need to create and use Excel spreadsheets.

Learning Objectives

This course is designed to provide participants with the skills they need to effectively utilize Microsoft Excel. This two-day hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC. Participants may choose to utilize Excel 2007 or 2010 during class.

Topics Covered Include:
 

  •     Creating, Saving, Opening Workbooks
  •  
  •     Adding and Naming Worksheets
  •  
  •     Editing Data in Cells
  •  
  •     Selecting Cells
  •  
  •     Formatting a Worksheet
  •  
  •     Merging Cells
  •  
  •     Cell Alignment
  •  
  •     Changing Row Height and Column Width
  •  
  •     Page Breaks
  •  
  •     Formulas (Addition, Subtraction, Multiplication, Division)
  •  
  •     Order of Operations
  •  
  •     AutoSum
  •  
  •     Relative / Absolute References
  •  
  •     Filling Formulas
  •  
  •     Functions (Average, Min, Max, Sum, Count)
  •  
  •     Selecting nonadjacent cells
  •  
  •     Inserting/Deleting Cells, Rows, Columns
  •  
  •     Borders and Shading
  •  
  •     AutoFormat/Format Painter
  •  
  •     Hide/Unhide columns, rows
  •  
  •     Paste Special… Options
  •  
  •     Hyperlinks
PowerPoint Essentials

If you're responsible for running meetings, conducting employee orientation sessions, or leading training sessions, learning how to use PowerPoint can increase your effectiveness and help you save time. MTI's PowerPoint Essentials seminar is designed to provide attendees with the skills they need to create their own PowerPoint presentations.

Learning Objectives

This course is designed to provide attendees with the training they need to create computerized presentations and handouts using PowerPoint. This half-day, hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC.

Topics Covered Include:

  • Planning the Presentation
  • Elements of the Main Window
  •  Using templates
  • Views
  • Text Boxes
  • Formatting Text
  • ClipArt
  • Outline View
  • Promoting / Demoting Text
  • Summary Slides
  • Copying and Deleting Slides
  • Masters
  • Themes and Designs
  • All Slides, Selected Slides
  • Changing the Color Scheme
  • Animating Text
  • Inserting Images

Word Essentials

If you're responsible for creating and editing various types of documents for your company, learning how to effectively use Microsoft Word can increase your effectiveness, help you save time, and allow you to create business documents that send the image your organization wishes to convey. MTI's Microsoft Word Essentials course is designed to provide attendees with the skills they need to properly create documents using this powerful word processsing application.

Learning Objectives

File / Organization Basics

  • Creating & Renaming Folders
  • Saving As…
  • Search/Find files
  • Headers and Footers

Page Numbering

MS Office General Shortcut Keys

Using the Ribbon – Thinking Like Microsoft (Categorically)  

Formatting Text

  • Changing Font Face, Size
  • Using Styles
  • Bullets and Numbering
  • Finding and Replacing Text Update practice documents.

Formatting Paragraphs

Formatting Documents

  • Columns
  •  Page Orientation
  • Themeing

Spelling and Grammar Checking

 Working with Images

  •  Inserting ClipArt
  •  Inserting Images
  •  Text Wrapping Around Images Update practice documents.
This course is taught in a hands-on lab, learning by doing. The course is designed for beginners with a few more advanced operations, but most self-taught word users tend to learn new process that make doing the job easier.