Excel database reports jobs
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optimally to produce...
I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
Tell Me / Teach Me / We do together "to integrate" A form in a website to Google Analytics: Data to be collected: - Text data - Numeric data - Date and time data I am seeking to: - Generate reports - Execute statistical analysis
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
...clients. - Handle API integrations and effectively connect various systems to HubSpot using tools like Zapier and Make .com. - Optimize HubSpot objects and automate processes, including form submissions that trigger deal creations and associate contacts. - Develop and manage workflows and lifecycle drip email campaigns tailored to different client needs. - Oversee the creation and analysis of custom reports for diverse clients. - Manage sales pipeline visualization and adjustments for various projects. - Train team members on advanced HubSpot functionalities for a range of scenarios. - Ensure seamless data synchronization across connected applications for all clients. - Configure and manage HubSpot chatbots as per client requirements. - Implement SEO strategies within the HubSpot...
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
I'm seeking an expert data scraper to compile a comprehensive list of small to medium enterprises (SMEs) across Victoria, NSW, North Queensland, and South Australia. The scope of businesses should focus on restaurants and retail stores. The information needed for each business is as follows: - Business Name - Address - Phone Number - Website - Email Ideal candidate should have robust experience in data collection and validation to ensure the information provided is current and accurate. Proficiency in navigating Australian business directories and databases will be a valuable asset. Your scrupulous attention to detail and commitment to data integrity are critical for this task.
I need a database where we can store our sales transactions. The database will be manually updated by our staff. I would also like to have reports generated on our sales. Key Requirements: - Develop a database to store sales transactions - Enable manual data entry by staff - Implement a reporting system that can generate sales reports Ideal Skills: - Proficiency in database development - Experience with manual data input systems - Ability to create custom reporting features Please provide examples of previous similar projects you've worked on.
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I'm looking for an experienced SEO specialist to help improve the search engine ranking of several product listing websites. Key Aspects: - I need your expertise for 4 or more ...primary goal is to enhance search engine ranking. - These websites are mainly comprised of product listings. Skills required: - Proven track record in SEO, particularly in e-commerce and product listing websites. - Up-to-date knowledge of search engine algorithms. - Experience in increasing search engine ranking, not just traffic. - Excellent communication skills and ability to provide clear reports and recommendations. Your role will be pivotal in boosting the visibility of these websites online, so that they can attract more potential customers. Please include relevant examples of your past wo...
...one-on-one battles between users, multiplayer battles, and AI-controlled battles. - **Rewards Opening and Functionality:** Users should be able to open rewards, primarily in the form of virtual goods. - **Admin Panel:** The backend should include functionalities like authentication, a comprehensive dashboard, user listing, transaction management, KYC (Know Your Customer) compliance, and detailed reports. Ideal Candidate: - Proficient in implementing complex gaming functionalities. - Experienced in integrating secure payment gateways. - Skilled in developing an engaging user experience. - Proficient in developing and managing an admin panel. The project is a perfect fit for a developer who is passionate about gaming and has a proven track record of developing similar iGaming pla...
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
I require an expert in data analytics, specifically someone proficient in Power BI, for an upcoming project of mine. The scope of the work involves generating meaningful visualizations around customer insights data that I have. Detailed responsibilities will include: - Understanding the nature of the collected data - Developing clear, comprehensive visual reports using Power BI Ideal candidates would possess: - Extensive experience with Power BI - Strong understanding of data visualization concepts - Ability to work independently on customer insights data - Good communication skills to explain complex data in a simplified manner Additionally, experience in analyzing customer behavior would be a huge plus. Please provide examples of previous data visualization assignments, sp...
...targeting European customers. - Regularly monitor and optimize the campaign to ensure maximum effectiveness in boosting sales. - Provide detailed reports on the campaign's performance, including key metrics like click-through rates and conversion rates. Ideal Skills and Experience: - Proven track record in successfully managing Amazon ads campaigns, especially in the European market. - In-depth knowledge of Amazon's advertising platform, particularly Sponsored Products. - Strong analytical skills to interpret data and make informed decisions for campaign optimization. - Excellent communication skills and ability to provide clear and concise reports on campaign performance. If you have the necessary skills and experience to drive sales through Amazon ads in E...
...tablets, and smartphones. Content Management System (CMS): A scalable database that allows easy addition, editing, and deletion of content. An easy-to-use management interface that allows instructors to efficiently manage courses and content. Student Management and Registration System: Capability for students to register and log in to their personal accounts. Detailed information about course progress and outcomes. Secure Payment System: Integration with trusted payment service providers such as Apple Pay and Mada, among others. Ensure that payment transactions are conducted securely and are protected. Performance Evaluation and Monitoring System: Ability for students and instructors to provide ratings and reviews. Analytical reports that show the performance and progress ...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
The individual report (~4000 words) carrier's 40% weighting in the Transportation Studies module and will be assessed by an individual report submitted via canvas. In your report you would need to include the experimental and the model results of your selected noise barriers. You will be judged on how you have been innovative in your conceive, design and how you improved the performance rating of your noise barrier. Assessment Criteria 1) Conceive (research noise barriers) = weight age (10%) 2) Project 1: Performance of reflective/absorbing noise barriers = weight age (40%) 3) Project 2: Traffic noise mapping = weight age (40%) 4) Modelling of noise barrier = weight age (10%) Project Details: Project Description: We are seeking a skilled freelancer to assist with a project that ...
...specific platforms, a freelancer with experience in working with them would be ideal. Additionally, PHP Laravel framework familiarity is essential. Requirements include: - Real-time synchronization: All data updated in any of these accounting software should reflect on my ERP system instantly. - Automatic data updates: An ability to schedule regular automated updates. - Custom Reporting: Tailored reports based on the data received from the platforms. - Error handling and Data Validation: Ensuring data is validated with robust error handling procedures. Given that I skipped indicating the specific data, your proposal should outline a solution for an All-in-One integration, that is ready to extract and integrate any type of data. High proficiency in API integration, backend deve...
...sales management systems. This project will involve the creation of a comprehensive system that integrates sales and inventory management, along with a mobile application for Android and iOS. Key Features of the System: - User Registration and Login: A secure and easy-to-use registration and login system for users. - Sales Tracking and Reporting: Ability to track sales data and generate detailed reports. - Inventory Management: Manage and track product inventory within the system. - Partner Activity Tracking: A feature that tracks partner activities, sales, and commissions. - Communication & Marketing Tools: The system should include tools for email marketing, social media sharing and posting, and SMS marketing capabilities. Mobile App Features: - User Registration and Logi...
...competitor's reports (provided) I envision a 2 or 3 page PDF report that's easy-to-read and visually appealing and aligns with the branding of Merlin Car Auctions. The design should be clean, clear and organized, ensuring potential buyers can quickly and easily review the information provided. The 1st page should be the vehicle details and checklist of mechanical components that have been inspected. The 2nd page should be for the condition of the vehicle's bodywork and images of any damage. Ideal Skills and Experience: - Graphic design experience, particularly with report layouts - Familiarity with design software to create multi-page PDFs - Understanding of how to present technical information in a clear and engaging way I have attached our current inspection ...
...therapy sessions, including Gestalt Therapy, Occupational Therapy, Physical Therapy, Music Therapy, Behavioral Therapy, Play Therapy, Sound Therapy, Reiki Practice, Animal Therapy, Nutritionist Services, and sessions with Autism Specialists. Actively communicate with therapists and specialists to ensure they are delivering the best possible care and meeting all set goals and objectives. Manage reports and advice and opinions from top doctors around the world. Research and source opinions and advice from leading experts in autism care to continuously enhance treatment strategies. Ensure that all stakeholders, including therapists and medical professionals, are aligned with the family’s goals and are providing regular updates on progress and development. Manage and monitor t...
I need to integrate code with Google Analytics to my existing Google Analyt...to my existing Google Analytics system. The integration should focus mainly on user IDs, collection clicks, and other relevant user interaction data. Then, using this data, comprehensive and useful reports need to be constructed. Key functionalities: - Integrating Google Analytics data from website datalayers code. - Leveraging this data to trace and analyze user interactions. - Establishing reports based on analyzed data. Ideal skills and prior experience: - Proven experience in Google Analytics - Knowledgeable about user interaction analytics - Expertise in creating comprehensive reports - Proficient with data integration Please Note: I will do all the work, I just need some guidance ...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm looking for an experienced freelancer to tackle data entry. The focus is on text data, which needs to be accurately inputted into a structured database. While attention to detail is important, issues checking for spelling or grammar errors will not form part of the job scope. In line with this, the ideal candidate should: - Have a proven track record with data entry projects - Have expertise in structured databases - Be able to work accurately with text data - Have the ability to complete tasks effectively within the given timeline.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I am looking for a database website that serves as a customer form. This form will be used by customers to fill in various fields. Upon submitting the form, they will automatically receive a comprehensive response based on the information they provided. Key Requirements: - The customer form should include fields for Name, Contact information, Address, Location, Product or Service details, Width and Height, Dimensions, and Vertical or Horizontal preference. - The form should have an inbuilt auto-calculation feature that computes the Total cost, based on the area calculated, and any additional amount based on the customer's requirements. Delivery of Reverted Information: - The system should trigger an automated response to the customer. This can be in the form of an Email, a We...
I'm having some issues with my network connection dropping and I need an expert in network analysis, specifically using Wireshark, to help me troubleshoot. Specifically, the project will entail: - Analyzing TCP traffic - Identifying and addressing the root cause of the persistent connection disruptions - Providing detailed reports on findings and recommendations for solutions Ideal skills and experience for this job: - Extensive experience with Wireshark and other network analysis tools - Knowledge of TCP - Expertise in troubleshooting connection drops - Strong report and documentation skills If you've successfully performed similar network troubleshooting tasks in the past, I'd love to hear from you.
...confidentiality while handling personal data of healthcare professionals. Provide regular progress reports to the management team, highlighting insights into the data collection process and any challenges encountered. Therapies to Include: Gestalt Therapy Occupational Therapy (OT) Physical Therapy Music Therapy Behavioral Therapy Play Therapy Sound Therapy Reiki Practice Animal Therapy Nutritionist Services Autism Specialists Required Skills and Qualifications: Demonstrated experience in research, especially within the healthcare or medical sectors. Strong understanding of data collection techniques and database management. Excellent attention to detail and commitment to accuracy. Proficiency in Microsoft Excel or similar spreadsheet software, capable of managing ...
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...
We are seeking a skilled artist or designer to create a sketch based on a collection of images and photos. The project entails transforming these visual references into a cohesive and aesthetically pleasing sketch. The sketches will be used for various purposes, including but not limited to concept art, illustrations, and design prototypes. Image Collection: W...our feedback. The freelancer should be open to constructive criticism and willing to make necessary adjustments to meet our requirements. High-resolution digital sketch files in a format compatible with common design software (e.g., PSD, AI, or PNG). Final sketches should be delivered in both black and white and color versions, if applicable. The freelancer should provide updates and progress reports throughout the project...
...link is 100 to 150 INR. And I need 65 to 100 live links (It will be great if its follow and indexed links only). Without live link or indexed link, I will not release the milestone or payment. Note: Links should be live and active. I will provide 21 URLs in starting (5 Backlinks per URL I need). I have complete backlinks database of Per URL. Will share screenshots as well. I will give you one month of time, before 31st May, you need to complete this task and submit reports of live links. Key requirements: - 100 do-follow backlinks (21 URLs I will provide) - Domain authority should be in between (DA) 30-50 - Industry/Niche: Business or Health Ideal candidate should have: - Proven track record in backlink building - Strong understanding of SEO and search engine algorithm...
...management, payroll and other standard feature. - User-Friendly Interface: A clean and intuitive user interface that facilitates easy navigation and usage for administrators, managers, and employees. - Customization Options: The ability to customize and configure modules according to specific organizational requirements. - Reporting and Analytics: Built-in reporting tools to generate insightful reports on various HR metrics, including attendance, leave balances, and employee performance. - Security Measures: Robust security measures to safeguard sensitive employee data and ensure compliance with data protection regulations. - Documentation and Support: Comprehensive documentation and reliable support services to assist with installation, setup, and troubleshooting. We are seekin...
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.
