- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
If you prefer instructions that show you how rather than tell you why, then this visual reference is for you. Hundreds of succinctly captioned, step-by-step screen shots reveal how to accomplish more than 375 Excel 2007 tasks, including creating letters with Mail Merge, assigning formats to cells, editing multiple worksheets at once, and summarizing with PivotTables and PivotCharts. While high-resolution screen shots demonstrate each task, succinct explanations walk you through step by step so that you can digest these vital lessons in bite-sized modules.
Contents
PART I: Excel Basics. 1) Getting Started with Excel. 2) Managing Workbooks. 3) Formatting Cells. PART II: Designing Worksheets. 4) Editing Worksheets. 5) Proofreading a Worksheet. 6) Adjusting Worksheets. 7) Managing Workbook Structure. 8) Working with Views. 9) Printing Worksheet Information. PART III: Calculating Data. 10) Performing Basic Math. 11) Working with Common Formulas. 12) Mastering Date and Time Formulas. 13) Working with Financial Formulas. 14) Working with Lookup Formulas. 15) Applying Reference, Information, and Text Formulas. 16) Working with Logical and Error Trapping Formulas. 17) Analyzing Tabular Information with Functions. 18) Analyzing Formulas and Worksheets. PART IV: Mastering Excel Charts. 19) Discovering Chart Basics. 20) Changing Chart Layout Details. 21) Formatting Charts. 22) Working with Graphic Elements. PART V: Analyzing Data. 23) Working with Tables. 24) Summarizing Data with PivotTables and PivotCharts. 25) Visually Analyzing Data. 26) Linking and Consolidating Worksheets. 27) Performing What-If Analysis. 28) Performing Advanced Statistical Analysis. PART VI: Customizing the Excel Environment. 29) Working with Macros. 30) Changing Excel Behavior. PART VII: Using Excel in Collaboration with Others. 31) Using Workbooks in a Multi-User Environment. 32) Sharing Excel Data with Other Programs. A) Excel Functions.
