Computing Services
Excel: Data Analysis with Functions
Course Outline:
- Managing Large Amounts Of Data
- Freezing Worksheet Titles
- Splitting Worksheet Windows
- Display Magnification
- Advanced Excel Analysis Functions
- Evaluating With IF Statements
- Summing, Counting, Averaging Conditionally
- Retrieving Data With VLookup
- Ranking Data With Functions
- Analyzing With Date Functions
- Examples Of Other Functions
- Financial Functions
- Text Functions
- Installing Excel Add-In Programs
Handouts:
UC_Excel_2007_Module_4_-_Data_Analysis.pdf (41 pages)Practice Files:
Videos
ExcelBasics07Mod4.rm (Instructor screen capture with voice) [Video Timestamps]last update October 27, 2008 -ei for kv
