#8 Go Spreadsheets

date
May 12, 2023
slug
8-sheets
status
Published
tags
summary
Starting spreadsheets next
time
1h-05m
type
Post
 
I came across this two part video on youtube by Bill Howe, University of Washington, on Introduction to data science. It gives more academic outlook and so far the style of teaching is pretty good. It is total of 14hrs of content and I’ve watched just about an hour of it.
 
I started a short spreadsheets course on datacamp. This time instructor is James. I thought I’ll be able to finish it soon, but I lost wifi and didn’t make much progress with it .
 
 

Notes

Cells address are identified by row and column number.
  • B2 is second column and second row
Saving values in a cell requires pressing enter or moving another cell.
Cell ranges
  • C2:C5 extends from 2nd row to 5th row of 3rd column
  • C2:D5 is a rectangular grid starts from C2 on top left and D5 on bottom right
Formulas can be written starting with = . The Order of operations followed is () > ^ > */ > +-.
  • Arithmetic operations can simply be performed by use of +, -, *, /. Exponent is ^
  • #DIV/0! shows up if divided by zero.
 
 
 
 

© ibrar 2023