Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can we manage business transaction or records in Ms Excel?

user-image
Question added by Deleted user
Date Posted: 2016/05/17
Ghada Eweda
by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.

Microsoft excel is most popularly used in business especially in accounting is used to know, understand, and analyze the numbers, it helps to handle financial transactions . Accounting can be resumed as the system used to identify, record, and document the monetary transactions of any kind. Microsoft Excel is a spreadsheet application used to create and manage business transactions that deal with accounting. To make this possible, it can assist you with creating lists of transactions, then using those list to create charts and other analysis tools. As a regular Microsoft Windows application, to use Microsoft Excel, you can click Start ->(All) Programs -> Microsoft office> Microsoft Office Excel.

Finding and Using Special Symbols in excel

If you want to hide the Quick Access toolbar, you can right-click it and click Remove Quick Access Toolbar. To know what a button is used for, you can position the mouse on. A tool tip would appear. Once you identify the button you want, you can click it.

You can show a variety of special characters in Excel by choosing a particular font. These characters can represent the entire cell entry or only a portion of the entry. For example, to show the check marks  the cells were formatted using the Wingdings font. When a cell is formatted with this font, entering the formula =CHAR() causes Excel to display a check mark.

To find a particular symbol, you can enter a numeric series from0 to in, say, cells A1:A of a worksheet. To do so, click the Home tab, select Fill from the Editing group, and click Series. In versions prior to Excel, use Edit, Fill, Series.

With the numbers0 through in column A, enter this formula in cell B1:

=CHAR(A1)

Then copy and paste from B1 into the range B2:B. Select B1:B, click the Home tab, and select Symbol from the Font drop-down box in the Font group. In versions prior to Excel, choose Format, Cells.

Then, using the Font tab, assign the range a font such as Symbol. Look through the B1:B range to see whether it contains the symbol you want. When you find it, use the combination of the value, the CHAR function, and the font to display the symbol. You can assign different fonts to different characters in a text entry by highlighting the character in the formula box and continuing exactly as you would to format a full cell.

Another approach is to click the Ribbon's Insert tab and select Symbol from the Text menu. Select a font, such as Wingdings, and scroll down until you find the symbol you're looking for. Click it and then click Insert. If you're using Excel or, start by choosing Symbol from the Insert menu.

However, your choice of method is just a matter of personal preference. Therefore, choose the one that makes it easier for you to find a given symbol.

Kripesh Krishnan Kutty Nair
by Kripesh Krishnan Kutty Nair , Merchandiser , Al Seer Group

you can create accounting formats, create documents and to save these in folders where you needed

Deleted user
by Deleted user

Very Easily you can record your business transaction in MS Excel. it depends on your business products but the procedure are same for all the business accounts. 

Wasim khan wazir
by Wasim khan wazir , Finance Specialist , Mott Macdonald

I am agree with above answers...... 

ghazi Almahadeen
by ghazi Almahadeen , Project Facilitator , Jordan River Foundation

Thanks for the invite ............................ agreed with the answers Mr. Sultan Nasser

Sultan Nazer
by Sultan Nazer , Sr. Manager Riyadh Offices Operation , Economic Cities and Special Zone Authority

There are many ways for Excel to do that , if you put all case in the excel you can mointer the customer in all ways . you tell if this customer is frequant or once in a life time . you can also track your customer in all transaction is making mak it easyer for you provide hime of what he need with out even asking .

 

i hope i give you some light onyour quastion .

Vaqar Ali Sayyed
by Vaqar Ali Sayyed , AutoCad Opertator , Carlo Gavaazzi Arabia Co. Ltd.

Thanks for the invite .....agreed with the experts answers.

I apologize for the answer I leave the answer to the specialists the  experts in this the field that's not my area.

mohammed negm
by mohammed negm , مدير مبيعات , مؤسسة أطياف لتجارة المواد الغذائية

I agree with  Ghada Eweda  answers, thanks for the invitation

More Questions Like This