Now we have the Purchase Transaction in my previous postLet's move on to other transaction, Sales TransactionWe buy, We sell our products for certain markupExample: For 1 kilo of Orange, 90 pesos is the cost per kilo, we have to gain about 20% of its cost. That is, 90 x .20 = 18 pesos is … Continue reading Handling Large Accounting Data Records in Microsoft Excel pt2
"If you're looking for a storage for your data, you can use Microsoft Access instead, but its seems to be more difficult to deal with compare to Microsoft Excel. (Small businesses). If you don't want to use Microsoft Access, here deal with user-friendly Microsoft Excel. "Accounting is part of our daily lives, even in your … Continue reading Handling Large Accounting Data Records in Microsoft Excel pt1
IconWhat is an Icon? Ask google :)Icon uses ".ico" file extension. See here for more infohttps://en.wikipedia.org/wiki/ICO_(file_format)If you want to create your icon, it's very easy. Firstly, Set your picture/s you want to create.Mine is the Tic Toe that i postedHereIf you don't have pictures, yet. You can use "screen shot" method using PrtSc (Print Screen) on … Continue reading How to Make your Own Icon Image in Microsoft Windows
Please Refer to this Post How to make TicTacToe Program Excel VBA Well, I may be honest with you, it's just actually a mimic but it's very useful to impress your friends or even your love ones.We'll just use trick here. So let's see here 1st Do we have a pre-build program? If you don't … Continue reading How to Build your own Executable Program using Microsoft Excel VBA (Tic-Tac-Toe) – Mimic
Simple TicTacToe Program If you don't have a Visual Basic Program (IDE) like VB6 or anything to build a program or software but you have only Microsoft Office (Excel) Application. Can we build such as this program the tic-tac-toe (as Bill Gates' TicTacToe First Program)? Well indeed, but here we have to learn coding of … Continue reading Tic-Tac-Toe in Microsoft Excel? Let’s do it!
Message BoxHello! Wanna see amazing trick to amaze your friends?Well you don't need to have a 3rd party software or other software just Notepad built in Windows. So let's get to it1. Create a text document, press Ctrl+R then type "notepad" or search with the Search Bar2. In the notepad type the following:MsgBox "Hello My … Continue reading Windows Start up: Pop up Message Box to Amaze your friends using only a Notepad
Message Box1. First open your microsoft excel program2. Make sure the developer option is enabled. Please see the linkhttps://msdn.microsoft.com/en-us/library/bb608625.aspx3. And of course you have to allow or enable the settings for macro to run the code(File --> Option --> Trust Center -->Trust Center Settings --> Macro Settings --> Check "Enable all macros")4. After that, navigate … Continue reading How to create a message box in excel using VBA and pop up whenever you open your workbook (excel file)