Workshop ini dirancang khusus untuk para profesional yang ingin menguasai Excel sebagai alat analisis yang tidak hanya tangguh tetapi juga fleksibel. Melalui pendekatan hands-on, Anda akan mempelajari cara membuat formula yang lebih efisien, mengoptimalkan penggunaan fungsi statistik dan lookup, serta mengaplikasikan dynamic arrays untuk meningkatkan produktivitas kerja. Workshop ini juga memberikan solusi nyata melalui contoh-contoh praktis yang langsung dapat diterapkan pada pekerjaan sehari-hari Anda, membantu menyederhanakan proses dan menyelesaikan berbagai tantangan data yang kompleks.

Materi: 
• Excel Formulas 101
Excel Formula Syntax, Writing Efficient Formulas with Fixed and Relative References, Common Error Types, Formula Auditing with Trace Precedents & Dependents, Evaluate Formula & Error Checking, Navigating Excel Worksheets with Ctrl Shortcuts, Saving Time with Function Shortcuts, Accessing Tools with Alt Keys, Data Validation

• Conditional Statements & Logical Operators
Anatomy of IF statements, Nesting Multiple IF Statements, Adding Conditional AND/OR Operators, , Using NOT & “<>” Conditionals, Fixing Errors with IFERROR, Common IS Statements

• Common Excel Statistical Functions
Basic Excel Statistical Functions, Extracting Values with SMALL/LARGE, RANK/PERCENTRANK, Randomization with RAND() & RANDBETWEEN, Row-Level Calculation with SUMPRODUCT, Conditional Aggregation with COUNTIFS, SUMIFS, AVERAGEIFS

• Lookup & Reference Functions
Working with Named Ranges, Counting Rows  & Columns with ROW/ROWS, &  COLUMN/COLUMNS, VLOOKUP/HLOOKUP, IFFRROR, INDEX, MATCH, XLOOKUP, CHOOSE, OFFSET, COUNTA

• Text Functions
Capitalization with UPPER, LOWER, PROPER, TRIM, Combining Text with CONCATENATE, Extracting Strings with LEFT, MID, RIGHT & LEN, Converting Text to Values with TEXT & VALUE, Searching Text String with SEARCH & FIND, Categorizing Data with IF(ISNUMBER(SEARCH)), Combining RIGHT, LEN, and SEARCH, Replacing Text with SUBSTITUTE

• Date & Time Functions
Understanding Excel Date Syntax with DATEVALUE, Formatting Dates & Filling Date Series, Creating Real time Functions with TODAY & NOW, Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND, Calculating the Month Start or End with EOMONTH, Calculating % of Year with YEARFRAC, Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS, Calculating Differences Between Dates with DATEIF

• Formula-Based Formatting
Creating, Editing & Managing Formula Based Rules, Highlighting Rows Using The MOD Function, Formatting Based on the Value of Another Cell, Formatting Cells Using Stats Functions, Formatting Cells Using Text Functions & Logical Operators

• Dynamic Array Formulas untuk Excel 2019 / Excel 365
Legacy vs “Dynamic” Excel, Spill Range Properties, Dynamic Array Functions, The SQRT Function, The SQRTBY Function, The FILTER Function, The UNIQUE Function, Combining SORT, FILTER & UNIQUE, Referencing Spill Ranges in Calculations, Conditional Formatting with Dynamic Arrays, The SEQUENCE Function, The RANDARRAY Function, The FREQUENCY Function, The TRANSPOSE Function

Persyaratan: 
Window dengan Microsoft Office 365 atau versi Excel 2019 keatas.

Cocok diikuti oleh:

• Pengguna Excel yang ingin menggunakan formula dan fungsi tingkat lanjut
• Setiap orang yang ingin meningkatkan skill Data Analytics dan bekerja dengan lebih effisien dengan data
• Pelajar / mahasiswa yang mencari pendekatan yang praktis dalam mempelajari Data Analytics
• Setiap orang yang mengejar karir di bidang analytics, data science atau business intelijen.

Pembicara : Dr. Ikin Solihin, MBA, AFM, CTP, FPAC, CMA, FRM, FMVA, CSCP
Jabatan : Praktisi Keuangan dan Data

Tanggal : 17 September 2024

Waktu : 09.00-16.30 WIB

Venue : Hotel Santika Premiere Slipi

contact : 0813 1111 6063