Excel 2007 Workbook for Dummies

Author : Greg Harvey,PhD

Page : 365 pages

Chapter :

This ebook can be download in here :
Excel 2007 Workbook for Dummies


Ebook content :

Part I: Creating Spreadsheets
Part I is from chapter 1 until chapter 5
In This Chapter
a. Identifying the different parts of the Excel display screen
b. Selecting commands on the Office menu
c. Selecting commands on the Ribbon
d. Customizing the Quick Access toolbar


Entering the Spreadsheet Data
Launching Excel and opening a new workbook
a. Moving around the workbook
b. Selecting cell ranges in a worksheet
c. Doing simple data entry in a worksheet
d. Using AutoFill to create data series and copy formulas
e. Saving the spreadsheet as an Excel workbook file


Formatting the Spreadsheet
In This Chapter
a. Resizing columns and rows in a worksheet
b. Formatting cells with the Home tab of the Ribbon
c. Formatting cells with the Format Cells dialog box
d. Using Cell Styles
h. Using Conditional Formatting
i. Hiding columns and rows in a worksheet


Printing Spreadsheet Reports
In This Chapter
a. Previewing pages in the Page Layout view
b. Using Page Break Preview to adjust the paging
c. Adding readymade and custom headers and footers to a report
d. Adjusting various Page and Print Settings
e. Printing all or portions of a workbook


Modifying the Spreadsheet
In This Chapter
a. Selecting the cell ranges that require editing
b. Finding data entry errors with Text to Speechc.
Inserting and deleting cell ranges
Moving and copying cell ranges
Using comments in the spreadsheet
Finding and replacing cell entries and spell checking the spreadsheet
Editing worksheets as a group


Part II: Using Formulas and Functions
Part II is from chapter 6 until chapter 14

Part III: Working with Graphics
Part III is from chapter 15 until chapter 16

Part IV: Managing and Securing Data
Part IV is from chapter 17 until chapter 18

Part V: Doing Data Analysis
Part IV is from chapter 19 until chapter 20

Part VI: Macros and Visual Basic for Applications
Part IV is from chapter 21 until chapter 22

Part VII: The Part of Tens
Part IV is from chapter 23 until chapter 24

Appendix: About the CD

Index