Brainmatics

Data Visualization with Microsoft Excel

Microsoft Excel 2013 adalah aplikasi spreadsheet untuk mengatur, mengurutkan, menghitung, dan memanipulasi data dengan menggunakan formula. Spreadsheet Excel terdiri atas kolom dan baris, tetapi juga mencakup fitur yang lain, seperti grafik dan diagram.

Training ini mempelajari tenang dasar-dasar visualisasi data menggunakan Microsoft Excel. Anda akan menjadi terbiasa dengan user interface Excel 2013, Anda juga akan mempelajari fitur-fitur terbaru dari Microsoft Excel 2013 ini.

CONTENT

1. Using Formulas with Conditional Formatting

2. Important Database Concepts

    2.1. Traditional Limits of Excel and How Databases Help
    2.2. Database Terminology
    2.3. How Databases are Designed

3. PivotTable Fundamentals

    3.1. Introducing the PivotTable
    3.2. Customizing PivotTable
    3.3. Understanding Slicers
    3.4. Creating a Timeline Slicer
    3.5. Understanding the Internal Data Model

4. Using PivotTables and PivotCharts

    4.1. Analyzing data dynamically by using PivotTables
    4.2. Filtering, showing, and hiding PivotTable data
    4.3. Editing PivotTables
    4.4. Formatting PivotTables
    4.5. Creating PivotTables from external data
    4.6. Creating dynamic charts by using PivotCharts
    4.7. Insert a Linked Excel Table and Chart in PowerPoint

5. Introduction to Power Pivot

    5.1. Understanding the Power Pivot Internal Data Model
    5.2. Linking Excel Tables to Power Pivot
    5.3. Creating Relationships Among Your Power Pivot Tables
    5.4. Creating a PivotTable from Power Pivot Data
    5.5. Enhancing Power Pivot Data with Calculated Columns
    5.6. Utilizing DAX to Create Calculated Columns
    5.7. Understanding Calculated Fields

6. Creating Dashboards with Power View

    6.1. Activating the Power View Add-In
    6.2. Creating a Power View Dashboard

7. Adding Location Intelligence with Power Map

    7.1. Installing and Activating the Power Map Add-In
    7.2. Loading Data into Power Map
    7.3. Managing and Modifying Map Visualizations
    7.4. Adding Custom Components
    7.5. Customizing and Managing Power Map Tours

8. Using the Power Query Add-In

    8.1. Installing and Activating the Power Query Add-In
    8.2. Power Query Basics
    8.3. Understanding Column and Table Actions
    8.4. Power Query Connection Types
    8.5. Creating and Using Power Query Functions

INSTRUCTOR

Image

Satya Sanjaya Menamatkan pendidikan tinggi jurusan teknik mesin di Universitas Indonesia Jakarta. Aktif sebagai konsultan dan telah menyelesaikan banyak project dibidang System Programmer Administrator dan Database Administrator, seperti dalam penerapan Microsoft Windows NT Server, Microsoft SQL Server, Microsoft Sharepoint, dan ASP.Net MVC. Sekarang aktif sebagai pengajar / trainer diberbagai training center di Jakarta, untuk materi training berbasis Microsoft seperti Visual Basic, Visual Interdev , SQL Server, Visual Studio.Net, Microsoft Windows Server, Microsoft SharePoint, Microsoft Project, Crystal Report.