Data Analysis and Visualisation Training using Microsoft Excel
irna
Wed, 12/13/2023 - 07:19
Duration
3 Days
Price
--- Call Us ---
The ability to analyse and present data in a meaningful way is an essential skill for researchers and data analysts of all disciplines. Microsoft excel is one of the most popular analytical and visualization tools which is used in the day to day functioning of many organisations. Excel provides a platform to perform simple analysis by sorting, filtering, using formulas. It also has powerful tools such as pivot tables and data analysis toolpak for more complex analysis.
Key Outcomes:
- Achieve the understanding of descriptive statistics, stratified analysis and hypothesis testing. As a result, they will be able to take raw data and organize and analyse them efficiently.
- Be able to critically review research reports and papers.
- Be able to use excel optimally, making meaning of raw data and presenting them in a creative and easy to digest manner.
Objectives
- Learn to Use Excel
o Data collection methods
o Understanding variables to datasets
o Exploring the capabilities of Excel
o Learning to use Excel
o Organising data
o Variable formats: number, string, dates and others
o Ranges and tables
o Sorting and filtering
o Working with functions - Data Analysis: Descriptive statistics and Subgroup analysis
o Introduction to descriptive statistics
o Making sense of data using Excel
o Stratified analysis - Data visualisation
o Review of Excel graphs
o Pivot charts
o Building interactive dashboards
Contact
- Nurman (+62 857-2375-3840)
- Irna (+62 822-1664-7749)
- Puji (+62 813-2424-2115)
- Shafa (+62 813-9049-0664)