Search

Microsoft Excel 2007: Level 2

This course familiarizes students with intermediate-level spreadsheet features.
SKU: P2425EN
PRICE BREAKS - The more you buy, the more you save
Quantity
100+
500+
Price
$18.75
$12.50
$25.00
Level 2: 60 Lessons – approximately 6 hours of training

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.

No final exam or certificate available.
Products specifications
Course Language English
Length Range Over 60 Minutes
Length (Hours) 2.50
Module Number(s) 3988EN
Course Features Audio
Write your own review
  • Product can be reviewed only after purchasing it
  • Only registered users can write reviews
*
*
Bad
Excellent
Level 2: 60 Lessons – approximately 6 hours of training

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.

No final exam or certificate available.
Products specifications
Course Language English
Length Range Over 60 Minutes
Length (Hours) 2.50
Module Number(s) 3988EN
Course Features Audio