DIGITAL SKILLS
2022-2023
Welcome to Excel
Cells, sheets and formulas
• Formulas
• Cells
• Columns (letters, first)
• Rows (numbers, second)
• Sheets
Cells, sheets and formulas
• Formulas
• Cells
• Columns (letters, first)
• Rows (numbers, second)
• Sheets (Ctrl PgDn/Up)
• Written numbers
(“constant”)
Navigating & Selecting
• Change cells: Arrows. Stuck? Esc
• Move to ends: Ctrl + Arrows
• Select adherent cells: (Ctrl +) Shift + Arrows
• Select separate cells: Ctrl + whatever you select
or click on
Writing
• In formula bar double click or F2
• Directly in cell (double) click or F2
• To indicate text “ ” (used in formulas)
• Start a formula with = (or +)
• Ignore a formula ‘ in the beginning
Deleting
• If you’re writing in a cell:
• Del(ete) button
• Backspace
• If you’ve selected a cell
• Del(ete) button
Wash away your sins
• Ctrl z
or
•
Wash away your sins
• Ctrl z
or
• So… nothing you can do wrong
• So… experiment!
Basic Math
Basic math
• Plus + (also works with dates)
• Minus -
• Multiply *
• Divide /
• Power ^
Basic math
• Plus +
• Minus -
• Multiply *
• Divide /
• Power ^
Basic math
• Plus +
• Minus -
• Multiply *
• Divide /
• Power ^
Basic math
• = equal to
• < smaller than
• > larger than
• <= smaller than or equal to
• >= larger than or equal to
• <> is not equal to / is different from
Basic math: sum
1. =A1+A2+A3+272 • Page
special
2. =sum(A1,A2,A3,272) (later)
3. =sum(A1:A3,272) =sum(A1:A2,A3,272)
4. Shortcut Alt =
5. Autosum:
6. Select range
Basic math: profit
Quantity x (price – cost per item) – fixed cost =
profit
• Price 100 euro per item
• Quantity 1,000
• Fixed cost 100 euro
• Variable cost 50 euro per item
o What is the profit?
Changes
in values
How much did it change?
• absolute change = New value – Old value
• % change = (N – O) / O
or N / O -1
How much did it change?
• absolute change = New value – Old value
• % change = (N – O) / O
or N / O -1
• January $ 200
• February $ 210
•What was the % change in February?
Write 200 and 210 in separate cells. Then calculate.
Make a value in- or decrease
• Increase %
Original value x (1 + %)
For instance: salary raise, price increase, +
VAT
• Decrease %
Original value x (1 - %)
For instance: discount, value drop, -
commission
Make a value in- or decrease
• You buy 1,000 euro worth of stock
(shares)
• It drops 50% in value
• Then its value rises 80%
• How much did your stock increase in
value? (in euro and in %)
Calculate in Excel, using Value*( 1 + - %)
Part of
a whole
How much % is a number
of a total number?
• Part / total = %
• % * total = Part
Por example
• Sales France / total Sales = France’s % of sales compared
to total
• % discount * Total amount = value of the discount
• VAT % * amount without VAT = value of the VAT
What did you learn?
• Cell, row, column, sheet, formula bar
• Selecting, writing & deleting
• +-*/^
• =Sum(
• Profit
What did you • Changes in amount: N–O
learn? • Changes in %:
O–1
(N - O) / O or N/
• Make a value increase: value x ( 1 + % )
• Make a value decrease: value x ( 1 - % )
• Part / total = %