"...Datamann's excellent pricing and great customer care has increased my company's ability to grow and increase market ...  read more

General Information | Classes Schedule | Available Classes Back to Schedule Microsoft Excel 2007 - Beginner Prerequisites: Introductory Classes - Introduction to Computers Levels: Beginner   Intermediate   Advanced   Class length: 1 day Class Objectives Start Microsoft Excel, identify the main components of the Excel window and an Excel workbook, and use the Help feature. Enter and edit labels, values, and formulas in a worksheet, and find and replace a formula. Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas. Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet, and use the AutoSum feature. Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area. Create, format, modify, and print charts based on worksheet data. Class Outline Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: Exploring the Excel window Topic C: Getting help Topic D: Navigating workbooks Topic E: Closing workbooks Unit 2: Entering and editing data Topic A: Entering and editing labels and values Topic B: Entering and editing formulas Topic C: Working with pictures Topic D: Saving and updating workbooks Unit 3: Modifying a worksheet Topic A: Moving and copying data Topic B: Moving and copying formulas Topic C: Using absolute references Topic D: Inserting and deleting ranges, rows and columns Unit 4: Using functions Topic A: Entering functions Topic B: Using AutoSum Topic C: Other useful functions Unit 5: Formatting worksheets Topic A: Formatting text Topic B: Formatting rows and columns Topic C: Number formatting Topic D: Conditional formatting Topic E: Copying formats adn applying table formats Unit 6: Printing Topic A: Preparing to print Topic B: Page Setup options Topic C: Printing worksheets Unit 7: Creating charts Topic A: Chart basics Topic B: Modifying charts Topic C: Printing charts Unit 8: Managing large workbooks Topic A: Viewing large workbooks Topic B: Printing large worksheets Topic C: Using multiple worksheets

Privacy Policy datamann.com © 1975 - 2010 All Rights Reserved. Best Viewed in Internet Explorer and 1024x768 Screen Resolution Template and Graphics by Results Marketing/Communications L.L.C.   Developed and Hosted by GalaxyPlace