Kursus Microsoft Excel

Pada pelaksanaan bisnis perkantoran, berbagai macam dokumen perlu dibuat. Contoh dokumen yang dibuat adalah rancangan anggaran, invoice, project timeline, laporan penjualan, laporan keuangan dan lain sebagainya. Dokumen-dokumen ini dapat dibuat dengan aplikasi spreadsheet (Walkenbach, 2015). Microsoft Excel merupakan aplikasi spreadsheet yang banyak digunakan pada berbagai industri (Gartner, 2017).

Microsoft Excel dapat digunakan mengolah berbagai data dengan mudah, cepat, dan akurat. Contoh pengolahan data yang dapat dilakukan adalah penghitungan data angka, pembuatan chart, penyortiran data, perbaikan data teks secara massal, hingga pembuatan dashboard (Walkenbach, 2015). Data dan grafik dapat diedit dan ditampilan hasilnya secara realtime (Slager, 2016).

Training Microsoft Excel membahas dasar-dasar penggunaan aplikasi. Selain itu juga akan dibahas metode pengolahan, penyortiran, agregasi, dan analisis data. Training dilengkapi dengan berbagai studi kasus sesuai konsep dan teori yang dipaparkan. Dalam proses pelaksanaannya, bagi seluruh peserta yang mendaftarkan tidak diberlakukan pre-test.

Objek Pembelajaran

  1. Mampu mengoperasikan Excel 2016
  2. Mampu membuat formula dan macro
  3. Mampu menampilkan data secara visual
  4. Mampu melakukan konsolidasi data ke dalam workbook tunggal
  5. Mampu menggunakan fitur kolaborasi

Peserta

  1. Data Processor
  2. Data Analyst
  3. Data Scientist
  4. Profesional TI
  5. Profesional Keuangan

Konten Materi

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
4.6. .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

Curriculum is empty

There is no review for this course

Leave a Reply

Your email address will not be published. Required fields are marked *