Data Analysis with Excel for Complete Beginners Course - CloudSwyft Global Systems, Inc.
FutureLearn
Key Information
Campus location
Online Philippines
Languages
English
Study format
Distance Learning
Duration
10 weeks
Pace
Part time
Tuition fees
USD 39 / per month *
Application deadline
Request info
Earliest start date
Request info
* after your 7-day free trial you can pay $39 per month to keep learning online
Scholarships
Explore scholarship opportunities to help fund your studies
Introduction
Learn data analysis from scratch, including an introduction to essential maths and Microsoft Excel.
An introduction to the fundamentals of data analysis using Excel
Data analysis skills are in increasing demand across a huge range of industries, but if maths is not your strong suit, it can be a daunting thing to learn. This ExpertTrack has been designed with exactly that in mind. It is a complete beginner’s guide to the subject, covering the basics of data analytics, maths, and Excel fundamentals to refresh your memory and build your confidence in these areas.
You’ll explore:
- Data in life and society
- Ways to build your data literacy
- Data analysis methods
- How to create tables and pivot tables in Excel
- How to create data visualisations in Excel
- The maths behind data analysis
- How to apply basic inferential maths to your data sets
Every course within this ExpertTrack is self-paced, allowing you to review the course content as quickly or as slowly as you’d like.
Brush up on your mathematics before delving into data analysis
Data analysis involves applying maths - whether it’s statistics or simple formula - to data sets. This ExpertTrack offers you the chance to refresh your maths knowledge before you get started so that you feel confident in mathematical notation, applying summary statistics, and calculating business metrics as you proceed through the courses.
Learn how to use Excel functions for data analysis
Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.
You will learn how to perform data analysis using Excel’s most popular features, including how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarise data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.
Grow your data analysis skills
Once you’ve covered the maths behind data analytics and the Excel functions to support it, you’ll be able to grow your analytics skills more directly. This involves creating flexible data aggregations and representing data visually. Before long, you’ll be able to calculate margins and other calculations, as well as filtering data and creating reports using simple Excel formulas.
Feel confident making data-driven decisions
All of this works towards offering you more control and confidence in your data. You’ll be able to apply your newfound skills in both decision making and problem-solving at work. You can even use this as a pathway into more specialised training in data analysis.
Key skills you will learn
- Microsoft Excel
- Decision Making
- Mathematics
- Data Analysis
Experience requiredIn order to benefit from this course, it would be helpful to have a basic understanding of how to create formulas and how cells are referenced by rows and columns within Excel. | Getting startedThis ExpertTrack has been designed for learners who are new to Excel and to data analysis, who want to improve their skills. You may want to advance your career, perform tasks more efficiently, or test out whether a career in data analysis is really for you. |
ExpertTrack course overview
- Introduction to Data Analysis using Excel for Absolute Beginners
Learning from scratch? This course provides an accessible entry point into the fascinating world of data analysis. - How to Use Microsoft Excel for Data Analysis
Improve your skills using Microsoft Excel and associated Excel features, to better report and analyse your data. - Data Visualisation Fundamentals for Absolute Beginners
Gain an introduction to data visualisations to communicate your data analytics to a diverse audience. - Essential Mathematics for Data Analysis in Microsoft Excel
Understand the basic maths that powers data analysis with this beginner’s course.
How ExpertTracks work
Join an ExpertTrack to master new skills in your chosen specialist area. Work through a series of topic-focused courses at your own pace, and pass the final assessment to earn a digital certificate award that proves your expertise.
Join a free 7-day trial Decide if the ExpertTrack is right for you with free access to the full suite of courses and assessments for a week. | Keep learning for $39/month Pay a monthly subscription fee of $39 for as long as it takes you to complete the ExpertTrack. You can learn at your own pace and cancel at any time. | Earn digital certificates Receive a certificate for every completed course and pass the final assessment to earn a digital certificate that you can share with your professional network. | Become an expert Use your specialist training to progress further in your career or build expertise in areas you’re passionate about. |
World-class learning with
CloudSwyft Global Systems, Inc.
CloudSwyft has partnered with the top global technology companies to deliver cutting edge digital skills learning across the modern workplace.
This ExpertTrack is accredited by Microsoft
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