Excel Aided Engineering and Science Self-Study Manual

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