Excel Formula Creation
Budget: $10 – $30 USD
As the client, I am seeking a freelancer skilled in the utilization of Excel formulas. My project specifically revolves around financial computations, so a familiarity is with this area is beneficial. The details about what specific financial calculations will be automated are not specified at the moment.
Tasks will be assigned around the following:
- Setting up Excel formulas
- Automating financial calculations
Ideal qualifications:
- Proficiency in Excel formulas
- Knowledge in financial calculations
- Strong attention to detail
Please note, a demonstration of your problem-solving abilities in the domain of financial calculations in Excel will be key in the selection process.
OK I am numbering column A 1-15. In column B I will be entering each profit for a deal but these profits will not be entered the same day. They will be entered over the month as they happen. Therefore column b will start out blank and be built upon as the month progresses. In column C I would like the cumulative average of however many deal profits have been entered. In column F1 I would like to manually enter the desired profit average of the 60 deals done at the beginning of the month For ex, if I would like to average $300 profit over the 60 deals then I would put 300 in F1. Then as I enter each profit in column B as they occur, I would like to know what my profit must be on each of the remaining blanks in order to achieve F1. As i enter the actual profit in each cell a i get them, the remaing empty cells below will change to the new number needed for the remaing cell in order to achieve F1 at the end
Tasks will be assigned around the following:
- Setting up Excel formulas
- Automating financial calculations
Ideal qualifications:
- Proficiency in Excel formulas
- Knowledge in financial calculations
- Strong attention to detail
Please note, a demonstration of your problem-solving abilities in the domain of financial calculations in Excel will be key in the selection process.
OK I am numbering column A 1-15. In column B I will be entering each profit for a deal but these profits will not be entered the same day. They will be entered over the month as they happen. Therefore column b will start out blank and be built upon as the month progresses. In column C I would like the cumulative average of however many deal profits have been entered. In column F1 I would like to manually enter the desired profit average of the 60 deals done at the beginning of the month For ex, if I would like to average $300 profit over the 60 deals then I would put 300 in F1. Then as I enter each profit in column B as they occur, I would like to know what my profit must be on each of the remaining blanks in order to achieve F1. As i enter the actual profit in each cell a i get them, the remaing empty cells below will change to the new number needed for the remaing cell in order to achieve F1 at the end