Analysing Data for Business Decision Making Using MS Excel

Course Content

This course is about harnessing the power of Microsoft Excel to analyse business problems and identify solutions, allowing you to turn data into information to make sound decisions that, in today's fast-paced climate, can lead to a competitive business advantage. You gain the knowledge and hands-on skills required to exploit some of Excel’s intermediate and advanced features, such as PivotTables and PivotCharts.Most of the class time is spent on hands-on exercises. These exercises are designed to provide you with practical, real-world experience using the Excel features in an efficient and effective manner. Hands-on exercises include:

  • Performing statistical and financial calculations
  • Reducing speculation with "what-if" analysis
  • Designing formulas that capture errors and require less maintenance
  • Creating interactive data reports with PivotTables
  • Recording macros to simplify data analysis

Entry Requirements

Experience with Excel fundamentals is assumed. You should be able to:

  • Reference cells through absolute and relative addressing
  • Create formulas
  • Work with worksheets and workbooks
  • Use AutoFill
  • Format numbers in a worksheet
  • Resize columns and rows
Course Overview
  • Study Type

    Part-Time Day

  • Campus

    Gardyne Campus

  • Start Date

    10 Jan 2020

  • SCQF Level

    5

  • Duration

    1 Day

  • Subject Area

    Business & Administration

  • Course Fee

    £220

  • All course fees are reviewed annually, and subject to change. Published fees apply to the courses mode of delivery.

The course application is currently closed. You can find out more information about this course by making an enquiry.

Make an enquiry