Training

Many people have gained their experience in Microsoft Excel by trial and error -- they are self-taught, and for the most part, are able to “get by” with their current skills.

After receiving training, you will no longer have to settle with just “getting by,” but the skills you will acquire will enhance the ones you already have developed, and teach you techniques and shortcuts that will have a big impact on your productivity and efficiency.

Now you will be able to get the job done faster and with less frustration!

Classroom-based and on-site training, including Microsoft Excel and custom applications

Customized Workshops for Your Company

  • Micro Touch can tailor an Excel workshop to meet your company's specific needs at no additional cost.
  • One great advantage is our customized scheduling of the 6-hour course to your busy schedule. We can present training in multiple 2-hour slots on any business day that is convenient for you and your staff.
  • We also offer individual or small group sessions for your staff that cover what your staff wants to learn at and their learning pace.
  • Look below to get an idea of what we usually cover then email us if you have any additional questions about Excel topics not mentioned.

What is Included in Our Workshops

  • State of the art CD-ROM manuals, which explain in detail the Excel topics discussed in class. These manuals contain state of the art screen shots of Excel, step-by-step Excel instructions, useful Excel tips, the examples covered in class and supplementary examples.
  • In-class consulting on your company’s specific Excel problems. The class can be designed around the problems faced by your company.

Basic Excel Training

Level 1

For people that have never used Excel before or have a very limited knowledge of it.

It is recommended that you have a basic understanding of the Windows environment.

  1. Understanding the Excel Spreadsheet Screen
  2. Entering Labels and Values and Formatting
  3. Adding and Subtracting Values using + or - and SUM
  4. Multiplying and Dividing Values
  5. Averaging Values using AVERAGE
  6. Copying and Editing Values and Formulas
  7. Printing the Worksheet
  8. Creating a Multiple Tab Worksheet
  9. Using SUMIF to categorize values
  10. Linking Values from one Worksheet to Another

Intermediate Excel Training

Level 2

For people that have used Excel before and have a basic understanding of it.

  1. Excel Worksheet Functions
  2. Excel RANGE names
  3. Excel Charting
  4. Database Sorting
  5. Database Filtering
  6. Worksheet Protection and Security
  7. Beginning Macros using the Recorder
  8. Print Formatting Techniques
  9. Worksheet Forms objects (Drop down boxes, radial buttons, text boxes)
  10. Adding Graphic Objects to Worksheets

Advanced Excel Training

Level 3

For Excel users that have a good understanding and have applied their knowledge.

  • Macros
  • MS-Forms object
  • Visual Basic for Applications (VBA)
  • Other topics arranged by client request