Automating Data Entry using Data Validation in Excel
Profits is backed by revenue and revenue is backed by products entity is selling. Accountants often on daily basis have to prepare sales report. Two of the important ingredients of every sales report is the product name itself and price per unit. For such reports accountants often have to type products’ names and per unit […]
Payroll calculator with Piece Work wage payments in Excel - How to Series
In every organization small or big we have to process salaries and wages also known as payroll. And this process is carried out sometimes on monthly basis or weekly and sometimes on daily basis as well. This is a repetitive process that accountants cannot escape and if wage calculation basis are little complex then one […]
What is Accounting Worksheet?
In accounting a worksheet or also known as extended trial balance is a business form containing multiple columns that is sometimes prepared in the concluding stages of accounting cycle. It is prepared after unadjusted trial balance is extracted from the ledgers’ balances. Major purpose of the worksheet is to incorporate adjustments to the closed accounts in […]
Calculating Depreciation of assets in Excel - How to
In accounting world depreciation is one key calculation to be done for every period to make the reports and is also an important part of financial management decision making process in some cases. However, depreciation calculations can sometimes be tedious and long if we have to do it for multiple classes of assets for multiple […]
Running totals and Running balance in Excel - How to
On daily basis accountants prepare day books and ledgers as regular part of accounting cycle. Usually students in the beginning learn to prepare accounts in T format. However, professional accountants maintain accounting books in dedicated accounting software in which bookkeeping is a little different. If accounts are maintained using T format then user can know […]
How to sort Rows horizontally left to right instead of Columns vertically top to bottom in Excel
Sorting is one of the many good things excel offers. And it does make our job a lot easier once the data is arranged in particular order. However there is one limitation to the usual use of sorting i.e. it sorts in vertical fashion that is columns are sorted top to bottom in the order […]
How to make a basic Tax calculator in Excel
Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small change you might have to punch millions of calculator keys again to get the tax liability calculated. But we have a rescue pack for you in the name of Excel! Many […]
Preparing ACCA Exams - Quick Guide and FAQs
A lot of students are asking me loads of different questions of different nature while preparing for ACCA exams including what subject to take what to leave, how to plan study and exam attempt, which questions to do first in the exam, what topics are important, what to read and what to leave etc. Following […]
Excel Most Wanted - Selection shortcut keys Mega collection
While working in Excel or any data related job selection is one job in itself. And even in Excel it is not easy when you making your way through thousands of cells. However, life is much easier if you know selection tricks Excel has to offer and even better is they come in shape of shortcut keys […]
Excel for Accountants - Introduction to Excel Interface
To understand anything we must first understand what each of the visible components can do and only then we can understand what it really holds for us including what is not visible for the time being. When we double click excel icon and application runs. Our eyeballs witness many things inside that application window. Before […]
