Embedded Files
within Excel (week1) we did individual workbooks
within Excel (week1) we did individual workbooks
Day_3_Task_3_Bike_Sales_Visualisations_Lab Task 3 data.xlsxWeek 1: Excel & Core Data Foundations
Week 1: Excel & Core Data Foundations
Overview: This module focused on fundamental data regulations and core spreadsheet operations using Microsoft Excel.
Regulatory Compliance: Researched key legal frameworks governing customer data, including the Data Protection Act, UK GDPR compliance and enforcement by the ICO, and the Freedom of Information Act.
Spreadsheet Techniques: Practiced importing retail sales datasets, formatting data as official Excel tables using shortcut controls, and applying sorting and filtering options.
Mathematical & Logical Functions: Calculated commission totals and averages, and utilized conditional formulas like the SWITCH function to categorize product sales volumes.
Data Summarisation & Presentation: Built and refined pivot tables to analyze multi-variable sales and student grade metrics, alongside preparing structured findings for senior leadership review.
A description of the images you are showcasing for your project, your process and the artefacts you created along the way
A description of the images you are showcasing for your project, your process and the artefacts you created along the way
Essential Excel Functions Explained
Essential Excel Functions Explained
SUM: Adds together all the numbers in a selected range of cells. Perfect for calculating total sales, revenue, or combined scores quickly.
AVERAGE: Calculates the mathematical mean of a group of numbers by adding them all up and dividing by the count of cells. Great for finding typical performance levels or mean scores.
IF: Tests a condition to see if it is true or false. If the condition is met, it returns one specified result; if not, it returns another. For example, checking if a student's grade is above a certain threshold to output "Pass" or "Fail".
VLOOKUP / LOOKUP: Searches for a specific value down the first column of a table and pulls back a corresponding piece of data from another column on the same row. Essential for matching IDs, names, or product codes with their records.
SWITCH: Evaluates a single expression against a list of values and returns the first matching result. This is a clean, efficient alternative to writing long, complicated chains of nested IF statements (such as categorizing sales volumes into "High", "Medium", or "Low").
COUNT / COUNTA: Counts how many cells in a range contain numbers (COUNT) or contain any data at all (COUNTA), helping you understand the size and completeness of a dataset.
Page updated
Google Sites
Report abuse