Impact - MS Excel

Introduction to Microsoft Excel


Description
This course will cover basic Excel skills, providing a foundation through which you can start to understand your data. It will look at how to navigate around an Excel Spreadsheet, understand cell references, input and format data, apply filters and use basic formula in the day-to-day data collection involved in your work.

Who is this course for?

This course is for anyone who wants to increase their confidence in Excel and garner a basic understanding of Excel. This course is relevant to anyone using Excel spreadsheets in their role, or anyone who would like to start using them.

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: Introduction to Microsoft Excel
  • Fill in the Gaps: What can Microsoft Excel do?
  • Video: What is MS Excel?
  • Video: Excel for DA Services​
  • Understanding the Excel Workbook
  • The 'Introduction to Excel' Workbook
  • Information about Excel Demos
  • Video: Starting Off with Excel​
  • Video: Navigating Excel​
  • Demo: Stage 1: Exporting Data from your CMS
  • Video: Excel Foundations
  • Assignment: Excel Foundations
  • Demo: Excel Foundations - Cell Reference
  • Demo: Excel Foundations - Sheet Name
  • Demo: Excel Foundations - Column Width
  • Video: Stage 2: Checking Data
  • Assignment: Checking CMS Data
  • Demo: Check CMS - Convert Numbers
  • Demo: Check CMS - Format Dates
  • Demo: Check CMS - Geography
  • Video: Excel Basic Tools
  • Assignment: Basic Tools
  • Demo: Basic Tools - Tables
  • Demo: Basic Tools - Adding charts and graphs
  • Video: Stage 3: Answering Your Questions​
  • Quiz: Answering Example Questions
  • Demo: Quiz Answers
  • Match Up: Excel Formula
  • Video: Formulae
  • Quiz: Using Excel Formulae
  • Demo: Formula Quiz
  • Demo: Formula Top Tips
  • Video: Equations
  • Video: Stage 4: Presenting your dataset
  • Demo: Design Themes
  • Video: Graphs on Excel
  • Demo: Graphs on Excel
  • Video: MS Forms and Excel​
  • Demo: MS Forms
  • Going beyond your Case Management System with Excel
  • Video: Excel and Data Protection
  • Assignment: Data Protection and Excel
  • Demo: Data Protection
  • Summary Quiz: Introduction to Microsoft Excel
  • Post-Course Survey
  • Course Handout
Completion rules
  • You must complete the test "Summary Quiz: Introduction to Microsoft Excel"
  • Leads to a certificate with a duration: 2 years