Go To TechNet Home Page

The Most Popular Spreadsheet for WindowsTM, Microsoft Excel Version 5.0--Datasheet

OVERVIEW

That's because as a member of the Microsoft Office family of programs, Microsoft Excel features IntelliSenseTM technology-built-in intelligence that senses what you want to do and produces the results you want. IntelliSense tech- nology includes automatic features and wizards that step you through tasks. So routine tasks are automatic and complex jobs are easier.

You'll also find that you have complete control over everything in your spreadsheet. For example, now you can directly enter and edit information in cells and manipulate data and charts, so you'll have a faster and easier way to do your work.

Microsoft Excel introduces a new way to analyze your data. You can instantly create dynamic views and reports of your data, and spend less time setting up information. And you can develop your own solutions with easy-to-use tools to customize your spreadsheet and rich development tools to build powerful enterprise solutions.

Best of all, Microsoft Excel is part of the family of Microsoft Office programs that work alike and work together, so when you learn one, you're on your way to learning them all.

With Microsoft Excel version 5.0, you can focus on your work rather than your computer. Maybe that's why it's the most popular spreadsheet for the Microsoft Windows operating system.

HIGHLIGHTS

An intuitive interface makes your work easier.
• Enter and edit information directly in cells with Rich Cell Editing.

• Right-click the mouse button to see context-sensitive shortcut menus.

• Move individual or groups of cells with drag-and-drop data movement.

• Tab dialog boxes combine your options into one intuitive box, so you don't have to search through menus.

• Every file is a workbook that contains as many related sheets as you like. Workbook Tabs make it easier to navigate through and select sheets.

• Workbooks let you simultaneously edit or format multiple sheets and support 3-D formulas that make it easy to consolidate multiple sheets.

• Select and build formulas with the Function Wizard-it helps build formulas, assists with arguments, and lists your most recently used functions.

• Quickly understand shared worksheets with Auditing tools that visually trace formulas in a worksheet.

• Identify buttons and toolbars quickly with pop-up ToolTips.

IntelliSense technology lets you do more with less effort.
• Get tips on how to work faster and smarter with the TipWizardTM assistant.

• Leave the adding to the AutoSumTM button-it sums ranges and can sum rows and columns simultaneously.

• Save time and effort retyping with AutoFill, which extends your data or series for you.

• Make every worksheet look professional instantly with AutoFormat.

• View a subset of your information on the spot with AutoFilter.

• Sort data more easily and flexibly with AutoSort or define custom sort orders.

• Choose the Subtotal command to automatically generate subtotals for your data.

• Use AutoOutline to create reports at any level of detail with a few clicks.

Chart the way you want to.
• Create meaningful charts of your data with ChartWizard-it walks you through building a chart and lets you choose your own options.

• Directly resize and format any part of your chart with Hands-On Charting.

• Update your chart with the Drag-and-Plot feature. Simply drag new data to your chart, and your chart updates automatically.

• Mix chart types into one chart with Combo-Charts. For example, you can chart "Revenue" as a line and "Ex- penses" as a column on the same chart.

Focus on your analysis, not your data.
• The PivotTable Wizard pulls your raw data together and builds a sum- mary table based on your layout.

• View and analyze data from multiple perspectives with PivotTableTM dynamic views. Build different reports and views by dragging and dropping headings any way you like.

• Take the routine out of your analysis with automatic calculations such as comparisons and percentages.

Easily share files and work with others.
• Effectively work with others with the Workgroup toolbar:

  - Find File helps you search for files.

  - Interactive File Sharing lets you share files, notifies you of file availability, and updates "read only" files.

  - Send mail from Microsoft Excel and include files as attachments.

  - Use the Routing button to send documents sequentially to people or to an entire team at once.

• Take advantage of an improved Scenario Manager. Now you can create "what if" scenarios on multiple ranges of cells and view and access those scenarios from a drop-down list.

Access and retrieve data easily.
• Save time by using the Text Import Wizard to help you import files.

• Import data into Microsoft Excel with MS* Query. MS Query supports ODBC (Open Database Connectivity), which provides connections to the widest range of external data.

Easily build the solutions you need.
• Use on-sheet controls to automate your work without macros.

• Customize your toolbars easily.

• Use the macro recorder to automate your tasks.

• Program more easily and more power- fully with Microsoft Visual Basic* programming system, Applications Edition, the common macro language.

• Support for OLE 2.0 automation lets Microsoft Excel work with other programs in your solution.

A smooth move from Lotus* 1-2-3*.
• Use familiar 1-2-3 commands with the Help for Lotus 1-2-3 Users feature and get a demonstration of the equivalent Microsoft Excel commands.

• Transfer files without losing work- full file compatibility with Lotus WKS, WK1, WK3, Impress, AllwaysTM, Multiplanr, and Quattror Pro for the MS-DOS* operating system.

• Transfer existing files easier with improved 3-D capabilities.

• Use the Macro Interpreter to run Lotus 1-2-3 version 2.01 compatible macros unmodified.

THE MICROSOFT OFFICE FAMILY: A WHOLE NEW WAY TO WORK.

SPECIFICATIONS

To run Microsoft Excel, you need:
• MS-DOS operating system version 3.1 or later

• Any of the following: Microsoft Windows operating system version 3.1 or later, Microsoft WindowsTM for Workgroups version 3.1 or later, Microsoft Windows NTTM operating system version 3.1 or later, or Microsoft WindowsTM for Pen Computing

• Personal computer using a 286 or higher microprocessor

• 4 MB of memory

• Hard disk space required:

  - Laptop (min.) installation: 8 MB

  - Typical installation: 15 MB

  - Custom installation: up to 22 MB

• A 3.5" or 5.25" disk drive

• EGA or higher resolution monitor compatible with Microsoft Windows 3.1 or later

• Microsoft Mouse or compatible pointing device (mouse recommended)

Go To TechNet Home Page

Go To Microsoft Home Page