Collins J. Carlton. Excel for Advanced Users

Atlanta, Georgia: ASA Research, 2010. – 175 p.Course Information.
Excel Advanced Concepts.
Excel & the Internet.
Functions.
The IF Functions.
Using Functions to Clean & Crunch data.
Data Commands.
Macros.
Solver.
Example Case Studies.
Gantt Chart.
Combo Chart.
Organizational Chart.
Portfolio – Investment Mix and Performance Tracking.
Digging Deeper into Excel’s Fundamentals.
XML.
Using Excel with Your Accounting System.
Instructor’s Biography.
Course Evaluation Form.