Courses

TechMentors provides training courses for Microsoft Excel and Access.  Each can be taught in a one-on-one, or as a group class for your team.  Each can be taught over Zoom, or in your office (once the pandemic’s shelter-in-place has been lifted).

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

Back To Top