Microsoft Excel workshops 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 EMAGENIT newsletter signup - Discounts Contact EMAGENIT about your questions Follow us on linked in and receive discounts up to 25% off our training upcoming Microsoft Excel classes and other EMAGENIT services

Microsoft Excel and Microsoft Excel VBA Public Seminar Training Microsoft Excel and Microsoft Excel VBA Onsite Training Microsoft Excel Webinar and Microsoft Excel VBA Webinar Training Our Complete Microsoft Excel and Microsoft Excel VBA Training Schedule Compare Our Microsoft Excel and Microsoft Excel VBA Workshops Microsoft Excel Self-Study Training Manuals Award Winning Microsoft Excel Software Design We are more than happy to answer any of your questions EMAGENIT - Microsoft Excel Training, Excel VBA Training and Excel Software Design

EMAGENIT - Microsoft Excel Training, Excel VBA Training and Excel Software Design

Our Next Microsoft Excel and Excel VBA Training Dates

Excel for Business

Beginning Microsoft Excel Workshop for Business Professionals - Outline and Signup

09/30/14

Beginning Microsoft Excel Training for Business Professionals

Public Seminar and Online Live Webinar

Intermediate Microsoft Excel Workshop for Business Professionals - Outline and Signup

10/01/14 

Intermediate Microsoft Excel Training for Business Professionals

Public Seminar and Online Live Webinar

Advanced Microsoft Excel Workshop for Business Professionals - Outline and Signup

10/02//14 

Advanced Microsoft Excel Training for Business Professionals

Public Seminar and Online Live Webinar

Excel for Business

Microsoft Excel Dashboards Workshop - Outline and Signup

10/14/14 - 10/16/14

Microsoft Excel Dashboards Training - Combined Audience

Public Seminar and Online Live Webinar

Beginning Microsoft Excel VBA Workshop for Business Professionals - Outline and Signup

11/03/14 - 11/04/14

Beginning Microsoft Excel VBA Training for Business Professionals

Public Seminar and Online Live Webinar

Advanced Microsoft Excel VBA Workshop for Business Professionals - Outline and Signup

11/05/14 - 11/07/14

Advanced Microsoft Excel VBA Training for Business Professionals

Public Seminar and Online Live Webinar

Excel for Engineering and Science

Microsoft Excel Workshop for Engineers and Scientists -Outline and Signup

12/22/14

Advanced Microsoft Excel Training for Engineers & Scientists

Public Seminar and Online Live Webinar

Beginning Microsoft Excel VBA Workshop for Engineers and Scientists - Outline and Signup

12/15/14-12/16/14

Beginning Microsoft Excel VBA Training for Engineering and Science

Public Seminar and Online Live Webinar

Advanced Microsoft Excel VBA Workshop for Engineers and Scientists - Outline and Signup

12/17/14-12/19/14

Advanced Microsoft Excel VBA Training for Engineering and Science

Public Seminar and Online Live Webinar

About EMAGENIT

View our NASA award for our Microsoft Excel work on the Mars Rover project

Pronounced "Imagine-IT", we specialize in Microsoft Excel training, Microsoft Excel VBA training and Microsoft Excel software design. We have been training and developing software in Microsoft Excel for over 15 years. At EMAGENIT, we have been personalizing our training and problem solving since our very first day of business. We offer a wide variety of Microsoft Excel and Microsoft Excel Visual Basic programming workshops to take you from the beginning to the most advanced Excel power use. Our experience includes developing Microsoft Excel applications for companies like Time Warner, NASA JPL, Caterpillar and the US Navy so whom better to teach you than a company that actually uses what they teach. We have also won awards from NASA for our Excel software design on the Mars Rover project.

Our innovative style of teaching provides you with the best hands on training in the industry. You will be amazed at how much you can learn in such a short amount of time. Our training programs are taught onsite at your workplace, through a live broadcast webinar or you can come to one of our public seminar courses. Anytime you take a course from us, you can come back any time and retake it free, an exceptional value (free repeat details).

Free Microsoft Excel Tips and Help

Free Microsoft Excel Training Help

Our free Microsoft Excel Help Topics page provides useful information on basic Excel operation, Excel worksheet functions and using VBA to command Microsoft Excel. View Our Microsoft Excel Help Page

 

Microsoft_Excel_Workshop_Quick_Look

   Beginning Excel        Intermediate Excel         Advanced Excel       Beginning Excel VBA        Advanced Excel VBA

Public and Webinar Business Workshops - Quick Look

Beginning Microsoft Excel for Business Professionals - Outline and SignupBeginning Microsoft Excel Training for Business

Duration: 1-day

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Beginning Excel Training Introduction

Our "basic" Microsoft Excel 1-day workshop that shows you the fundamentals of Excel like entering data, formatting, copying and pasting, basic formula construction, auto summing and more. It not only teaches you the basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday problems.

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

Beginning Microsoft Excel for Business Professionals - Outline and Signup

Intermediate Microsoft Excel for Business Professionals - Outline and SignupIntermediate Microsoft Excel Training for Business

Duration: 1-day

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Intermediate Excel Training Introduction

Our "data processing and formulas" Microsoft Excel 1-day workshop that shows you how to build powerful formulas using VLOOKUP, IF, SUMIFS..., link and manage sheet information, organize process and analyze worksheet data, build professional charts, build pivot tables, process text, link to Word and PowerPoint and much more.

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 logic in formulas using the IF, AND, OR and IS functions

  • How to use data validation and conditional formatting

  • How to filter data using auto filter, text wizard and text to columns

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

  • How to build basic pivot tables

  • How to create professional looking business charts

  • How to link Excel to Word and PowerPoint for reports

Intermediate Microsoft Excel for Business Professionals - Outline and Signup

Advanced Microsoft Excel for Business Professionals - Outline and SignupAdvanced Microsoft Excel Training for Business

Duration: 1-day

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Advanced Excel Training Introduction

Our "advanced analysis and basic dashboards" Microsoft Excel 1-day workshop that shows you how to create advanced analysis, data processing and basic dashboard tools in Microsoft Excel. It focuses on how to use advanced formulas, worksheet functions, ActiveX controls, logical formulas, conditional formatting, data validation, pivot tables and charts to assemble these complex tools. It also provides an introduction to macros (VBA).

In our Advanced Microsoft Excel training workshop you will learn:

  • A full formula, cell naming and workbook linking review

  • How to construct and use ActiveX controls on the worksheet

  • How to create business dashboards using formulas, charts, drawing shapes, data validation, conditional formatting and ActiveX controls

  • How to create advanced formulas for data processing that use advanced logic and can adjust to changing data

  • How to design worksheet tables that can be used with advanced formulas and as databases

  • How to import text files into Excel

  • How to integrate business data in Excel by linking with external data using MS Query, XML and Text Wizard

  • How to link Microsoft Excel with other applications like Word and PowerPoint

  • How to create advanced pivot tables and pivot charts

  • An introduction to VBA macros including creating your own custom worksheet functions to replace large cumbersome worksheet formulas

Advanced Microsoft Excel for Business Professionals - Outline and Signup

Beginning Microsoft Excel VBA for Business Professionals - Outline and SignupBeginning Microsoft Excel VBA Training - Excel Macros for Business

Duration: 2-days

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

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 calculations, processing worksheet data, moving information, creating charts, building pivot tables, building report generation tools in Word and PowerPoint and more.

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

Beginning Microsoft Excel VBA for Business Professionals - Outline and Signup

Advanced Microsoft Excel VBA for Business Professionals - Outline and SignupAdvanced Microsoft Excel VBA Training - Excel Macros for Business

Duration: 3-days

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Advanced Microsoft Excel Macro Training Introduction

Our 3-day "hands-on" Excel VBA training shows you how to construct advanced business 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.

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

Advanced Microsoft Excel VBA for Business Professionals - Outline and Signup

Combined Audience Workshops - Quick Look

   Microsoft Excel Dashboards

Public and Webinar Combined Audience Workshops - Quick Look

Microsoft Excel Dashboards - Outline and SignupMicrosoft Excel Dashboards Training - Combined Audience

Duration: 3-days

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Microsoft Excel Dashboards Training Introduction

Learn how to create advanced dashboards that let you visualize and integrate your Excel data. Developed from our Excel software design experiences, our 3-day "hands-on" workshop shows you how to create sophisticated Microsoft Excel dashboards including status displays, project management displays, Gantt charts, chart gauges, various summary charts, maps, pivot charts and any other dashboard you can dream up. It shows how to use all of Microsoft Excel's capabilities to construct these sophisticated dashboards and more importantly the strategies behind putting them together.

In our Microsoft Excel dashboards workshop you will learn:

  • How to create status displays, project management displays, Gantt charts, chart gauges, various summary charts, maps, pivot charts and any other dashboard you can dream up

  • A complete Excel formula review including debugging

  • How to format worksheets, use drawing shapes  and use pictures to produce professional looking Excel dashboards

  • How to build and format the advanced charts that are at the core of your Microsoft Excel dashboards

  • How to construct, manage and use names in Excel to identify the cells and ranges that your dashboards will use

  • How to construct names using formulas that automatically find cells, ranges and adjust to changing data

  • How to process and reorganize the data that your dashboards will need

  • How to construct proper tables in Excel that your Excel dashboards can use

  • Advanced ways to use conditional formatting in your Microsoft Excel dashboards

  • Advanced ways to use data validation in your dashboards

  • How to build and integrate ActiveX controls in your dashboard

  • How to build advanced formulas that process your Excel data

  • How to create the advanced logic formulas that your Excel dashboards will need

  • How to use Excel's data features to filter and integrate the data that your dashboard will use

  • How to insert Microsoft MapPoint in your Excel dashboards

  • How to put it all together to build that advanced dashboard

Microsoft Excel Dashboards - Outline and Signup

Engineering Workshops - Quick Look

   Microsoft Excel Training       Beginning Excel VBA        Advanced Excel VBA

Public and Webinar Engineering Workshops - Quick Look

Advanced Microsoft Excel for Engineers and Scientists - Outline and SignupAdvanced Microsoft Excel for Engineers & Scientists

Duration: 1-day

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Microsoft Excel Training 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.

Advanced Microsoft Excel for Engineers and Scientists - Outline and Signup

Beginning Microsoft Excel VBA for Engineers and Scientists - Outline and SignupBeginning Microsoft Excel VBA Training - Excel Macros for Engineers & Scientists

Duration: 2-day

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

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 the technical features of Excel. It also shows how to use VBA to manage worksheet cells and information, control worksheets and workbooks, process resizing technical data, perform calculations, create technical charts, build custom worksheet functions and powerful system models, build basic dashboards and more.

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

Beginning Microsoft Excel VBA for Engineers and Scientists - Outline and Signup

Advanced Microsoft Excel VBA for Engineers and Scientists - Outline and SignupAdvanced Microsoft Excel VBA Training - Excel Macros for Engineers & Scientists

Duration: 3-days

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

Available:  Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Advanced Microsoft Excel Macro Training Introduction

Excel VBA Training Introduction:  Our 3-day Excel VBA training shows you "hands-on" from an engineering & science perspective how to create advanced data analysis tools, system 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

Advanced Microsoft Excel VBA for Engineers and Scientists - Outline and Signup

 

 

 

Site Map

Copyright 2002-2014 EMAGENIT All Rights Reserved