Microsoft Excel-Aided Engineering and Science Manual

At a quick glance.

Includes our full Microsoft Excel and Excel VBA macro write-up. It is everything we have rolled into one manual.
Covers a variety of topics including data processing, automated reporting, modeling, numerical analysis, design optimization, and dashboard design.
Includes our complete Excel VBA write-up including automated calculations; models; data processing; userforms; and databases.
100's of real world examples and 1000's of lines of useful VBA code included.

Excel Aided Engineering Science Examples

More about the manual.

The first half of the manual covers fundamental Excel topics like worksheet operation, cell data entry, worksheet formatting, formulas, worksheet functions, and cell naming. It also covers essential data topics like worksheet table design, Excel tables, charts, sorting and filtering data, PivotTables, and linking Excel with other programs like Word and PowerPoint.

Other must know Excel topics covered include external data integration using Power Query and MS Query, designing reports that adapt to changing data, integrating design teams, creating advanced array formulas, performing design optimization using Solver, system modeling, and creating industrial grade dashboards.

Our Excel discussion also covers solving numerical techniques on the worksheet including linear systems, Runge Kutta, Newton's method, integration, differentiation, and boundary value problems.

The second half of the manual includes everything we know about using Excel VBA in engineering and science. It covers 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.

Some key manual topics.

It's a 2200+ page manual, there's a lot of topics!

Creating, opening, saving workbooks; controlling workbook views; using the Ribbon and Excel help
Worksheet formatting, formulas, names, array formulas, problem formulation, functions, and numerical analysis methods
Using Sort, Filter, Advanced Filter, Excel tables, Slicers, and PivotTables for data analysis
Using ActiveX controls, Conditional Formatting and Data Validation for worksheet UI development
Using MS Query and Power Query to query, integrate, and filter external workbook and database data
Creating and building technical charts and chart reports in Excel
Advanced Microsoft Excel dashboard design
How to use the VBA Editor Windows, VBA modules, and debug tools
Complete VBA language, VBA procedure, and Excel automation review
How to develop models and data processing tools using Excel VBA
How to design custom worksheet functions in VBA that perform advanced calculations and numerical analysis
Constructing and controlling system models in Excel VBA
Performing trade studies and automating Solver in Excel VBA
Using shapes, pictures, and worksheet cells to design basic UIs to run your VBA code
Using events, ActiveX controls, userforms, worksheets, events, shapes, charts, and VBA to create advanced Excel UIs
Commanding databases using VBA, SQL, and DAO
How to control Word, PowerPoint, and Outlook using VBA
How to run Fortran DLLs from Excel VBA and worksheet formulas

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:	2200 + pages with examples
Platform:	Windows 7 and above
Sent:	Sent within 3 hr after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions:	Excel 2013 for Windows and above