I'm searching for a proficient Data Analyst to assist in organizing and managing data for our online classes. The data will primarily include: - Attendance rec...extensive experience with Google Sheets, as these are the primary tools for data management. Key Responsibilities: - Data entry and organization: Ensuring all data is logged accurately and systematically. - Generating reports and visualizations: Creating clear and informative reports and visualizations to help understand trends and insights from the data. Skills and Experience: - Proficient in Excel/Google Sheets - Prior experience in data entry, organization and report generation - Ability to create visualizations from data I'm looking for someone who can help us make sense of our data and ultimately improve...
I need assistance in fixing an Excel file. The main issue I'm encountering is creating formulas, specifically logical functions such as IF, AND, OR. The primary goal of using these functions is to categorize data. Ideal Skills: - Proficient in Excel with a strong understanding of logical functions. - Experience with data categorization in Excel. - Ability to troubleshoot and fix formula errors.
...Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de Excel 2. Dos idiomas ingles y español Control de planilla 1. Salarios 2. Cargos 3. Vauchers...
I'm in need of an experienced Excel specialist to build a comprehensive customer database, with fewer than 300 customers of a meal delivery program. This database will be primarily for tracking customer records, and will also include various customer-related information that can be summarized with pivot tables, monthly and annual reports. The database should store: -Customer Name -Customer Address - Contact details -Special requests -Allergy alert information - Service history -Delivery route number -Delivery route order (in what order are the deliveries made) - Feedback and complaints Furthermore, I need this database to produce various reports. Specifically, I need it to assist with: - printing production orders - generating monthly government reports - integrating with b...
Es una App que busca unir a los proveedores de servicios de Mantenimiento (Carpinteros, Albañiles, Cortadores de Arboles, Plomeros, Electricistas, etc), con clientes que requieran alguna solución inmediata a precio razonable. Al descargar la aplicación el usuario deberá elegir que es….. si Proveedor ó...Contar con mensajería, entre cliente y proveedor. • Almacenar fotografías o video por cotización o solicitud de trabajo. • inglés y en Español. • Manejar expediente para proveedores y expediente para clientes. • Pago en línea para suscripción de proveedores. • Calificación de clientes y proveedores. • Table de Control para el Administrador • Base de Datos de P...
I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should i...
I'm seeking an Excel professional with expertise in financial modeling, specifically for budget forecasting. The project involves analyzing financial data and crafting precise models to support the forecasting process. Ideal Skills: - Advanced Excel skills, particularly in financial modeling. - Experience with budget forecasting. - Strong data analysis capabilities. - Familiarity with financial data. The successful freelancer will have a proven track record in creating accurate and effective financial models in Excel. Your role will be vital in assisting with future budget planning.
Disclaimer- this information, leads and and company is to stay private. Job Title: Lead Generation Specialist | Pre-Qualified Leads for Digital Services Job Description: Full service Digital marketing company is seeking a Lead Generation Specialist to find and deliver pre-qualified leads for website development, SEO, and digital marketing services. Our focus is on Alberta-based businesses, with Canada-wide opportunities. We’re looking for someone who can: - Research companies actively searching for these services via job postings, ads, or RFPs. - Pre-qualify leads by identifying companies with outdated websites, poor SEO, or unmet digital needs. - Provide decision-maker contact details (owners, managers, or marketing directors). --- Deliverables: A weekly li...
I'm looking for a part-time assistant to help with a simple data-entry task. The task involves reading data from a TradingView chart and transcribing it into an Excel spreadsheet. Key Details: - The task will take approximately 5-8 hours to complete and needs to be repeated every week. - You have the flexibility to choose the day and time of the week to perform the task. - An initial 1 hour training/demonstration via video call (either Skype or Signal) is required. - You should be able to understand spoken English, particularly my Australian accent. Please provide your hourly rate.
I'm looking for a way to calculate the totals in a specific cell within a bunch of worksheets all within the same Windows folder. Key Requirements: - The workbooks I want to sum from only contain one sheet each. - I want to specify the cell to sum by cell reference (like A1) Please let me know if you can help.
I need assistance with transferring data from a Word file to an Excel file. - Content: The Word file contains text only, with approximately 200 line items. - Task: Copy and paste each line item from the Word file including the headers into the D column of the excel file. - Text Wrapping: Ensure to wrap the text so that everything fits into Column D. - Starting Point: Begin placement at row 321 in the Excel file. - Formatting: Bold all headers in the Excel file, no other additional formatting is needed. Please ensure no line is missed in the transfer. Ideal skills for this project include proficiency in Excel and attention to detail. Previous experience with data entry is a plus.
I'm seeking a proficient Excel expert to update my spreadsheet. The task primarily involves working with existing formulas and performing statistical analyses. Key Responsibilities: - Update formulas in various tabs based on new data. - Conduct statistical analysis similar to what's already present in the spreadsheet. Ideal Candidate: - Strong proficiency in Excel, specifically with formulas and calculations. - Experience with statistical analysis. - Attention to detail to ensure all updates are accurate and consistent.
I'm looking for an Excel expert to help me match a specific value X in my data and list the adjacent values to the right. Key Details: - Data Format: The data is in an Excel sheet. - Scope: I need values from 12 columns to the right of the matched value X. -If selected supplier, then bring that selected supplier information to the final selected supplier area. - Output Format: The results should be placed in "Final Selected" range Ideal Skills: - Proficient in Excel and data manipulation. - Experience with matching and filtering data. - Ability to clearly communicate progress and results.
I am looking for an experienced Financial Analyst with advanced Excel skills to collaborate on my project. Specifically, I am interested in purchasing pre-built, high-quality financial models that are robust, user-friendly, and professional. These models should cater to the needs of accounting and finance professionals. Examples of the types of models I’m looking for include: Cash Flow Forecasts Budget Templates Budget vs Variance Analysis KPI Dashboards for Finance or Accounting Financial Analysis Models CAPEX Trackers Requirements: Models must be dynamic, well-structured, and easily customizable. Must include detailed formulas, assumptions, and visualizations (if applicable). Ideally suited for use by accountants, finance managers, and analysts. You must have the legal ri...
I have an Excel spreadsheet of companies and need someone to find their respective domains and add them to the spreadsheet. Requirements: - Find the domains of each company in the list - Add the domains to the existing Excel spreadsheet - Perform basic verification of the domains for accuracy Ideal Skills: - Proficient in Excel - Internet research skills - Basic understanding of domain verification processes - Attention to detail
I need an expert in Excel to create an interactive dashboard using three data sources from multiple sheets. This sheet is heavily used by multiple users on a daily basis. Prior to going live, I'd like a 'beta' version to be completed. Key Requirements: - Incorporation of bar charts and timeline sliders for visualizing the data in a dashboard Ideal Skills: - Advanced Excel capabilities with a focus on data visualization - Experience in creating interactive, user-friendly dashboards - Knowledge of various chart types, particularly stacked bar charts (showing progress on a set goal) and timeline sliders - Understanding of data integration and presentation options. Please note, the goal is to create a dashboard that is not only informative but also intuitive an...
...Professional Data Entry, Excel Management, and Photo Editing Services As a skilled Data Entry Operator with extensive experience in handling various types of data, I offer fast and accurate data entry services to ensure seamless management of your information. I specialize in organizing and inputting large volumes of data into spreadsheets, databases, and other systems. My ability to maintain consistency and accuracy is crucial for any project that requires timely completion. In addition to data entry, I provide expert Excel management services, specifically for handling protein data. Whether it's for scientific research, dietary tracking, or nutritional analysis, I can structure and organize protein-related information efficiently. I am proficient in using Excel...
I'm seeking an experienced designer or stone mason to create a comprehensive printed A5 booklet catalog featuring stone masonry projects. The focus should be on both residential and commercial stone masonry. Ideal Skills and Experience: - Expertise in stone masonry or design - Prior experience in creating similar catalogs - Print design experience, particularly for A5 booklets - Knowledge of both residential and commercial stone masonry - Strong attention to detail
i have two of my suppliers websites that i need product data scrubbed and put into an excel sheet. All the images need to be saved to a file with product code label.
I'm an Ontario, Canada-based user experiencing issues with my newly installed DaVinci Resolve 19.1.2. Upon launching the software, I encounter three pop-up messages relating to cache, gallery, and capture locations. These pop-ups are hindering my ability to record audio. I need a professional with expertise in DaVinci Resolve and Windows systems to: - Diagnose and rectify the pop-up issues. - Ensure that the software is correctly set up for use. The ideal freelancer for this project should: - Have extensive experience with DaVinci Resolve. - Be proficient in troubleshooting Windows software issues. - Be able to provide clear and concise explanations of the solutions implemented.
...data being stored and retrieved from a database. Key Project Requirements: - User Roles: The site will have two levels of user access control: Admin and User roles. - Financial Tables Functionality: Users should be able to add, edit, and delete entries, filter and search data, and generate reports on financial tables. - Data Handling: The site will allow for manual upload of Excel files and exporting data to Excel for further analysis. The pages of the site will include: 1. Categories and Pricing: Displaying items, prices, buyers, sellers, and profit margins. 2. Account Assets and Expenses: Summarizing the account's assets and expenditures. 3. General Account Information: Showing overall account details. Ideal Skills and Experience: - Proficiency in PH...
...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Completed and running in the hosting server. Recourses : Website is using wordpress . Microsoft 365 suite , hosting ( hostgator - Cp...
...records and documentation. Assist with payroll processing and reporting. Liaise with external auditors, tax advisors, and financial institutions as needed. Qualifications: Bachelor’s degree in Accounting, Finance, or a related field (preferred). Proven experience as an accountant, bookkeeper, or in a similar financial role. Proficiency in accounting software (e.g., QuickBooks, Xero) and Microsoft Excel. Strong understanding of accounting principles, practices, and regulations. Excellent organizational, analytical, and problem-solving skills. High level of accuracy and attention to detail. Strong written and verbal communication skills....
I'm looking for a professional who can create a comprehensive spreadsheet for my locksmith business, focusing on financial tracking. The primary purpose of this spreadsheet will be to monitor weekly pay, monthly expenses, and year-t...monthly expenses, and year-to-date totals. Key Requirements: - The spreadsheet should be user-friendly and able to provide rolling totals. - Depending on the final design, the spreadsheet may need to generate reports automatically, so a versatile approach is preferred. - It should be able to accommodate both manual input and potential future automation. Ideal Skills: - Proficiency in Microsoft Excel or Google Sheets. - Experience with financial tracking and report generation. - Previous work with small business or service industry spreadsheets w...
I'm in need of a skilled Excel professional for data analysis. I have a dataset ready for analysis. Please note that the specific type of analysis hasn't been predetermined, so flexibility and expertise in various types of data analysis will be beneficial. Ideal Skills and Experience: - Proficient in Excel - Strong data analysis skills - Experience with various types of data analysis - Able to deliver insightful interpretations of the data
I'm looking for an expert in spreadsheet development to build a custom Excel sheet for tracking progress claims on construction projects. Key Features: - Automatic calculations: The sheet should be able to compute totals, subtotals, and other necessary financial figures without requiring manual input. - Customizable templates: The spreadsheet should be template-based, allowing for easy customization to suit different projects. Ideal Skills: - Proficiency in Excel with a strong understanding of its advanced features (formulas, pivot tables, macros etc.) - Experience in construction project financial tracking would be a significant advantage. - Ability to create user-friendly, customizable templates. - The data in the current pdf spreadsheet does not need to be fully rep...
...Dashboard: View, approve, or reject KYC submissions. Status updates (e.g., Pending Verification, Approved, Rejected). Alerts for incomplete or flagged applications. Risk Assessment: Automated risk scoring based on customer details. Alerts for high-risk customers. Compliance Features: Integration with AML guidelines (e.g., audit trails, reporting tools). Exportable compliance reports for audits (Excel/PDF). Security: SSL encryption for all data transfers. Role-based access control for admin and user roles. GDPR/Privacy law compliance for data storage and handling. Additional Features: Real-time email/SMS notifications. Analytics for KYC trends and risk metrics. White-labeling options for businesses to use their branding. Technical Preferences Frontend: Responsive design (HTML...
...out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1- Deliverable: 131,050 rows - - DFW-USA: From the 22 US Universities listed, collect 50 professors / Instructors and 1,000 students (BS, MS, and Ph.D.) contac...
...out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1- Deliverable: 131,050 rows - - DFW-USA: From the 22 US Universities listed, collect 50 professors / Instructors and 1,000 students (BS, MS, and Ph.D.) contac...
...of an Excel-Based Budgeting and Monitoring Tool for Construction Projects (WBS-Based) Description: We are seeking an experienced freelancer to create a budgeting and monitoring tool for construction projects, designed exclusively in Microsoft Excel. The tool must be based on a Work Breakdown Structure (WBS) and include task and activity management, rather than focusing solely on resources. Required Skills: • Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. Expected...
I need to find and compile contact information for 382 Conveyancing Solicitors and 313 Probate Solicitors within 25 miles of MK45 1AH. Requirements: - Data scraping expertise - Excel proficiency for data organization Task Breakdown: 1. Gather a list of 382 Conveyancing Solicitors and 313 Probate Solicitors using data scraping techniques. 2. Compile their details (Name, Company Name, Company Address, Phone Number, Email) into a spreadsheet. The email should be sourced from their respective websites. 3. Categorize the solicitors' data based on their type - "Conveyancing", "Probate", or "Conveyancing/Probate" (for duplicates). 4. Organize the entire list by distance from the postcode MK45 1AH. Please note: - The ideal freelancer should have experie...
I'm looking for an Excel expert to create a comprehensive Excel sheet for my team's workload analysis and look-ahead program. Key Functions: - Workload Distribution: The sheet should help in distributing tasks evenly among team members based on their capacity and skillset. - Progress Tracking: It should allow us to monitor the progress of each task and project. - Deadline Reminders: The sheet should have a mechanism for reminding us of upcoming deadlines. The sheet will be used exclusively by my team members, so it needs to be user-friendly and intuitive. No integration with other software or tools is required. Ideal Skills: - Advanced Excel skills - Experience in creating workload analysis tools - Understanding of project management principles and tasks ...
I'm working on Excel export feature.
Automated Investment Management Tool for Rupeezy Broker (Phase 1: Buy/Sell Automation) Project Description: The objective of this project is to develop an Excel-based or standalone software solution integrating Rupeezy broker APIs. This Phase 1 focuses on automating basic Buy and Sell functionalities, along with real-time reporting, margin trading calculations, and investment tracking. Additionally, the tool will include a feature to automatically calculate target price adjustments based on user-defined profit percentages and margin costs, executing orders daily when conditions are met. Phase 1 Requirements: Core Features API Integration: Integrate Rupeezy broker APIs using: API Documentation GitHub Library Securely connect to the broker's platform for real-time data and o...
I'm seeking a meticulous data entry professional to help with organizing and validating customer data. The data is currently in Excel/CSV files and requires detailed validation for accuracy. Key Responsibilities: - Input, sort, and organize customer data with precision. - Perform detailed validation checks to ensure data accuracy. - Assist with data management and reporting as needed. Ideal Skills: - Exceptional attention to detail and accuracy. - Proficiency with Excel/CSV files. - Experience with data entry and quality control. - Strong administrative support skills. With over 24 years of experience in administrative roles, including expertise as a Steno-Typist, Personal Assistant, and Admin Manager, I am confident this project will be a success. I look forward to...
I'm seeking an expert in Microsoft Excel to create a dynamic and visually appealing sales analysis dashboard for my bicycle business. This tool will help in understanding various performance metrics, and ultimately, in making informed business decisions. Key Features: - Incorporation of specific metrics: Sales trends by month, Profitability by product, and Customer demographics. - Exclusive use of Pie charts for data visualization. - Implementation of advanced data analysis techniques: Forecasting future sales and Seasonal trend analysis. The ideal candidate will have extensive experience in data analysis and visualization using Excel, with a strong understanding of business metrics. Prior experience in creating interactive dashboards will be a significant advantage. P...
I am seeking a skilled data analyst with a strong background in prescriptive analysis, utilizing Excel spreadsheets and SQL databases. The primary focus of this project is to conduct a thorough examination of our data for market research purposes. Key Responsibilities: - Conduct prescriptive data analysis to aid in decision making - Utilize Excel and SQL for data manipulation and examination - Deliver insights that can influence our market strategy Ideal Skills: - Advanced Excel and SQL proficiency - Expertise in prescriptive data analysis - Experience in market research analysis Please include your relevant experience and examples of similar projects in your bid.
I'm seeking a detail-oriented professional to assist with entering customer data from Excel spreadsheets into our database system for my existing business. Key Responsibilities: - Accurately input customer data from Excel into our database system. - Maintain confidentiality and handle sensitive information responsibly. - Ensure data integrity and consistency throughout the process. Ideal Skills and Experience: - Proven experience in data entry, particularly with customer data. - Familiarity with Excel and database systems. - Excellent attention to detail and a commitment to accuracy. - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking a freelancer to collect contact details of 2000 Canadian farmers from the internet. The details should include: - Email addresses - Phone numbers - Mailing addresses The farmers can be from all over Canada, but particularly from Ontario, British Columbia, and Quebec. I'm interested in contacting: - Crop farmers - Livestock farmers - Mixed farming operations - Dairy Farms - Fishing Companies - Importers of Fruit & Vegitables Ideal skills and experience: - Proficiency in data collection and internet research. - Experience in compiling databases. - Understanding of the farming industry will be an advantage. Please ensure the data is accurate and well-organized.
I'm seeking a skilled professional to help with mixed data types (text and numerical) collection and organization. Ideal Skills: - Proficiency in data collection methods and tools. - Excellent organizational skills. - Ability to handle and organize mixed data types.
I'm looking for a data-savvy freelancer to help me gather information on software and AI influencers. The primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social media platforms - Att...primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social media platforms - Attention to detail - Ability to present data in a clear and organized manner The data should be presented in a Spreadsheet (Excel/...
I need a proficient Android app developer to create a telecalling application. The app's main function will be for lead generation. Key Features: - Admin Panel: A separate web-based dashboard where I can upload contact details from an Excel sheet. - Click-to-Call Functionality: The app should display contact details for easy dialing. - API Integration: The app must utilize the Gsm (Phone SIM) for calling. - WhatsApp API: To send messages to end users directly from the app. - Feedback Mechanism: Incorporating a call disposition mechanism to capture conversation feedback through predefined options. - Tracking Features: The app should monitor total calls dialed, average talk time, and various call statuses (completed, missed, lead, callback, prospect, etc.) - Reporting: An admin ...
...for businesses across Canada by scraping a number of websites. This will be a multi-stage project. You will find businesses’ contact details from five types of websites, with each type being a stage in this project: Stage #1: Municipality websites Stage #2: Chamber of Commerce websites Stage #3: Business Improvement Area (BIA) websites Stage #4: Niche business directories Stage #5: Business associations ** NOTE: This first project only concerns the first type of website: Municipality websites. Once this stage is completed, I will move on to the second stage (Chamber of Commerce websites) ** Here is exactly what you will do in this first stage, step-by-step: Stage #1: Municipality websites: a) You will scrape the website for every municipality (i.e. city) in Can...
I'm in need of a person to create an Excel catalogue for my collection of 78 RPM discs. (had to re post as images and uploads did not come through on prior post) With 203 images to work from, the catalogue will need to encompass several key pieces of information which is available on the image of each disc including the artist, song title, record label, catalogue number, genre, unique identifiers, and any other relevant details observable from the images. The final catalogue will also need to include a condensed size version of each photo. - Artist - Song Title - Record Label (exact wording) - Catalogue Number (if applicable on disk) - Genre (basic classification e.g., Jazz, Blues) - Unique Identifiers (full transcriptions of labels) - Any other information found on each pho...
I'm looking for someone proficient in Microsoft Excel to assist with data entry. The data is mixed - both numeric and text. Key Responsibilities: - Accurately input mixed data into Excel - Perform basic data validation checks to ensure accuracy - Report any discrepancies in the data Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Ability to perform basic data validation checks Experience with data entry and Excel is a must. I look forward to your bids.
I need an expert to help me through some excel questions for about an hour on a zoom call. My main goal for the call is: - Creating new formulas The ideal freelancer for this project should have: - Extensive experience with Excel, particularly with creating mathematical operations - Excellent communication skills for a seamless Zoom interaction - Patience and ability to explain complex concepts in a simple way
I'm seeking an experienced SQL developer to write a MySQL query for me. The task involves combining two data tables based on a specific column, with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the dat...with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the data based on the item_id column. - Filter the data based on the Sales Group. - Ensure the query is compatible with MyPHPAdmin. - The final output needs to be exportable to Excel. Ideal Skills and Experience: - Proficient in SQL and MySQL. - Prior experience with data integration tasks. - Familiar with MyPHPAdmin and Excel...
