Excel Aided Engineering and Science

Excel-Aided Engineering Science Manual

Covers from beginning to advanced Excel including our complete Excel VBA write-up. Its everything we use.

  • Covers formulas, modeling, data processing, charting, numerical analysis, data integration, dashboards.
  • Covers Excel VBA fundamentals to advanced Excel VBA including UI topics and databases.
  • Over 2200+ pages of industry proven Excel topics.
  • 100's of real world examples.
  • Buy a manual now, apply the price towards a class later. They are free with our classes.

Price: $145.00

Purchase Manual

Manual specs.

For:Engineers and Scientists
Format:ADOBE PDF and Excel Files as zip file download
Details:Covers beginning general Excel to advanced Excel VBA topics, everything from all of our manuals
Book:2200 + pages with examples
Platform:Windows 7 - Windows 10
Sent:Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Versions:Excel for Windows 2010-2019, Microsoft 365

Manual Introduction. This all in one self study manual covers fundamental Excel concepts along with the advanced Excel topics needed for creating adaptable, problem solving engineering and science Excel tools.

The first half of the manual covers fundamental Excel topics like workbook and worksheet operation, cell data entry, worksheet formatting, formula design, cell naming, worksheet functions, Conditional Formatting, Data Validation, table design, sorting, filtering, using Excel tables, PivotTable design, technical chart creation and linking Excel with other programs like Word and PowerPoint. The advanced topics covered include 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, advanced modeling, and creating state of the art dashboards. Our manual also covers unique advanced topics like 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, from the fundamentals to the most advanced topics we have encountered, from data processing to designing advanced interfaces. The topics are so broad, we refer you to the book outline below for all the details.

Excel Aided Engineering Science Examples
< < < Scroll Picture > > >

Actual Manual Problems

Learning Module 1: Creating, Opening, Saving Workbooks; Controlling Workbook Views; Using the Ribbon and Using Help

Learning Module 2: Using Microsoft Excel in Engineering and Science

Learning Module 3: Formatting, Formula Construction, Data Analysis, Problem Formulation and Construction Methods for the Excel Worksheet

Learning Module 4: Creating Technical Charts and Chart Reports in Excel

Learning Module 5: VBA Editor and Module Basics

Learning Module 6: VBA Language Review | Excel Automation | Reports | Data Processing | Models

Learning Module 7: VBA Function Procedure Design

Learning Module 8: VBA Sub Procedure Design

Learning Module 9: Using Events, ActiveX Controls, Userforms and VBA to Create Advanced Program Interfaces

Learning Module 10: Calling Fortran DLLs from Excel VBA

Learning Module 11: Team Linking in Excel

Learning Module 12: Packaging Team Tools in Excel

Learning Module 13: Commanding Databases and Other Applications Using VBA

Learning Module 14: Integrating VB.Net and VBA (Coming Soon)

Learning Module 15: Design Optimization in Excel Using Solver

Learning Module 16: Constructing Large System Models in Excel

Learning Module 17: Microsoft Excel Dashboard Design

Learning Module 18: Using MS Query and Power Query to Query External Data

Price: $145.00

Purchase Manual
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2021

EMAGENIT All Rights Reserved