Have you ever wanted to improve your excel skills to:
- Improve the efficiency of routine tasks?
- Develop reporting spreadsheets to understand your management information?
- Update your existing spreadsheets to reduce errors and increase accuracy?
- Present information to your staff, investors or customers in a clear understandable format?
If so, then this 4 part workshop is for you. Using actual reports, you will learn to tailor your spreadsheet to do exactly what you want with minimal effort and high levels of accuracy.
If you are a business owner, book-keeper or a member of staff who deals with financial or management information, then this course is designed with you in mind. No prior excel knowledge is required but a basic understanding of the system would be an advantage.
Workshops will be held on the following dates and times:-
Workshop 1- 7th June 2017 09.30 to 12.30 hours
Basic Introduction: Excel Introduction; Editing; Viewing; Spreadsheet Structure; Cell references; Design; Connecting Workbooks.
Workshop 2- 14th June 2017 09.30 to 12.30 hours
Data Handling & Analysis: Sorting & Filtering; Controlling User Input; Formatting; Lookup & Reference; Logical Functions.
Workshop 3- 21st June 2017 09.30 to 12.30 hours
Data Analysis: Basics; Summarising Data; Pivot Tables; Basic Macros.
Workshop 4- 28th June 2017 09.30 to 12.30 hours
Presentation: Cell Formatting; Number Formatting; Graphs & Charts; Page & Print Setup.
Registration on the 1st workshop will automatically register onto all 4 workshops as it is advisable to attend the complete series.
You will need to bring a laptop to the course with Excel 2010/2013/2016 installed – all other course material will be provided.