Intermediate Microsoft Excel Training for Business (1-day)

Our "data processing and formulas" Microsoft Excel workshop that shows you how to build power formulas using VLOOKUP, IF, SUMIF..etc, build pivot tables, process text files, process and analyze worksheet data, link to Word and PowerPoint and more.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Intermediate Excel Training Focus

Our "hands-on" intermediate Excel training focuses on useful formula design for data processing and modeling, using Excel's built-in range features like Data Validation, useful worksheet functions like VLookup and applying Excel's built-in data processing tools and worksheet functions to analyze and clean text files and worksheet 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. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs. For a complete outline, click the Workshop Outline button below.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Business Professionals

• Platform: Windows or Mac

• Training Materials: Included, 1800+ page manual including our Excel Add-Ins

• Training Method: Hands-on, interactive

• Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance

• Filtering data using Auto Filter and  Advanced Filter

• Working with text files using Text Wizard and Text to Columns

• Cleaning and restoring text in files using the Left, Right, Mid, Substitute, Clean and Trim worksheet functions

• Using Data Validation and Conditional Formatting

• Perform table lookups using VLookup and HLookup, Match, Index and Indirect

• Build summary/pricing worksheets

• Build pricing sheets that can toggle between pricing tables

• Build array formulas using VLookup, HLookup, CountIf, Match and SumIf...etc

• Use logic in formulas (IF, And, Or)

• Name cells and ranges

• Create dynamic ranges in formulas that adjust to data

• Link Excel to Word and PowerPoint for reports

• Build basic pivot tables

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Intermediate Microsoft Excel Training for Business Public Meeting Signup

Microsoft Excel Training for Engineers & Scientists (1-day)

Our "power formula" Excel workshop for engineers and scientists that shows you how to create powerful formulas using VLOOKUP, IF, OFFSET, MATCH, INDIRECT... that analyze data and perform sophisticated analysis. Also discussed is custom worksheet function design using VBA, modeling, numerical analysis techniques, pivot table construction, dashboard design and linking to Word and PowerPoint. This workshop is taught by an engineer.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Microsoft Excel Training Focus

Our "hands-on" Microsoft Excel training for both engineers and scientists focuses on useful formula design in the areas of data processing, analysis and modeling. Our workshop discusses formula basics along with advanced array formula design that help engineers and scientists develop sophisticated analytical tools. Included in our discussion are important worksheet functions like VLOOKUP, IF, INDEX, COUNTA, COUNTIF, AND, OR, OFFSET, ADDRESS, COLUMNS, ROWS and MATCH. Stressed are construction techniques that allow formulas to automatically adapt to and seek out their information needs. Also stressed are model construction techniques that allow large amounts of information to be maintained and transferred between worksheets and workbooks. The text worksheet functions are also covered 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. These functions can far out perform any formula created on the worksheet and are the key to creating powerful analysis routines for the worksheet. 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.

For a complete outline, click the Workshop Outline button below.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Engineers and Scientists

• Platform: Windows

• Training Materials: Included, 1800+ page manual including our Excel Add-Ins

• Training Method: Hands-on, taught by an engineer / software developer

• Repeat this workshop for free as many times as you want. View offer details

• Formula Basics: Basic formula design, formula debugging and cell name review

• Dashboards: How to use ActiveX controls, form controls, conditional formatting and data validation to create advanced interfaces on the Microsoft Excel worksheet

• Smart Worksheets: How to construct "smart" Microsoft Excel worksheets using Excel's logic, information, and lookup and reference worksheet functions including VLOOKUP, MATCH, OFFSET, COUNTIF, INDEX, INDIRECT, IF, AND, Or, ADDRESS, COLUMN, ROW

• Array Formulas: How to use array formulas to build advanced worksheet formulas that determine and adapt to changing information requirements

• Text Functions: How to use the text worksheet functions like RIGHT, MID, LEFT SUBSTITUTE, REPLACE, SEARCH and CLEAN to prepare data to be analyzed

• Databases / Lists: How to create and manage databases in Microsoft Excel

• Text Wizard and Text to Columns: How to import and parse data files in Excel

• Custom Worksheet Functions (VBA): How to create custom worksheet functions using VBA that replace mega formulas on the worksheet and allow numerical techniques to be employed on the worksheet

• Pivot Tables: How to create and use Microsoft Excel pivot tables for reports

• Linking Workbooks: How to link workbooks and worksheets together including team integration and large scale information transfer

• Link Excel to Word and PowerPoint: How to link Microsoft Excel to Word and PowerPoint for report generation

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Beginning Microsoft Excel VBA Training for Engineers & Scientists (2-days)

Our "workhorse" Microsoft Excel VBA workshop for engineering and science that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, create functions, build powerful models, build dashboards and command Word and PowerPoint. This workshop is taught by an engineer.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Beginning Excel VBA Training Focus

Visual Basic for Applications (VBA) can be used in conjunction with Microsoft Excel to construct automated engineering and science tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using VBA with Excel, engineers and scientists can develop analysis tools quickly with minimum cost. VBA can be used for engineering and scientific tasks like analyzing data, automating chart construction, building report generation tools, communicating with databases, constructing dashboards, system models the list is endless. This workshop discusses the basics of using Excel VBA in the engineering and science disciplines. For a complete outline, click the Workshop Outline button below.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Engineers and Scientists

• Platform: Windows

• Training Materials: Included, 1800+ page manual including our Excel Add-Ins

• Training Method: Hands-on, taught by an engineer / software developer

• Repeat this workshop for free as many times as you want. View offer details

• What is VBA?

• How engineers and scientists can use the Microsoft Excel Visual Basic Editor's debugging tools for their purposes

• How to use Visual Basic for Applications (VBA) for engineering and scientific purposes

• How to use the VBA language including variables, loops, logic, arrays, functions...etc

• How to control key Microsoft Excel program elements using VBA (Visual Basic)

• How engineers and scientists cans use VBA to analyze engineering and scientific data on the Microsoft Excel worksheet

• Basic dashboards design for engineers and scientists using Excel and VBA

• How engineers and scientists can construct their own worksheet functions (UDF's) using Excel Visual Basic (numerical analysis techniques discussion included)

• How engineers and scientists can automate chart construction using Excel VBA

• How to use the Macro Recorder to record engineering and scientific tasks in Microsoft Excel

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Advanced Microsoft Excel VBA Training for Engineers & Scientists (3-days)

Our "premier" Microsoft Excel VBA workshop for engineers and scientists that shows you how to construct complex dashboard driven analysis and data integration tools in Excel. It shows not only how to use Excel for this task but how to use VBA to tie into other programs, databases and computer languages as well including FORTRAN. This workshop is taught by an engineer.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Advanced Excel VBA Training Focus

The capability exists within Microsoft Excel VBA to construct sophisticated engineering and scientific tools that integrate seamlessly with the Microsoft Excel environment. Using advanced Microsoft Excel VBA programming techniques, sophisticated applications can be constructed in Microsoft Excel that command, organize and analyze engineering and scientific data, automatically chart engineering and scientific data, generate reports, talk to other applications integrating their data, perform engineering and scientific modeling, integrate FORTRAN routines... the list is endless. Many companies are turning to constructing engineering and scientific applications in Excel due to the lower cost, lower development time and because of Excel's exceptional abilities. This workshop discusses the advanced uses of Excel VBA in the engineering and science disciplines.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Engineers and Scientists

• Platform: Windows

• Training Materials: Included, 1800+ page manual including our Excel Add-Ins

• Training Method: Hands-on, taught by an engineer / software developer

• Repeat this workshop for free as many times as you want. View offer details

• What is VBA?

• Advanced data analysis techniques for engineers and scientists using VBA and Excel

• Advanced Excel VBA programming techniques for automated chart construction in Microsoft Excel

• Advanced dashboards using Excel and VBA for engineers and scientists

• Advanced interface construction using ActiveX controls and userforms

• Advanced Microsoft Excel VBA programming techniques for creating event driven engineering and scientific applications in Microsoft Excel

• Advanced VBA error trap construction for engineers and scientists

• How to create Excel menu bars and toolbars

• Advanced Excel VBA programming tips for communicating with FORTRAN, VB ActiveX DLLs, PERL and C

• System modeling discussion including how to use Solver with VBA

• Advanced VBA programming strategies for communicating with engineering and science oriented databases

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.