Excel for Data Analysis

Header

Course Overview

Course Overview
Improve your Excel skills and learn how to present, interpret and analyse data

Open Is this course right for me?

This is a course for those with very little confidence in or experience of computers. You will start with the basics and develop digital skills and learn how to analyse data. Whilst maths and English will be appropriately supported you will need a reasonable level of English. As part of the first session, we ask learners to complete a short English and basic numeracy assessment, as you will be building a portfolio and will need good understanding to complete the written work. You will be supported throughout the course by your tutor and other learners. Prior to completing this course, you should be able to: 1. Know how to create and safe files, 2. Be confident with the main toolbar and its functions, 3. Understand printing settings (printing charts and etc), 4. Be willing to make mistakes and learn.
Prosp Is This Right For Me

Open What will I learn?

1. Excel Spreadsheet use – revision: Explore the Excel interface, enter and edit data, and save your work. 2. Perform Basic Calculations: Use formulas and functions like SUM, AVERAGE, and MIN/MAX to analyse data. 3. Format Data for Clarity: Apply formatting to make your data easier to read, including borders, colors, and currency symbols. 4. Organize Data with Sorting & Filtering: Sort and filter information to quickly find and manage data. 5. Create Charts and Graphs: Visualize data using bar charts, pie charts, and line graphs. 6. Master Key Formulas: Use formulas like IF, VLOOKUP, COUNTIF, and DATE functions for deeper data analysis.
Prosp What Will I Learn

Open How will I learn?

You will learn mainly by using the computer to work on practical tasks; by means of question and answer sessions and demonstrations by the tutor. You will receive handouts to help you practice at home.
Prosp How Will I Learn

Open Will I gain a qualification?

Prosp Qualification

Open Next steps

You can progress to other CLMK courses – browse our brochure online.
Prosp Next Steps

Open Please bring

Please bring to class a notepad and pen, plus a folder to keep your work in.
Prosp Please Bring
ITL01130
16/01/2025
Format
27/02/2025
3.00 hours per week
6 weeks
£0.00
Central Milton Keynes Learning Centre