Microsoft Excel Data Analytics

Course Overview

Course Overview:

Microsoft Excel is a powerful tool for data analysis that is widely used in many industries. In this course, you will learn how to use Excel to organize and analyse data, create reports, design charts, and make data-driven decisions. You will also learn how to use Excel's built-in features to manipulate data in Power Query.

Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

Target Audience:

  • Business professionals who want to improve their data analysis skills or anyone who wants to learn how to use Excel for data analysis.

Course Content:

  • Leverage the Power Query tool to connect with a wide range of data sources
  • Use Excel's built-in functions and formulas to manipulate data
  • Interact with a variety of table types (Simple, Table and PivotTable)
  • Use various excel tools such as Aggregate, filter, and sorting
  • Create charts and graphs to visualize data
  • Create live interactable dashboards
  • Apply conditional formatting and data validation to improve data accuracy
  • Perform statistical analysis and make data-driven decisions

Prerequisites for attending:

  • Learners should have a basic understanding of Excel and its functions or have completed an intermediate Excel course
  • Access to a licensed version of Microsoft Excel is required for this course
  • A stable internet is required
  • A second monitor is recommended but not required

Programme Information

Study Mode:  Virtual (via Teams)

Duration:  6 hours

Times:  9.30  - 4.00pm

Price : £90

For further information on this course contact corporate@wcs.ac.uk or call 0141 581 2121 .