The Microsoft Excel for Data Analysis and Reporting course has a new MANCHESTER date

Microsoft Excel for Data Analysis and Reporting (intermediate level)
Date: Thursday 12th July 2018
Location: St John Ambulance, St John House, Crossley Road, Heaton Chapel, Stockport SK4 5BF
Cost: IoF Individual Member £175, Charity Individual £195
Trainers: Victoria Barham
Booking: CLICK HERE

OVERVIEW

In this one day course Victoria will introduce you to Excel functionality that is fundamental when analysing and presenting data in Excel. Using relevant examples, you will leave with actionable learnings that you can implement to save time and to make your Excel spreadsheets more flexible and visual.

This is a practical course suitable for those who are familiar with basic Excel functionality but keen to learn more to enhance their work, for example Analysts, Campaign Managers and Database Administrators.

Attendees will need to bring their own laptop with Excel (preferably Windows, with Excel 2010 or later) installed.  Sample data and all course material will be provided on the day by the course trainer.

COURSE OUTLINE

Essential Functions and Formulas

There are functions and formulas that are essential when analysing and summarising data in Excel. Using hands on experience of working with charity data for over 9 years, Victoria will cover the functions and formulas that are essential when analysing and summarising data in Excel.  These will include using named ranges, sorting, filtering, functions for text manipulation, working with date variables, logical functions such as IF / AND / OR / SUMIF / COUNTIF, and LOOKUP functions.

Excel Charting

Visualising your data in chart form can be a useful way to identify trends and engage your audience. In this session you will learn how to create attractive and relevant charts.

An Introduction to PivotTables

PivotTables are a powerful feature within Excel that allow the user to summarise large datasets with ease. In this session Victoria will introduce you to PivotTables, showing you how to summarise, present and explore complex data with them. 

This is a practical course suitable for those who are familiar with basic Excel functionality but keen to learn more to enhance their work.

What people are saying about it:

“Extremely useful day, looking forward to applying the things I learnt in my job role”

This course was run at a very good pace and Victoria is a very patient and attentive trainer”

Victoria Barham

Victoria has enjoyed many years working within analytical roles, including over 12 years within the Charity Sector. Victoria provides freelance analytical support with clients including DM Insight, PDSA, Tree Aid, Birmingham Children’s Hospital, Noah’s Ark Children’s Hospice, Marie Curie and The Christie Charity with projects including data preparation and exploration, Campaign targeting, selection, and analysis, RFV analysis, Forecasting models, Lifetime Value analysis, FastStats Excelsior Reporting and Predictive Modelling. Victoria can also provide bespoke Excel training courses and is also an accredited trainer in FastStats Discoverer and Excelsior.