Data laporan excel jobs
You will get a high-end and robust calendar based entirely on Excel! I have over ten years of experience in automating tasks in Excel using formulas and VBA code, and I know that a few automations at the right spots can simplify your daily routine, save you dozens of hours, and boost your performance while focusing on what matters! In the delivered calendar, you will have the option to customize the categories/personnel that will be assigned the tasks or appointments. Based on the selected version, more features are available, like customizing colors, attaching documents, exporting to PDF, and more.
I'm looking for an Excel whiz to help me set up a daily activity log. The log needs to: - Track hours worked - Automatically calculate total hours - Include a section for lunch breaks only Ideal candidates should have: - Extensive Excel knowledge - Experience creating activity logs - Attention to detail
I need a C# program that can update the creation dates on files in SharePoint Online. The program should get datetime from an Excel (or CSV) file that I will provide. This Excel file will contain 2 columns : files path + datetime values (that should be set as the creation dates). Requirements : - Extensive knowledge of C# programming - Knowledge to connect to SharePoint Online (OneDrive) - Full source code must be release at the end of the project - All the intellectual property will be transferred, without any reserve, to the project owner (databird sàrl)
I'm seeking an Advanced Excel professional capable of creating comparative analysis charts and graphs for financial data, specifically comparing work progress. Key Requirements: - Remote work capability - Expertise in Excel chart/graph creation - Experience with financial data - Strong understanding of comparative analysis - Excellent ability to visualize complex data Ideal Skills: - Advanced Excel skills - Financial analysis experience - Data visualization expertise - Strong attention to detail - Excellent communication skills for remote work
I'm in need of an experienced MIS Executive to assist with a variety of tasks including data analysis and reporting, database management, and automation process improvement. The primary focus of the data analysis will be assessing operational efficiency. Key Responsibilities: - Analyzing operational data to identify areas for improvement - Managing and maintaining databases - Implementing automation for process improvement The ideal candidate should be proficient in Excel, as this is the preferred tool for sales data analysis. Experience with other data visualization tools such as Tableau or Power BI is a plus, but not a requirement. Your expertise should help drive operational efficiency and contribute to overall business success.
I have a sales rate sheet on paper that I need converted to Excel. I also need additional columns showing discounted rates, with the discounts calculated automatically at 12.5% and 15%. Ideal skills for this project include: - Proficient in Excel - Data Entry - Ability to work with physical documents - Experience with creating automated calculations in Excel
I am looking for an experienced Excel professional to create a dashboard for visualizing my sales data. The primary focus will be on utilizing charts and graphs to present the data in an insightful and clear manner. Key Responsibilities: - Develop an engaging and easy-to-navigate Excel dashboard - Use charts and graphs to visualize sales data Ideal Skills: - Proficient in Excel with extensive experience in creating dashboards - Strong understanding of data visualization techniques - Ability to present complex data in a simple, engaging manner
I'm seeking assistance with formatting an Excel spreadsheet for the reconciliation of an Employee Loan account. Key Requirements: - Expertise in Excel, particularly in spreadsheet formatting. - Experience with conditional formatting, table design and layout, and cell styles and fonts. - Understanding of account reconciliation processes. The successful freelancer will help me present the data clearly and effectively, allowing for a smooth reconciliation process. Your input will be crucial in organizing the data and highlighting key figures.
I need someone with access to Refinitiv Eikon DataStream to download data for all UK listed companies over the last 6 years. List of variables will be shared to the selected candidate. The ideal freelancer for this project should have: - Prior experience with Refinitiv Eikon DataStream - Expertise in financial data analysis - Proficiency in Excel Data Format: - I would like to receive the downloaded data in Excel format. Please provide your previous relevant experiences when bidding for this project.
I need an Excel expert to help me modify and randomize my data. The tasks include: 1. Changing all dates in the “Proc Date” column to only Tuesdays and Wednesdays from July 2024 to December 2024, excluding Christmas Eve, Christmas Day, and New Year’s Day. The dates can be random, in no particular order. 2. Updating the phone numbers in the “Phone” column to: (908) 730-8880 for the entire column. 3. Changing the address in the “Address of the Facility” column to: 1630 NJ-31, Clinton, NJ 08809 for the entire column. 4. Altering the ages in the “Ages of the Patients” column to random numbers between 12-89 for the entire column. 5. Modifying the name in the “Facility Name” column to: North Hunterdon Dental Associa...
I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.
I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data
...assignments, approvals, etc.). Email or in-app notifications when needed. Security & Permissions: Secure login with username/password (and optional 2FA). Ability to restrict data access on a role or department basis. Scalability & Performance: The system must handle a growing number of users, data, and transactions without performance issues. Cloud-Based (Preferred): Ideally accessible from anywhere via web browser. Option for on-premise installation if necessary. Reporting & Analytics: Comprehensive reporting tools for sales, financials, HR, tasks, and other modules. Ability to export reports in various formats (PDF, Excel, CSV). Multi-Language Support (Optional): If feasible, the system should allow localization for different languages. Integration: Po...
Retired senior needs help with keeping ongoing matters organized. Would need someone familiar with Word, Excel, willing to train for light duties in QuickBooks. At employer's residence (dealing with Parkinson's and really need some help) Personable, very laid back environment but employer needs help with filing, some calendaring, keeping appts straight etc, Offer needs to hire for a few weeks, maybe less.
...وبيانات سيتم تحديدها لاحقا الفروع: يمكن إضافة أكثر من فرع واحد لاستخدام هذا البرنامج مربع المسار: إنها مجموعة من الأسئلة. يتم تحديد عنوان الأسئلة ويتم وضع أكثر من سؤال واحد ويتم وضع أذونات للإجابة، سواء كان رقما أو كتابة أو تاريخا وما إلى ذلك. يمكنه إضافة أكثر من عنوان واحد داخل كل عنوان. أكثر من سؤال واحد (ستظهر هذه الأسئلة للشخص الذي سيستخدم النظام في شكل مربعات مملوءة (كل عنوان للأسئلة له ملف Excel أو نموذج تصميم خاص به. يتجاوز عدد عناوين الأسئلة 60 عنوانا أو أكثر ويندرج كل عنوان تحته. كل عنوان له وسيلة ولكل عنوان شكله أو نموذجه الخاص الذي يختلف عن الآخر. عند التنزيل، سيتم تزويدك بذلك (سيتم تزويدك بجميع الملفات ونريدك إدخالها مباشرة في النظام) مربع الإحصائيات: يمكنك اختيار أحد الأسئلة التي تم وضعها سابقا في مربع المسارات عن طريق الإدمان ثم تظهر جميع الأسئلة وفقا للعنوان ويحتوي...
I'm seeking an experienced freelancer to compile a detailed list of properties in a specified region. The project involves gathering and organizing property details in a comprehensive ...freelancer to compile a detailed list of properties in a specified region. The project involves gathering and organizing property details in a comprehensive and accurate manner. Requirements: - Exceptional accuracy and attention to detail. - Proven experience in data collection and organization. - Proficiency in Excel or Google Sheets for organizing property data. - Ability to research reliable sources. Deliverables: - A well-organized spreadsheet with all the required property details. If you have experience in real estate data collection or similar projects, please pro...
I'm in need of a proficient Excel expert who can design a custom Excel template for tracking my expenses. The main purpose of this template is to help me with financial tracking. Key Requirements: - Design a user-friendly Excel template with a focus on expense tracking - Incorporate built-in calculations or formulas for totals and subtotals Ideal Skills: - Proficient in Microsoft Excel - Experience in creating financial tracking templates - Strong understanding of expense tracking and budgeting Please, submit your proposal if you can assist with this task.
I need assistance with my Excel template for a UPS franchise. The template currently has projections and assumptions filled out, but I need help refining the future projections and assumptions with a strong focus on sales growth. Key tasks include: - Analyzing and refining future projections and assumptions - Assisting with sales growth predictions Ideal candidates should have: - Strong numerical skills - Proficiency in Excel - Experience with business projections - Understanding of franchise operations - Ability to interpret and analyze data
...terms. I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual cor...
I'm seeking a meticulous research expert to gather competitive pricing on Amazon, Walmart, and Wayfair. The task involves analyzing many product SKUs and descriptions, and in some cases, images. I need the following data for each product: - Competitor Pricing - Unit Sales - Number of Reviews The collected data should be presented in a clear and organized spreadsheet. Ideal candidates should have strong analytical skills, experience with market research, and proficiency in using Excel or similar spreadsheet software. A keen eye for detail and the ability to interpret product images is also a plus. I'm looking forward to your bids.
...looking for an experienced and skilled Data Analyst to design and build three real-time dashboards to monitor key performance indicators (KPIs) related to sales performance, customer engagement, and operational efficiency. These dashboards will provide daily, weekly, and monthly insights, seamlessly updating in real time without the need for manual data imports. While we are currently exploring Klipfolio, we are open to alternatives such as Google Looker Studio or similar platforms if they better meet our needs. Key Responsibilities: Design and build three user-friendly, real-time dashboards to track specified KPIs. Connect dashboards directly to DX1 data reports, Excel, and other relevant data sources. Enable real-time data updates to minimi...
I am seeking a skilled and Data Analyst to create comprehensive dashboards in Power BI for a financial project. The goal is to visualize and analyze key performance indicators (KPIs) that will help to make data-driven decisions and enhance financial performance tracking. Project Requirements: 1. Data Analysis & Visualization: o Analyze and structure financial data from various sources (Excel, SQL, etc.) o Create dynamic and interactive dashboards in Power BI to visualize KPIs such as revenue, expenses, profit margins, cash flow, and more. o Utilize data models, DAX, and Power Query to enhance the dashboards. o Provide clear insights and recommendations based on the dashboard data. 2. Customization and User Interactivity: o Develop filter...
I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual corrections t...
Hi! Usual conditions - four groups so €50 Have you got the excel file still?
I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compen...
I'm in need of custom Excel templates specifically designed for financial reporting. These templates will be used primarily for tracking and managing accounts receivable. Ideal skills for this project include: - Advanced Excel proficiency - Experience with financial reporting - Knowledge of accounts receivable management - Ability to create user-friendly templates
I'm looking for a freelancer who can help me automate the analysis of trading oi and volumes from the NSE using Excel. Key Tasks: - Automate the collection and analysis of NSE trading volume data within Excel - Use statistical analysis techniques to interpret the data The ideal candidate for this job should be proficient in Excel automation, have a strong understanding of statistical analysis techniques, and be familiar with NSE trading volumes.
I need assistance with using mathematical formulas in Excel, specifically 'Sum and Average' and 'Index and Match'. Your role will mainly involve data entry and creating charts. Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience with data entry and chart creation - Familiarity with mathematical formulas, specifically 'Sum and Average' and 'Index and Match' - Attention to detail and ability to work accurately.
I'm seeking a proficient web scraper to extract contact details from the provided website. Ideal Skills: - Proficient in web scraping tools and software. - Experienced in data extraction from company websites. - Deliver the extracted data in Excel format.
I'm in need of assistance with data entry into an Excel sheet. The data is of mixed types - both text and numeric. Key tasks include: - Manual entry from various files - Ensuring the data is organized into standardized rows and columns Ideal candidates should have: - Proficiency in Excel - Attention to detail to ensure accurate data entry and formatting.
I am in need of comprehensive data about lodges in the Serengeti ecosystem. This data should include both the latitude/longitude of these lodges and reviews. Your task will be to compile this information into an Excel spreadsheet. The completed data set will be used for a research paper, so accuracy and thoroughness are paramount. Ideal skills and experience for this job include: - Proficiency in data collection and analysis - Experience with Excel - Attention to detail - Ability to understand and meet academic research standards.
...routes. • Multiple map views with status indications (idle, parked, moving). • Real time fuel tracking via data from the vehicles original fuel gauge system. 2. Subscription and Payment Platform • Payment gateway integration for subscription renewals and package purchases. • Notifications for payment confirmations. 3. Advertisement Platform • Allow placement of ads for related services. • Dynamic ad slots for targeted promotions. 4. Device API Integration • Support for APIs from various tracking devices (e.g., Cantrack, Teltonika, Tramigo, Fifo, Baanooliot). • Real-time reporting and seamless communication. 5. Reports and Analytics • Graphical, Excel, and PDF report formats. • Exportable data for vehicle status, trip...
I'm in need of an Excel expert to help me create a comprehensive savings tracker. This spreadsheet needs to have a variety of features and capabilities to assist in monitoring and managing my savings. Key Requirements: - The spreadsheet should automatically calculate various components, reducing the need for manual input and increasing efficiency. - It should have a user-friendly dashboard that presents key information clearly and succinctly. Calculations Needed: - The tracker should be able to calculate my monthly savings. - It should also project my total savings over a set time period. Ideal Skills: - Proficiency in Excel is a must, with experience in creating similar spreadsheets highly desirable. - Ability to design intuitive dashboards within Excel. - Str...
...implement a tailored solution that will replace my current project management setup, which includes Trello boards, Excel spreadsheets, and physical files. Key functionalities include: - Central Hub for all contacts - Accounts board to manage deals from inception to completion - Integrated management system for contacts, leads, sales, projects - Dashboards Currently, we don't have a dedicated CRM software. Customer and project management is done manually and is becoming increasingly challenging. Therefore, the ideal freelancer for this project should have: - Extensive experience with monday.com. - Strong understanding of CRM systems. - Good knowledge of data analytics and task management tools. - Excellent design skills to create a user-friendly interface. - The ...
...tariff document. This PDF includes company details, a tariff table (with vehicle types, sizes/capacity, prices, and minimum charges per mile), our logo, and a footer with contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members to manage the content. If you’re able to provide this servi...
I'm seeking a meticulous freelancer to help me input mixed data (text and numerical) from paper documents into a single Excel worksheet. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Experience in data entry from paper documents - Able to handle mixed data (text and numerical) - Familiarity with OCR software to convert printed or handwritten text into machine-readable data. - Expert in verifying data entries for accuracy and completeness. - Proficiency in organizing and managing files to ensure data is easily accessible. - Basic mathematical skills to handle numerical data accurately. - Ability to handle sensitive information with a high level of confidentiality. The project involves less than 100...
I'm seeking a skilled Excel professional to design a comprehensive scheduling spreadsheet for managing project timelines. Key Requirements: - The spreadsheet must be created in Microsoft Excel. - It should include drop-down menus that are linked to if/then statements, filling in information on additional sheets as necessary. - The main project timeline sheet will need to capture task names and descriptions, start and end dates, assigned team members, and a tool and material list. - The tool and material items should be linked to task descriptions. The spreadsheet will be designed to be as user friendly as possible. The Goal is to autofill as much as possible and use repetitive task lists to create a material and tool list preparation guide. This is the most difficul...
Seeking data collection specialist for 3D printing price research across 30 to 40 online platforms. Project involves: Collecting pricing data for various 3D printed parts (7 different sizes) Comparing quotes across multiple technologies (SLS, MJF, FDM, Metal L-PBF) Documenting prices for different materials (plastics and metals) and quantities (1-1000 units) Creating structured Excel dataset with 9 columns including platform details, manufacturer info, technology specs, and total costs Documenting inaccessible platforms and URL changes Deliverables: Excel file with comprehensive pricing data Protocol document noting platform accessibility issues Timeline: Due by February 15th Required skills: Data collection, Excel, Basic understanding o...
take mp4 as input, convert mp3 and do RAG , use pinecone to upload vector. and save answers in excel file according to questions in local folder.
As we deal will Convert Anki .apkg to Excel with 10$
Automate Your Adobe Workflow with Custom Scripts I specialize in developing automation scripts for Adobe applications like Photoshop and Lightroom. I can automate any task possible within Adobe applications, enabling it to be repeated hundreds of times with precision. Whether you need to streamline repetitive tasks, integrate external tools (Excel, Word, etc.), or create a fully-featured automation with a user-friendly interface, Ive got you covered. My scripts save time, reduce errors, and boost efficiency. Each solution is tailored to your specific needs, with fast delivery, clear documentation, and professional support. Lets simplify your workflow and take your productivity to the next level! Every solution is custom-built to your requirements. If you record a video showing the...
Extract data from website and export in excel sheet
I'm looking for a Excel expert who can help me automate the extraction of data from 3 different PDF formats. Requirements: - Create 3 different Power Query scripts to extract both text and table data from PDFs located in a specified folder. - The extracted data should be saved into multiple Excel files. - Implement simple data transformations such as sorting and filtering after extraction. Ideal Skills: - Expertise in Excel, Power Query and PDF data extraction. - Experience in creating scripts for data automation. - Knowledge of simple data transformation techniques.
I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.
I need help with web scraping from a specific e-commerce website. The goal is to gather comprehensive data for product analysis. Key Data Points: - Product details - Pricing information - Stock levels - Minimum order quantities - Delivery times - Specific product information as detailed on the sites The extracted data should be delivered in an Excel format. Ideal Candidate: - Proficient in web scraping tools and techniques - Excellent data analysis skills - Familiar with e-commerce platforms - Able to deliver clean, well-organized data in Excel Looking forward to your proposals. The website would be the following and we would like to see the details for all manufacturers listed:
More details: What specific tasks do you want the macro to perform? Data analysis, Data formatting Do you need the macro to run automatically under certain conditions? No, I'll run it manually What level of user interaction do you foresee with the macro? Simple prompts and inputs
...every subscriber - Be authentic and chat like the girl would - Improvise fictional sp1cy scenarios and build rapport with top spenders Requirements needed: - You need to be able to chat fluently in English - A laptop/computer with reliable internet - Comfortable with sp1cy content and engaging in improvised fictional conversations - 0F Chatting experience is a MUST - Familiar with Excel Spreadsheets (This is what you will use to track your sales and commission) - - - Able to work from 8pm-1am AEDT 6 days/week (These hours may change) Payment: - AUD$4/hr + 3% Commission on all of your sales and tips generated - Your commission is uncapped and there is potential for wage increase based on proven excellence. - Paid weekly every Wednesday Hours: - 5hrs/per day...
I'm in need of a skilled professional to assist with data collection and verification from a trade fair website. The aim is to enhance my sales outreach efforts. Tasks will include: 1. Checking the exhibitor page for company names and existing contact details 2. Searching for missing information on the internet 3. Finding and adding LinkedIn profiles of individuals in top and mid-management positions within these companies Ideal candidates should have: - Excellent research skills - Proficiency in data collection and verification - Familiarity with LinkedIn and able to identify relevant profiles - Understanding of sales outreach processes Excel format will be given to collect the data.
...tariff document. This PDF includes company details, a tariff table (with vehicle types, sizes/capacity, prices, and minimum charges per mile), our logo, and a footer with contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members to manage the content. If you’re able to provide this servi...
...focusing on top level executives and department heads in healthcare organizations, private hospitals and fintech firms. You could choose a market and go from there, 200-5000 employees enterprises must be targeted. - Deliver a well-organized contact list for potential business outreach with emails ( excel ) Ideal Skills: - Proven experience in lead generation and market research using LinkedIn and similar tools. - Strong understanding of how to conduct market research and leads generation. - Excellent data organisation and presentation skills. - Strong communication skills for potential follow-up correspondence. Please submit your proposal if you have the required experience and skills. This is a bid just for initial list of validated leads, if we see your potential t...