Tags: GOAL SEEK

Compute gross annual salary from a know net annual salary figure

{ 0 Comments }

By Ashish Mathur · January 10, 2012 · CALCULATION · Leave a comment

Given the net annual salary figure and progressive tax rates for different income slabs, one may want to calculate the gross annual salary. You may refer to my solution in this workbook.

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

Goal seek multiple cells

{ 2 Comments }

By Ashish Mathur · March 20, 2010 · CALCULATION · Leave a comment

When running the Goal seek functionality, one can specify on one “Set cell”. To Goal seek on multiple cells, refer to the this workbook.

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

Search for:

Recommendations from LinkedIn

I’ ve been part of the training program that Ashish had conducted at our organisation. I found the sessions to be extremely useful for my day to day work and Ashish was exemplary in the way he conducted these sessions. Very practical, systematic and enforcing, the examples provided were of utmost relevance. I have no hesitation in recommending Ashish’s training programs.

Santosh Kumar Peshkar

It was a two day session at Quatrro where Ashish trained people from diverse work profiles about Advanced Excel Techniques. The expertise, he posses regarding his subject matter and the preciseness with which he handled the queries of attendees, is really adorable. He is doing a good job by creating awareness among people about undiscovered excel functions, which can seriously reduce time and efforts for daily excel users. I wish him best of luck for his future…

Gunjan Gupta, ACA

Ashish Mathur is an expert in Excel with amasing knowledge on the subject. HIs conceptual knowledge and the way he provides the excel training shows how in depth he has researched on the subject. Always interested to find the best approach to a problem he shows a “nothing is impossible” attitude. Way to go and thanks a lot for the useful training.

Shruti Gupta

Ashish Mathur is on the of Best Excel Expert that i have come across in my life. I met him once in our Corporate traning session on excel. He truely surprised me by his skills on Excel. His method of explaining the excel techniques was also impressive. The whole batch praised about that excel session. All that i can say that i will always be in touch with you “Ashish Mathur, Sir”

CA.Amandeep Singh Sabharwal

I knew excel but after attending the session from Mr. Ashish I was ablt to identify new avenues of using the same function which I was not aware off and tremendous application of the same. It is awesome to see how he conduct the session too. God Bless Him!

Vishal Goel