Some Microsoft Excel's short cut tips for Accountant

Microsoft Excel is very useful for all of us in our regular work at the office and business activities. Without Excel or Google Sheets, we cannot calculate our financial/mathematical operations. Today I'm going to talk about a little bit of tips and tricks for an accountant that he/she needs daily for performing tasks.



For an accountant, Excel is important. That's why here are some tips for them, and this trick is daily used by me for my work as an accountant.

1. How to input the current date on an Excel sheet in a shortcut way?

If you want to enter current date in excel then you need to press ctrl + ; this is one method; another is =Today()

2. How to remove grid lines from the background?

If you want to remove grid lines from the background, then use this shortcut key for performing the operations: Alt+W+VG.

3. If you want to make bold text, then use ctrl+B

4. If you want to make text italic, then use ctrl + I

6. Automatically adjust column width (Alt+H+O+I 

7.  To automatically adjust the row height, Alt+H+O+A

8. In a shortcut, if you want to format cell then you have to press ctrl+1

9. To create a list in one cell, you can go to Data-Data Validation, then Validation Criteria, select List, and provide a source. These are some of my regularly used shortcut options for working as a bookkeeper. Hope you find helpful from these. In-future I will discuss more deeply about other short-cut key. Thanks


Comments

Post a Comment

Popular posts from this blog

What is Auditing

Image
 What is auditing? A thorough review of a company's financial statements to ensure the financial records are fair and accurate. The main goal of auditing is to make sure that a company's financial statements are accurate and are following regulatory guidelines. There are three main types of audits. They are given blew: 1. Process Audit 2. Product Audit 3. System Audit Process Audit  This type of audit verifies that processes are working within established limits. It even evaluates an operation or method against predetermined instructions or standards to measure conformance to these standards and the effectiveness of the instructions. A process audit may  1. Check conformance to defined requirements such as time, accuracy, temperature, pressure, composition, responsiveness, amperage, and component mixture. 2. Examine the resources followed and the measures collected to determine process performance. 3. Check the adequacy and effectiveness of the process controls establishe...
Read more

Accounting ratios for analytical procedures

Image
Certain accounting ratioss may be used as analytical procedures . Here are the key ratios used. 1. Performance ratios Return on capital employed * Profit before interest and tax/equity + net debt 2. Return on shareholders' funds *Net profit for the period/Share capital +reserves 3. Gross profit margin * Grossoss profit * 100 /Revenue 4. Cost of sales percentage * Cost off sales * 100 /Revenue 5. Operating cost percentage *Operating costs*100/Revenue 6. Net margin = operating margin *Profit before interest and tax*100/Revenue 7. Short-term liquidity ratios Current ratios *Current assets : current liabilities 8. Quick ratios *Receivables + Current investments +Cash: current liabilities 9. Long term solvency ratios Gearing ratios * Net Net debt/equity * 100 10. Interest cover *Profit before interest payable / Interest payable 11. Efficiency ratios Net assets turnover *Revenue / Capital employed 12. Inventory turnover *Cost of sales/Inventories 13. Inventory days * Average inventory / ...
Read more

How to use free Quick Books

Image
QuickBooks is accounting software. It is cloud-based software; you can easily get access to your business's books from anywhere in the world. Every small or medium-sized business needs QuickBooks for their business's bookkeeping. For using QuickBooks, we need to subscribe to them. According to the policy of their business, they offer various types of prices for their QuickBooks application users. Previously they offered a one-month free trial, and still, they have this feature, but not for every continent of the world; this offer is for some parts of the world.  However, for practicing in QuickBooks, we also need to purchase their subscriptions. This is quite expensive for students or those who want to practice. Today I'm going to share with you a link. With the help of it, you can practice QuickBooks free for a lifetime. You can practice unlimited with their practice file and demo company.  After practicing, when you are confident enough to handle the books of a company, t...
Read more