Covers every feature of the newest version of Excel and discusses time-saving shortcuts, creating charts and maps, customizing menus, designing and manipulating lists and databases, and integrating Excel with other applications

Using Excel for Windows 95 (Using ... (Que))

written by Ron Person

Indianapolis, IN: Que Corp.

Alpha Books

Que Pub

Hayden

Special ed., Indianapolis, IN, Indiana, 1995

United States, United States of America

Special, Subsequent, PS, 1995

[curator]paul.n@archive.org[/curator][date]20110406224114[/date][state]approved[/state]

"Based on version 7 of Excel"--T.p. verso.
"Includes Windows 95 upgrader's guide tear-out card"--P. [4] of cover.
Includes index.

Based on version 7 of Excel.

topic: Microsoft Excel (Computer file); Business; Electronic spreadsheets

Type: 英文图书

Bookmarks:
1. (p1) Introduction
2. (p2) Everyday Worksheet Tasks
2.1. (p3) 1 Spreadsheet Power in Excel for Windows 95
2.2. (p4) 2 Getting Around in Excel and Windows
2.3. (p5) 3 Navigating and Selecting in a Workbook
2.4. (p6) 4 Entering and Editing Data
2.5. (p7) 5 Formatting Worksheets
2.6. (p8) 6 Working with Formulas
2.7. (p9) 7 Using Functions
2.8. (p10) 8 Moving or Copying Data and Formulas
2.9. (p11) 9 Reorganizing Workbooks and Sheets
2.10. (p12) 10 Managing Files
2.11. (p13) 11 Creating Templates and Controlling Excel's Startup
2.12. (p14) 12 Printing Worksheets
3. (p15) Creating and Formatting Charts
3.1. (p16) 13 Creating Charts
3.2. (p17) 14 Modifying Charts
3.3. (p18) 15 Formatting Charts
3.4. (p19) 16 Building Complex Charts
3.5. (p20) 17 Using Maps to Analyze Data
4. (p21) Optimizing Excel
4.1. (p22) 18 Managing the Worksheet Display
4.2. (p23) 19 Adding Graphics Elements to Sheets
4.3. (p24) 20 Outlining Worksheets
4.4. (p25) 21 Creating Automatic Subtotals
4.5. (p26) 22 Taking Advantage of Excel's Add-Ins
5. (p27) Analyzing the Worksheet
5.1. (p28) 23 Manipulating and Analyzing Data
5.2. (p29) 24 Building Forms with Controls
5.3. (p30) 25 Using the Power of Pivot Tables
5.4. (p31) 26 Analyzing and Reporting with Pivot Tables
5.5. (p32) 27 Linking, Embedding, and Consolidating Worksheets
5.6. (p33) 28 Auditing Workbooks and Worksheets
5.7. (p34) 29 Solving with Goal Seeking and Solver
5.8. (p35) 30 Testing Multiple Solutions with Scenarios
5.9. (p36) 31 Using the Analysis ToolPak
6. (p37) Managing Lists or Databases
6.1. (p38) 32 Designing a List or Database
6.2. (p39) 33 Entering Data in a List or Database
6.3. (p40) 34 Entering Data with the Template Wizard
6.4. (p41) 35 Sorting Data
6.5. (p42) 36 Finding, Filtering, and Editing Lists and Databases
6.6. (p43) 37 Working with Filtered Data
6.7. (p44) 38 Retrieving Data from External Databases
7. (p45) Using Excel with Office and Networks
7.1. (p46) 39 Using Excel with Office Applications
7.2. (p47) 40 Working with a Group of People
7.3. (p48) 41 Using Excel with DOS and Mainframe Applications
8. (p49) Customizing and Automating Excel
8.1. (p50) 42 Customizing the Excel Screen
8.2. (p51) 43 Creating Custom Toolbars and Menus
8.3. (p52) 44 Introducing Visual Basic for Applications
9. (p53) Index of Common Problems
10. (p54) Index

theme: Microsoft Excel (Computer file); Business; Electronic spreadsheets

Written By Ron Person. Based On Version 7 Of Excel--t.p. Verso. Includes Windows 95 Upgrader's Guide Tear-out Card--p. [4] Of Cover. Includes Index.

2023-06-28