Excel Intermediate
This one day course is designed to help you develop your Excel skills. It is aimed at people that need to put together their own spreadsheets - including simple databases. It will help you set up efficient worksheets to gather data for funding returns, collate and analyse monitoring information for funders and present that data effectively... and more! If you've struggled with Excel, this is the course for you.
The course includes:
- Sorting and filtering data
- Basic formulas - get Excel to do the maths for you
- Database functions - quick and easy number crunching
- Pivot Tables - making it simple to analyse large amounts of data
- VLOOKUP tables - save time entering repetitive information and more
- Creating and editing charts - presenting data in easy to understand graphs




