This course is part of the Applied Data Analysis ExpertTrack
Advanced Data Analysis and Visualization Using Microsoft Excel
Learn how to import, manipulate, analyse and visualise data in Excel.

Duration
3 weeksWeekly study
5 hours100% online
How it worksIncluded in an ExpertTrack
Course 1 of 4
Advanced Data Analysis and Visualization Using Microsoft Excel
Other courses you might like
This course isn't running right now. We can email you when it starts again, or check out these other courses you might like.
Browse more in Business & Management and IT & Computer Science
Millions of people use Excel every day 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 will 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.
What topics will you cover?
- Data Analysis in Excel
- Data Models and DAX in Excel
- Importing Data into Excel
- Visualising Data in Excel
- Power BI
Prove you're job ready
Highlight the new, job-relevant skills you’ve gained and supplement existing qualifications with a hard-earned, industry-specific digital certificate – plus one for every course within your ExpertTrack.
- Learn the latest in your chosen industry or subject.
- Complete each course and pass assessments.
- Receive certificates validated by the educating organisation.
- Impress employers with learning outcomes you can add to your CV.
- Make your career dreams a reality.
Download a PDF
Learning on this course
On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.
What will you achieve?
By the end of the course, you‘ll be able to...
- Collected and transformed data from multiple sources
- Discussed and combined data in mashups
- Assessed about data model creation
- Described, analyzed, and visualized data
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!
Start learning today - free 7-day trial
After your free trial you can:
- Pay $39 per month to keep learning online
- Have complete control over your subscription; you can cancel any time
- Work at your own pace and set your own deadlines at every stage
- Only pay while you’re learning; the subscription will cancel automatically when you finish
- Complete online assessments to test your knowledge and prove your skills
- Earn digital course certificates and a final award that you can share online, with potential employers, and your professional network
- Keep access to the content of courses you complete even after your subscription ends
Learning on FutureLearn
Your learning, your rules
- Courses are split into weeks, activities, and steps to help you keep track of your learning
- Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
- Stay motivated by using the Progress page to keep track of your step completion and assessment scores
Join a global classroom
- Experience the power of social learning, and get inspired by an international network of learners
- Share ideas with your peers and course educators on every step of the course
- Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others
Map your progress
- As you work through the course, use notifications and the Progress page to guide your learning
- Whenever you’re ready, mark each step as complete, you’re in control
- Complete 90% of course steps and all of the assessments to earn your certificate
Want to know more about learning on FutureLearn? Using FutureLearn
Get a taste of this course
Find out what this course is like by previewing some of the course steps before you join: