Microsoft Excel-Aided
Engineering and Science Manual

Microsoft Excel-Aided Engineering/Science Self Study

Since 1998

Our Excel "all in one" manual for engineering and science.

Over 2200+ pages of useful of useful Excel tips, formulas and strategies along with our complete Excel VBA write up. Everything we know and use in consulting.

Questions? 1.805.498.7162   Customers >

Microsoft Excel Manual Specifics

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 2007-2019, Office 365

Manual Introduction. This all in one general Excel and Excel VBA self study manual covers all the basics needed for solving engineering and science problems in Excel. The basics discussed include cell operation, worksheet formatting, formula design, cell naming, worksheet functions, sorting, filtering, Pivot Tables, Excel tables, array formulas, data importation, chart creation and linking Excel with other programs like Word and PowerPoint. Our manual also covers solving numerical techniques on the worksheet like linear systems, Runge Kutta, Newton's method, integration, differentiation and boundary value problems. It also discusses how to create sophisticated system models, perform design optimization using Solver and team and data integration. Our manual also discusses how to turn create dashboards using ActiveX controls, charts, formulas and drawing shapes. Also included is our complete beginning and advanced Excel VBA write-up.

Price: $169.00

Add to Cart

Our Refund Policy >

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

Learning Module 2: Microsoft Excel Uses in Engineering and Science

Learning Module 3: Formatting, Formula Construction, Data Analysis, Problem Formulation and Construction Methods for the 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 | Controlling Key Excel Elements with VBA

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: FORTRAN/VBA Mixed Language Programming

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

Facebook Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved