BMATWT 452 - Building Materials Computing
Home
Course Syllabus
Assignments
Lecture Outlines
Readings
Contact
Exam 1 - Skills List
Email Etiquette
Signature Files - Definition and Practical
Automatic Forwarding of Email
LISTSERV - Definition
Microsoft Excel - Basic Skills
Cells- Defined
"Workbook" - contains "Worksheets"
Constant Values, Alpha characters, numeric characters
Formulae - begin with?
Simple math functions +-*/
Exponentiation
=SUM() function
Changing Column & Row widths & heights
Inserting/Deleting Columns Rows
Formatting Cells to: Currency, Percent, and comma style for numbers
Absolute Cell References (Using the $ sign in front of column letter or row number to "fix" it in place)
Multiple SHEETS in a Workbook, inserting, Renaming, Gathering information from several sheets
ESTIMATING AND BIDDING
Estimating - flow-of-information
Difference between Estimating and Bidding
Many different Estimating Software Packages
Conversions: Cubic yards to cubic meters,
lumber dimensions to board-feet
DATABASES vs. SPREADSHEETS
advantages and disadvantages
MORE EXCEL TIPS
COUNTIF/SUMIF functions
CHOOSE function
MOD function
DATEDIF function