People Innovation Excellence

Short Course: Microsoft Office Excel & VBA Macro Programming

To enhance today productivity in daily office task, it is mandatory for employee especialy who manage and play with enormous data to be able to master spreadsheet application such as Microsoft Office Excel. As the most used spreadsheet apps in the world, there are tons of functionality and feature in Excel that are more than capable to help you in managing data such as creating tables of data, basic calculation, charting, pivoting table, up to advance function such as macro programming.

BINUS Creates who pursuit for the development in enterprise capability building, offer this courses in total of 4 levels that can be delivered in up to 6 days of training. These 4 levels are:

  1. Ms Excel Basic – 1 day. Include: Basic interface of Ms Excel, worksheet, using help, entering and editing data (with formula, pictures, etc.), modifying worksheet with references, using function, worksheet formatting, and charting.
  2. Ms Excel Intermediate – 1 day. Include: Using multiple worksheet & workbooks (linking and managing), advanced formatting, cell and range names, table modification, template and setting, web and sharing features, advanced charting, and documenting feature (auditing, comments, protection, workgroup collaboration).
  3. Ms Excel Advance – 1 day. Include: Advanced function, lookup and data table, pivot table and pivot chart, conditional formatting and SmartArt, advanced data management (validating data entries, exploring database functions), export and import, analytical option, and macro & custom function.
  4. Ms Excel VBA Macro – 3 days. Include:  Making Excel Macro, Macro recorder, security, visual basic editor, Macro errors, debugging, object, properties, method, macro programming, and form.

 

This course has been implemented in numerous enterprise in various industries such as banking, automotive, FMGC, insurance, and so on. The latest in the 1st semester of 2017 are held in Astra International Tbk, Bank Tabungan Negara Tbk, and DBS Bank Indonesia, Tbk.


Published at :
Leave Your Footprint

    Periksa Browser Anda

    Check Your Browser

    Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

    Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

    Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

    Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

    We're Moving Forward.

    This Site Is No Longer Supporting Out-of Date Browser.

    If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

    Best viewed with one of these browser instead. It is totally free.

    1. Google Chrome
    2. Mozilla Firefox
    3. Opera
    4. Internet Explorer 9
    Close