Microsoft Excel Overview |
Uses of Microsoft Excel

Microsoft Excel Overview | Uses of Microsoft Excel

Microsoft Excel Tutorial

Microsoft Excel with its supporting computer language, Visual Basic for Applications (VBA), is one the most versatile tools on the market place today for developing advanced business, engineering and scientific tools.

Microsoft Excel Overview

In general, Microsoft Excel is a spreadsheet tool that is capable of performing calculations, analyzing data, presenting information in advanced dashboards and integrating information from different programs. That is just for starters. 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, charts and controls like a web page; they are extremely versatile. A worksheet 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 or from some other data source.

  • A typical business dashboard, its elements and the workbook that contains it are presented in the illustration below. This simple quota capacity dashboard pictured was developed in Microsoft Excel in less than an hour and utilizes the Conditional Formatting feature, Data Validation feature, drawing shapes, charts, ActiveX controls and worksheet functions like VLOOKUP. These are all Excel features which operate on the worksheet.
Microsoft Excel Worksheet Software Design
  • A typical engineering worksheet, 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 and utilizes the Conditional Formatting feature, Data Validation feature, drawing shapes, ActiveX controls and custom VBA User Defined Worksheet functions. These are all Excel features which operate on the worksheet.
Microsoft Excel Worksheet Example

Uses of Microsoft Excel in Business, Engineering and Science

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 modeling and analysis
  • Advanced modeling including numerical simulation
  • Team and model integration
  • Model optimization using Solver
  • Automated report generation using text files, workbooks and databases
  • Data processing and data mining
  • Real time integration with other applications like Word and PowerPoint
  • Database control and data visualization
  • Advanced dashboard design

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.



Site Map

Copyright © 2002-2015

EMAGENIT All Rights Reserved