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.

This course is a full eLearning course, without live webinars but instead including recorded tutorials, resources and interactive activities that can be accessed anywhere at any time.

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).

Coupon codes may be available for your team 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