Blogs about: Microsoft Excel

Featured Blog

Menghitung jumlah teks yang ditemukan

Tujuan: Menghitung jumlah dari suatu kriteria yang kita cari dalam suatu range cell (NB: tidak menghitung >1 suatu kriteria yang ditemukan dalam satu cell yang sama; bukan pencarian case sensitive)… more »

excel blogsheet

Menghitung jumlah teks yang ditemukan

excelans wrote 1 week ago: Tujuan: Menghitung jumlah dari suatu kriteria yang kita cari dalam suatu range cell (NB: tidak mengh … more »

Tags: Formula, Excel, excel formula

Menambahkan angka nol di depan angka dengan batasan jumlah digit tertentu

excelans wrote 1 week ago: Tujuan: Menambahkan angka nol secara dinamis dan otomatis di depan suatu angka dengan batasan digit … more »

Tags: Formula, belajar excel, Excel, Belajar Microsoft Excel, Excel Indonesia, excel formula

How do I split a name column in Excel into first name & second name?

catyoung wrote 1 week ago: How many hours have you spent retyping a column of names into ‘first name’ and ’se … more »

Tags: Microsoft Office, Data, split names, data to columns, data-cleansing, mail merging

2 kunci — 3 comments

excelans wrote 2 weeks ago: Yang ingin dicapai: unprotect sheet excel dengan 2 password yang berbeda dan berhasil >>>La … more »

Tags: Cobicoba, Excel, excel challenge

how to change the default file format in MS Excel2007

Admin wrote 2 weeks ago: Problem:I installed MS Office 2007 like two weeks ago and since then, I’ve been looking for ev … more »

Tags: Do It Yourself, HOW TO?, Microsoft Office, Tutorials

50 Jurus Rahasia Excel — 1 comment

excelans wrote 2 weeks ago: Akhirnya sempat juga ke Gramedia Matraman (uh sok sibuk ni yee..), setelah beberapa minggu baca info … more »

Tags: XLresources, belajar excel, Belajar Microsoft Excel, Buku, Excel

Multiple sheet input

excelans wrote 2 weeks ago: Langsung lihat gambar untuk lebih jelasnya. … more »

Tags: Lain-lain, belajar excel, Belajar Microsoft Excel, Excel

Belajar Excel Bersama Microsoft Office Help

excelans wrote 2 weeks ago: Apabila tidak ada buku tentang microsoft office,, kemana alternatif acuan kita untuk belajar microso … more »

Tags: XLresources, Lain-lain, belajar excel, Belajar excel indonesia, Excel, Belajar Microsoft Excel, Microsoft Excel help

Jaringan pengetahuan excel indonesia — 4 comments

excelans wrote 3 weeks ago: List berikut adalah berbagai alamat situs, forum maupun blog berkaitan dengan microsoft excel dengan … more »

Tags: XLresources, belajar excel, Belajar Microsoft Excel, Excel, Excel Indonesia

Search for a 'string' in Excel Workbook

selvavpasupathy wrote 1 month ago: The following code can be used to search a specific string in an Excel workbook within all the sheet … more »

Tags: VBA Examples, vba example, sample, Excel, Macro, Search, String, socko

Using Microsoft PowerPoint Advanced Techniques

Christopher wrote 1 month ago: Judging by most office PowerPoint presentations, most employees don't realize that there is … more »

Tags: Microsoft PowerPoint, General Discussion, Game mechanics, My Opinion, Free Downloads, Microsoft Office, Microsoft, Microsoft Word, Powerpoint

ASAP Utilities

maiideas wrote 1 month ago: I use the Microsoft Excel program almost daily.  I find the ASAP Utilities add-in an invaluable too … more »

Tags: Workplace, time, ASAP Utilities, Bastien Mensink, Add-in

Money Deposit Worksheet

dsmith77 wrote 1 month ago: This is a simple worksheet I made to organize the various bills and coins received from school fundr … more »

Tags: business personal, Education, Productivity, spreadsheet, Money, deposit, fundraiser, worksheet

Total Points to Percentages Lookup Sheet Generator — 1 comment

dsmith77 wrote 1 month ago: Ever used one of those old-fashioned slide rules to calculate a grade out of 100% when you had an od … more »

Tags: Education, Productivity, Excel, spreadsheet, slide-rule, Grade Calculation, Grade Calculator

Great Excel blog article — 1 comment

pregen wrote 1 month ago: Working with Excel is one of my favorite things to do.  It is fun to cruise the Net using Google t … more »

Tags: MS Office Stuff, data cleanup

Pump Up Employee Competence and Morale with MOS Certification

Christopher wrote 1 month ago: Looking for a way to give your business that extra edge companies? Want you could get more of its … more »

Tags: Microsoft PowerPoint, General Discussion, Game mechanics, My Opinion, Arcade Games, Microsoft Office, Microsoft, Microsoft Word, Powerpoint

MS Excel

dewalangit wrote 1 month ago: Jawaban tugas komputer per 26/5/2008 Jawaban untuk no 1 dan 2 Jawaban untuk no 3 Kalau misalnya badl … more »

Tags: tugas komputer, Excel, computer assignment, MS Excel, Tugas

DocSyncer for Google docs

dvanarsd wrote 1 month ago: Somebody had to come up with a way to synchronize the documents you edit in Microsoft Office so they … more »

Tags: Google, Microsoft Office Suite, Microsoft Office 2007, Microsoft PowerPoint, Microsoft Word, Online Software, file conversion, Microsoft, office

Excel 2007 shortcuts

dvanarsd wrote 1 month ago: PC Magazine (June 200 has a list of “11 Killer Excel 2007 Shortcuts”: Ctrl-Shift- … more »

Tags: Macros & Shortcuts, Microsoft Office 2007, macros, Shortcuts, Microsoft, 2007, Excel