Microsoft Excel 2007 Intermediate

Microsoft Excel 2007 Intermediate Excel 2007 gives professionals and everyday users the powerful tools necessary for getting the most out of their data. This course is designed for those users who wish to progress their current knowledge of Excel to include the more complex features. This course will enable delegates to:

• Work effectively with the Database facilities.
• Use formula and functions.
• Build and format spreadsheets.
• Create and format charts.

Course Content Working with Large Worksheets Viewing Options.
Hiding and Displaying Data.
Printing Large Worksheets.
Working with Multiple Worksheets Using Multiple Worksheets.
Linking Worksheets by Using 3-D Formulas.
Managing Workbooks.
Data Consolidation.
Linking across Applications.
Formulae Sumif and Countif.
Round and Intege.
Lookups and Named Ranges.
Logical Statements.
And & Or.
Index and Match.
Subtotal Function.
Is Functions.
Text and Date.
Advanced Charting Chart Formatting Options.
Creating Combination Charts.
Using Graphic Elements.
List Management Introducing Lists.
Sorting and Filtering Lists.
Advanced Filtering.
Custom Lists.
Text to Columns.
Custom Views.
Advanced Formatting Borders and Shading.
Using Special Number Formats.
Working with Dates.
Working with Styles.
Conditional Formatting.
Other Advanced Formatting.
Notation and Auditing Comments and Text Boxes.
Auditing Features.
Data Validation.
Protection.
Workgroup Collaboration.
Customising Excel Changing Options.
Customising Toolbars and Menus.