This course will show you how to do more with your data, including adding graphics (such as Smart Art and PivotTables) and performing advanced data analysis. This course is a must-have for anyone who works with Excel on a daily basis.
Professional training materials to teach either one day or half day Microsoft Office training workshops including Excel 2007. Thousands of trainer's around the world now use these customizable training solutions every day with confidence. Everything you need is classroom ready, so you can focus on the training.

Workshop outline:

Module One: Getting Started
Icebreaker - Housekeeping Items - Pre-Assignment Review - Workshop Objectives - Action Plans And Evaluation Forms

Module Two: Opening And Closing Excel
Opening Excel - Understanding The Interface - Understanding Worksheets - Understanding Workbooks - Closing Excel

Module Three: Your First Worksheet
Entering Data - Using The Wrap Command - Editing Data - Adding Rows And Columns - Checking Your Spelling

Module Four: Working With Excel Files
About the New File Format - Saving Files - Publishing Files To PDF - Sending Files via E-Mail - Opening Files

Module Five: Viewing Excel Data
An Overview Of Excel Views - Switching Views - Using Zoom - Switching Between Open Files

Module Six: Printing Excel Data
An Overview Of The Page Layout Tab - Setting Up Your Page - Using Print Preview - Printing Data

Module Seven: Building Formulas
The Math Basics Of Excel - Building A Formula - Editing A Formula - Copying A Formula - Relative vs Absolute Referencing

Module Eight: Using Excel Functions
Formulas vs Functions - Understanding The Formulas Tab - Using The SUM Function - Using Other Basic Excel Functions - Using The Status Bar to Perform Calculations

Module Nine: Using Time Saving Tools
Using AutoSum - Using AutoFill - Using AutoComplete - Sorting Data - Filtering Data

Module Ten: Formatting Your Data
Changing The Appearance Of Your Text - Changing The Appearance Of Numbers - Setting Alignment Options - Changing Cell Size - Using The Merge Command

Module Eleven: Working With Colours
Adding Borders - Adding Shading - Using Cell Styles - Using The Format Painter - Using Conditional Formatting

Module Twelve: Wrapping Up
Words from the Wise - Parking Lot - Action Plans and Evaluations

Instructor Guide

149

pages

Participant Guide

pages

Slides

Vital Skills Workshops

For your key people

OUR UK-based facilitators will run your Vital Skills Workshops either at your own premises, or at a convenient off-site venue.

All facilitators have advanced degrees and/or professional qualifications in their field.

Vital Skills Workshops run for 5 to 6 hours and are ideal for groups of 5-25. more

YOUR INVESTMENT

Course & Facilitator

FEES FOR a Vital Skills Workshop in the UK start from �690, depending on the course. Request a Proposal

Travel Expenses

NO CHARGE for travel within 120 miles of London. Actual and reasonable travel expenses are charged for other locations.

Outside the UK? Request a Proposal

Course Materials

EACH participant receives a Vital Skills workshop folder, pen and handouts at �9 per person.

Venue and catering

YOU CAN arrange your own venue and catering, or we can arrange a suitable venue.

Request a Proposal

Are you a trainer?

Use our

Vital Skills material

IF YOU would like to facilitate Vital Skills Workshops, for your own organisation, or external clients, we can provide the high quality learning resources you need.

Facilitator guide
Participant guide
Course Handouts
PowerPoint Slides

Partner with PARNELL and deliver Vital Skills Workshops based on our extensive library of quality learning resources, covering a wide and growing range of subjects.

More information