Skip main navigation

Welcome to the Course

.

Welcome to the Data Analysis and Visualisation Using Excel course.

Every day millions of people use Excel for their daily tasks, whether it’s for number crunching, reporting, calculations – you name it. In this course, you’ll learn how to use Excel to perform data analysis and visualisations. You’ll learn how to bring data from other sources into Excel, perform data cleaning and pre-processing steps, create data mash-ups, build your business logic in the Excel data model, and present the data with interactive visualisations.

Whilst having an understanding of Excel analytic tools and experience working with data from databases will be helpful, we’re sure that everyone can follow this course. If you’re a novice user, ask questions in the discussions throughout the course. If you’re a more advanced learner or a seasoned Excel user, why not help your fellow learners?

Course Content

In this course, we’ll cover the following topics:

  • Data Analysis in Excel
  • Data Models and DAX in Excel
  • Importing Data into Excel
  • Visualising Data in Excel
  • Power BI

Who is the Course For?

We welcome all learners! While you may find the understanding of Excel analytics tools such as Excel tables, pivot tables and pivot charts, and working with data from databases challenging, we’re sure that everyone can follow this course. If you’re a novice user, visit the discussion forum. If you’re a more advanced learner or a seasoned Excel user, stick around the discussion forum and perhaps help your fellow learners!

Course Schedule

This course is in a self-paced format. You can listen to the lectures and attempt the labs at your pace. You should aim to complete this course in 15 hours or 5 hours a week for 3 weeks.

Course Subscription

Your CloudSwyft Online Hands-On Lab session for this FutureLearn ExpertTrack course is free to use for 2 hours for your first 7 days with us on this learning journey.

Subscribe now (if you haven’t already) for this ExpertTrack and you’ll get an additional 12 Lab hour credits for this course for 1 month, along with your certificate of completion. You will get 12 hours more for another month of subscription thereafter.

Next up, you’ll learn about the FutureLearn platform and how to navigate the course, and you’ll be able to introduce yourself to your fellow learners. We hope you’ll have an enriching and engaging learning experience!

This article is from the free online

Advanced Data Analysis and Visualization Using Microsoft Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education