Excel Basics Training Course
Peserta kursus akan dapat melakukan berbagai perhitungan secara efisien dengan cara yang transparan untuk mengatur dan menyajikan hasilnya, menggunakan berbagai mekanisme untuk memfasilitasi dan mempercepat pembuatan spreadsheet di Excel.
Pelatihan langsung yang dipimpin instruktur ini (online atau di lokasi) ditujukan untuk analis data yang ingin menggunakan Excel untuk analisis data.
Pada akhir pelatihan ini, peserta akan mampu:
- Buat spreadsheet di Excel.
- Visualisasikan data dengan bagan, grafik, dll.
- Hasilkan laporan untuk dibagikan di antara anggota tim.
Format Kursus
- Ceramah dan diskusi interaktif.
- Banyak latihan dan latihan.
- Implementasi langsung di lingkungan laboratorium langsung.
Opsi Kustomisasi Kursus
- Untuk meminta pelatihan khusus untuk kursus ini, silakan hubungi kami untuk mengaturnya.
Course Outline
Perkenalan
- Informasi dasar tentang program ini
- Konstruksi jendela utama
- Operasi pada buku kerja (notebook) dan lembar
Memasukkan dan mengubah data dalam sel spreadsheet
Memformat data
- Menentukan cara menampilkan berbagai jenis data dan hasil perhitungan (misalnya tanggal, jumlah, persentase atau pecahan)
- Menentukan tepi dan latar belakang sel
- Memformat judul baris dan kolom
- Menggunakan Gaya
Navigasi
- Bergerak ke atas dalam lembaran besar
- Pekerjaan paralel pada beberapa spreadsheet/buku kerja
Menyalin dan memindahkan data
- Pilih area (rentang sel)
- Memindahkan data
- Tempel Spesial
- Isi otomatis string sel (rangkaian) data (misalnya, nomor pesanan dan tanggal hari kerja berikutnya)
Rumus, alamat dan nama sel
- Membuat, memodifikasi, dan menyalin rumus
- Referensi melingkar
- Pemformatan bersyarat
- Jenis alamat dan penggunaannya
- Referensi ke lembar kerja dan buku kerja lain
- Menggunakan nama sel
Fungsi
- Aturan umum untuk menggunakan fungsi tersebut
- Fungsi yang sering digunakan
- Fungsi bersarang
- Menggunakan kondisional
- Penyihir Fungsi
Grafik
- Jenis bagan utama dan penggunaannya
- Prinsip umum untuk membuat grafik yang menarik
- Membuat Bagan.
- Komponen graf dan modifikasinya
- Buat jenis bagan Anda sendiri
Requirements
- Pemahaman dasar tentang komputer
Hadirin
- Analis Data
Open Training Courses require 5+ participants.
Excel Basics Training Course - Booking
Excel Basics Training Course - Enquiry
Testimonials (3)
The practice
Eliza - DEICHMANN SRL
Course - Excel Basics
some new functions i did knew before, such as power query; fomat cell -alignment-fill
Bella - fu ma si jing mi duan jian (da lian) you xian gong si
Course - Excel Basics
The guy was really helpful and knowledgeable and i really learned a lot in two days.
Francesca Maggiolo - Bettzeit GmbH
Course - Excel Basics
Upcoming Courses (Minimal 5 peserta)
Related Courses
Working with spreadsheet in Microsoft Excel
14 HoursThe course participants will be able to efficiently perform a variety of calculations in a transparent way to arrange and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets, as well as protect the calculations and their results against unauthorized persons
Excel Advanced with VBA
21 HoursParticipants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.
Visual Basic for Applications (VBA) in Excel (intermediate level)
14 HoursCourse is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.
Microsoft Office Excel - working effectively with the spreadsheet
14 HoursTraining for those working with a Microsoft Excel spreadsheet that would like to improve their work.
Visual Basic for Applications (VBA) for Analysts
21 HoursKursus ini dirancang untuk pengguna Excel untuk membuat analisis dan laporan.
Excel and VBA Programming for Audit and Finance Professionals
28 HoursPlease answer the following questions:
- Is your daily work in Excel is a never-ending string of commands copy-paste?
- Are you wasting time on repetition of similar operations to prepare the data for analysis?
- Do you know all the keyboard shortcuts in Excel, but you are not satisfied with the results?
- Rather than deal with data analysis and preparation of wasting time?
- Do you have to manually verify the correctness of such data obtained from different systems?
- Do you have to stay at work after hours or Excel to take books home because not doing during the day?
- Is Your job is to prepare reports based on a large data set?
- Do you feel that working in Excel, you come to a roundabout way of results?
If you can answer YES to one of the questions then it's time stop this nightmare. This training is for you.
Find out how you can speed up your daily operations and get most out of MS Excel.
WARNING
After the training, your life will change dramatically. Activities, which occupied the whole day will take just a few moments. Are you ready for this?
Microsoft Office Excel - intermediate level
14 HoursExcel adalah program spreadsheet populer yang dibuat oleh Microsoft. Jest digunakan untuk menyimpan, mengatur dan menganalisis data dalam bentuk tabel. Berikut beberapa fitur dan fungsi utama Excel: 1. Spreadsheet: Terdiri dari lembaran-lembaran, dimana setiap lembarnya merupakan suatu array yang terdiri dari sel-sel yang disusun menurut baris dan kolom. Ini memungkinkan Anda membuat beberapa lembar dalam satu file, yang memungkinkan Anda mengatur kumpulan data yang berbeda. 2. Perhitungan dan Rumus: Memungkinkan Anda melakukan berbagai perhitungan matematis, statistik, dan logika menggunakan rumus. Ini memiliki serangkaian fungsi bawaan seperti SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, dll. 3. Pemformatan dan Tampilan Data: Menyediakan alat untuk memformat data, termasuk mengubah font, warna, gaya, dan membuat grafik , tabel pivot dan diagram. 4. Penyortiran, Pemfilteran, dan Pengelompokan: Memungkinkan Anda mengurutkan data menurut kriteria tertentu. Memungkinkan Anda memfilter data untuk hanya menampilkan informasi yang dipilih. Kemungkinan untuk mengelompokkan data tergantung kebutuhan. 5. Analisis data: Alat untuk melakukan analisis tingkat lanjut seperti analisis skenario, tren, perkiraan, dan pembuatan makro. 6. Berbagi Data: Memungkinkan berbagi dan kolaborasi data secara real-time, memungkinkan banyak pengguna mengerjakan data yang sama secara bersamaan. 7. Otomatisasi tugas: Kemampuan untuk membuat makro dan mengotomatiskan tugas menggunakan bahasa pemrograman VBA (Visual Basic for Applications). Excel banyak digunakan di berbagai bidang, mulai dari bisnis hingga sains dan pendidikan. Fitur-fiturnya yang komprehensif memungkinkan analisis data, pembuatan laporan, anggaran, jadwal, pengelolaan data dan banyak aplikasi lainnya.
Excel Advanced
14 HoursPeserta kursus akan dapat secara efisien menggunakan alat analisis data seperti skenario dan tabel pivot, menggunakan fitur untuk melakukan penghitungan tanggal dan fungsi pemrosesan teks, serta membuat dan beradaptasi dengan kebutuhan makro untuk mengotomatisasi pekerjaan dengan spreadsheet.
Analysing Financial Data in Excel
14 HoursAudience
Financial or market analysts, managers, accountants
Course Objectives
Facilitate and automate all kinds of financial analysis with Microsoft Excel
Excel Data Analysis
14 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at beginner-level to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.
By the end of this training, participants will be able to:
- Use Excel formulas and functions to perform calculations and data manipulation.
- Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
- Use Excel charts and graphs to create and customize data visualizations.
- Use Excel data validation and conditional formatting to ensure data quality and highlight data insights.
- Use Excel data import and export features to connect to external data sources and share data with others.
Financial Analysis in Excel
14 HoursDuring the training, will present the issues of financial analysis using the advanced features of Excel.
This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.
Excel For Statistical Data Analysis
14 HoursAudience
Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.
Course Objectives
This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.
This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them.
Excel VBA Introduction
14 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.
By the end of this training, participants will be able to:
- Record and edit macros as required.
- Write procedures using data from the sheet.
- Create your own functions.
- Handle an event (opening worksheet cell update etc.) by means of the handler.
- Create a form.
Visual Basic for Applications (VBA) in Excel - Introduction to programming
21 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.
By the end of this training, participants will be able to:
- Record and edit macros as required.
- Write procedures using data from the sheet.
- Create your own functions.
- Handle an event (opening worksheet cell update etc.) by means of the handler.
- Create a form.
Visual Basic for Applications (VBA) in Excel - Advanced
14 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks.
By the end of this training, participants will be able to:
- Write an advanced object-oriented application
- Convert text files
- Use of external data sources
- Use external libraries