Excel 2007: Analysis Using Functions & What-If Tools 11/3/2009
Thu, 10/29/2009 - 09:18 — Dawn VanBramer
Please log in to provide your instructor with some information about you and your goals for attending the training session. Your user id will appear with your post after you log in. Please list your name in the Subject line. In the Comment area, please include information about your Department/Unit, projects pertaining to the session topic, and your goals for attending the workshop.
Thank you!
Prerequisite(s): Excel 2007: The Basics workshop
In this hands-on workshop, participants will explore the use of advanced tools for data analysis and querying in Excel, a spreadsheet and data management tool. A professional manual will be provided in this workshop.
Objectives:
* Perform calculations on arrays
* Use the IF, AND, SUMIF and COUNTIF functions
* Apply different types of conditional formatting
* Use the Goal Seek and Solver tools
Roy Hoffman
I am an ARL employee in the UWO/Systems Development and Testing Department. I use EXCEL to maintain test results in spreadsheets and provide reports on the data stored in them. As a novice in EXCEL, I was hoping to learn how to better use some of the EXCEL features with the goal of providing better reports for users of this data.
Jean Beierlein
I am looking to further my knowledge of Exel by analyzing data, and getting spreadsheets to tell me more using the different functions.