INTRODUCTION TO DATA ANALYSIS USING EXCEL

This course is currently closed for new learners. Register for our email alerts and we’ll let you know when this or similar courses become available.

Introduction

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

In this 2 hour online course, you will learn how to perform data analysis using Excel’s most popular features.

Course code

SDAE

Location

Varies

Duration

2 hours

Price

£TBA

Course Content

  • Learn about Excel tables and what is their advantage over regular ranges.
  • Use a table to filter, sort and see totals.
  • See how calculations can be used to add columns to the existing data in Excel table.
  • Create our first pivot table.
  • Use multiple pivot tables and pivot charts to create our first dashboard.
  • Connect multiple slicers to the pivot tables.
  • Explore in more depth the full power of pivot tables.
  • See how to filter the data shown in the pivot in many ways to achieve interesting subsets of the data

Course Contact Details

If you would like more information or to reserve a place on a course, please get in touch.

Telephone: 01387 734199
E-mail:shortcourses@dumgal.ac.uk

Booking Terms & Conditions | Dumfries & Galloway College (dumgal.ac.uk)

Other Courses at DGC

Introduction To Power BI Desktop

INTRODUCTION TO POWER BI DESKTOP - Computing & IT

PowerBi - a business analytical service provided by Microsoft is a great tool that lets you visualise data and share insights. It is a collection of software services, apps and connectors that work together to turn data from different sources into interactive dashboards and reports.This 3 hour online course covers the essential skills in ...

Introduction to E-Sports NPA @ SCQF Level 5

Computing and IT esports

Esports is one of the fastest growing professional sports in the world, with forecasts of a global worth of more than £1billion by 2023. This course will give you an introduction into E-sports and advise you how you can progress within the computing industry which extends far beyond games development and Esports, with a variety of comput...

AN INTRODUCTION TO CYBER SECURITY

Computing and IT - cyber security

This course provides learners with a baseline understanding of common cyber security threats, vulnerabilities, and risks. It’s an overview of the main information security risks and how to mitigate them. The course is focused on the needs of small organisations.Aimed at anyone who is interested in security, decuring data or information....