Data Analysis : Excel
Begineer• Technology
Overview
Evidence comes in the form of qualitative or quantitative data about the world around you. It is not always obvious, however, how to structure, aggregate, analyse or interpret the data to help you make decisions. In this free course, you will look at how to use data to make decisions in a systematic way using Microsoft Excel.
Microsoft Excel is a spreadsheet software that you will most likely encounter numerous times either in a professional context or outside the workplace. In this course you will explore its functions, which will enable you to analyse data and explore relationships between variables. You will learn to summarise, describe and visualise both univariate and bivariate data in tabular and graphical form.
What You’ll Learn
- * explore the functionalities of Excel that are used for problem solving in a business context
- * demonstrate the numeracy skills required for gathering and organising data for decision making related to a specific problem
- * use graphical techniques (histograms and scatter diagrams) to provide a visual summary of available data
- * recognise data presentation and communication techniques used in a range of traditional and electronic media
- * describe the relationship between two variables (independent and dependent variables).
What You’ll Get
Understanding of Data Visualization Concepts: Students gain a solid understanding of fundamental concepts related to data visualization, including types of charts, best practices for presenting data visually, and principles of effective data communication.
Proficiency in Excel’s Data Analysis Tools: Participants learn how to leverage Excel’s built-in data analysis tools and functions to manipulate and analyze data sets effectively. This includes techniques for cleaning and preparing data, as well as using functions like PivotTables, VLOOKUP, and IF statements.
Creation of Various Chart Types: Students become proficient in creating a variety of chart types in Excel, such as bar charts, line graphs, pie charts, scatter plots, histograms, and more. They learn when each chart type is most appropriate and how to customize them to effectively communicate insights.
Interpretation of Visualizations: Participants learn how to interpret visualizations and extract meaningful insights from them. This includes identifying trends, patterns, outliers, and correlations within the data, and making informed decisions based on the insights gained.
Data Storytelling: The course may cover techniques for effectively telling a story with data, including how to structure presentations, choose the most appropriate visualizations to support key points, and communicate findings clearly and persuasively to different audiences.
Hands-On Practice: Students engage in hands-on exercises and projects throughout the course to apply their knowledge and skills in real-world scenarios. This may involve working with sample data sets or bringing in their own data to analyze and visualize.
Critical Thinking and Problem-Solving Skills: By working through data analysis challenges and tasks, participants develop critical thinking and problem-solving skills, enabling them to tackle complex data analysis problems independently.
Certificate of Completion: Upon successfully completing the course, participants typically receive a certificate of completion, which can be used to demonstrate their proficiency in data analysis and visualization techniques using Excel.