Automated dashboard reporting excel jobs
I'm in need of a freelancer with extensive experience in data cleaning for mixed data types in Excel. You'll be dealing with spreadsheets where the info types may vary significantly and could involve issues such as inconsistent entries, missing or incomplete data, and incorrect data format. I've not specified how many worksheets or tabs are involved in the project, so be prepared for anything. Key skills and experience needed: * Strong Excel knowledge * Proven data cleaning experience * Ability to work with mixed data types * Attention to detail to spot inconsistencies * Good problem-solving abilities to rectify missing or incomplete data * Ability to meet tight deadlines. Please note that while this description provides an overview, the scope could vary o...
As a Media TV Channel, we are seeking a UDAID Contract Compliance Specialist to review our contracts, ensure compliance with cont...adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with USAID contracts is a must. - Previous work in media TV channels would be beneficial. - Strong background in contract compliance and financial auditing. - Detail-oriented with excellent commun...
I need a competent Excel specialist to develop a robust strategy for documentations. The specific tasks are not yet determined, and the information that needs to be included will be clarified as we proceed. However, the project has no strict deadline, giving you ample time to plan, organize, and execute best practices. The ideal candidate will possess: - Outstanding Excel skills, including creating and working with complex formulas. - Robust organizational skills to manage and structure vast amounts of information. - Proactive attitude for identifying potential tasks that need documentation. - High attention to detail and accuracy. - Experience in data entry, sales records, and inventory management would be advantageous. Please bid with your plan of action and examples of p...
I'm in need of a sharp Australian expert who has access to the Australian Bureau of Statistics (ABS) database and can help me gather pertinent data regarding Melbourne's older population. If you have experience with ABS table builders this should be a relatively easy job as much of the data is collected in these ranges. Key Deliverables in Excel: - All SA3s in the Eastern and Southern Melbourne planning regions - TOTAL number of people in each SA3 and the number of people in the ages of 50+, 60+, 70+, 80+, 85+ - The number of people with income per week in each SA3 of $3,000-$3,999, $4,000 - $4,999, $5,000 - $5,999, $6,000 - $7,999, $8,000 or more The example table shows information from the 2016 Census and I will need data from the 2021 Census. Key Requirements: - ...
I need an expert to organize multiple Excel sheets. The sheets will include financial data, inventory records, and sales figures. They should be arranged in the following manner: - By date - By category - By location You should have experience in data organization and be proficient in Excel. Your attention to detail will be crucial.
1 excel import task. and fix minor issue in db. Able to work with ftp. Follow and start Immediately
Please Sign Up or Login to see details.
I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.
I need a highly accurate and detail-oriented individual to assist with entering both numeric and text data into Excel. Requirements: - Excellent proficiency in Excel - Previous data entry experience - High level of accuracy and attention to detail - Ability to handle both numeric and text data entry efficiently This role will suit someone who thrives on working with data and can ensure that all data gets entered correctly the first time, every time.
I'm looking for a freelancer proficient in Excel to help me with daily data entry and organization tasks. Key aspects of the project include: - **Data Entry and Organization**: Your main responsibility will be to input new data, as well as maintain and organize existing data in a structured manner. - **Regular Updates**: The document will need to be updated regularly, making consistency and accuracy pivotal in this role. Ideal candidates should have: - Strong proficiency in Excel, particularly in data entry and organization. - A keen eye for detail and a methodical approach to work. - The ability to work consistently, as the document will require daily updates. - Prior experience with similar tasks is a plus, but not essential.
I have a project that requires the entry of numerical data into a digital format. The purpose of this task is to prepare the data for analysis and reporting. Key Requirements: - Entering numerical data - Accuracy is a must - Understanding of data analysis Ideal Skills & Experience: - Proficiency in data entry - Background in data analysis - Attention to detail - Ability to work with large datasets - Experience in database management will be a plus Please show your interest if you've got the necessary skill set and experience to get this done effectively.
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I am looking for a smart POS system with automated checkouts. Which means it should have a system that automatically scans and checkout products without the need of counter. Let me explain in storyboard. Story Board 1) A person goes to a supermarket, picks his products in trolley and moves through a gate or line. So there the camera or sensor should be placed and as he passes on the next stop there should be a screen and printer where his total amount is shown in screen and the printer prints his bill automatically. And the person can pay to the total amount to cashier via cash or online and get their products home. With this system, I'd expect the person to suggest the type of sensor or camera that needs to be purchased. Would be good if the system is online.
...organisation, we focus on delivering services to the Australian community. We are currently facing challenges with adopting AASB 1058, particularly in regards to reporting transactions. Our reports seem to confuse users, especially with the misleading nature of the statement of profit loss. I am in need of an expert in the following areas: - Understanding and interpreting AASB 1058 - Nonprofit financial reporting - Ability to simplify complex financial data The ideal candidate should have prior experience in helping nonprofits navigate regulatory requirements and clarify financial data. Your role will be to assess our current reporting practices, highlight areas of potential confusion, and suggest clear, compliant and understandable ways of presenting our financ...
...categorization and organization of products. - **Sales Reporting**: I need a robust reporting functionality that can provide insights into sales trends, popular products, and overall store performance. - **Customer Database**: The system needs to be able to store customer data, such as purchase history and contact information. Additionally, it should have the capacity to segment customers for targeted marketing and loyalty programs. Ideal Skills and Experience: - **POS System Development**: Experience in developing custom POS systems is a must. Familiarity with the requirements of multi-store setups is highly desired. - **Inventory Management**: Strong background in building efficient inventory management systems. - **Sales Reporting**: Proficiency in creating det...
I require a professional data scraper to scrape multiple websites. Key tasks include: - No limitation on type of data scraped as this was not specified. - Scraping must be done across multiple websites, specifics will be provided upon project commencement. - All data should be delivered in Excel spreadsheet format. Ideal skills and experience: - Prior experience in web scraping across multiple diverse websites. - Proficient in using different scraping tools. - Strong understanding of Excel and data parsing. - Attention to detail and commitment to high quality, error-free work.
I am looking for an experienced Excel tutor to provide me with in-person lessons focusing on basic formulas and functions. My Current Skill Level: I would rate myself as a beginner - I have minimal experience with Excel and would need a tutor who can help me understand the basics. Skills to Learn: My main goal is to grasp basic formulas and functions within Excel. I'm looking to build a strong foundation before moving onto more complex features. The ideal candidate for this job has: - Proven experience in tutoring or teaching beginners Excel - Strong understanding of basic formulas and functions in Excel - Excellent communication skills to effectively convey concepts to a novice - Availability for in-person sessions If you think you&#...
I require a Power BI expert to mentor me on creating high-quality dashboards using raw data like sales data, customer survey results, and financial statements. The scope of the training will include: - Data Modeling Techniques - Advanced Visualization Strategies The main aim of creating these dashboards will be to monitor our sales performance and analyze customer feedback. Thus, it will be ideal if you have experience in these areas and are comfortable teaching the skills needed. Being proficient in utilizing DAX formulas would be a significant advantage as well. Your task will be to transfer your knowledge about Power BI tools efficiently, helping me to master these operations at a professional level.
We require someone skilled in Excel formatting and function use to build an Excel sheet specifically for financial expense tracking. The aim is to streamline the management of our financials by keeping a reliable track of expenses. While we have some options in mind, we're open to suggestions on how to effectively design and utilize this tool. Your key tasks would be: - Create an Excel based tool tailored for financial expense tracking, taking care to ensure it's user-friendly and simplifies the tracking process. - Enable customizations that further cater to our financial needs. While no specific type of expenses were indicated, the freelancer should be capable of creating a versatile sheet that can record various types of expenses in the future, should the...
I need a skilled professional who can adeptly convert financial Excel sheets into a document fit for presentations, adhering to standard formatting. The extensive data consists of complex financial information. The perfect match for this project would have: - Profound experience in handling Excel and financial data - Proven knowledge in producing sophisticated documents, maintaining presentability and readability - Ability to deliver precise and clear formatting in standard style Exactness, reliability, and a keen eye for detail are integral for this task. Efficient turnaround time would be appreciated.
...qualifications, experience, and reviews from other parents/students. - User Reviews: A section for parents/students to leave reviews about the tutors they've worked with. - Student Profile: Profiles for students, allowing parents to track their progress and specific learning needs. - Payment Gateway: The platform should support a subscription-based payment model. - Follow-Up System: An automated mail/call system to gather feedback and track progress. - Additional Learning Materials: A section to provide extra learning resources to parents/students. Ideal candidates for this project should have experience in creating user-friendly and secure e-commerce websites, preferably with a focus on educational platforms or online marketplaces. A solid understanding of UI/UX ...
As part of my research, I require a professional who can gather and analyze quantitative data on the target market. Key Responsibilities: - Conducting observational studies to collect numerical...observational studies to collect numerical data on market trends and consumer behaviors. - Ensuring the data's integrity and reliability. - Providing clear and comprehensive reports based on the findings. Ideal Candidate: - Proven experience in market research, particularly in data collection. - Proficiency in conducting observational studies. - Strong analytical skills. - Excellent communication and reporting abilities. - Understanding of market trends and consumer behavior. This project will give you the opportunity to contribute to insightful market research. Looking forward to ...
I need to outsource the API connection to various e-commerce platforms to retrieve data for reporting, using Python. Here is the list of platforms I need to connect to: 1/ Shopee 2/ Lazada 3/ Google Ads 4/ TikTok 5/ Tokopedia Requirement: a demo of a project you have previously connected that is on the list You can choose one or all platforms to outsource.
As a team heavily reliant on Google Sheets for our daily reporting, we're looking for a proficient freelancer who can automate the process of compiling our marketing metrics. Key Tasks: - Automate the process of copying data between sheets - Ensure data collation for metrics such as click-through rates, conversion rates, and social media engagement Ideal Skills and Experience: - Extensive knowledge in Google Sheets - Experience in automation and data analysis - Knowledge of marketing metrics would be an asset
...above our competition and target audience is key. The ideal candidate will have: - Extensive experience in Google PPC - Proven track record of increasing conversions/sales in our industry ( Please don't take this account if working with other web agencies in the same state as us.) - Deep understanding of the industry - Innovative strategies tailored to our target audience. - Daily and Weekly reporting is very important - Able to work in our time zone Eastern. Note: Our ads have enough data for our PPC. We are looking to work with someone honest and dedicated with our team. If you are overworked or have too many clients you work with, this will not be a good fit. We need daily communication and work that is done every day. If you feel you would be a great fit, please ...
...coast region of Australia. Key Information Required: - Contact details: I need a name of the person who manages the trucks their phone number. - Geographic location: It's important to know where these individuals or companies are located. - I need the company name The final list should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Strong research abilities: The ability to dig deep and find the right contacts in these specified industries. - Proficiency in Excel: The ability to compile and present the data in an organized and clear manner. - Understanding of the target industries: Experience in or understanding of the Transportation and logistics, Construction, and Agriculture sectors would be a big plus. Please let me know about any past ...
...the quality of their own leads by contacting the customer by calling or messaging them to scheduling a zoom call using Calendly. The states will depending on the states you hold an active license in. (I will help you get your Non-Residence license in the states you get clients) #2 Agent Acquisition Specialist. I am looking for someone to scout for people looking for jobs that allows them to excel in the company quickly. I am looking to hire 10 more agents just like you. Or agents with potential in any state (CLOSERS). This position with require you to generate your own leads for potential life insurance agents screen them for the criteria listed above, and book the potential agent on a zoom call with me or one of my staff using Calendly. Please note that these agents will...
...improve relevance and rankings for targeted keywords. Content Strategy: Develop a content creation plan that attracts and engages our target audience, and supports SEO goals. Link Building: Implement a white hat link-building strategy to improve domain authority and page authority. Technical SEO: Ensure the website is optimized for speed, mobile-friendliness, and indexed properly by search engines. Reporting and Analysis: Provide monthly reports on traffic, rankings, and other key performance indicators to track the progress of the SEO efforts. Achievable Targets: Visibility Increase: Achieve a top 10 ranking on Google for at least 5 major keywords related to football statistics by the end of the campaign. Traffic Growth: Increase organic traffic to the website by 40% by the end...
I'm looking for an experienced Salesforce expert to create a comprehensive reporting system and dashboard. This system should help me track the effectiveness and progress of my Sales Development Representatives (SDRs) through the sales funnel. Key Responsibilities: - Developing Salesforce reports for tracking key metrics: - Conversion rate from leads to opportunities - SDR Call to Connect - SDR Connect to Appointment Set - Appointment Set to Appointment Held - Appointment Held to Opportunity Converted - Creating a real-time updating dashboard that visually represents these metrics. Ideal Skills: - Proven experience with Salesforce and its reporting functionalities - Ability to create complex dashboards - Understanding of Sales and Sales Funne...
I'm seeking an expert to develop a custom data dashboard focused on displaying my business's sales data. Ideally, this dashboard should represent the data through a visually engaging pie chart. Key Requirements: - Proficiency in data visualization tools - Strong understanding of pie chart data representation - Experience in incorporating total sales data into dashboards This project requires a professional who can effectively convert raw sales data into comprehensive visual representations. An understanding of sales analytics and data interpretation would be beneficial to the successful completion of this project.
I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can deliver this tas...
I need a data analyst to clean, analyze, and report on survey data using SPSS for a research project. This should in...moderating and mediating factors. Key tasks: - Data cleaning: Streamline raw survey data in preparation for analysis. - Statistical Analysis: Use SPSS to conduct extensive data analysis. - Report Writing: Create a comprehensive report detailing findings from the analysis. Ideal candidate profile: - Strong proficiency in SPSS - Excellent analytical skills - Experience with survey data and reporting - Familiarity with demographic datasets and correlational analysis - Strong understanding of moderating and mediating variables in research. This project offers an engaging opportunity to leverage SPSS for research analysis, providing valuable data points to guide fu...
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for ea...
...experienced Laravel developer who can help advance a personal accounting website I've started. The main functionalities needed are: - SASS functionality for website use - Managing and reporting transactions and bills - Help group transactions and subscriptions - Bank account synchronization via APIs. While I do want this function, I'm not locked into a specific bank API yet. I'm eager to hear your recommendations on this. - Reporting the synchronized transactions. The ideal candidate is someone with substantial experience in Laravel development. Specific skills in integrating banking APIs or creating data reporting features will be a plus. I've provided a full and detailed brief for the project. The very basics of the site has been started but...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, an...
...conditions (each associated with a specific percentage) using a dropdown menu. Based on the user's selection, calculate an average of two predefined percentages and multiply this average by the retrieved material quantity. Key Deliverables: Functional Revit plugin that seamlessly integrates with Revit 2024. User-friendly interface displaying retrieved quantities and options for percentage selection. Automated calculations based on user inputs. Timeframe: Skills Required: Proficiency in C# programming and Autodesk Revit API. Strong understanding of Revit scheduling and data retrieval. Experience in developing custom user interfaces for Revit plugins. If you meet the requirements and are interested in this project, please submit your proposal detailing: Relevant experi...
...efficient responses to specific triggers in my business. Key Requirements: - Develop a robust Zapier automation that's responsive to Bark triggers - Tailor triggers to specific events, including: - End of Tenancy cleaning - Commercial cleaning contractors - Office cleaning - Moving out cleaning Skills and Experience: - Proficiency in Zapier, with a proven track record of building automated workflows. - Familiarity with Bark or similar platforms for setting up triggers. - Strong communication skills to ensure the automation is in line with my business needs. It's important that the freelancer I hire has a proactive approach and can suggest improvements to the automation setup. The selected candidate will have an opportunity to work on a project that h...
I need someone who can program a smart automatic lighting control system in C language, utilizing the TM4C123GH6PM Microcontroller. The system ...Prior experience in developing smart systems with motion sensing capabilities. - Understanding of energy-efficient programming and user interface simplicity. - Strong knowledge of response time optimization. Key Project Details: - The system should be able to detect motion and adjust lighting in two different zones accordingly. - It should incorporate time scheduling features that allow for automated lighting control. - Efficiency is a priority. It should be programmed to be energy-efficient while maintaining a simple and user-friendly interface. - Response time is crucial for this system to ensure the lighting adjustments are timely and ...
I'm seeking a coder who can create a custom script for my Airtable database. The primary functionality I'm after is the ability for the script to import and export da...Airtable form. Key requirements: The script must be able to read and parse out a paragraph of information from an Airtable form to effectively break out each payment. Ideal candidate will have: - Profound experience with Airtable: You should be well-versed in Airtable's functionalities and have hands-on experience creating custom scripts. - Scripting expertise: Strong background in creating automated scripts for data import/export tasks, particularly within the Airtable environment. - Attention to detail: The ability to ensure that the script operates accurately and that data integrity is maintaine...
...will be comfortable with Shopify's Liquid and API requests, and able to implement the following features: - Product filtering: I want to make it easy for my customers to find the product they are looking for. - Shopping cart: Ensuring the checkout process is smooth and user-friendly is crucial to me. - Chat functionality: I want to have chat functionality for customer support and engagement. - Automated product catalogue updating: I want a system that will automatically update the online catalogue with new products and changes. - Social media integration: It's important to me that my website is easily shareable and that my customers can connect with us on various social media platforms. -Website devlopment: I want the website to look nice and professional The target a...
I am in need of a skilled developer with experience in creating automated trading algorithms for the Interactive Brokers platform. The goal here is to design an algorithm that will execute trades according to a set of custom rules I've established. Key requirements and expectations for this project include: - The algorithm needs to be developed in Python - Trades should execute on Interactive Brokers and plot custom rules on TradingView. - Custom rules are provided by the client and not based on common indicators like Moving Average Crossover or RSI. - No manual intervention required; trades solely based on custom rules. - Experience in optimizing entry and exit orders for large orders or low liquidity scenarios required. - Trading signals, such as support and resistance line...
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
...accomplished LinkedIn manager to oversee and innovate my account. Your primary tasks would include post creation, connecting with professionals in my industry, and monitoring & reporting on the account's performance. Tasks: - **Post Creation:** You'll be responsible for creating engaging posts that resonate with my target audience. These should be creative, relevant, and portray a professional image. - **Connection Building:** Your ability to establish and maintain connections with other professionals in my industry is key. The aim here is to expand my network and foster valuable connections. - **Monitoring & Reporting:** Regularly monitoring the account's activity and performance metrics is crucial. You'll need to provide me with detailed repo...
I need an expert in Linux, particularly in the use of SSHFS for remote file access, to expand my existing blog article. The aim is to provide my readers, who are at an intermediate level in their understanding of Linux, with a comprehensive tutorial. Key tasks include: - Detailing the process of automating remote file system mounting using SSHFS in Linux - Providing step-by-step instructions accompanied by useful screenshots to aid comprehension - Ensuring that the tutorial aligns organically with the tone and style of the existing blog article The ideal freelancer for this assignment will have proficient knowledge of Linux, SSHFS, and tech writing skills, with a knack for simplifying complex tech concepts. Additionally, I'm going to share the original blog so that the freelancer c...
I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.
As a recruitment firm, we are in need of a customized, interactive recruitment tracker. It should primarily support the following features: - Applicant tracking: it must meticulously log and monitor the progress of each candidate from application to hire or decline. - Interactive dashboard: An intuitive, easy-to-use dashboard that shows accurate data on the current number of applicants, job vacancies, and status of hiring processes is crucial. The ideal freelancer for this project should possess extensive experience developing similar HR tools, and have a keen understanding of data visualization for dashboards. Understanding recruitment processes is also a plus.
