Microsoft Excel 2003 Intermediate

This Intermediate course will improve your efficiency in the way you manage data. We will show you how to use Excel’s advanced spreadsheet functions, such as creating summaries using tables and charts and how to customise the Excel environment for your particular requirements.
By the end of the day, you will be able to:

• Work with multiple worksheets and link data
• Use hyperlinks in your spreadsheets
• Use conditional functions and formats
• Understand payment and date functions
• Apply, modify and create styles using the function wizard
• Use advanced graph and chart techniques, 3D charts and pictograms
• Use Excel as a simple database
• Import data from other files using dynamic links
• Understand the IF, PMT and date functions
• Make use of graphics in Excel spreadsheets
• Familiarise yourself with graph types and auto-formatting, gridlines in charts, combination charts, advanced viewing techniques (3D charts) and how to incorporate pictograms in graphs

Details

• Our trainers are experts in their topic and deliver courses in a practical, interactive style
• The maximum number of people on a training course is 12 so that the trainer can accommodate the learning needs of each delegate
• Each delegate is provided with a laptop and we use the most up to date technology
• A two course buffet lunch and unlimited tea and coffee are included in the price

Timing
Courses start at 9.30am and end at 4.30pm with half an hour for lunch

Is this the right course for me?
Yes, if you already have some experience of Microsoft Excel.

Level
Intermediate

About the Facilitator

Your Trainer
Bob is an expert IT trainer and is a Microsoft Office Specialist Master Instructor. He has worked across a range of businesses and has helped people at all levels improve their IT skills. Bob is comfortable supporting people to learn at introductory level and enjoys the challenge of helping people develop their skills at advanced level.

 

Support available
If your business is located in the West of Scotland you may be eligible for a grant of up to 50% of the cost of participating in these courses. There are a number of places available which are reserved for businesses with less than 250 employees and companies must meet certain eligibility criteria.

Click here to see location map

Options

• We can customise this course for you if you have a particular challenge in your company.  One of our specialist advisers will be happy to work on a solution with you.  If you have a group of 12 people who need the same training customised learning is a cost effective way to develop them and costs can be as little as £100 per person. Click here for more information.
• We can also provide one to one coaching in this subject area. Click here for more information