My learning.

Find a course, enrol, and finish it with a verifiable certificate.

Month 1 — Excel Foundations

Excel basics, data cleaning, charts, and reporting fundamentals.

2 lessonsOffice & Data SkillsFree to enrol

Lessons

01

Excel Basics and Core Navigation

Video: enrol to watch
Excel is a grid of cells. Each cell has an address made of its column letter and row number, so the cell where column B meets row 4 is B4. Everything else builds on that idea. Moving around - Ctrl + arrow key jumps to the edge of a block of data. On a 10,000-row sheet this saves endless scrolling. - Ctrl + Home returns to A1. - Hold Shift while using those shortcuts to select as you move. Your first formulas Every formula starts with an equals sign: =A1+B1 =SUM(B2:B50) =AVERAGE(B2:B50) =COUNT(B2:B50) The colon means "through", so B2:B50 is a range covering those rows. Relative vs absolute references Copy =B2*C2 down a column and Excel helpfully shifts it to =B3*C3, =B4*C4 and so on. That is a relative reference, and it is usually what you want. Sometimes it is not. If every row must multiply by one fixed tax rate sitting in F1, lock it with dollar signs: =B2*$F$1 The dollar signs stop that part from moving when you copy the formula. Forgetting them is the single most common cause of a spreadsheet quietly producing wrong numbers. Sheets and workbooks A workbook is the file. A sheet is one tab inside it. Keep raw data on its own tab and do your calculations elsewhere, so you never overwrite the original numbers. Practice Enter ten numbers in column A, then build formulas that return their total, their average, and each number as a percentage of the total using an absolute reference.
02

Data Cleaning and Practical Formatting

Video: enrol to watch
Real data arrives messy. Cleaning it is most of the job, and these are the tools that do it. Removing duplicates Select your range, then Data > Remove Duplicates. Excel keeps the first occurrence of each row. Always do this on a copy, never your only version of the data. Trimming stray spaces A trailing space makes "Dubai " and "Dubai" different values, which quietly breaks lookups and pivot tables. TRIM strips them: =TRIM(A2) Fixing inconsistent text =UPPER(A2), =LOWER(A2) and =PROPER(A2) force consistent capitalisation. PROPER("john smith") returns "John Smith". Splitting and joining columns Data > Text to Columns separates "Smith, John" into two fields. To combine them back: =A2&" "&B2 Finding what does not match =IF(A2=B2,"match","check") flags rows that disagree between two columns, which is how you reconcile two exports of what should be the same data. Formatting that actually matters Numbers stored as text will not sum. If a column of numbers sits left-aligned by default, Excel is treating it as text. Multiply by 1, or use Data > Text to Columns and finish the wizard, to convert it. Set dates to a real date format rather than text, or sorting puts 10 January before 2 February. Conditional formatting (Home > Conditional Formatting) colours cells by rule, which makes outliers and blanks visible at a glance instead of hunting for them. Practice Take a list with duplicate rows, mixed capitalisation and stray spaces. Produce a cleaned copy where every name is consistently capitalised, spaces are trimmed, and duplicates are gone.

Related courses

All courses