Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    Introduction To Ms Excel v1.00

    Uploaded by

    Dewi Wulandari
    This document introduces Microsoft Excel for data analysis. It discusses the importance of data analysis, Excel's capabilities for data preparation, analysis, and visualization, and the types of industries and professionals that need Excel skills. The presenter then provides an overview of how to use Excel for data cleaning, combination, calculations, logical tests, pivot tables, and visualization.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Introduction To Ms Excel v1.00

    Uploaded by

    Dewi Wulandari
    11 views27 pages
    This document introduces Microsoft Excel for data analysis. It discusses the importance of data analysis, Excel's capabilities for data preparation, analysis, and visualization, and the types of industries and professionals that need Excel skills. The presenter then provides an overview of how to use Excel for data cleaning, combination, calculations, logical tests, pivot tables, and visualization.

    Original Title

    1. Introduction to Ms Excel v1.00

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document introduces Microsoft Excel for data analysis. It discusses the importance of data analysis, Excel's capabilities for data preparation, analysis, and visualization, and the types of industries and professionals that need Excel skills. The presenter then provides an overview of how to use Excel for data cleaning, combination, calculations, logical tests, pivot tables, and visualization.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    11 views27 pages

    Introduction To Ms Excel v1.00

    Uploaded by

    Dewi Wulandari
    This document introduces Microsoft Excel for data analysis. It discusses the importance of data analysis, Excel's capabilities for data preparation, analysis, and visualization, and the types of industries and professionals that need Excel skills. The presenter then provides an overview of how to use Excel for data cleaning, combination, calculations, logical tests, pivot tables, and visualization.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 27

    Introduction to Ms.

    Excel
    for Data Analysis
    Perdana Suteja Putra, S.T., M.T.
    Who am I!
    Perdana Suteja Putra, S.T., M.T.
    Lecturer and Expert ITTelkom Surabaya
    Experienced Consultant at Accenture Indonesia
    Expertise:
    Product design & development , Business Assesment &
    Management, Technology Transfirmation, Ergonomic & Safety

    Email: [email protected]
    LinkedIn: Perdana Suteja Putra
    Instagram: perdanasuteja
    Agenda

    The Importance Who need Ms.Excel


    01 Introduction to data analysis
    03 Do we really need it?

    Ms. Excel capability Ms. Excel Overview


    02 Introduction to Ms. Excel
    04 Let’s go!
    01
    Data Analysis
    Let’s do it!
    What’s Data Analysis

    Data Analysis
    Suatu proses pengumpulan, modelling, dan analisa atas
    suatu data untuk mendapatkan kesimpulan dan menjadi
    dasar dalam pengambilan keputusan.

    Identify Collect Clean

    Analyze Interpret
    Data Analyst vs. Data Scientist
    Data Analyst Salary
    02
    Ms. Excel
    Let’s do it!
    What’s Ms. Excel
    Ms. Excel
    Excel is a spreadsheet program from Microsoft and a
    component of its Office product group for business
    applications. Microsoft Excel enables users to format,
    organize and calculate data in a spreadsheet.
    What’s Ms. Excel
    Its Capability

    LISTING & PROJECT


    PRESENTING
    ORGANIZING PLANNING & DATA ANALYSIS
    DATA
    DATA INVOICING
    ▪ Marketing Data • Convert numbers • Timeline • Marketing
    ▪ Sales Data into tables, chart, • Process, etc. • Accounting
    ▪ HR Data and graphs. • Manufacturing, etc
    ▪ Customer Data, • Etc.
    etc.
    03
    Who need it?
    Let’s do it!
    Who need Ms. Excel?
    Who need Ms. Excel?
    TYPE OF INDUSTRIES USE MS EXCEL:
    ✓ Manufacturing
    ✓ Sales
    ✓ Construction
    ✓ Consulting
    ✓ Banking
    ✓ Software
    ✓ Stock Broking, etc

    WHO NEEDS TO MASTER THE SKILL:


    ✓ Admin
    ✓ Human Resources
    ✓ Marketing
    ✓ Finance
    ✓ Auditor
    ✓ Engineering
    ✓ Sales, etc
    03
    Ms. Excel Overview
    Let’s do it!
    Analysis using Ms. Excel?
    Data Preparation
    ✓ Data Cleaning.
    ✓ Data Combination.

    Data Analysis
    ✓ Data calculation using Math Formula.
    ✓ Logical analysis test.
    ✓ Summarization of data using Pivot Table.

    Data Visualization
    ✓ Visualization of data to identify trends, correlations, or relative
    significance among information.
    ✓ Create interactive dashboard.
    Ms. Excel: Data Preparation
    Ms. Excel: Data Preparation
    3. Data Combination
    ✓ Menggabungkan informasi kolom pada tabel berbeda menjadi satu data dengan formula
    Vlookup atau Hlookup.
    Kota Jumlah Kasus Level PPKM Pasien Sembuh Kota Jakarta Medan Surabaya Yogyakarta Semarang Bali Samarinda Bogor Bandung
    Bandung 5 Level 2 3 Pasien Sembuh 3 10 3 8 5 2 8 9 3
    Jakarta 20 Level 3 3
    Bogor 13 Level 2 9 Formula:
    Medan 9 Level 1 10 =HLOOKUP(
    Surabaya 5 Level 1 3 )

    Kota Level PPKM


    Jakarta Level 3 Formula:
    Medan Level 1 =VLOOKUP(
    Surabaya Level 1 )
    Yogyakarta Level 2
    Semarang Level 3
    Bali Level 3
    Samarinda Level 2
    Bogor Level 2
    Bandung Level 2
    Ms. Excel: Data Analysis
    Ms. Excel: Data Analysis
    Ms. Excel: Data Analysis
    Ms. Excel: Data Analysis
    3. Pivot Table
    Ms. Excel: Data Visualization
    Ms. Excel: Data Visualization
    Introduction to Ms. Excel
    for Data Analysis
    QnA
    Summary
    ● Analisa data merupakan skill yang sangat penting untuk dimiliki untuk dapat
    memahami suatu data dan mengestraksi informasi sebagai dasar
    pengambilan keputusan.

    ● Microsoft Excel merupakan software yang umum digunakan untuk


    melakukan analisa data.

    ● Profesi yang membutuhkan skill Microsoft Excel antara lain Admin, Human
    Resources, Marketing, Finance, Auditor, Engineering, Sales, dll.

    ● Tools pada Microsoft Excel perlu dikuasai untuk dapat digunakan dalam
    melakukan analisa data dari mulai proses Data Preparation, Data Analysis,
    dan Data Visualization.

    ● Skill tersebut akan dibahas secara detail pada Bootcamp Edspert.Id.


    Introduction to Ms. Excel
    for Data Analysis
    Thanks in Advance

    You might also like