Impact - MS Excel

Evaluation with Microsoft Excel


Description
This course will cover methods for using Excel to evaluate your service. Learners will learn to prepare data by formatting datasets ready for analysis, including how to merge two datasets. The course will cover analysing data, including some tricks and formula to help you understand your data and how to use pivot tables, charts and graphs to review data.

Who is this course for?

This course is for anyone who has basic Excel skills and wants to extend their knowledge and confidence to allow them to evaluate their service.

Eligibility for free or discounted courses:

This MS Excel course belongs to the ‘Impact – MS Excel’ bundle, that includes both MS Excel courses. Buying a bundle will enable you to save 10% off the 2 courses. To buy the bundle, go onto the Course Catalogue and view the white panel on the right-hand side. You will be able to view the discounted course combinations in ‘BUNDLES’. When purchasing a bundle, you will also be able to redeem any relevant coupons that you are eligible for (see below).

We offer this course as free or discounted to specific groups of organisations. This currently includes Women’s Aid member organisations, London-based organisations, and ‘By and for’ organisations. Specialist ‘By and for’ services are run by and for the communities they serve, such as for Black and minoritised women, Deaf and disabled women and LGBT+ survivors.

If your organisation belongs to one of these groups, the coupon codes available for your team are visible in the ‘Noticeboard: Opportunities and discounts’ section of this page: https://www.womensaid.org.uk/what-we-do/ontrack/training-courses/

When purchasing your course, you will be able to enter the relevant coupon on the payment information page. Usage of the coupon codes is monitored regularly to ensure the coupons are not misused by any individual or organisation.
Content
  • Guide to our On Track and Impact eLearning Courses
  • Pre-Course Survey
  • Introduction Video: Evaluation with Microsoft Excel
  • Video: What is Evaluation?
  • Using the 'Evaluation with Excel' Workbooks
  • Client Profile Workbook
  • Adult Outcomes Workbook
  • Information about Excel Demos
  • Video: Stage 1: Prepare Data
  • Assignment: Importing and Merging
  • Demo: Import Data
  • Video: Importing and Merging Data
  • Demo: Index Match
  • Demo: VLOOKUP
  • Video: Formatting Workbooks Part 1
  • Assignment: Formatting Workbooks Part 1
  • Demo: Rename Sheet
  • Demo: Themes
  • Video: Formatting Workbooks Part 2
  • Assignment: Formatting Workbooks Part 2
  • Demo: Passwords
  • Demo: Freeze Rows
  • Video: Formatting Workbooks Part 3
  • Assignment: Formatting Workbooks Part 3
  • Demo: Sorting A to Z
  • Video: Cleaning and Recoding Data Part 1
  • Quiz: Cleaning and Recoding Data Part 1
  • Demo: Cleaning and Recoding Data Part 1
  • Video: Cleaning and Recoding Data Part 2
  • Video: Cleaning and Recoding Data Part 3
  • Assignment: Cleaning and Recoding Part 3
  • Demo: Cleaning and Recoding Part 3
  • Video: Stage 2: Analyse Data
  • Video: Conditional Formatting
  • Assignment: Conditional Formatting
  • Demo: Conditional Formatting
  • Video: Basic Descriptive Statistics
  • Quiz: Excel Descriptive Statistics
  • Demo: Descriptive Statistics
  • Video: Pivot Tables
  • Assignment: Pivot Table
  • Demo: Pivot Tables
  • Video: Stage 3: Present Data
  • Video: Charts and Graphs
  • Assignment: Charts and Graphs
  • Demo: Charts and Graphs
  • Video: Exporting Your Data
  • Video: Excel and Data Protection
  • Assignment: Excel and Data Protection
  • Demo: Excel and Data Protection
  • Post-Course Survey
  • Course Handout
  • Summary Quiz: Evaluation with Microsoft Excel
Completion rules
  • You must complete the test "Summary Quiz: Evaluation with Microsoft Excel"
  • Leads to a certificate with a duration: 2 years