Microsoft Excel - Intermediate

Microsoft Excel 2003, 2007 or 2010

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

Follow ByteBack on Twitter»

Share |

COURSE OUTLINES

Course outlines are 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.

I thoroughly enjoyed the training session. I have learned so much and all of it is relevant to my job. I am looking forward to putting what I`ve learned into practise. Thank you.

Karen Ellis - Credent Commercial Insurance Ltd.

Amazed at what I`ve learned - I thought I knew - realised I didn`t! Fantastic - would recommend Elaine Jenkins - Credent Commercial Insurance Ltd

Excellent training day, well presented, pleasure to be here. Would definately come again!

Best course I have ever been sent on.

What I learned in the first half hour will save me hours in the workplace

Lots more learned that I thought and I have developed my knowledge much more, thank you Sue ;o)

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.