Business Skills   

Participants should have some knowledge of MS Excel. Includes an overview of Microsoft Excel, and a quick review of creating and saving a workbook. Learn how to create simple formulas in Excel such as sum, maximum, minimum, average, and count. Also create and edit charts such as column, bar and pie, how to add labels to a pie chart, and how to place a chart on a separate worksheet. ONE DAY WORKSHOP.

Participants should have knowledge of Microsoft Excel or have taken Formulas and Charts I (CE9 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.