Being in a different time zone is very interesting. I don’t know about you but when I am traveling with a big difference in time, I like to make a chart like the one above. Helps keep the days and times lined up. Notice how I used yellow to signify morning and blue to signify [...]
Import Data from Excel into a MySQL Table
Export Data from a MySQL Table to Excel
How do you get lots of data from a spreadsheet into HTML format without spending a lot of time geeking? Watch this tutorial and see!
Download Samples
example_clients (Excel File)
example_clients (HTML File)
Goals
Learn to create and manipulate a spreadsheet
Resources
The tool: OpenOffice.org Calc
The learning resource: InPictures Web Site Tutorials, http://inpics.net/calc.html
Terms
cell
cell format (number, text, value, function, calculation, date, currency)
row
column
label
macro
replicate
template
worksheet
“what if” questions
range
absolute
relative reference
Concepts
Basic Calculations
Formatting Worksheets
Manipulating Data
Advanced Calculations
Making Data Visible
Projects
Basic Calculations
Add
Subtract
Multiply
Divide
Calculate averages
Find the maximum value
Formatting Worksheets
Format text
Format cells
Adjust columns and rows
Print worksheets
Manipulating Data
Move, copy, and paste
Add/delete columns
Add/delete [...]
