Call us at:   1.805.498.7162     1.805.558.9277

EMAGENIT

Innovative, Experience Driven Microsoft Excel Training, Self-Study Manuals and Software Design

Business, Engineering and Science

Excel and Excel VBA Training Schedule
	Our Excel and Excel VBA (macros) training schedule page displays all of our dates, pricing and signups for our Public and Webcast workshops. View Our Complete Training Schedule

Our Next Microsoft Excel Workshop
	Introduction to Microsoft Excel VBA 5/20/2013  8:30 - 4:00 PM PT Use our Excel VBA class to enhance your Microsoft Excel productivity skills reducing tasks that takes hours to seconds. Outline / Signup

-

-

--

-

-

-

-

Beginning Microsoft Excel Training for Business

Duration: 1-day

Included: 1800 + page manual, "hands-on" training,  free repeats

Beginning Excel Training Introduction

Our 1-day "hands-on" beginning Excel training teaches you not only basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday problems. Complete Outline and Signup

In our Beginning Microsoft Excel training workshop you will learn:

• Basic data entry

• Number formatting

• Basic formula construction

• How to use SUM, Max and Min

• Copying and pasting

• Sorting and filtering data

• Basic worksheet formatting like bolding, aligning, row/column adjustments

• Printing

Intermediate Microsoft Excel Training for Business

Duration: 1-day

Included: 1800 + page manual, "hands-on" training,  free repeats

Intermediate Excel Training Introduction

Our 1-day "hands-on" intermediate Excel training focuses on useful formula design for data processing and analysis. Also discussed are key topics like how to build basic dashboards, how to use key Excel worksheet functions like VLOOKUP and SUMIFS, how to use Excel's built in data processing tools and how to build and use basic pivot tables. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution. Complete Outline and Signup

In our Intermediate Microsoft Excel training workshop you will learn:

• How to build basic formulas, debug them and name cells and ranges

• How to arrange data on the worksheet so Excel's tools and formulas can read them

• How to perform table lookups using VLOOKUP and HLOOKUP, MATCH and INDEX

• How to clean and restore text on the worksheet using the LEFT, RIGHT, MID, SUBSTITUTE, CLEAN and TRIM worksheet functions

• How to build formulas that can toggle between tables using the INDIRECT function

• How to build summary/pricing worksheets using basic array formulas

• How to build logic in formulas using the IF, AND, OR and IS functions

• How to build basic dashboards using Data Validation, charts, Conditional Formatting and formulas

• How to filter data using Auto Filter, Advanced Filter, Text Wizard and Text to Columns

• How to create dynamic ranges in formulas that adjust to data size and header movement

• How to build basic pivot tables

• How to link Excel to Word and PowerPoint for reports

Advanced Microsoft Excel Training for Business

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Advanced Excel Training Introduction

Our 1-day "hands-on" advanced Excel training focuses on creating sophisticated Excel solutions using advanced formulas, dashboards, database queries, pivot tables and charts. We teach you how to develop these advanced solutions on the worksheet then how to assemble the appropriate Excel tools in ways you have never thought of before. It also provides an introduction to macros (VBA). In the workshop, we teach our clients how to develop a complete Excel strategy for a complex problem. Complete Outline and Signup

In our Advanced Microsoft Excel training workshop you will learn:

• Advanced formula construction, array formula construction, formula debugging and cell / range naming

• How to build advanced dashboards using data validation, conditional formatting, ActiveX controls, charts and drawing shapes

• How to design a proper worksheet table that can be used in advanced formulas and used as a database

• How to summarize data on multiple sheets using dynamic ranges that shift to changing tables size, moving headers and start stop points

• Advanced Microsoft Excel skills for constructing time formulas on the worksheet

• Advanced Microsoft Excel communication strategies with databases, text files and workbooks using Microsoft Query

• Advanced Microsoft Excel skills for linking separate workbooks and worksheets

• Advanced Excel skills for linking with other applications like Word and PowerPoint

• Advanced Microsoft Excel skills for importing text files

• Advanced Excel pivot table construction

• Introduction to VBA macros and the VBA Editor including custom worksheet function design

Beginning Microsoft Excel VBA Training - Excel Macros for Business

Duration: 2-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Beginning Microsoft Excel Macro Training Introduction

Our 2-day "hands-on" Excel VBA training shows you the fundamentals of using VBA to create powerful useful business tools in Microsoft Excel. It provides a complete review of the VBA language along with definitions of Excel objects, properties and methods and how to use them. It stresses not only the mechanics of using VBA with Excel but also the strategies behind building successful business programs. Important topics covered include controlling key Excel elements like ranges and worksheets, performing model calculations, processing worksheet data, creating charts, building pivot tables, building basic dashboards, building report generation tools in Word and PowerPoint and more. Complete Outline and Signup

In our Beginning Microsoft Excel VBA training workshop you will learn:

• How to use the Visual Basic (VBA) Editor and its debugging tools including using modules

• A complete review of the VBA language including Subs, Functions, variables, arrays, loops and logic

• The strategy of how to write loops and logic in your VBA code as well as how to assemble and organize programs

• How to control key Microsoft Excel tasks with VBA like formatting, sorting, filtering, moving data...

• How to control Basic Excel elements like workbooks, worksheets, charts and ranges using VBA

• How to perform calculations on worksheet models and data using expressions (formulas), VBA functions and worksheet functions in VBA

• How to use Microsoft Excel VBA to analyze resizing data on single and multi worksheets

• How to use VBA to copy/paste data in patterns and fill in tables in Excel

• How to create basic dashboards that control models and data in Microsoft Excel using VBA

• How to create and format basic charts and pivot tables using VBA

• How to use VBA to create report generation tools that use Word and PowerPoint

• How to use Excel VBA to build your own custom worksheet functions (UDFs), great for modeling and analysis problems

• How to use the Visual Basic Macro Recorder and interpret its recordings

• A basic discussion on how to control databases, workbooks and text files using ADO, SQL and VBA

Advanced Microsoft Excel VBA Training - Excel Macros for Business

Duration: 3-days

Included: 1800 + page manual, "hands-on" training,  free repeats

Advanced Microsoft Excel Macro Training Introduction

Our 3-day "hands-on" Excel VBA training shows you how to construct advanced business analysis tools in Excel. Excel VBA topics discussed include advanced analysis and data processing strategies, advanced information control, how to create and command ActiveX controls and userforms, advanced dashboard construction, advanced database control using SQL, modeling, and advanced command of Excel's features including pivot tables and charts. It not only shows how to use VBA to command Excel but also shows how to tie into other programs like Word and PowerPoint as well. Complete Outline and Signup

In our Advanced Microsoft Excel VBA training workshop you will learn:

• A complete review of Excel object, properties and methods and the VBA language

• How to control the Windows folder system and Windows registry using VBA

• How to use advanced worksheet functions, VBA functions and expressions in your code to splice text, figure out times and dates, process data....

• Advanced control of worksheets and workbooks including tracking multiples of them in your code at once

• Advanced VBA data processing techniques for data stored in multiple worksheets, workbooks and folders including summary table construction

• How to open, read, close and delete text files using VBA

• Advanced VBA programming techniques for creating charts

• How to create advanced business dashboards on worksheets using ActiveX controls, VBA, charts, shapes, cells and userforms

• How to create event driven programs using VBA including programs that run on a date/time or keystroke

• How to control models, their formulas and names using VBA including creating custom worksheet functions (UDFs)

• How to control the Excel Ribbon and create your own custom toolbars to run your programs

• How to control databases, workbooks and text files using DAO, ADO and SQL in VBA

• Advanced VBA techniques for communicating with other languages and programs including controlling Word and PowerPoint for report generation tools

Introduction to Microsoft Excel VBA Macros Training for Business, Engineering and Science

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Introduction to Microsoft Excel Macro Training Introduction

Our 1-day "hands-on" Excel VBA training shows you how to use VBA to control important Microsoft Excel tasks like copying and pasting, sorting, formatting, data processing and pivot table construction. It discusses VBA language fundamentals like loops, logic and variables then how to control Excel using VBA. Our training allows you to start controlling Microsoft Excel right away. Complete Outline and Signup

In our Introduction to Microsoft Excel VBA training workshop you will learn:

• How to use the Visual Basic Editor and debug your code

• How to write the VBA language including Subs, Functions, variables, arrays, loops and logic

• How to use VBA to control Excel

• How to use VBA to analyze data on on the worksheet

• How to use VBA to perform calculations on worksheet information

• How to automate charts and pivot tables using VBA

• How to use the Visual Basic Macro Recorder and interpret its recorded code

Microsoft Excel Dashboards Training for Business, Engineering and Science

Duration: 3-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Microsoft Excel Dashboards Training Introduction

Our 3-day "hands-on" Microsoft Excel training first shows you how to create sophisticated dashboards manually using advanced formulas, data validation, conditional formatting, charts, ActiveX controls and pivot tables. It then swings towards macros (VBA) and demonstrates how to build adaptive dashboards that control Excel's data and modeling features, userforms, ActiveX controls, databases and multiple workbook and worksheet stored data. Complete Outline and Signup

In our Microsoft Excel dashboards workshop you will learn:

• Advanced formula construction including array formulas that adapt to changing data

• How to construct correct worksheet tables that VBA, SQL and formulas can use

• How to develop formula based Excel dashboards that use ActiveX controls, conditional formatting, data validation, drawing shapes and charts

• How to construct and use names to identify cells and ranges including how to construct dynamic names

• A Microsoft Excel VBA language review emphasizing dashboard construction and analyzing and organizing business data

• How to use VBA to command Excel's dashboard elements including drawing shapes, pictures, cells, pivot tables, charts and ActiveX controls

• How to use VBA to summarize multiple workbook/worksheet data

• How to run VBA function procedures from a worksheet cell, key to modeling

• How to open multiple workbook files and text files automatically using VBA and the Windows filing system

• How to create event driven Excel dashboards using VBA

• How to communicate with databases (SQL Server, Access, ...) using DAO and ADO

Microsoft Excel Training for Engineers & Scientists

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Microsoft Excel Webinar Introduction

Our 1-day "hands-on" Microsoft Excel training focuses on useful formula design in the areas of data processing, analysis and modeling. It discusses formula basics along with advanced formula and array formula design that help engineers and scientists develop sophisticated analytical tools. Also stressed are key worksheet functions, model construction techniques and the text worksheet functions that allow data to be parsed (split) and cleaned before being analyzed, a huge problem in data processing. In addition to formula construction, how to create your own custom worksheet functions in VBA is also discussed. How to construct interfaces using ActiveX, data validation and conditional formatting is also covered in the workshop. Rounding out the discussion is how to build reports in Excel using pivot tables and linking Excel with Word and PowerPoint. Complete Outline and Signup

Beginning Microsoft Excel VBA Training - Excel Macros for Engineers & Scientists

Duration: 2-day

Included: 1800 + page manual, "hands-on" training,  free repeats

Beginning Microsoft Excel Macro Training Introduction

Our 2-day "hands-on" Excel VBA training shows engineers and scientists the basics of using Excel and VBA to create time saving technical tools. Our training shows you from an engineering & science perspective how to use VBA to command Excel, control worksheet cells and ranges, control worksheets and workbooks, process resizing data on worksheets, fill out data forms, perform calculations, create charts, create custom worksheet functions, build powerful models, build basic dashboards and more. Complete Outline and Signup

In our Beginning Microsoft Excel VBA training workshop you will learn:

• How to use the Visual Basic Editor, its debugging tools and modules

• A complete review of the VBA language including variables, loops, logic, arrays, functions...etc

• A complete review of how to put together a program in VBA and use loops and logic to control it

• How to control Microsoft Excel objects, properties and methods

• How to perform calculations in VBA using worksheet functions, expressions (formulas) and VBA functions

• How to control workbooks, worksheets and ranges using VBA including formatting and naming

• How to use VBA to fill data in forms

• How to use VBA to analyze engineering and scientific worksheet data and automatically adjust to its changing size

• How to move and reorganize data on the worksheet using VBA

• How to construct basic dashboards for data analysis and modeling purposes

• How to use VBA to manipulate worksheet based models and their formulas

• How to construct custom worksheet functions (UDF's) using Excel VBA (numerical analysis techniques discussion included)

• How to automate basic Word and PowerPoint features using Excel VBA for reporting purposes

• How to automate technical chart and pivot table construction using VBA

• How to use the Macro Recorder to obtain key Excel commands that are used in VBA

• Basic control of databases, workbooks and text files using ADO, DAO, SQL and VBA

Advanced Microsoft Excel VBA Training - Excel Macros for Engineers & Scientists

Duration: 3-days

Included: 1800 + page manual, "hands-on" training,  free repeats

Advanced Microsoft Excel Macro Training Introduction

Our 3-day "hands-on" Excel VBA training shows you from an engineering & science perspective how to create advanced data analysis tools, technical models, database tools, dashboard tools and program integration tools using Excel VBA.  Complete Outline and Signup

In our Advanced Microsoft Excel VBA training workshop you will learn:

• A complete VBA language review including the advanced use of loops, logic, variables, arrays and expressions in your code

• Advanced techniques for commanding key Excel objects, properties and methods including making an object from scratch in a VBA class module

• How to control the Windows file and folder system and the Windows registry using VBA. The Windows registry is a great place to store program and model information independent of a workbook.

• Advanced data processing techniques for accessing multiple worksheets, workbooks and folders including text files

• Advanced looping and object variable techniques for accessing and tracking massive amounts of data

• How to use advanced worksheet functions, VBA functions and expressions in your code to splice text, figure out times and dates, process data....

• How to create advanced automated charts using Excel VBA

• How to create advanced technical dashboards using charts, shapes, worksheets, pictures, userforms, ActiveX controls and VBA

• How to integrate ActiveX controls and VBA with existing worksheet models that are formula based

• How to create advanced custom worksheet functions for modeling and data analysis purposes

• How to create event driven applications including running procedures at a given time or key stroke

• How to create custom Excel toolbars from userforms and make buttons on the ribbon

• Advanced programming tips for communicating with FORTRAN, C and VB DLL's

• Advanced VBA programming strategies for communicating with databases using ADO, SQL and VBA