Terima kasih telah mengirimkan pertanyaan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Terima kasih telah mengirimkan pemesanan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Kerangka Materi
Bagian I. Squeeze more from Excel
Overview of tools on the Data tab
- Access to external data - apakah benar-benar perlu mengunjungi situs web bank setiap hari untuk mengetahui kurs euro hari ini?
- Defining connections to external data (Access, Web, Text, XML, ...)
- Sorting multi-level - aturan dan opsi pengurutan yang tepat
- Efficient Advanced filtering - bagaimana cara membuat Strainers yang memiliki akses ke kriteria filter
- Fast text-to-column
- Delete duplicate data
- Forcing input the correct data - bagaimana memastikan data dalam format tertentu
- Simulation Analysis - bagaimana menyiapkan presentasi profesional dari skenario yang mungkin
- Simulation Analysis - bagaimana menaksir hasil dari rumus
- Grouping and autokonspekty - bagaimana mengelompokkan baris dan kolom serta menampilkan berbagai tingkat detail
PivotTable and PivotChart
- Calculated fields - bagaimana menambahkan bidang ke PivotTable yang tidak ada di lembar kerja
- Computational elements in the table
- Grouping data and create professional-looking statements
Bagian II. Automation ie VBA.
Macros
- Recording and editing macros: Silence on the set - is recording
- Where to store macros - dimana tempat terbaik untuk menulis makro
Introduction to procedural programming - the necessary basis
- Sub and Function - bagaimana memanggilnya dan apa yang mereka lakukan
- Data Types - apa yang diperlukan variabel dan apakah sebaiknya mendeklarasikan
- The conditional statement If ... Then .... ElseIf .... Else .... End If
- Case statement and the accompanying trap
- Loop for ... next, loop ... each
- Loops for ... loop while, until
- Instructions loop break (exit)
Visual Basic in action
- Download and upload data to a spreadsheet (Cells, Range)
- Download and upload data to the user (InputBox, MsgBox)
- The extent and lifetime of variables
- Operators and their priorities
- Useful module options
- Securing code - perlindungan kode dari peretasan dan pratinjau
- Key Excel objects: Application, Workbook, Workbooks, Worksheet, Worksheets,
- ThisWorkbook, ActiveWorkbook, ActiveCell, Selection, Range, Cells, ...
Debugging
- Immediate window
- Locals window
- The processing step - apa yang harus dilakukan ketika sesuatu berhenti bekerja
- Watches
- Call Stack
Error handling
- Types of errors and ways to avoid
- Capturing and handling run-time errors, which is why properly written code can sometimes not work
- Construction: On Error Resume Next, On Error GoTo label, On Error GoTo 0
Persyaratan
Setidaknya memiliki pengetahuan rata-rata tentang MS Excel.
28 Jam
Testimoni (5)
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Kursus - Visual Basic for Applications (VBA) in Excel (intermediate level)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Kursus - Excel VBA Introduction
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Kursus - Access VBA
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Kursus - Data and Analytics - from the ground up
I generally enjoyed the practical examples.
