Microsoft Excel for Engineers and Scientists Workshop Outline

Our "power formula" Excel workshop for engineers and scientists that shows you how to create advanced formulas 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.  Read below and see how our 14 years of Excel training and consulting can help supercharge your Excel skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

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.

In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs.

• 1-day workshop

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Engineers and Scientists

• Platform: Windows or Mac

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

• Training Method: Hands-on

In this 1-day "hands-on" workshop you will cover:

• 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 dashboards on the Microsoft Excel worksheet

• Nesting Worksheet Functions: How to nest Microsoft Excel worksheet functions, prelude to advanced formula design

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

• Concatenation: How to perform text concatenation in Microsoft Excel worksheet formulas, used in advanced formula design and reporting

• 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

• Dynamic ranges: How to construct formulas that automatically adjust in size to data

• 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

• Microsoft Excel users that understand basic worksheet skills (typed in a cell, used a formula before, opened a workbook...etc).

• It is intended for engineers and scientists.

Public Location: Thousand Oaks,CA, Directions/Thousand Oaks Info

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, CA which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our courses on-site nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information.

Our public workshops are a short commute for those living in:

For more information about our public workshops, visit our public workshops page our call us at 805.498.7162.

Submit a question to us via email at engexcel@emagenit.com

Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.558.9277 for more information about this workshop.