Datamann continues to provide a level of personalized service and personal attention to detail that is hard to come by in ...  read more

General Information | Classes Schedule | Available Classes Back to Class List Microsoft Excel 2007 - Intermediate Prerequisites: Introductory Classes - Introduction to Computers Microsoft Excel 2007 - Beginner Levels: Beginner   Intermediate   Advanced   Class length: 1 day Class Objectives Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets. Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarize data by using the Consolidate command. Change the View, General, and Calculation settings of Excel; and customize toolbars and menus. Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells. Sort lists by columns; and filter lists based on complex criteria. Format data points; create combination charts and trendlines; and add and format graphic elements. Use auditing features; add comments and text boxes; and protect a worksheet or part of a worksheet. Work with Excel's built-in templates; and create and manage custom templates. Class Outline Unit 1: Working with large worksheets Topic A: Viewing options Topic B: Hiding, displaying, and outlining data Topic C: Printing large worksheets Unit 2: Using multiple worksheets and workbooks Topic A: Using multiple worksheets Topic B: Linking worksheets by using 3-D formulas Topic C: Consolidating data Topic D: Linking workbooks Topic E: Managing workbooks Unit 3: Customizing Excel Topic A: Using the Options dialog box Topic B: Customizing toolbars and menus Unit 4: Advanced formatting Topic A: Borders and shading Topic B: Using special number formats Topic C: Working with dates Topic D: Working with styles Topic E: Other advanced formatting Unit 5: List management Topic A: Examining lists Topic B: Sorting and filtering lists Topic C: Advanced filtering Unit 6: Advanced charting Topic A: Chart formatting options Topic B: Using combination charts Topic C: Using graphic elements Unit 7: Documenting and auditing Topic A: Auditing features Topic B: Comments and text boxes Topic C: Protection Topic D: Workgroup collaboration Unit 8: Using templates Topic A: Built-in templates Topic B: Creating and managing templates

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