Microsoft Excel and Microsoft Excel VBA Training Help

• 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.

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.

  • View workshop outline

   

• 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.

  • View business workshop outline, View engineering and science workshop outline

   

• Advanced Excel VBA Programming - 3 days

  Select this workshop:

  • If you or your group have already used VBA at a basic level and want to go more in depth in the areas of data processing, automated chart construction, dashboard construction, database communication, userform construction and other program automation.

  • View business workshop outline, View engineering and science workshop outline

   

• 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.