| Schedule |
|
|
| Location |
|
AGC Building Seattle Technology Lab (first Floor) 1200 Westlake Avenue N. Seattle WA 98109 |
| Cost |
|
$95.00 |
| Capacity |
|
12 seats still available |
FUNCTION INTRODUCTIONHave you ever tried to set up formulas in a worksheet and just can't get past using AutoSum? Come learn the process of setting up formulas in MS Excel. We will review the basics of how math is done in Excel and how to develop spreadsheets with formulas that give us the information we need. A strong foundation in working with functions will greatly increase you ability to work with Excel! We will look at several construction applications involving functions.
This course is a prerequisite to all the Excel Shorts, including Estimating with Excel.
**Prerequisite - Introduction to Computers and Excel Basics
Topics:
* Math Review * AutoSum * Relative & Absolute Reference * Name Box * Payment, If and Lookup Functions * Multi-sheet Functions * Creating a Numerical Summary Worksheet * Build a Budget * Scenarios & Goal Seek * Excel Problem Solving Skills
Need a user account? Click here to create one. Please create an account to register Already have a user account? Click here to login.
|