Microsoft Excel 2007 Level 3
Starting dates and places
Description
Microsoft Excel 2007 Level 3
Course Duration
1 day
Target Audience
This course is aimed at users who have attended Level 1 and 2 Microsoft Excel 2007 courses, or for experienced users wishing to clarify existing knowledge using various methods and techniques.
Course Objectives
This course will provide delegates with the necessary skills and knowledge required to:
· Understand and use Microsoft Excel and 2007 New Features, Office Button, Ribbon, Quick Access Toolbar, Live Preview, Mini Toolbar, File Extensions and File Sizes
· Review Basic Excel Formula, Functions and Techniques
· Understand and use Microsoft Functions and th…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Microsoft Excel 2007 Level 3
Course Duration
1 day
Target Audience
This course is aimed at users who have attended Level 1 and 2 Microsoft Excel 2007 courses, or for experienced users wishing to clarify existing knowledge using various methods and techniques.
Course Objectives
This course will provide delegates with the necessary skills and knowledge required to:
· Understand and use Microsoft Excel and 2007 New Features, Office Button, Ribbon, Quick Access Toolbar, Live Preview, Mini Toolbar, File Extensions and File Sizes
· Review Basic Excel Formula, Functions and Techniques
· Understand and use Microsoft Functions and the Insert Function Tool
· Understand and use Date and Time Functions
· Understand and use Multiple Sheets
· Understand and use Chart Options
· Understand and use Pivot Tables and Pivot Charts
· Understand and use Round Function
· Understand and use the Formula Ribbon
Course Contents
Revision – List of Topics
Using the IF Function
Using Logical Functions
ISERROR Function
Conditional Formatting
Date and Time Functions
Format Cells - Date and Time
System Date and Time Codes
Serial Numbers - Date and Time
Custom Formats - Date and Time
Moving between Sheets
Selecting a Sheet or Group of Sheets
Renaming Sheets
Moving and Copying Sheets
Inserting and Deleting Sheets
Construct Formula Referencing in other Sheets
3-D Referencing
Analysing Results of Pivot Tables
Pivot Table Toolbar
Toolbar - Pivot Tables Tool
Toolbar - Pivot Tables - Menu Options
Toolbar - Format Report
Toolbar - Chart Wizard
Toolbar - Hide and Show Detail
Toolbar - Refresh Data
Toolbar - Include Hidden Data
Toolbar - Always Display Hidden Items
Toolbar - Field Settings
Toolbar - Show Field List
Changing the Layout of a Pivot Tables
Pivot Tables - Shortcut Menu - Options
Toolbar Option - Pivot Table Wizard
Understanding the Round Function
Round to Two Decimal Places
Round to a Whole Number
Round to Whole Hundreds
Round Up to Next Whole Number
Round Down to Next Whole Number
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.