![Otak Atik [dot] Com](http://www.otakatik.com/wp-content/themes/typebased/styles/default/logo.jpg){kind=logo}
As a powerful spreadsheet application, Microsoft Excel has many formulas to help us to create many report models. No doubt about it. Including formula which has function to calculate a range data with one or more criteria. Before Microsoft Excel 2007, the earlier version of Excel has SUMIF function to do that job.
Read more
When we’re demonstrating our report to our client or boss maybe sometime we need to focus on a cell in Microsoft Excel project. And as we know Microsoft Excel doesn’t give the builtin function to zoom only a cell.
Read more
Microsoft Office XP has including Speech Recognition in its installation package. With Speech Recognition you can dictate your document or give it some commands, so you have an alternative input method beside type them by keyboard. So I want share its commands list to make it easier and how to install it if you don’t have it yet.
Read more
I’m sure you already know about the benefits of AutoCorrect in Microsoft Word. Yes, with AutoCorrect you can reduce error in typing your document because if you make a mistake, AutoCorrect will then fix it to you. Beside it, AutoCorrect have other advantages that I want to show you.
Read more
Do you ever try to enter a mobile phone number on Excel? Usually, a mobile phone number is beginning with zero number such as 0255499512. When you enter it on Excel cell, Excel will consider it is a number entry and Excel will apply a number format automatically. Whereas, the number format isn’t allowing number that begin with zero number. Then, Excel will remove number: 0 so the entry becomes 255499512.
Read more
Since Windows XP brings long file name format, it has helped its users because folder/file name is clearer to read and represents its content. But one of its weaknesses is when we type its path manually. But I have a trick that can help you to type a document name within its path in Run dialog.
Read more
I often mad with my Microsoft Excel cells which contain formula has replaced or copied with office partner whereas I had make it for two days. And I found a way for overcame that problem accidentally. Just use the Hidden and Locked cell features on Excel.
Read more
My boss did ask me to made meeting invitations to all sales division employees yesterday. And I made it with Microsoft Word but I did not want to make it one by one manually because it will take times. So, I think I will make it with mail merge. Mail merge is one of Microsoft Word features that very help the users.
Read more
Adjust column width on Excel is our routine activity, if we’re creating Excel project. Usually, we set it to longest character number on our data in that column. Because if your data is longer than your column width, it appears be #### character. I have a trick to make it easier.
Read more
Every time you create a Microsoft Word document, it saves its properties too. By default, Microsoft Word will fill the properties with you registration name and company name. Unfortunately, you don’t always want it. Maybe you want set document properties with nothing or with yours. Whatever you choose, you must clean it first but if you must clean it every time you create a document, that’s not a good idea. You can make a macro to make it with a click.
Read more
If you enjoyed the post, make sure you subscribe to the RSS feed.
© ©2009 Otak Atik All Rights Reserved. | Privacy Policy
Powered by WordPress. Design by 
Recent Comments