Excel Expert for Urgent Task -- 2
Budget: $30 – $250 CAD
As an immediate requirement, I need an expert in Excel who is well-versed with an array of formulas and functions. The key tasks required for this project are as follows:
- The application of Vlookup and Hlookup, Logical functions (IF, AND, OR) and Arithmetic operations (SUM, AVERAGE, MIN, MAX)
- Conducting Data analysis using Pivot tables and creating various scenarios in the Scenario Manager
- Ability to work with multiple worksheets
- Organising the spreadsheet using Grouping & Outlines and employing advanced Excel functions
- The project also involves the creation and handling of intricate elements such as Worksheet Linking/Workbook features, the usage of Header and Footer and providing a touch of Creativity & Originality
Structure-wise, the project involves a commission spreadsheet as the first, a forecast worksheet as the second, and a loan spreadsheet as the third. Accuracy in calculations and spreadsheet formatting is mandatory. The ability to perform these tasks quickly and efficiently is paramount as the deadline is tonight.
- The application of Vlookup and Hlookup, Logical functions (IF, AND, OR) and Arithmetic operations (SUM, AVERAGE, MIN, MAX)
- Conducting Data analysis using Pivot tables and creating various scenarios in the Scenario Manager
- Ability to work with multiple worksheets
- Organising the spreadsheet using Grouping & Outlines and employing advanced Excel functions
- The project also involves the creation and handling of intricate elements such as Worksheet Linking/Workbook features, the usage of Header and Footer and providing a touch of Creativity & Originality
Structure-wise, the project involves a commission spreadsheet as the first, a forecast worksheet as the second, and a loan spreadsheet as the third. Accuracy in calculations and spreadsheet formatting is mandatory. The ability to perform these tasks quickly and efficiently is paramount as the deadline is tonight.