Training Services

You and your employees need to be as productive as you can to make it in today’s competitive market. To become productive, people need knowledge and skill. In the past gaining knowledge was limited to reading a book or going to a class. Skill was gained through practice. Both took lots of time and included examples and exercises that had nothing to do with your business.

What if there were a better way? What if the instructor was a skilled mentor who first learned about your business and then created written lessons and exercises that applied directly to your business? What if the courseware was a searchable PDF file?  What if the teaching was recorded for later review? And what if, after the instruction, the mentor periodically met with your people and followed up on their progress? Would that make a difference?

TechMentors helps businesses make a difference.  To make your team knowledgeable, skilled, and productive we use the generic courses listed below to create custom curriculum that will meet your needs. It can include your real-world examples, one-on-one or group training via Zoom, customized practice exercises, and follow up.

EXCEL COURSES  ACCESS COURSES  $ PRICING  REGISTER

Microsoft Excel Courses

Excel
Essentials

Ideal for individuals who are brand new to spreadsheets

  • Create worksheets
  • Cells and ranges
  • Data tables
  • Simple formulas
  • Simple functions
  • Charts

This is a 6-hour course

MORE INFO REGISTER

Excel
Review

A quick refresher course that fills in gaps for the self-taught

  • Navigation tips
  • Manipulate data
  • Printing
  • Basic Pivot Tables
  • Basic formulas and functions

 

This is a 4-hour course

MORE INFO REGISTER

Excel
Formulas & Functions

A full course just on doing simple to advanced calculations in Excel.

  • Review basic formulas
  • Named ranges
  • Summary, Math, Lookup, Text, Date, If…Then, and more
  • Combine functions for complex calculations

This is a 6-hour course

MORE INFO REGISTER

Excel
PivotTables

Covers basic through advanced features of PivotTable reports and charts

  • Basic Pivot Tables
  • Pivot Table Tricks
  • Sorting and grouping
  • Filtering and slicers
  • Style and layout options
  • Calculated fields and items

This is a 6-hour course

MORE INFOREGISTER

Excel
Macros and VBA

Learn to automate Excel with Macros and the VBA programming language

  • VBA terms and syntax
  • Create and record macros
  • Variable and constants
  • Interacting with users
  • Decision structures
  • Loops

This is a 12-hour course

 REGISTER

Excel
VBA Forms

Learn to enhance your macros with user-friendly fill-in-the blank VBA forms

  • Create forms
  • Add labels, text boxes, images, drop downs, buttons, check boxes and more
  • Program the form
  • Update sheet with form data

This is a 6-hour course

 REGISTER

Microsoft Access Courses

Access
Overview

Overview course ideal for those who need to understand and use an existing Access database.

  • Parts of an Access Database
  • Front- and back-end files
  • View, enter and delete data
  • Find and sort data
  • Run reports
  • Create simple queries

This is a 6-hour course

 REGISTER

Access
Introduction

Provides an introduction to building Access databases.

  • Parts of an Access Database
  • Using Views
  • Fields, Records and Tables
  • Basic Table Relationships
  • Create Queries
  • Create Forms
  • Create Reports

This is a 6-hour course

REGISTER

Access
Queries

Learn to create simple and advanced queries to extract database data

  • Review Query Basics
  • Query Calculations
  • Multi-table Queries
  • Sorting and Filtering Data
  • Interactive Queries
  • Exporting Queries to Excel

This is a 6-hour course

REGISTER

Access
Action Queries

Learn to create action queries and advanced select queries.

  • Update Queries
  • Append Queries
  • Make-table Queries
  • Delete Queries
  • Cross-tab Queries
  • SQL Queries
  • Union Queries

This is a 6-hour course

 REGISTER

Access
Forms and Reports

Learn to develop and modify forms and reports

  • Edit existing forms and reports
  • Keyboard shortcuts
  • Properties, anchors  and layouts
  • Headers and Footers
  • Drop-downs list boxes, buttons and images

This is a 6-hour course

REGISTER

Access
Advanced Forms & Reports

Create advanced forms and reports in Microsoft Access.

  • Option Groups
  • Toggle buttons
  • Sub-forms and sub-reports
  • Tabs for multiple layers
  • Dialog boxes
  • Linked forms
  • Dynamic reports

This is a 6-hour course

REGISTER

Access
Macros

Lean to automate your database with Access macros.

  • What is a macro?
  • Create a general purpose macro
  • Create an embedded macro
  • Make macros interactive
  • AutoKey macros
  • AutoExec macros

This is a 6-hour course

 REGISTER

Access
VBA

Learn to automate your Access database with the Visual Basic for Applications programming language.

  • Modules vs Macros
  • Converting macros into modules
  • Learn the VBA language
    (Objects, Properties, Methods, and Arguments)
  • Event driven programming

This is a 12-hour course

REGISTER

Access
Special Topics

A custom course where you pick one or more special topics.  Here are some examples:

  • Create a menu
  • Add user security and password protection
  • Email from Access
  • Interface with Excel, Word or PowerPoint
  • Any additional topic of your choosing.

Usually a 6 hour course

REGISTER

Pricing

Prices below are for generic courses delivered over the internet.

  • $75 per half-hour for a one-on-one
  • $195 per student for a 4-hour course
  • $295 per student for a 6-hour course
  • $595 per student for a 12-hour course

Contact us about customizing the curriculum and/or location to meet your needs

Back To Top