Intermediate/Advanced Microsoft Excel 2003
1 Day Course (runs from 9am to 5pm) £125
Delivery Method:
Hands on Demonstration, Hand Outs (Step-by-step guide)
What will the course cover?
· Entering Text, Data and Formula
· Moving Around the Worksheet
· Entering Formula - Addition, Subtraction, Division, Multiplication etc
· Replicating Formula
· Creating a Bar Chart and a Pie Chart
· Formatting A Range Cells for Two Decimal Places, Integer and Currency
· Inserting and Deleting Column(s) and Row(s)
· Print A Range or Entire Worksheet
· Displaying Formula
· Printing Formula
· Formulation: Average, Count, Maximum, Minimum
· Countif / Sumif
· Pivot Table
· Relative Addressing
· Absolute Addressing
· LOOKUP, VLOOKUP and HLOOKUP Functions
· Filter - Simple Filter and Custom AutoFilter
· Use of Spreadsheet's Database functionality - 'Excel List'
· Adding Subtotals to a Database
· Linking Worksheets
· Lots of Exercises
