Call us at:   1.805.498.7162     1.805.558.9277

Home > Microsoft Excel Workshops > Microsoft Excel Training for Engineering and Scientists

Microsoft Excel Training

for Engineers and Scientists

Our 1-day Excel workshop that shows you from an engineering & science perspective how to create advanced data analysis and modeling tools that use adaptive range names, power formulas, advanced array formulas, pivot tables, charts and other key Excel features. Also included is a VBA (macro) introduction. Taught by an engineer , 1800+ page manual included , hands-on training , Mac users welcome , Free Repeats

Microsoft Excel Training For Engineers & Scientists 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.

Included in Our Microsoft Excel Workshop

• Free Repeats

• 1800+ page manual filled with key Excel strategies, examples and tips

• Hands-on training

• Personal questions answered

Audience Prerequisites

• Microsoft Excel users that understand basic Excel skills (typing in cells, used a formula before, opened a workbook...)

• It is intended for all types of engineering and science professionals

Workshop Training Choices

Available:  Public, Webcast, Onsite, Self-Study Manual

• Public, Webcast and Self-Study signup buttons below

• For onsite information or if you have any questions, please contact us 1.805.498.7162 or 1.805.558.9277.

Microsoft Excel Workshop Outline

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 analyze worksheet text

• 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

• Large Scale Modeling: 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

Signup, Pricing and Self-Study

The Public and Webcast buttons below will lead you to our training schedule page listing all possible dates, prices and signups for those training categories. If you are unsure what a webcast is click here. The Self-Study button will lead you to our manual page where you can get the manual pricing and the manual outline. The manual comes with the class.