need a excel project completed fast
₹100-400 INR/小时
1include relative absolute and mixed cell reference
2use all the summary statistics (sum, average, min, max, count, etc.)
3use at least three different instances of date and time functions
4use at least three different formats such as number, date, custom etc.
5use at least three different instances of nested if functions
6use vlookup and index/match functions
7create and use range names and use them in formulas
8have a chart with axis names, chart title, etc. describing the data
9use data bars
10use at least three instancs of conditional formatting, one of which needs to be custom formatted
11design a table
12sort the table at two levels or more
13use the subtotal function
14have grouped data
15have at least three relevant pivot tables with at least two calculated fields
16have a slicer available for the pivot table
17create a one variable data table
18create a two variable data table
19use scenario manager or solver (with saved and summarized scenarios)
20use advanced filters
21use the database functions
22use the sumif(s), countif(s), averageif(s) functions
23use rank, percentrank, quartile, frequency, stdev, and correl functions
24create a histrogram
25at least three different formulas using arrays
26at least two cases of data validation
项目ID: #13953869
关于项目
授予:
I'm an professional excel expert. I recently wrapped up a contract as a senior data analyst with a big Insurance company, and I’m now looking for opportunities with other large data organizations.
有11名威客正在参与此工作的竞标,均价₹312/小时
I have the expertise in Excel and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
Thank You for posting project we specialize in excel based programming. Team Background: MNC employee with vast knowledge contact sky pe- uvisomtecnologies
I hava maney experience about thease work. Dan his will be my 1st job in freelancer. Give me some chance
I understand the urgency of your work and I will complete the work in 2 hours. Results will be as expected and I promise not to disappoint you.