Download Files uploaded by CA Kumar Mukesh

2221 KB

Internal Audit Report format-Production

Internal Audit Report format-Production

Internal Audit working/ Report for Production Efficiency and Idle Time Following is the detailed working of the production efficiency and Idle time performed by me on my previous job in a garment manufacturing company. It is very useful working and it ca...

Posted on 18 April 2013 (Downloads: 5670) Audit

129 KB

Treasury and cash management work program

treasury_and_cash_management_work_program.doc...

Posted on 11 April 2013 (Downloads: 805) Audit

79 KB

Information and communication audit work program

information_and_communication_audit_work_program.doc...

Posted on 11 April 2013 (Downloads: 395) Audit

120 KB

Control environment audit work program

control_environment_audit_work_program.doc...

Posted on 11 April 2013 (Downloads: 354) Audit

121 KB

Asset liability mgmt policy review work program

asset_liability_mgmt_policy_review_work_program.doc...

Posted on 11 April 2013 (Downloads: 366) Audit

65 KB

Accounts Payable Audit Programs

accountspayable...

Posted on 11 April 2013 (Downloads: 1115) Audit

73 KB

Payroll/Human Resources Review Work Program

The non-payroll expenditure audit program provides the detailed testing to verify the operation of the internal controls and procedures reviewed during the preliminary survey. The extent of the detailed testing will be determined by the auditor and super...

Posted on 11 April 2013 (Downloads: 843) Audit

97 KB

Remove duplicates & sort a list using Pivot Tables

today I want to show you a technique I have been using toÂ dynamically extract and sort all unique items from a last list of values using Pivot Tables & OFFSET formula....

Posted on 02 April 2013 (Downloads: 1369) Info Technology

233 KB

How to Look up Based on Multiple Conditions

Not always we want to lookup values based on one search parameter. For eg. Imagine you have data like below and you want to find how much sales Joseph made in January 2007 in North region for product â€œFast carâ€?...

Posted on 30 March 2013 (Downloads: 1445) Info Technology

45 KB

How to Lookup Values to Left?

There is no argument that VLOOKUP is a beautiful & useful formula. But it suffers from one nagging limitation.Â It cannot go left....

Posted on 30 March 2013 (Downloads: 1555) Info Technology

85 KB

Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week]

Sometimes we donâ€™t know what we want. If this happens when I am in a bar, I usually order a cocktail. Just a mix of everything. The same will work in Excel too....

Posted on 30 March 2013 (Downloads: 3349) Info Technology

67 KB

Tips on Rounding numbers using Excel Formulas

We can use a variety of formulas to round numbers in Excel depending on the situation.Â We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers ba...

Posted on 30 March 2013 (Downloads: 1537) Info Technology

160 KB

Grouping Dates in Pivot Tables

Do you know you can group dates in pivot tables to show the report by week,Â month or quarter?Â I have learned this trick while doing analysis on a pivot table today. In this online lesson on pivot tables, I will teach you how to group dates in pivot tab...

Posted on 30 March 2013 (Downloads: 1193) Students

132 KB

Excel Pivot Tables Tutorial : What is a Pivot Table and How

In this tutorial, we will learnÂ what is a pivot tableÂ andÂ how to make a pivot table using excel....

Posted on 26 March 2013 (Downloads: 3700) Info Technology

34 KB

Comprehensive List of Excel Keyboard Shortcuts

Few weeks back I have invited all of you toÂ share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks...

Posted on 25 March 2013 (Downloads: 2186) Info Technology

261 KB

Conditional Formatting in Excel - 5 Tips to make you a Rocks

Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and go...

Posted on 25 March 2013 (Downloads: 3743) Info Technology

42 KB

Delete Blank Rows in Excel-Quick Tip

Blank rows or Blank cells is a problem we all inherit one time or another.Â This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel sprea...

Posted on 23 March 2013 (Downloads: 2343) Info Technology

49 KB

Extracting Unique, Duplicate and Missing Items using Formula

Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they h...

Posted on 23 March 2013 (Downloads: 1647) Info Technology