Browsing Category »Office«

Command line spreadsheets merger – xlsx, xls, ods and csv

March 9, 2015
Command line spreadsheets merger – xlsx, xls, ods and csv

Hello everyone, this excel or spreadsheets merger are somehow become trending on my blog. Question keep coming event hough most of the questions are answered already on comments. I even wrote another post regarding the question about copying worksheets to worksheet(s) by customizing the vba macros scripts. Those comments, email or questions makes me think that vba […]

Customize excel merger macros script, copying worksheets

February 20, 2015
Customize excel merger macros script, copying worksheets

It’s been a while since my old post about merging multiple excel files, but still i received so many question regarding excel merger with MS Office 2007 vba macros for various conditions or situations. Therefore i beg your apologies for all un-replied emails, comments and messages that i received via Youtube, Gplus, Facebook and also twitter […]

Edit PDF for Free with LibreOffice

February 14, 2014
Edit PDF for Free with LibreOffice

Another question from a friend and today’s question is about software to edit PDF for free. Well, if you’re expecting a premium pdf editor for free, i guess you can’t find it anywhere. A great PDF editor usually a commercial one. But if you’re looking for a simple PDF editor which can do standard editing […]

Simple Excel merger (single worksheet and small files only)

November 5, 2013
Simple Excel merger (single worksheet and small files only)

I received so many unpublished question regarding merging multiple excel files with macros, some of them ask about things that i don’t understand. Please understand that I’m not an expert on this Excel Marcos stuff since i also got the trick from friend. But i’ll do my best to find the answer and reply to […]

Create pdf files from MS Word in 2 ways

June 1, 2013
Create pdf files from MS Word in 2 ways

Yesterday an office mate ask me how to create pdf files from word documents. It’s a bit surprising because i thought everyone know about this simple task. Especially when you’ve your own computer since several years ago and been playing with internet ever since. There is a lot of tools, a lot of freeware, you can […]

Free scan to PDF with LibreOffice

April 12, 2013
Free scan to PDF with LibreOffice

If you’re looking for a way to scan documents or pictures into pdf, you can use LibreOffice as a free scan to pdf tool. LibreOffice bundled with several office application such as Writer for Word processing, Calc for spreadsheet, Impress for presentation and and Draw for Diagramming and Charting Tool. Most of them has an ability to import […]

Merge multiple excel files into a single spreadsheet (MS Excel 2007)

March 18, 2013
Merge multiple excel files into a single spreadsheet (MS Excel 2007)

Recently I’ve got something to work on with several excel files. More than 150 excel files generated by a web based application have to be merged into one file and then create a summary from it. Usually i did this by doing copy paste all values one at a time into a new empty spreadsheet, or […]

Find duplicates in excel and LibreOffice Calc

February 20, 2013
Find duplicates in excel and LibreOffice Calc

When you move from MS Excel to LibreOffice Calc, you might find it harder in the beginning to work with the Excel way on LibreOffice (LO) Calc. For example menus and shortcuts. There was time when i keep working on both application at the same time in order to find duplicates in excel that i thought not available […]

Simple excel calculate date with excel form

December 29, 2012
Simple excel calculate date with excel form

Today I wanna share a simple work based on my daily jobs, an excel form to calculate years and months between two dates. Every years in the earlier of April, we work filtering incoming documents by validating many things including ages of every senders. There are no special application or program we had to help the job. […]

Several things about MS Excel 2007 you might want to know

December 19, 2012
Several things about MS Excel 2007 you might want to know

There are many features on MS Excel 2007 that I usually ignored or just don’t know. Not to mention the common functions, a simple shortcut or an easy mouse click. Even an AutoSum button turned me into a noob on friend eyes. Not because I don’t know the button function but because I did too much “Insert […]