Excel Aided Engineering and Science Self-Study Manual

Our all-in-one Excel manual will show you everything you need to know to build powerful analysis, modeling, data processing, and reporting tools using Excel or Excel VBA. It is all of our manuals combined into one and much more.

Excel Aided Engineering and Science

Our all-in-one Excel manual that covers everything we know on using Excel and Excel VBA in engineering & science.

How our manual can help you.

Excel-Aided Engineering and Science

Our all-in-one self study manual covers the Excel topics you need to develop powerful engineering and science tools. The first half of the manual covers the basics like worksheet formatting, problem analysis, cell naming, formulas, functions, and charts. It also covers using Excel's data tools, PivotTables, and analyzing worksheet and text data.

Additional topics include using Power Query to shape and integrate data, creating advanced array formulas, using numerical methods on the worksheet, creating models, and designing dashboards and user interfaces.

The second half of the manual covers from the fundamentals to the most advanced Excel VBA topics we have encountered. It will show you how to automate things like models, analysis problems, charts, data processing, and database tools.

  • Controlling workbooks, worksheets, formats, the Ribbon, and Excel help
  • How to build formulas, cell names, functions, numerical methods, and UI's on the worksheet
  • Using Sort, Filter, Excel tables, Slicers, functions, PivotTables... to analyze data
  • Using Power Query to query, integrate, and filter external workbook and database data
  • Creating and formatting technical charts and chart reports in Excel
  • How to create advanced dashboards on the worksheet
  • How to use the VBA Editor, modules, and debug tools
  • Complete VBA language, VBA procedure, and Excel automation review
  • How to develop analysis, model, data processing, and charting tools with Excel VBA
  • How to command databases and text files using VBA, SQL, and DAO
  • How to develop advanced UIs from VBA, ActiveX controls, events, userforms, shapes...
  • How to design custom worksheet functions (UDFs) to perform advanced calculations
  • How to run Fortran DLLs from Excel VBA and worksheet formulas

What you will learn in our manual.

Expert Excel Training

$149.00

Buy the manual now and apply its price to a class later. Just let us know when purchasing a class.

Coming in November

Manual specifications and download.

For:Engineers and Scientists
Format:ADOBE PDF and Excel Files as zip file download
Details:Covers beginning to advanced Excel topics along with our full VBA write up
Book:Fully illustrated, step-by-step instruction, with over 200 fully documented Excel and Excel VBA examples
Platform:Windows 7 and above
Download:Sent within 3 hrs after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions:Excel 2013 for Windows and above

Associated classes.

Need Help? Please call us at 1.629.207.9662

Copyright © 2002-2023

EMAGENIT All Rights Reserved