Excel as Your DatabaseExcel 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. |
Other editions - View all
Common terms and phrases
Access Allow appears apply argument button calculate cell reference check box Clear click Data click Format click Home click OK click Open click Tools color column command Complete Conditional Formatting connection contain copy create criteria cube Custom Data Analysis data field data records Data Source data table data values database Define Delete desired dialog box display Edit Enter example Excel Excel workbook exercise External Data Figure Filter Find Finish Format formula group of cells Import Insert macro match Microsoft object ofthe Open Open in Excel option PivotTable PivotTable and PivotChart practice Protect provides Query Quick Range Replace sample Scenario select cells Sheet Show Solver Sort specified SQL Server Step Subtotal users Validation Visual Wizard workbook worksheet cells