Excel 5 for Windows Spreadsheet Databases

John Dranchak (Autor)

Buch | Softcover

350 Seiten

1994
John Wiley & Sons Inc (Verlag)
978-0-471-30360-2 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

Describing how to take full advantage of Excel's complex sorts and queries, this guide explains how to: search your data; create charts; perform statistical analysis; design a flat-file database; integrate spreadsheets with databases; and import and export data to other formats.

Excel 5 is not only a Windows spreadsheet, but also a powerful database tool that can handle data and list management needs. Describing how to take full advantage of its complex sorts and queries, this guide explains how to: search your data; create charts; perform statistical analysis; design a flat-file database; integrate spreadsheets with databases; link Excel files to external databases; and import and export data to other formats.

What Is a Database?; Sorting; Filtering; Data Forms; Database Functions; Data Tables; Reading and Writing Other Data Formats; Custom Data Forms; Pivot Tables; Advanced Pivot Tables; Macros/VBA; MS Query Overview; Microsoft Query as a Stand-Alone Application; Structured Query Language Basics; Using SQL Server; Index.

Erscheint lt. Verlag	3.8.1994
Zusatzinfo	Ill.
Verlagsort	New York
Sprache	englisch
Maße	190 x 234 mm
Gewicht	1984 g
Themenwelt	Informatik ► Betriebssysteme / Server ► Windows
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	0-471-30360-7 / 0471303607
ISBN-13	978-0-471-30360-2 / 9780471303602
Zustand	Neuware