Brainmatics

Microsoft Excel 2013

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 dasar-dasar semua kebutuhan Anda yang ada di Excel. Anda akan menjadi terbiasa dengan user interface Excel 2013, Anda juga akan mempelajari fitur-fitur terbaru dari Microsoft Excel 2013 ini.

OBJECTIVE

  1. Mengenal dan bekerja dengan Excel 2013.
  2. Menulis fungsi (formulas), membuat macro, dan mengelola data.
  3. Menampilkan data secara visual dan bagaimana menambahkan gambar ke dalam worksheets.
  4. Melakukan konsolidasi dari berbagai set data ke dalam workbook tunggal.
  5. Melakukan analisa data menggunakan tool Quick Analysis Lens.
  6. Mengkolaborasikan Excel 2013 dan menampilkan workbook secara online.

CONTENT

1. Understanding Excel 2013

    1.1. Identifying the different Excel 2013 programs
    1.2. Identifying new features of Excel 2013
    1.3. Customizing the Excel 2013 program window
    1.4. Creating workbooks
    1.5. Modifying workbooks
    1.6. Modifying worksheets
    1.7. Merging and unmerging cells

2. Working with data and Excel tables

    2.1.Entering and revising data
    2.2. Managing data by using Flash Fill
    2.3. Moving data within a workbook
    2.4. Finding and replacing data
    2.5. Correcting and expanding upon worksheet data
    2.6. Defining Excel tables

3. Performing calculations on data

    3.1. Naming groups of data
    3.2. Creating formulas to calculate values
    3.3. Summarizing data that meets specific conditions
    3.4. Working with iterative calculation options and automatic workbook calculation
    3.5. Using array formulas
    3.6. Finding and correcting errors in calculations

4. Changing workbook appearance

    4.1. Formatting cells
    4.2. Defining styles
    4.3. Applying workbook themes and Excel table styles
    4.4. Making numbers easier to read
    4.5. Changing the appearance of data based on its value
    46. .Adding images to worksheets

5. Focusing on specific data by using filters

    5.1. Limiting data that appears on your screen
    5.2. Filtering Excel table data by using slicers
    5.3. Manipulating worksheet data
    5.4. Defining valid sets of values for ranges of cells

6. Reordering and summarizing data

    6.1. Sorting worksheet data
    6.2. Sorting data by using custom lists
    6.3. Organizing data into levels
    6.4. Looking up information in a worksheet

7. Combining data from multiple sources

    7.1. Using workbooks as templates for other workbooks
    7.2. Linking to data in other worksheets and workbooks
    7.3. Consolidating multiple sets of data into a single workbook

8. Analyzing data and alternative data sets

    8.1. Examining data by using the Quick Analysis Lens
    8.2. Defining an alternative data set
    8.3. Defining multiple alternative data sets
    8.4. Analyzing data by using data tables
    8.5. Varying your data to get a specific result by using Goal Seek
    8.6. Finding optimal solutions by using Solver
    8.7. Analyzing data by using descriptive statistics

9. Creating charts and graphics

    9.1. Creating charts
    9.2. Customizing the appearance of charts
    9.3. Finding trends in your data
    9.4. Creating dual-axis charts
    9.5. Summarizing your data by using sparklines
    9.6. Creating diagrams by using SmartArt
    9.7. Creating shapes and mathematical equations

10. Using PivotTables and PivotCharts

    10.1. Analyzing data dynamically by using PivotTables
    10.2. Filtering, showing, and hiding PivotTable data
    10.3. Editing PivotTables
    10.4. Formatting PivotTables
    10.5. Creating PivotTables from external data
    10.6. Creating dynamic charts by using PivotCharts

11. Printing worksheets and charts

    11.1. Adding headers and footers to printed pages
    11.2. Preparing worksheets for printing
    11.3. Printing worksheets
    11.4. Printing parts of worksheets
    11.5. Printing charts

12. Working with macros and forms

    12.1. Enabling and examining macros
    12.2. Creating and modifying macros
    12.3. Running macros when a button is clicked
    12.4. Running macros when a workbook is opened
    12.5. Inserting form controls and setting form properties

13. Working with other Office programs

    13.1. Linking to Office documents from workbooks
    13.2. Embedding workbooks into other Office documents
    13.3. Creating hyperlinks
    13.4. Pasting charts into other Office documents

14. Collaborating with colleagues

    14.1. Sharing workbooks
    14.2. Saving workbooks for electronic distribution
    14.3. Managing comments
    14.4. Tracking and managing colleagues’ changes
    14.5. Protecting workbooks and worksheets
    14.6. Authenticating workbooks
    14.7. Saving workbooks as web content
    14.8. Importing and exporting XML data
    14.9 Working with SkyDrive and Excel Web App

INSTRUCTOR

mulyanaMulyana. Kelahiran Lebak – Banten, menyelesaikan D3 Teknik Komputer di Bina Sarana Informatika dan S1 Teknik Informatika di STMIK Eresha – Jakarta. Menguasai program Microsoft Office 2007, 2010 dan 2013 (Excel, Word, PowerPoint dan Access) dengan pengalaman implementasi di dunia industri. Selain itu, juga memiliki kemampuan teknis seperti melakukan desain, instalasi dan troubleshooting LAN dan CMS (Content Management System). Saat ini aktif sebagai trainer di Brainmatics dan pengurus IlmuKomputer.Com.