Participants should have knowledge of MS Excel or have taken Formulas and Charts I (CED9 572). Create more advanced formulas in Excel, including the 'If' function, applying absolute referencing to cells that will remain constant, grouping worksheets together, creating formulas for all grouped worksheets, and creating and filtering data lists. Creating and editing charts and linking Microsoft Excel to other Microsoft applications will also be discussed. ONE-DAY WORKSHOP.