Microsoft Excel 2007 - beginners

Get the most out of Microsoft Excel 2007 – it has more power to help you than you realise

Microsoft Excel dominates modern business life, but most people use only a fraction of its power – maybe you’re one of them. Well, even if you regard computers as a necessary evil, this course will open your eyes to the many ways in which Excel can actually make your working life a whole lot easier.

Is it for me?

If you have little or no knowledge of Excel 2007, but have some experience of personal computers, this is the course for you.

What’s it all about?

Our workshops are effective because they are based on your real life problems – we expect you to bring all your Excel baggage with you! Your learning from the day will stick with you because we use a range of activities, have lots of practice time, and encourage a large amount of questions.

Learning works best when learners can make their own discoveries, so you will have time to play with Excel and perhaps have your own Eureka moment!

Our supportive and experienced trainers believe that the most important thing is to meet our learners’ personal objectives. However, to give you an idea of the type of skills you will learn, by the end of the course you should be able to:

• work within the basic Excel environment

• create a new workbook

• open and navigate within workbooks and worksheets

• make changes to data in a workbook

• copy and paste data in Excel

• understand, create and work with formulas and functions used to make calculations

• print your workbook data

• create effective charts in Microsoft Excel

• use the new ‘ribbon’ and quick access toolbar

Tell me more!

Excel 2007 has so much to offer, that we can’t fit all of it into the workshop as there are 90 different possible topics. However, you will receive an indispensable folder of materials to keep on your desk which will include all the following topics:

Excel 2007 Orientation

• Starting Excel

• The Excel Screen

• Using The Ribbon

• Using KeyTip Badges

• Minimising The Ribbon

• Shortcut Menus

• Using Shortcut Menus

• Understanding Dialog Boxes

• Launching Dialog Boxes

• The Quick Access Toolbar

• Customising The Quick Access Toolbar

• The Office Button

• Using The Office Button

• The Status Bar

• Customising The Status Bar

• Exiting Safely From Excel

Creating a new workbook

• Understanding Workbooks

• Using The Blank Workbook Template

• Typing Text Into A Worksheet

• The Save As Dialog Box

• Saving A New Workbook

• Typing Numbers Into A Worksheet

• Typing Simple Formulas In A Worksheet

• Easy Formulas

• Typing Dates In A Worksheet

• Easy Formatting

• Checking Spelling In A Worksheet

• Making And Saving Changes

• Safely Closing A Workbook

Formulas and functions

• Understanding Formulas

• Creating Formulas That Add

• Creating Formulas That Subtract

• Formulas That Multiply And Divide

• Understanding Functions

• Using The SUM Function To Add

• Summing Non-Contiguous Ranges

• Calculating An Average

• Finding A Maximum Value

• Finding A Minimum Value

• More Complex Formulas

• What If Formulas

Copying Excel data

• Understanding Copying In Excel

• Using Fill For Quick Copying

• Copying From One Cell To Another

• Copying From One Cell To A Range

• Copying From One Range To Another

• Copying Relative Formulas

• Copying To A Non-Contiguous Range

• Copying To Another Worksheet

• Copying To Another Workbook

Row and column formatting

• Approximating Column Widths

• Setting Precise Column Widths

• Setting The Default Column Width

• Approximating Row Height

• Setting Precise Row Heights

• Hiding Rows And Columns

• Unhiding Rows And Columns

Printing

• Understanding printing

• Previewing Before You Print

• Performing A Quick Print

• Selecting A Printer

• Printing A Range

• Printing An Entire Workbook

• Specifying The Number Of Copies

• The Print Dialog Box

Creating charts

• Understanding The Chart Process

• Choosing The Chart Type

• Creating A New Chart

• Working With An Embedded Chart

• Resizing A Chart

• Dragging A Chart

• Printing An Embedded Chart

• Creating A Chart Sheet

• Changing The Chart Type

• Changing The Chart Layout

• Changing The Chart Style

• Printing A Chart Sheet

• Embedding A Chart Into A Worksheet

• Deleting A Chart

Questions, questions

Before you start the course we will send you a questionnaire to find out what you know already and what your expectations are for the course.

Venues

You can either come along to our state of the art computer lab, or if you would prefer we can come to your location.

A choice of delivery methods

We can offer a variety of delivery methods:

• One day workshops – either at our venue or bespoke at your venue

• 2 hour ‘bionic bursts’ (bespoke, focused, cost effective) at your venue

• At your desk training – we can work individually with up to 5 people at their desks during one day at your venue (highly bespoke & cost effective)

Your facilitator

Emma Konopka, your principal facilitator, has over 10 years teaching and training experience and experience of supporting clients in their use of a variety of professional research databases. With an MA in Information Studies, Emma combines her experience and knowledge with an engaging facilitator style.

Emma passionately believes in the power of collaboration and discovery in learning. Both of these help learners to learn more efficiently and retain more of the learning in the long term. Learners will be encouraged to play, experiment and work in groups. This accelerated learning style includes such techniques as:

• Problem-solving activities (wherever possible based on your real life problems)

• Collaborative group work

• Activities that engage the body as well as the mind (movement & physical activity help learning)

• Active encouragement of questions

• Lots of practice

Taster session

If you would like to get a taste of our one day workshops we can offer a free 1 hour trial at your offices. You will get to discuss your needs with Emma, you can choose any part of the workshop to see in action and preview the learning materials.

Name dropping

When you sign up for Microsoft Excel 2007 for beginners, you will be in good company:

“I just wanted to thank you for providing such a stimulating and thought-provoking course. I will certainly be implementing the tips and suggestions just as soon as I can. I returned to the office today with renewed vigour and cannot wait for the positive changes to start happening. You’re one smart cookie – keep doing what you’re doing, only good things can happen by taking the Today’s Pa training and I, for one, will spread the word!”

Hayley North - Microsoft

Below are just some of the companies who have sent their staff to our workshops recently:

• 2012

• AXA Insurance

• Barclays

• The British Library

• Brunel University

• Carphone Warehouse

• DLA Piper

• Girlguiding UK

• The Home Office

• Investa Real Estate

• Npower

• Pepsico

• Rugby Football Union

• Shell

• Surrey Police

• UBS

• Virgin

Fee

This course is available at our computer suite for £199. For a bespoke course at your venue please call 020 7622 2400 for more details.

Our philosophy

Courses and workshops from Indiquo are designed to engage and entertain, as well as inform – that’s how we can promise to make what can seem to be the dullest of subjects interesting.

Our trainers have real-world experience at all levels of the organisation, so they speak your language and understand your issues and problems. And because they have ‘been there and done that’, they know how to get straight to the heart of every subject.