Highlight Active Cell in MS Excel 2007

It is a very common problem that during presentation of any MS excel File we want to highlight active cell. There is some modules available but they might affect the format of your sheet.By adding this module to your sheet you can minimize this problem for example if you want to highlight the cell where you are working  as shown in figure1. 

for adding this feature to your excel sheet follow the steps Given below.

Step 1: Press ALT + F11 you will get the following screen

Step 2:Now Double Click on this Workbook and add following Module :

' Author Naushad Qamar
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
On Error Resume Next
Static OldRange As Range
Static OldIndex As Integer
Const movingColor = 6
If OldRange.Interior.ColorIndex = movingColor Then
OldRange.Interior.ColorIndex = OldIndex
End If
OldIndex = Target.Interior.ColorIndex
Set OldRange = Target
Target.Interior.ColorIndex = movingColor

End Sub

Step3:Now open your worksheet you will find active cell highlighted..

Step4: Now save File as Macro enabled as shown in figure :

Working sample Download
Please Do Comment and  give suggestions, moreover if you have any query,  feel free to ask.

Firm valuation (Monte Carlos Application)

For Firm valuation I used Monte Carlos Application.

For Monte Carlos Application I generated Random Values By using following macro
Sub montecarlos()
'This macro performed montecarlo simulations'
For rownum = 2 To 301


Range("b9").Value = Cells(rownum, 10).Value
Range("B11").Value = Cells(rownum, 11).Value
Cells(rownum, 13).Value = Range("c85").Value


Next rownum
End Sub
this Method will help to identify the riskiness of the project.
here is the link of complete template :
Monte Carlos Application Download link

Financial Feasibility study of business plan

A good template has been developed, in this template please take blue font as a variable. This is good template for new business and can be applied for existing one.

I worked on the longterm financial projection of 4 years and after that supposing the business is in stable phase. Due to this reason applied terminal growth from fifth year.

Please review and add your comments so that could furth improve it.
I did not focus on cost of equity, took it simple.

Download

Sales Analysis

You may find herewith a very strong template for sales analysis. You can analyze sales by product wise, Employee wise, customer wise and product category wise on just one click. This is helpful for marketing analyst, financial analyst and other executives. The same template can be used for other activities like purchase. This will be just a support for you.
In this template you can compare current performance vs. last corresponding period and can identify variance % so that corrective action could be taken in mean time.
In this template you will have to just collect data from system with different field like product, category, employee and customers. If you have more field can use, in this situation definitely it will be more dynamic and more result oriented.
There is only one thing in which you have to be very careful, you will have to use unique head excel can easily do this work. I use choose function for this template and conditional formatting to hide when heads are not available.
Please send your comments so that in future it could be improved more.

Jamal Qamar

Donwload Template

ACCOUNT ANALYSIS (APPLICATION OF DSUM)

This is a good template for those who work particularly on account analysis. I considered here expense account for this purpose.

DSum function is very good for grouping data from ledger; someone uses Sumifs (only available in Office 2007), Sumif and Sum array function for achieving this objective.

You can also use DCount, DAverage, DCount, DGet and DProduct in place of DSUm, but should be careful in working.

Only thing which you have to learn in DSum is its criteria option, put focus on criteria go to internet and learn more. The function will make your routine work very simple.

The function of Database (DSum, DCount, DAverage, DCount, DGet and DProduct) will be suitable also for marketing professionals because they can analyze data on product wise, region wise, sales personnel wise and etc.

For more useful Template Click on Link shown Top of the page.

Download Dsum Template Link1

Download Dsum Template Link2

For more Useful Excel Templates & Analysis Tips, visit links Given Below.university national admission UK

Cash Receipt Template(MS Excel)

This is a good template for those who work on monthly feasibility study for a longer time of period. I used three methods, used any one as per your convenience.
In this template you have to select receivable days, the model will adjust receivable amount, GST, Bad debts, write off and cash receipt automatically. Please consider blue font as a variable.
To achieve this objective, I used Hlook up function extensively. Through this model, I made my financial model more and more automated. Earlier, I have to manage receipts, bad debts and write off manually for direct cash flows.
Same tips one can apply as per his/ her requirement. This will be helpful particularly for Account, Finance and other Business professionals. It has been designed in more sophisticated way so that everyone could get advantage of it.

Please go through the template meticulously.

Note:
Through this template:
· You may learn Data Validation.
· You can apply H lookup function.
· You may use Nested If function and IsError.
· You may apply Index and Match function.

Download Template Link 1

Download Template Link2

Snapshot is given below for your interest.

Variance Analysis (MS Excel)

This template is very strong.
This will be helpful particularly for Account, Finance and other Business professionals. Through this template, you can manage your periodic reporting in more effective and efficient way and definitely you will be more and more productive.
It has been designed in more sophisticated way so that everyone could get advantage of it. In data sheet, you will have to take care of sensitive area any deletion or insertion may create problem.
Please go through the template meticulously.
Note:
Through this template:
· You may learn Vlookup
· You may use Choose function.
· You may apply Offset function.
· You may use Text function with date

Click here to Download Link1

Click here to Download :Link2

Snapshot is given below for your interest.