Excel 2007 Level 2


Full Description
Excel 2007 Level 2


This course familiarizes students with intermediate-level spreadsheet features. Students will learn how to convert older workbooks to the new default XML-based file format; customize the Quick Access toolbar; use logical and financial functions; format worksheets using themes, styles, and page breaks; use 3-D references; ready workbooks for the Web; use templates to create workbooks; and insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet. They will also learn how to customize workbooks by renaming worksheets; inserting, deleting, and hiding worksheets; and changing the color of worksheet tabs. In addition, the course points out how tables in Excel serve as databases and covers how to convert data ranges into tables, apply table styles, freeze and unfreeze rows and columns, sort tables, and use filters in tables. This product was developed using the Release Candidate 1 from Microsoft.


Outcomes:


This course teaches students how to:
  1. convert older workbooks to the new default XML-based file format
  2. customize the Quick Access toolbar
  3. use logical and financial functions
  4. format worksheets using themes, styles, and page breaks
  5. use 3-D references
  6. ready workbooks for the Web
  7. use templates to create workbooks
  8. insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet
And much more!


Assessment:


Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.


Course Information (see above or below lessons, outlines, activities, etc.)
Program Outline

This course contains 60 lessons
  1. Convert Workbooks
  2. Customize The Quick Access Toolbar
  3. Rename Worksheets
  4. Change Worksheet Tab Colors
  5. Select And Move Sets Of Workbooks
  6. Copy Worksheets
  7. Insert And Delete Worksheets
  8. Hide And Unhide Worksheets
  9. Use Save As
  10. Rename Folders While Saving
  11. Learn About Database Features
  12. Convert Ranges To Tables
  13. Apply Table Styles
  14. Find And Replace Cell Contents
  15. Freeze And Unfreeze Rows
  16. Freeze And Unfreeze Columns
  17. Hide And Unhide Rows And Columns
  18. Sort Tables In Descending Order
  19. Sort Tables In Ascending Order
  20. Understand Filters
  21. Use AutoFilter
  22. Understand Inserting Functions
  23. Explore Logical Functions
  24. Use The IF Function
  25. Use The OR Function
  26. Learn About Financial Functions
  27. Use The FV Function
  28. Use The PMT Function
  29. Use The NOW Function
  30. Understand Office Themes
  31. Apply Themes
  32. Apply Predefined Styles
  33. Define Styles
  34. Indent Text
  35. Rotate Text
  36. Preview And Insert Page Breaks
  37. Modify And Remove Page Breaks
  38. Find And Replace Cell Formats
  39. Understand Inserting Objects
  40. Insert And Resize Graphics
  41. Move And Delete Graphics
  42. Apply Picture Styles
  43. Create And Modify Shapes
  44. Add SmartArt Diagrams
  45. Modify The Appearance Of SmartArt Diagrams
  46. Add Comments
  47. Edit And Remove Comments
  48. Understand 3-D References
  49. Link Worksheets Using 3-D References
  50. Split And Arrange Workbooks
  51. Link Workbooks Using 3-D References
  52. Look At Online Information And The Web
  53. Understand Hyperlinks
  54. Create And Edit Hyperlinks
  55. Save Worksheets As Web Pages
  56. Save Workbooks As Web Pages
  57. Understand The Research Task Pane
  58. Insert Supporting Information Into Worksheets
  59. Explore Templates
  60. Create Workbooks Based On Templates

Contact Hours: 6