Call us at:   1.805.498.7162     1.805.558.9277

Microsoft Excel training options for business, engineering and science Innovative Microsoft Excel software design View our customer list from our over 14 years in business Phone numbers, email address and contact form Learn about EMAGENIT Home page containing upcoming Microsoft Excel classes and other EMAGENIT services Self-study Microsoft Excel manuals for business, engineering and science Microsoft Excel consulting services Microsoft Excel training schedule and prices

Home > Microsoft Excel Workshops > Microsoft Excel and Microsoft Excel VBA Training Guide

Microsoft Excel and Microsoft Excel VBA Training Guide

Microsoft Excel and Microsoft Excel VBA Training Help

for Business, Engineering and Science

Our Training Guide and what you get in our workshops is presented below. The guide will help you figure out the right Excel training course for your needs. Also a note, click on the red E button above and get even more training value for your money.

Free Workshop Repeats: Learning is not a one time event.

 
 

Free Repeats


Repeat Your Workshop for Free

  • Public Workshops: EMAGENIT allows you to repeat your public workshop as many times as you want, no date or repeat limit.

  • Webcast Workshops: If you take a live webcast workshop, you can take it again 3 times for free via the web, no date limit. Special arrangements can be made however, check with EMAGENIT for details.

    • You can then attend any public offering of the same webcast workshop for free as many times as you like, no date or repeat limit.

  • Onsite Workshops: If you take a specialized onsite workshop from us and would like to take the class again, EMAGENIT will place you in an equivalent public or webcast workshop.

  • Person Based Policy: Our repeat policy is person based not company based. If you switch employers, you can still repeat your workshop.

 

 

Workshop Manual


Manual Included in Workshop

  • A CD of either our Excel Aided Business or Excel Aided Engineering manual. These manuals contain over 1800 pages of how to instruction and hundreds of examples.

 

 

Step #1 - EMAGENIT Training Categories


Two Main Categories

EMAGENIT training is divided into two major categories:

  • Business

  • Engineering and Science

Before proceeding make a determination of what category best represents what you or your group do.

 

 

 

Step #2 - How Do You Want to Train


Four Ways to Train

EMAGENIT offers the following training options for business, engineering and science:

  • Public: You or your group travel to us

  • Webcast / Webinar: We train you or your group interactively over the web hands-on

  • Onsite: EMAGENIT travels to your company

  • Self Study: Buy a manual from us and get 3 months e-mail interaction

Before proceeding choose the training option. All of our training options can be found on the home page or under the Excel Workshops item in the main menu. Our homepage always lists our current public and webinar workshops and their upcoming training schedules.

 

 

Step #3 - What Do You Want to Learn


How We Break Down Our Training

EMAGENIT presents two types of Microsoft Excel training:

  • General Excel Training: You or your group learn how to write formulas, construct pivot tables, format worksheets, construct array formulas, filter data...etc, basically manually manipulating the Excel environment.

  • Excel VBA Programming - Macros: You or your group learn how to write computer code in Visual Basic for Applications (VBA) that automate Microsoft Excel tasks like data processing, automatic chart creation, commanding Microsoft Word and PowerPoint...etc. Generally, any workshop with VBA or Macros in its title is going to deal with programming. What is VBA?

 

 

Step #4 - Picking a Workshop


Use the following break down to identify the proper workshop for your needs.

General Microsoft Excel Training

  • Beginning Microsoft Excel for Business - 1 day

    Select this workshop if you or your group have:

    • Never opened Microsoft Excel

    • Just typed data in it

    • Have never typed formulas

    • Have never sorted or filtered data

    • View workshop outline

    If you or your group have already typed a basic formula, sorted or filtered data then select the intermediate workshop.

     

  • Intermediate Microsoft Excel for Business - 1 day

    Select this workshop if you or your group want to learn how to:

    • Write thinking formulas and basic array formulas

    • Construct summary worksheets and basic dashboards

    • Use worksheet functions like VLOOKUP, SUMPRODUCT, SUMIF, MATCH, IF, INDEX or SUM

    • Process data

    • Build charts

    • Build pivot tables

    • View workshop outline

     

  • Advanced Microsoft Excel for Business - 1 day 

    Select this workshop if you or your group want to learn how to:

    • Construct advanced dashboards using charts, array formulas (SUMPRODUCT, SUMIF, INDEX, MATCH, ROW...), conditional formatting, data validation and ActiveX controls

    • Create formulas that adjust to data size and adjusting headers

    • Build advanced pivot tables

    • Query databases

    • Import text files and clean text

    • Link Excel and Word/PowerPoint

    • View workshop outline

     

  • Microsoft Excel For Engineers and Scientists - 1 day 

    Select this workshop if you or your group want to learn how to:

    • Construct advanced dashboards using charts, array formulas (SUMPRODUCT, SUMIF, INDEX, MATCH, ROW...), conditional formatting, data validation and ActiveX controls

    • Create formulas that adjust to data size and adjusting headers

    • Build pivot tables

    • Process data

    • Create custom worksheet functions in VBA

    • Import and clean text files and text

    • Link Excel and Word/PowerPoint, link workbooks

    • View workshop outline

 

Microsoft Excel VBA Programming (Excel Macros)

  • Introduction to Excel VBA - 1 day

    Select this workshop:

    • If you have never seen VBA before and need to start using it without 2-days worth of instruction. It teaches the VBA essentials that professionals commonly use.

     

  • Beginning Excel VBA Programming - 2 days

    Select this workshop:

    • If you or your group have never programmed, just used the macro recorder or it has been years since programming. It covers the VBA language, data processing, automated chart construction, basic dashboards, analysis and more.

     

  • Advanced Excel VBA Programming - 3 days

    Select this workshop:

     

  • Microsoft Excel Dashboards - 3 days

    Select this workshop:

    • If you want to focus solely on making dashboards that control your data or models. It will lead you through making them with formulas then turn around and use VBA to make them.

    • View workshop outline

 

Onsite Workshops

  • EMAGENIT has a great deal of workshops that we can present onsite.

  • Please consult the Onsite page for more details or call us at 805.498.7162 for the training levels of these workshops and how we can mix and match them.

 

 

 

 

Site Map 

Copyright © 2002-2012 EMAGENIT All Rights Reserved