Advanced Computer Applications

The aim of this module is to develop advanced MS Excel skills to enable the student design and manage spreadsheets; apply best practice and be more effective with Excel using functions, formulas and Pivot Tables.

1. Design, based on business case study scenarios, well-crafted spreadsheets that are easy to understand, maintain, audit, and operate.

2. Design and create professional spreadsheets using advanced functions and formulas, customising formatting and incorporating logical, statistical and financial functions.

3. Organise, summarise and analyse business data using advanced tools including pivot tables, macros, analysis tools, filter and sort.

4. Integrate business data by using linking and embedding features with other office applications.