Core Training for Microsoft Office Excel 2007 - MS Excel Online Training Course

COMPUTER LITERACY -   Provides effective and affordable instructor led computer training courses in London and throughout the South East. Training is offered at all levels - from Beginner through to Guru – and on all the leading software applications, including Microsoft Office and Adobe Creative Studio. Our public scheduled courses are open to corporate clients and private individuals alike, and are run at our modern and fully resourced training centre in central London.  In addition we also offer, throughout London and South East England, company specific and bespoke training courses at client’s premises, at our training centre or at other mutually agreeable locations. For further information on the courses we offer please click on the “Home” link above, or give us a call today on 0870 240 6160.

	Course 5425: Getting Started with Excel 2007
	●	Module Introduction
	Exploring the Excel 2007 Environment
	●	Lesson Introduction
	●	Elements of the Excel 2007 User Interface
	●	Features of Excel 2007
	●	Self Test
	Creating and Modifying a Workbook
	●	Lesson Introduction
	●	Create a Workbook
	●	Lab: Setting up a Workbook
	●	Create and Rename a Worksheet in a Workbook
	●	Lab: Modifying a Workbook
	●	Customize a Workbook
	●	Self Test
	Modifying a Worksheet
	●	Lesson Introduction
	●	Modify Columns and Rows in a Worksheet
	●	Lab: Inserting and Modifying Columns and Rows
	●	Data Entry Options
	●	Lab: Entering a Data Series
	●	Self Test
	Editing Data in a Workbook
	●	Lesson Introduction
	●	List the Paste Options Available in Excel 2007
	●	List the Find and Replace Dialog Box Controls
	●	Lab: Moving, Finding, and Replacing a Value in a Workbook
	●	Lab: Finding a Cell in the Workbook with a Particular Format
	●	Use the Dictionary and Thesaurus
	●	Self Test
	●	Module Summary
	●	Glossary
	[Hide]

	Course 5426: Performing Calculations on Data in Excel 2007
	●	Module Introduction
	Managing Groups of Data
	●	Lesson Introduction
	●	Create and Rename a Table
	●	Lab: Adding and Modifying a Row in a Table
	●	Lab: Naming Groups of Data
	●	Self Test
	Using Formulas for Performing Calculations on Data
	●	Lesson Introduction
	●	Create and Edit a Formula
	●	Use the Function Library
	●	Lab: Using Relative and Absolute References to Create a Formula
	●	Create a Conditional Formula
	●	Self Test
	Identifying Errors in a Formula
	●	Lesson Introduction
	●	Identify Error Codes
	●	Trace the Precedents and Dependents of a Cell
	●	Evaluate Parts of a Formula
	●	Use the Watch Window
	●	Lab: Auditing a Worksheet
	●	Self Test
	●	Module Summary
	●	Glossary
	[Hide]

	Course 5427: Formatting and Printing Worksheets in Excel 2007
	●	Module Introduction
	Changing Workbook Appearance
	●	Lesson Introduction
	●	Format a Cell
	●	Lab: Creating and Applying Styles to Cells
	●	Workbook Themes and Styles
	●	Create and Apply a Table Style
	●	Lab: Applying Themes and Styles
	●	Self Test
	Enhancing the Readability of a Workbook
	●	Lesson Introduction
	●	Format Numeric Data
	●	Conditional Formatting
	●	Lab: Creating and Applying Conditional Formats
	●	Add Images to a Worksheet
	●	Self Test
	Printing Worksheets
	●	Lesson Introduction
	●	Headers and Footers
	●	Lab: Creating a Custom Header for a Workbook
	●	Set the Workbook Properties
	●	Lab: Printing a Worksheet
	●	Self Test
	[Hide]

	Course 5428: Filtering and Summarizing Data in Excel 2007
	●	Module Introduction
	●	Filtering Data
	Lesson Introduction
	●	Identify Filters in Excel 2007
	●	Lab: Creating and Using Filters
	●	Summarize List of Data
	●	Lab: Performing Calculations on Filtered Data
	●	Self Test
	Reordering Data
	●	Lesson Introduction
	●	Sorting Options in Excel 2007
	●	Lab: Sorting a Data List in Excel 2007
	●	Organize Data into Levels
	●	Find Data by Using VLOOKUP
	●	Self Test
	Validating Data
	●	Lesson Introduction
	●	Data Validation in Excel 2007
	●	Lab: Creating a Validation Rule
	●	Self Test
	●	Module Summary
	[Hide]

	Course 5429: Working with Pivot Tables and Charts in Excel 2007
	●	Module Introduction
	Creating and Manipulating PivotTable Reports
	●	Lesson Introduction
	●	PivotTable Reports in Excel 2007
	●	Organize Data in a PivotTable Report
	●	Lab: Creating and Pivoting a PivotTable Report
	●	Filter a PivotTable Report
	●	Show and Hide PivotTable Report Details
	●	Self Test
	Editing and Formatting PivotTable Reports
	●	Lesson Introduction
	●	Edit a PivotTable Report
	●	Change the Summary Function in a PivotTable Report
	●	Apply Formats to a Field
	●	Lab: Formatting a PivotTable Report
	●	Create a PivotTable Report from External Data
	●	Self Test
	Creating and Customizing a Chart
	●	Lesson Introduction
	●	Create and Manipulate a Chart
	●	Chart Styles Gallery in Excel 2007
	●	Customize and Save a Chart as Chart Template
	●	Lab: Customizing a Chart
	●	Self Test
	●	Module Summary
	[Hide]

	Course 5430: Collaborating with Others in Excel 2007
	●	Module Introduction
	Allowing Multiple Users to Access a Workbook
	●	Lesson Introduction
	●	Share a Workbook
	●	Save a Workbook as a Web Document
	●	Lab: Sharing a Workbook
	●	Self Test
	Managing a Shared Workbook
	●	Lesson Introduction
	●	Add Comments to a Cell in a Workbook
	●	Manage Changes in a Shared Workbook
	●	Lab: Tracking Changes in a Workbook
	●	Self Test
	Protecting and Authenticating Workbooks
	●	Lesson Introduction
	●	Access Protection
	●	Lab: Password-Protecting a Workbook
	●	Digital Signatures and Certificates
	●	Authenticating a Workbook
	●	Self Test
	●	Module Summary
	[Hide]