|
|
Crisp Comprehensive: Microsoft Excel 2007 Basic
|
|
|||||||||||
| Click here to view available downloads for this course | |||||||||||||
|
Duration: Self-study Description: Excel 2007 is the most popular spreadsheet program for both business and personal use. Well designed spreadsheets enable you to organize complex data, but more importantly they make it possible to analyze and share information clearly and securely. Whether you're reviewing complex financial statements or simply creating editable phone lists, start with a thorough understanding of all the features and tools within this powerful program. Table Of Contents: Getting started Topic A: Spreadsheet terminology Topic B: Exploring the Excel window Topic C: Getting help Topic D: Navigating workbooks Unit summary: Getting started Entering and editing data Topic A: Entering and editing text and values Topic B: Entering and editing formulas Topic C: Working with pictures Topic D: Saving and updating workbooks Unit summary: Entering and editing data Modifying a worksheet Topic A: Moving and copying data Topic B: Moving and copying formulas Topic C: Absolute and relative references- Topic D: Inserting and deleting ranges, rows, and columns Unit summary: Modifying a worksheet Using functions Topic A: Entering functions Topic B: AutoSum Topic C: Other useful functions Unit summary: Using functions Formatting worksheets Topic A: Formatting text Topic B: Formatting rows and columns Topic C: Formatting numbers Topic D: Conditional formatting Topic E: Copying formats and applying table formats Unit summary: Formatting worksheets Printing Topic A: Preparing to print Topic B: Page Setup options Topic C: Printing worksheets Unit summary: Printing Creating charts Topic A: Chart basics Topic B: Modifying charts Topic C: Printing charts Unit summary: Creating charts Managing large workbooks Topic A: Viewing large worksheets Topic B: Printing large worksheets Topic C: Using multiple worksheets Unit summary: Managing large workbooks Course summary Topic A: Course summary Topic B: Continued learning after class Glossary Index |
|||||||||||||

