Excel As Your Database guides those of you who need to manage facts and figures, yet have little experience, budget, or need for a full-scale relational database management system. Youll learn how to use Excel to enter, store, and analyze your data.

This book is written and organized in a way that assumes you have some familiarity with Excel, but not with databases. The book features quick-start solutions, practice exercises, troubleshooting tips, and best practices.

Les mer

Excel As Your Database guides those of you who need to manage facts and figures, yet have little experience, budget, or need for a full-scale relational database management system.

Data Basics.- Define Your Data.- Enter Data.- Find Data.- Connect to Other Databases.- Analyze Data.- Automate Repetitive Database Tasks.- Interoperate with Data in other Databases.
Covers Excel 2007 and 2003 When to use this technique" introduction for each section clarifies not just how to use a technique but under what realistic scenarios Step-by-step "how-to" procedures Try-it exercises based on realistic sample data
Les mer
GPSR Compliance The European Union's (EU) General Product Safety Regulation (GPSR) is a set of rules that requires consumer products to be safe and our obligations to ensure this. If you have any concerns about our products you can contact us on ProductSafety@springernature.com. In case Publisher is established outside the EU, the EU authorized representative is: Springer Nature Customer Service Center GmbH Europaplatz 3 69115 Heidelberg, Germany ProductSafety@springernature.com
Les mer

Produktdetaljer

ISBN
9781590597514
Publisert
2007-01-31
Utgiver
APress; APress
Høyde
235 mm
Bredde
191 mm
Aldersnivå
Professional/practitioner, G, 01
Språk
Product language
Engelsk
Format
Product format
Heftet

Forfatter

Om bidragsyterne

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.