Hasaan Fazal
One minute Excel Tutorial - Text to Coloumn
How to do it Well that is not the only thing it does. Its powers go beyond just splitting data in different coloumns. It can literally convert text to numbers in coloumn as well. But well that is left for future tutorial The application of this feature is however limited to delimiter or width etc. […]
One minute Excel Tutorial - Remove Duplicates
Data entry is a cumbersome job and often key punch operator ends up recording the same data again. Or if the data has been collected at different sources and on consolidation many similar instances can occur. This leads to repetition and duplicate entries of records. Well excel handles these nuisance as fast as one click! […]
One minute Excel Tutorial - Multiple Windows / Side by Side view
If you know how to split worksheet in independent work spaces then it makes working efficient as you can be at four different places within same work sheet. To learn how to split check out our one minute excel tutorial on split window However, split feature won’t help if you want to work on two […]
One minute Excel Tutorial - Split Margins / Split Window / Split Screen / Split View
Data is meant to be long and stretched but data segment that we want to attend is sometime too scattered that we cannot help scrolling. But this can be catered if we can somehow split the work space in two independent regions and then observing the two spaces. In excel this is easy with split […]
One Minute Excel Tutorial - Sorting
Having things in order is always a good idea as it increase understandability. Talking about order we can have things in alphabetical order or in reverse alphabetical order or talking in numbers then in ascending or descending order. And this can be done with ease in Excel in one breath. Consider the following example. Data […]
One minute Excel Tutorial - Freeze Panes
Often we are working on screen that provide limited visibility and thus data flows out of the visible region of the screen and thus we have to scroll up, down, left and right. But this movement sometimes impair our ability to understand the data well as either the row containing headings or column containing name […]
What is Matching principle in accounting?
Accounting principle that requires costs to be recognized after matching with the revenues earned associated with such costs i.e. the amount of costs recognized must be on equal footings with the revenues recognized. In other words costs shall be recognized at the rate at which benefits are rendered or revenue/income is earned by the entity. […]
What is Accrual basis of accounting?
According to accrual concept or accrual principle or accrual basis of accounting revenues and expenses are recorded in books of accounts when they are earned or incurred and not when they are received or paid in cash. In essence events of business are captured in accounting system when they are actually happening and not when […]
What is Journal and how many types of journals are in accounting?
These are the first formal books in which information regarding transaction is recorded . For the same reason they are also named as books of prime entry or books of original entry or day books. While making a record certain format is followed that only summarizes the information but also keep the value of information […]
What is the difference between accounting concepts accounting principles and accounting rules?
These three are definitely different but connected and their connection is critical in accounting. Under International Financial Reporting Standards (IFRSs) IASB Framework sets out accounting concepts in terms of: Objectives of financial statements: it is simple financial statements should be prepared in a manner that users can use the underlying financial information relating to entity […]