Microsoft Excel (Advanced)

Microsoft Excel (Advanced)

(SCQF level 6)

Part-time,

Course Options
No course offerings available at the moment.

Overview

Why this course?

Develop your Microsoft Excel skills to boost your resume, improve productivity, and increase your technical skills to an advanced level.

What will I learn?

  • Advanced Filtering, transposing data, and using names in formulas.
  • Creating a Template & an Outline.
  • Creating Scenarios.
  • Linking and Importing.
  • Functions and Formulae (Logical, Mathematical, Statistical, Text, Financial, Database, Nested).
  • Data Tables.
  • Macros.
  • Auditing & Precedents.
  • Charts.
    • Common Charts
    • Formatting and Modifying Charts
    • Adding Images to Charts
    • Pivot tables

Full desktop access to Microsoft Office 2013 app or newer is required

Course Details

This is an online course delivered over one day.