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

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.  

Related Tags