Bagi Anda yang pekerjaan sehari-harinya menggunakan Excel pasti paham betul bahwa dengan menggunakan rumus pekerjaan akan selesai jauh lebih cepat daripada menggunakan metode manual. Apalagi bagi Anda yang sudah mengerti (paling tidak sedikit) mengenai Macro Excel pastinya tau bahwa pekerjaan dengan macro akan membuat pekerjaan Anda selesai jauh lebih cepat daripada menggunakan rumus biasa.
For those of you who is using Microsoft Excel for daily work must understand very well that using the formula, your work could be completed much faster than using manual methods. Especially for you who already know about Excel Macros must know that working with macros will make your work much faster than using the usual formula.
Namun jika Anda mengira bahwa macro Excel hanya mengerjakan pekerjaan berulang yang itu-itu saja dan tidak dinamis, maka saat ini saya perkenalkan Anda kepada JMT Excel Utilities yang diciptakan oleh JMT Excel Consulting (http://jmt.puremis.net). Saya yakin setelah Anda menggunakan Add-Ins dari JMT ini maka pemahaman Anda mengenai Excel akan berubah. Anda akan merasa bahwa kemampuan Excel bisa tergali lebih dalam lagi jika Anda mengerti apalagi membuat rumus macro untuk membantu pekerjaan Anda sehari-hari.
But if you think that Excel macros work only for repeating work done and not dynamic, therefore now I’m introducing you to the JMT Excel Utilities created by JMT Excel Consulting (http://jmt.puremis.net). I'm sure after you use this Add-Ins from this JMT Consulting then your understanding about Excel will surely change. You will feel that the ability of Excel can be dug deeper if you understand how to make a macro formula to help you daily work much easier.
JMT Excel Utilities bisa Anda download di sini.
Untuk cara instalasi download di sini.
Click here to download JMT Excel Utilities.
Click here to download the installation guide.
File zip tersebut terdiri dari 6 file yaitu:
The Zip file contains 6 files:
JMT_Excel_Utilities.xla : File Add-Ins untuk Excel 2003 ke bawah
Add-Ins file for Excel 2003 to below
JMT Excel Utilities Help Files.xls : File Help untuk Excel 2003 ke bawah
Help file for Excel 2003 to below
JMT Excel Utilities 2007.xlam : File Add-Ins untuk Excel 2007 Add-Ins file for Excel 2007
JMT Excel Utilities 2007 Help Files.xls : File Help untuk Excel 2007 Help file for Excel 2007
JMT Excel Utilities Addin Read Me File.doc : File Readme Readme File
Ribbon Images.xlsm : File untuk Toolbar di Excel 2007 File for Toolbar in Excel 2007
Secara rinci menu JMT Excel Utilities adalah sbb:
In detail, JMT Excel Utilities menu is as follows:
Sheets Utilities
- Show Worksheet Tools
- Save Sheet As Workbook
- Show Selection Tools
- Highlight Blank Cells Conditionally
- Highlight Range Without Formatting
- Deselect Cells Within Range
- Show Selection Dimensions
- Show Row And Column Tools
- Insert Rows And Columns
- Show Quick Filter
- Show Fill and Unfill Tools
- Show Select Range Tools
- Show Comment Tools
- Copy and Paste Exact Formulas
- Copy Merged Area Top Left Cell
- Hide Error Messages In Formulas
- Calculation Tools
- Show Dynamic Range Tools
- Cond. Formatting Find And Replace
- Show Deletion Tools
- Clear The Active Sheet
- Delete External Links
- Show Drawing Objects Tools
- Copy Selection As HTML Table
- Export Picture Of Selection
- Copy Picture Of Selection
- Export Range As Text File
- Show Checkbox Tools
- Compare Cells
Chart Utilities
- (Visible when chart is selected) Add Data Labels From Range
- Change Series Colors From Range
- Move Data Labels To Left
- Maxe X Axis Cross At Minimum Value
- Show JMT Help Files
Data Utilities
- Show Text And Format Tools
- Show Replace Text Tools
- Insert Sequential List In Selection
- Find Maximum And Minimum Values
- Insert Bar Graph In Selection
- Convert Numbers To Text (Add ' Mark)
- Revert Text Numbers To Real Numbers
- Move Minus Sign To Front
- Positive And Negative Numbers
- Perform Quick Math On Selection
- Round Numbers In Selection
- Copy Sum Of Selection To Clipboard
- Delete Duplicates In Selection
- Show Conversion Tools
- Show Excel Calculator
- Show Special Characters
- Join Cell Text
- Insert Multi Line Cell Text
- Show Quick Write
- Show Excel Timer
- Show Time Picker
- Insert Calendar Sheet
- Select Days And Months
- Show Calendar Date Picker
Other Utilities
- Change Excel Application Settings
- Show Full Path And Book Name in Titlebar
- Copy Pathname To Clipboard
- Open Dialog Box With Current File's Folder
- Open Explorer With Current File's Folder
- Show Folder Details in Worksheet
- Add Workbook to Recent Files
- Clear Recent Files List
- Rename Active Workbook While Open
- Delete Active Workbook While Open
- Save Workbook With Backup File
- Reopen Workbook Without Saving
- Close Saved Workbooks
- Insert Headers And Footers
- Show Active Workbook Details
- Delete Active Workbook Macros
- Show Excel Menu Details
- Show Face IDs Toolbar
- Delete Custom Toolbars
- Delete Custom Controls
- Reset Tools
- Show Excel Color Details
- Show Color Picker
- Web Search From Excel
- Play Mastermind
- Play Simon Says
- Generate Password
- Add JMT Functions To Workbook
- JMT Excel Utilities Settings
- Show JMT Help Files
Custom Functions
- Custom Functions, How to use them
- Custom Function Details
Other
- JMT Excel Utilities
Pada blog saya ini satu per satu saya akan coba untuk menjelaskan cara penggunaannya langkah demi langkah berikut dengan gambarnya.
In this blog I will try to explain how to use the following step by step with pictures.
IJIN DONLOD YA PAKK..
hrs byk belajar nihh...hehehe..
Salam sukses,
Okta
@ Anonymous 1/1: Silahkan, semoga bisa membantu...
Mas DodDy, mohon bantuan nih. saya punya file "A" yang berisi rumus yang akan disalin ke file "A1", "A2", "A3", dst. Mohon bantuan code VBA nya dong. Terima kasih atas semuanya yang sudah dibagi di blog ini.