Brainmatics

Microsoft Excel 2016

Microsoft Excel 2016 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 2016, Anda juga akan mempelajari fitur-fitur terbaru dari Microsoft Excel 2016 ini.

 

OBJECTIVE

1. Mengenal dan bekerja dengan Excel 2016.
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 2016 dan menampilkan workbook secara online.

 

AUDIENCE

 

PREREQUISITES

 

CONTENT

1. Understanding Excel 2016

1.1. Identifying the different Excel 2016 programs
1.2. Identifying new features of Excel 2016
1.3. Customizing the Excel 2016 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 2016 (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.