Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel - Coggle Diagram
Excel
Rows and Columns
tables
Column :letters A-Z
Rows numbers 1-65536
cells
cell properties: Width height
sheets
User Interface
mouse pointers
icons
GUI
Ribbon
Basic Maths
= sign
simple maths symbols + - * /
BIDMAS (= 3*2+6)
=A1+B2
Entering Data
type
keys
Tab
enter
select area before typing
selecting cells
left click / right click
select multiple cells
click and drag
SHIFT
CTRL
simple formula
=sum(a1:z1)
=sum(c2:e2)
=average(c2:e2)
=max(c2:e2)
=min(c2:e2)
=functionName(cellrange 1:cellrange2)
What is a spreadsheet?
Manipulate table data
charts
maths
sorting
list
uses?
File > New
Budget
create an invoice
schedule
Formatting Cells
The Fill handle