pivot table in excel

10.0 USD

10.0 USD peopleperhour Technology & Programming Overseas
16 hour ago

Description


I have a large dataset containing over 30,000 rows of information in Excel. I need a skilled data expert to create a PivotTable that will help me analyze and summarize this data effectively.
### Key Requirements:- **Experience with Excel**: Must have advanced knowledge of PivotTables and data analysis features.- **Data Size**: Ability to handle large datasets efficiently (30,000+ rows).- **Summarization**: Help me extract key insights such as sums, averages, counts, etc., by categories and other filters.- **Customization**: Set up filters, slicers, and groupings to easily navigate and visualize the data.- **Deliverable**: Provide a well-organized PivotTable with the option to update as new data is added.
### Ideal Candidate:- Strong proficiency in Excel and data manipulation.- Ability to work with large datasets without performance issues.- Proven track record of creating custom PivotTables for business or analysis purposes.
If you have experience working with similar projects and can deliver an easy-to-use, efficient PivotTable setup, I would love to hear from you!

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Since the last developer could not manage to do the job this is now added to the list again. PI Work - Fix the default API to ensure it mirrors the discount information from the custom API. - Troubleshoot why the second API does not show discounts for the same products. - Address any API-related issues that affect SEO performance. 2. Internal SEO Cleanup (4-7 hours): - Fix invalid HTML elements in the pages. - Resolve canonical issues, pagination, and meta tag discrepancies. - Correct internal response codes (4xx errors) and missing header tags (H1, etc.). - Update and clean up page titles and duplicate issues. 3. Google SEO Issue Fixes (1 day approx.): - Resolve blocked URLs, canonical tag errors, and noindex tags. - Fix redirects, 403/404 errors, and server-side (5xx) errors. - Address any remaining duplicate canonical issues that Google identified. 4. Post-Cleanup Monitoring (Ongoing): - While the bulk of the work is straightforward and should be completed within 2 days, ongoing monitoring and adjustments will be necessary to help the site rank properly over time. - Track the site in Google Search Console and SEO tools to ensure all issues have been resolved and the site is indexing correctly. DA must grow fast. We have a backlink builder doing his job too. 5. Key Clarifications: - This is a short-term project. Anyone suggesting this will take weeks is overestimating the work. Cleaning up the current list of internal and Google SEO issues should take no more than 2 days for a skilled Magento 2.4 SEO expert. - While long-term ranking improvements will take time, the initial cleanup of these technical issues is simple and should be completed efficiently. 6. Internal Issues List: - Validation: Invalid HTML Elements in – 71 Pages - Canonicals: Non-Indexable Canonical – 1 Page - Pagination: Pagination URL Not in Anchor Tag – 1 Page - Response Codes: Internal Client Error (4xx) – 23 Pages - Pagination: Non-Indexable – 1 Page - Canonicals: Canonicalised – 3 Pages - Canonicals: Outside – 19 Pages - Page Titles: Over 561 Pixels – 9 Pages - Page Titles: Over 60 Characters – 10 Pages - H1: Missing – 13 Pages - Page Titles: Below 200 Pixels – 8 Pages - Canonicals: Missing – 33 Pages - Page Titles: Duplicate – 24 Pages - Images: Over 100 KB – 46 Pages - Page Titles: Below 30 Characters – 15 Pages - H1: Multiple – 1 Page 7. Google Issue List: - Blocked by robots.txt – Failed – 921 Pages (we are removing a lot of idiotic indexing here so it is OK, as usual you must adjust it) - Excluded by ‘noindex’ tag – Failed – 341 Pages - Alternate page with proper canonical tag – Failed – 168 Pages - Duplicate without user-selected canonical – Failed – 38 Pages - Crawled - currently not indexed – Failed – 871 Pages - Duplicate, Google chose different canonical than user – Failed – 2 Pages - Page with redirect – Not Started – 37 Pages - Blocked due to access forbidden (403) – Not Started – 5 Pages - Not found (404) – Started – 2,360 Pages (clarification: I had just added redirects to all; that is why it says started) - Server error (5xx) – Started – 215 Pages - Soft 404 – N/A – 0 Pages - Discovered - currently not indexed – Passed – 3 Pages
28.0 USD Technology & Programming peopleperhour Overseas
1 days ago
50.0 GBP Technology & Programming peopleperhour Overseas
23 hour ago
Dear All I hope this message finds you well. I am seeking someone with expertise in statistical analysis and academic writing to assist me in analysing a short Quality of Life scale designed for people with disabilities. The scale consists of only 8 items, divided into 5 dimensions, and is aimed at measuring different aspects of quality of life for individuals with disabilities. What I require is the following: A brief write-up of the methodology section, including a description of the study tools, sample size, and the methods of analysis employed. A general descriptive analysis of the results, with the dimensions ranked from highest to lowest, including the mean score for each dimension. An examination of the impact of certain variables, such as geographical region, family income, and the gender of the disabled person, on the results. I would like to determine whether these variables have any effect on the outcomes. Additionally, it is essential to note that the use of AI tools, whether for analysis or writing, is strictly prohibited. This will be verified prior to confirming the receipt of your work. The task is not overly complex, but I have provided detailed information to ensure clarity. The final report should be between 1200-1500 words, written in British English. Please only apply for this task if you have prior experience with academic papers and publications. If you do not have this background, I kindly ask you not to proceed. I look forward to your response. Best regards,
50.0 USD Technology & Programming peopleperhour Overseas
3 days ago
I am looking for an INDIVIDUAL, not a COMPANY to assist in an idea I have for an app for both IOS and Android, with the possibility of an accompanying website. It is possible, after communication that this will only need to be an interactive website and the app side is not required. I am looking to develop an ongoing relationship with this person, once I get the full requirements across. So, looking for someone that wants long term work rather than a quick couple of day project. In terms of budget, I appreciate this could go on for a while and so I am putting a low budget for now, but it is important to realise that I know it will increase once we talk about the work. This is really an initial concept budget. There will be a lot more work, which I hope all be more partnership based. An overview of the project, is an app and or website, that will be used to collect personal information of an individual. Almost like an interactive form, that can be changed and configured (centrally not by the user). The information is then stored centrally. Security is key, and simplicity. It must be easy to use and intuitive. Sorry I can't elaborate much at the moment, there's too much to go through. But I do invite questions and clarifications from you. In fact, I would prefer people to be asking questions, as it shows an interest and proves this has been read! Please send some examples of work done previously. Whether app or websites. I welcome proposals from people from any country. There will be an NDA to agree, before full details of the project are given. I will take my time finding the right person for this project, so
360.0 GBP Technology & Programming peopleperhour Overseas
21 hour ago