Intermediate Excel 2003

Date: 9th March

Location: Boston Scientific

Price:  €80 Per Person

Before attending this course you need to be familiar with the basic functions of Excel and be able to open, navigate and print a worksheet. A basic knowledge of formulas is helpful. You should be able to generate a basic chart. N.B. The course content is as listed – This course DOES NOT cover Macros or Pivot Tables.

Course Prerequisites

This course is specifically for those who already know how to input data into a spreadsheet and who are working on sheets created by others but want to know how to set up and manage their own worksheets. The course will specifically cover the following areas: Understanding how formulas are created. Understanding the difference between "relative" and "absolute" cell references. Naming cells and ranges and using names in formulas Understanding and using dates in calculations. Inserting comments. Creating custom lists. Conditional Formatting. Sorting by more than one field. Advanced Excel Charts – Retrieving records using autofilter, custom and advanced filters. Using the following Excel functions ONLY: IF Sum / Min / Max Average / AverageA Count / CountA Countblank Concatenate Left / Right / Mid Today() / Now () VLookUp / HLookup



















Trendlines, Combination Charts, Pareto Charts.





o

o

o

o

o

o

o

o

o