Monthly Archives: July 2011

How to Detect Fraud Quickly

Posted on July 28, 2011 by esol4489

Is your organization facing Frauds threats? Below are quick transactions tests that if executed with precision may unearth these frauds. If not, but continue doing them regularly, you may scare away fraudulent activity in your organization. There are many frauds … Continue reading →

Share
Posted in Frauds and Illegal Acts | 31 Comments

How to Use VLookup Excel Function

Posted on July 23, 2011 by esol4489

As promised in my previous post, this time I will start by discussing the Vlookup Microsoft excel function. VLookup is one of the most commonly used excel functions in data analysis today.I would like to show you with examples when and where … Continue reading →

Share
Posted in Microsoft Excel Simplified | 27 Comments

The Accounting Cycle Process Flow Chart

Posted on July 23, 2011 by esol4489

This is a follow up of my blog posting of July 2 titled Detailed Description of the Accounting Process Cycle. This is a continuation of this blog posting. Below is the Life Cycle of the Accounting Process summarized in a … Continue reading →

Share
Posted in Accounting Simplified | 21 Comments

How to Prepare for a Clean Audit and Keep out of Trouble

Posted on July 22, 2011 by esol4489

Most of us get frightened when we hear that the auditors are about to audit our section/department. Audit is inevitable the moment we became custodians of other people’s assets. Audits can be sanctioned by business owners, shareholders, government requirements etc. … Continue reading →

Share
Posted in Auditing Simplified | 23 Comments

How to Copy and Paste Only Visible Cells in an Excel Worksheet

Posted on July 15, 2011 by esol4489

Jobs have been hard to come by these days for inexperienced accounting staff among others. The other day a friend of mine who is looking for a job told me that during interview for a junior accountant job he was … Continue reading →

Share
Posted in Microsoft Excel Simplified | 32 Comments

Find and Replace Excel Function

Posted on July 14, 2011 by esol4489

Find and replace found in Microsoft applications is a powerful function that we can use to manipulate data in any Microsoft applications like word, excel, power point etc. This tool can be used to find and replace any kind of … Continue reading →

Share
Posted in Microsoft Excel Simplified | 22 Comments

Excel Functions Simplified

Posted on July 4, 2011 by esol4489

Most accountants and accounting students have some basic knowledge about excel. We even know by name various functions such as VLookup, HLookup, Match, if statements, creating subtotals, Pivot tables etc, but we have no clue of how to execute these … Continue reading →

Share
Posted in Microsoft Excel Simplified | 34 Comments

Detailed Description of the Accounting Process Cycle

Posted on July 2, 2011 by esol4489

Our topic of the Life Cycle of the Accounting Process continues. This time I add more details about the 10 steps of the entire accounting life cycle process. The detailed description of each of the accounting process cycle follows here below: 1.  Gathering of information About External … Continue reading →

Share
Posted in Accounting Simplified | 30 Comments

The Life Cycle of the Accounting Process

Posted on July 2, 2011 by esol4489

Introduction The accounting process cycle has many processes and for most beginners in the accounting career path, this road can be very confusing.  Traditionally, the accounting department is organized into various departments or sections such as Accounts Payable, Accounts Receivable, … Continue reading →

Share
Posted in Accounting Simplified | 20 Comments