This course is for anyone who has been using Excel for budgets and managing information.
Aims
By the end of the course, you will be confident in using some of Excel’s more advanced features. You will be able to do more complex “what if” scenarios and use conditional formula and pivot tables to manipulate information.
What you will learn
In particular you will be able to:
- Move around a spreadsheet speedily using range names and even use them in formula to make them easier to read.
- Use the auditing feature to check where the errors such as DIV?0 or NAME come from.
- Use the Scenario manager to do “what if” analysis of your information. For example, “how will a change in the salary bill affect the profit for the month?”
- Create calculations based on conditions. For example, add a £10 bonus to all staff who have achieved results above target.
- Use Hlookup and Vlooukup functions. For example, to look up how much poll tax should I pay based on the value of my house?
- Use Filters and Pivot Tables to help manipulate your data to find only the data you are interested in and make it easier to read.
Requirements
Delegates must be confident in using Windows and a mouse. Additionally you must have used Excel before and be familiar with entering formula and using absolute cell references (see our Excel Essentials and Intermediate Outlines).
Timetable
Session 1
Recap, Partial Absolute Cell References, Using Paste Function, Good Design Principles, Range Names, Adding Comments.
Session 2
Goal Seeker, Auditing Your Worksheet, Scenario Manager, Scenario Summary.
Session 3
Using the If Function, Vlookup or Hlookup.
Session 4
Recap, Advanced Filters, Pivot Tables.
The ‘Small Print’
The course will run from 10am to 4:45pm (light cold buffet 1pm to 1:45pm). Please be careful to arrive by 9.45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 30 minutes late you may be asked to leave and attend another day.
