Excel 2003 just the steps for dummies
著者
書誌事項
Excel 2003 just the steps for dummies
（--For dummies）
Wiley, c2006
- pbk.
大学図書館所蔵 件 / 全1件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes index
収録内容
- Putting Excel to work
- Sprucing up your spreadsheet
- Viewing data in different ways
- Analyzing data with Excel
- Practical applications for Excel
内容説明・目次
内容説明
Easy steps for creating spreadsheets you can really use Simple steps...for great results Use AutoOutline* Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet.* AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail.* To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.)* To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings.* To remove the AutoOutline, choose Data Group and outline Clear Outline. Get ready to* Format cells and data* Build formulas and functions* Save time with Excel tools* Add color graphics toyour spreadsheets* Analyze your data* Create charts and PivotTables
目次
Introduction. Part I: Putting Excel to Work. Chapter 1: Working with Excel Files. Chapter 2: Entering Spreadsheet Data. Chapter 3: Building Formulas. Part II: Sprucing Up Your Spreadsheet. Chapter 4: Formatting Cells and Data. Chapter 5: Adding Color and Graphics. Chapter 6: Working with Workbooks. Part III: Viewing Data in Different Ways. Chapter 7: Changing Worksheet Views. Chapter 8: Sorting Data. Chapter 9: Creating Charts with Excel. Chapter 10: Printing Workbooks. Part IV: Analyzing Data with Excel. Chapter 11: Working with Outlines. Chapter 12: Filtering Data. Chapter 13: Creating Pivot Tables. Chapter 14: Building Simple Macros. Chapter 15: Saving Time with Excel Tools. Part V: Practical Applications for Excel. Chapter 16: Creating a Commission Calculator. Chapter 17: Tracking Medical Expenses. Chapter 18: Planning for Your Financial Future. Chapter 19: Integrating Excel into Word. Chapter 20: Blending Excel and PowerPoint. Chapter 21: Using Excel with Access. Index.
「Nielsen BookData」 より
