|
Provided by: Online Training Directory 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.
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.
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.
|
|
||||||||
Training
Provided by Online Training Directory
- K asked: How much does this class cost?
- S asked: i want to learn about Excel Level
- P asked: wht does the module cover?
- T asked: price and how to take it
- R asked: More information please.
- S asked: Hello, how much is the charge for this course, I am interested in EXCEL Level and level
Excel 2007 Level 2
Outcomes This course teaches students 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
- insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet
- Convert Workbooks
- Customize The Quick Access Toolbar
- Rename Worksheets
- Change Worksheet Tab Colors
- Select And Move Sets Of Workbooks
- Copy Worksheets
- Insert And Delete Worksheets
- Hide And Unhide Worksheets
- Use Save As
- Rename Folders While Saving
- Learn About Database Features
- Convert Ranges To Tables
- Apply Table Styles
- Find And Replace Cell Contents
- Freeze And Unfreeze Rows
- Freeze And Unfreeze Columns
- Hide And Unhide Rows And Columns
- Sort Tables In Descending Order
- Sort Tables In Ascending Order
- Understand Filters
- Use AutoFilter
- Understand Inserting Functions
- Explore Logical Functions
- Use The IF Function
- Use The OR Function
- Learn About Financial Functions
- Use The FV Function
- Use The PMT Function
- Use The NOW Function
- Understand Office Themes
- Apply Themes
- Apply Predefined Styles
- Define Styles
- Indent Text
- Rotate Text
- Preview And Insert Page Breaks
- Modify And Remove Page Breaks
- Find And Replace Cell Formats
- Understand Inserting Objects
- Insert And Resize Graphics
- Move And Delete Graphics
- Apply Picture Styles
- Create And Modify Shapes
- Add SmartArt Diagrams
- Modify The Appearance Of SmartArt Diagrams
- Add Comments
- Edit And Remove Comments
- Understand 3-D References
- Link Worksheets Using 3-D References
- Split And Arrange Workbooks
- Link Workbooks Using 3-D References
- Look At Online Information And The Web
- Understand Hyperlinks
- Create And Edit Hyperlinks
- Save Worksheets As Web Pages
- Save Workbooks As Web Pages
- Understand The Research Task Pane
- Insert Supporting Information Into Worksheets
- Explore Templates
- Create Workbooks Based On Templates
About The Training Provider: Online Training Directory
Online Training Directory - JER Online (JER Group, Inc.) lists over 1000 , cost affordable, non-credit Courses and Certificates in its own proprietary online catalog. We are always adding "more courses...all the time " to a growing inventory.
The courses and certificates that comprise JER Online s course catalog are developed by (1) JER Online, (2) a growing number of accredited .edu partners and by (3) corporate...
