Microsoft Excel

These are outlines of what we hope to cover during the course. The course outlines are not written in stone and each course may vary slightly to meet the needs of the group attending. You will never be in a class of more than 9 people so you will always get plenty of personal attention and encouragement.

Please scroll down the page for all Excel Course Outlines

Microsoft Excel 2002, 2003 or 2007 Introduction

If you are new to Microsoft Excel, or are an existing Excel user that need to fill gaps in your basic excel skills, this course is for you.

Our Excel Introduction training course is designed to provide you with all the skills required to build spreadsheets from scratch, you will create formulas and prepare sheets for printing using page setup and formatting techniques.

Prior Knowledge: No prior knowledge of Excel is required.

Aims and Objectives: By the end of the course participants will be able to:

Understand the spreadsheet concept & terminology
Understand the Excel window
Create new workbooks
Move around in Excel
Select cells ~ keyboard and mouse
Enter, edit, delete and format data
Use undo/redo
Understand file procedures saving, closing and opening files
Create formulae & use the new AutoSum Plus feature
Use Functions average minimum and maximum
Replicate formula and work with Smart tags
Work with relative and absolute cell address
Change the order of calculation - BODMAS
Move, copy and paste data (drag and drop)
Spreadsheet presentation including alignment of data, number display
Column widths, row height,
Font, patterns and colours
Use templates
Produce charts
Create headers and footers
Print a worksheet
Use Help

Microsoft Excel 2002, 2003 or 2007 - Intermediate

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data. This one-day Excel training course will provide the delegate with an understanding of the more advanced features of Excel.

Prior Knowledge: Delegates should have a good working knowledge of Excel or have attended the introduction to Excel course

Aims and Objectives By the end of the course participants will be able to:

Recap Excel Basics any problems?

Whats new in Excel
Work with named ranges
Use Watch Window and the Formula Auditing Toolbar
Protect worksheets
Share work books
Use conditional logic
Use the IF function
Nest formulae
Multiple conditions
Create and use Lookup Tables
Work with multiple work sheets
Create 3D formulae
Work with multiple workbooks
Sorting and filtering
Add/remove subtotals
Customise and create toolbars

Microsoft Excel 2002, 2003 or 2007- Advanced

This one-day Excel training course will provide the delegate with an understanding of the more advanced features of Excel. This course will also de-mystify newer versions of Excel by showing you the main differences from earlier versions, and will also introduce some of Excel`s new and improved features.

Prior Knowledge: Delegates should have a good working knowledge of Excel or have attended the introduction to Excel course.

Aims and Objectives:

By the end of the course participants will be able to

Recap any Problems
Whats New in Excel
Create Pivot Tables to Summarise Data
Using the Pivot Table &
PivotChart Wizard
Adding a field to a PivotTable
Updating data in a PivotTable
Sorting data in a PivotTable
Setting the Pivot Table options
Hiding and showing subtotals
Collapsing and expanding levels
Extracting data from a Pivot Table
Grouping and ungrouping data
Grouping dates automatically
Record/Playback macros Scenarios
What are scenarios?
Adding scenarios
Scenario summary report
Editing & deleting scenarios
Use Goal Seek
What is Goal Seek?
Using Goal Seek Advanced Functions
Date functions
Typing dates
The Today function
Using dates in formulae
The Sumif and Round functions
Statistical
The Counta and Countif functions
Text Functions
The Concatenate function

The course outlines are only suggestions, I will happily prepare a course for your individual requirements. These are outlines of what we hope to cover during the course. The course outlines are not written in stone and each course may vary slightly to meet the needs of the group attending.

You will be amazed how much you can learn in one day! Yes, the courses are lively and quite intensive but as a maximum of 9 people attend each course I am able to tailor each course so that everyone attending will benefit fully from the training.

If you need bespoke training or training in your own offices please call to discuss your needs.

Self teach kits are also available with an easy to follow manual, exercises and an email helpline.

By booking your training with us you will be helping to support and develop a sustainable, not for profit IT resource within the Communities First area, encouraging more community engagement and raising awareness of other leisure time activities locally.

Follow ByteBack on Twitter»

Share |

ByteBack Training

Website developed by PomegranatePie »

Sue Jackson trading as ByteBack Training. Oak Trees, 4 Pen y Bryn Road, Colwyn Bay, Conwy LL29 6AF. Tel: 07770 472488. Email: sue@bytebacktraining.co.uk

ByteBack Training - Freelance IT Training specialist. Offering courses in Windows basics, Microsoft Word, Microsfot Excel, Microsoft Access, Microsoft Publisher, Microsoft Project, Microsoft Powerpoint, Internet/ Websites, bespoke courses and train the trainer. Covering the North West and Wales; courses can be held either at your premises or you can join the open course sessions at the Ty Llywelyn Community Centre.