Adult Education Southampton - Microsoft 2007 Excel - Advanced (B02173)

ADULT HOMEPAGE

Microsoft 2007 Excel - Advanced

Code	Time	Duration	Day	Tuition
B02173-1213 002	09:30 16:30	18/07/2013 18/07/2013	Thursday	£100.00
B02173-1314 001	09:30 16:30	30/01/2014 30/01/2014	Thursday	£120.00
B02173-1314 002	09:30 16:30	17/07/2014 17/07/2014	Thursday	£120.00

About the course:

This course aims to develop participants' skills in spreadsheet techniques and terminology to an advanced level.

By the end of the course delegates will be able import and export data, use pivot tables and charts, audit and analyse worksheets, manage worksheets and customise Excel.

Course Content:

Using Templates

Create and Edit Templates
Create New Workbooks Based on User-defined Templates
Modify Workbook Properties
Change Default Templates and Modify Template Settings

Working with Ranges

Create and Use Named Ranges in Formulas
Use Lookup Functions
Create and Modify List Ranges

Formatting Cells

Create and Apply Custom Number Formats
Apply Conditional Formatting
Create and Modify List Ranges
Importing and Exporting Data
Import Data from Text Files
Export Data to Other Applications
Link to Web Page Data

Using PivotTables and Pivot Charts

Formatting Graphics
Crop and Rotate Graphics
Control Image Contrast and Brightness
Scale and Resize Graphics
Apply Formats to Data Series

Auditing and Analyzing Worksheets

Explore Formula Auditing
Trace Precedents and Dependents
Locate Errors in Formulas
Circle Invalid Data
Evaluate a Nested Formula
Watch all Cells with Formulas

Summarizing Data

Group and Outline Structured Data
Add Subtotals to Worksheets
Create and Remove Custom Filters
Use Database Functions
Create Scenarios
Use Solver

Managing Worksheets

Consolidate Data from Several Worksheets
Create Shared Workbooks
Track Changes
Merge Workbook Revisions
Protect and Unprotect Cells and Worksheets
Protect Workbooks

Customizing Excel

Record Macros
Run Macros
Change Security Levels for Macros
Understand Editing Macros
Add and Remove Buttons from Toolbars
Add Custom Menus
Modify Default Font Settings
Set the Default Number of Worksheets

Entry Requirements/Qualifications:

Delegates should have knowledge of Windows 2003 or 2007 and be able to use a keyboard and mouse.

Equipment Requirements:

All equipment will be supplied.

Assessment:

Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression:

Delegates may wish to extend their knowledge by completing an ECDL qualification or improve their understanding other Microsoft Office packages.

Enrolment Instructions:

Bookings can be made online, or complete a Reservation Form and return it to the Employer Engagement Team. Please ensure you read a copy of the terms and conditions for bookings and that we are informed of any special requirements.