805.498.7162       805.728.5681
EMAGENIT Logo

Microsoft Excel Overview

Business, Engineering and Science

EMAGENIT Training Options
  • On-Site .... EMAGENIT travels to your company

  • Public....  You travel to Thousand Oaks, California

  • Self Study.... Buy our class manuals. Looking for FORTRAN DLL or ActiveX DLL design, we have that also

  • Web Cast...Take a workshop on your computer live with an instructor

 

Microsoft Excel Component Overview

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs. Microsoft Excel is comprised of organizational units called workbooks. A standard workbook contains worksheets and chart sheets. Worksheets perform calculations, store and organize data, present graphics and controls like a web page; they are extremely versatile. A worksheet in turn is comprised of millions of cells. The job of a cell is to store a formula that performs a calculation or communicates with some other application (i.e. program) such as a database. They also store and present data. A chart sheet's job is to present a chart or graph developed from data stored on a worksheet.
  • A typical business worksheet (A), its elements and the workbook that contains it are presented in the illustration below. This simple example is a shipping status system developed in Microsoft Excel in less than an hour utilizing the conditional formatting feature, drawing shapes and worksheet functions like Vlookup.

A. Business Example

  • A typical engineering worksheet (B), its elements and the workbook that contains it are presented in the illustration below. This simple example is a pressure vessel design developed in Microsoft Excel in less than an hour.

Microsoft Excel Worksheet Example

B. Engineering Example

 

 

The Uses of Microsoft Excel in Business and Engineering

Think of Microsoft Excel as a modular tool set that can be rapidly configured to accomplish a desired task. A key force behind Microsoft Excel's capabilities is a powerful programming language called Visual Basic for Applications (VBA) which comes standard with Microsoft Excel. Using Microsoft Excel and VBA, a professional can accomplish important tasks like:
  • Rapid analysis and charting
  • Advanced modeling including numerical simulation
  • Automated report generation
  • Problem optimization using Solver and Crystal Ball
  • Software design
  • Team and model integration
  • Database communication and control
  • Project command and control
  • Project constraint monitoring
  • Information command and control
  • Multi-language programming with FORTRAN and C code (DLL's) 
  • Real time integration with other applications
  • Data sorting and analysis

By using Microsoft Excel, company funds and time are not invested in developing software tools from the "ground up" in computer languages that take large staffs to maintain.

EMAGENIT NASA Award

EMAGENIT received an award for its involvement with NASA JPL in helping redesign and integrate their conceptual Rover mission software in Microsoft Excel. Click the picture above for more detail about our Rover involvement. To learn more about the NASA mission to mars click here.

Awards & Customers
 

Microsoft Excel and Microsoft Excel VBA Training

 

Request information about our training, products or software design Read about our public training schedule, location and pricing Read about our web cast training schedule and pricing Read about our onsite training workshops Read about our self study manuals and pricing Read about our unique software design services for Windows and Excel Visit our product store for our latest software and manuals Download Excel VBA code for data processing, dashboards, automated charting...

 

 

 

 

Copyright © 2002-2004 EMAGENIT All Rights Reserved