Install macro excel jobs
...entry skills, you can include additional skills such as using Excel formulas or knowledge of accounting software. * Define the completion time: Provide a realistic completion time estimate. * Define the budget: Indicate the budget range you have prepared. Data Entry Freelancer Required for 2024 Financial Budget Project We are looking for a meticulous and efficient data entry freelancer to help us enter 2024 financial data into a spreadsheet. This project includes: * Data: 2024 company transaction, expense, and revenue data. * Format: Data will be provided in Excel format. * Time: Project is expected to be completed within 2 weeks. * Skills: Experience in data entry, a basic understanding of accounting, and the ability to use Excel formulas are a plus. If you are i...
I've got an Excel dataset of 3500 parts that needs to be linked with their corresponding part drawings in the parts manual, which are all available as digitized PDF files. Ideal skills for the job include: - Proficiency in Excel - Attention to detail for accurate linking - Familiarity with handling and interpreting part drawings from PDF files The goal is to create a comprehensive and user-friendly reference that connects each part to its corresponding drawing.
Design and develop a custom Excel solution tailored to data analysis. The project will include advanced visualization through dynamic dashboards, robust data analysis using formulas and pivot tables. Key deliverables will be a user-friendly, interactive tool and provides actionable insights.
...a reputable university in Marketing, Communications, or a related field. Demand generation experience with proven success in driving business growth. Why Join Us? Work remotely for a leading US-based SaaS company. Collaborate with a global team of professionals. Opportunities for professional growth and skill development. Inclusive work environment where talented females are encouraged to excel. Application Instructions: Qualified candidates from Pakistan who meet the requirements are encouraged to apply. Please submit your updated resume and a cover letter outlining your relevant experience and achievements. No agencies allowed....
...a Native Speaker or a Non-native speaker with a level of C1-C2) and has the ability to write and refine texts not only for my blog but also for SEO optimization. If you possess expertise in adjusting language with precision, I would like to discuss further with you. Attention to detail and meeting deadlines are paramount. If you are passionate about the process of Copywriting and Rewriting and excel in working independently, please do not hesitate to reach out to me! I have a consistent workload of Copywriting & Rewriting each week, and the benefits are quite favourable. Let's collaborate effectively! If you: ✓ Have advanced proficiency in Greek, ✓ Can communicate ideas clearly, fluently, and logically, similar to a native or bilingual speaker, ✓ Are knowledgeable abou...
I'm looking for a proficient Excel expert who can help me develop a basic Rental Asset Inventory Management workbook with some automated calculations. Key Features: - ITEM LIST: This sheet should include Item ID#, Description, Last Purchase Date & Last Cost (both pulled from the transaction list), book Quantity (calculated from transactions), Asset Item and Total Values. - ITEM TRANSACTIONS: This sheet should include Date, Item ID#(drop down list), Supplier Name (drop down list), Supplier Invoice #, Action (Drop Down List -- Purchase+, Rent Out-, Rent Return+, Writeoffs-), Costs (for purchases). Requirements: - The workbook should have some automated calculations, but not to the extent of needing macros. - Item quantities should be automatically updated from transactions...
...Handling: Interact with Excel/Google Sheets for input/output and process scraped or external data. Publishing Automation: Automatically publish content into WordPress pages, posts, custom post types, and WooCommerce products. Integration with Tools & APIs: Seamlessly connect with external tools like ChatGPT, Stable Diffusion, , Apify, and more. Core Plugin Features: 1. Compatibility with WordPress Plugins: Elementor & Elementor Pro ElementsKit Addons Plugin RankMath & RankMath Pro WooCommerce Classic Editor Plugin WP Block Editor 2. Integration with APIs and Tools: AI Tools: ChatGPT API, MidJourney API, Stable Diffusion API Automation Tools: Apify, , Pabbly, n8n Data Sources: Excel, Google Sheets, Microsoft Excel 3. Automation Scenarios: Scenario 1: Proc...
...Atelier LinkedIn Feedback avant lancement séquence Durée : Semaines 2 à 3 (du 27 janvier au 7 février) → Lancement des séquences sur les canaux Mailing et LinkedIn (RUN) Définition des objectifs et des prochaines étapes Suivi des séquences existantes et itération de la stratégie Enrichissement des bases de données. Production de nouvelles séquences, bases de données, etc. REX Mensuel (Analyse macro du projet) Durée : À partir de la semaine 4 (à partir du 10 février) Outils attendus : - Le freelance doit maîtriser les outils nécessaires pour une stratégie outbound performante, notamment : Génération et enrichissement de bas...
I have a list of addresses in an Excel file that need to be formatted and transferred to a Word document for printing on generic sheet labels. Specific Requirements: - Use a generic sheet label format. - The list contains between 100 to 500 addresses. - Format the addresses in a single column on the labels. Ideal Skills: - Proficiency in Excel and Word. - Prior experience with label printing. - Attention to detail to ensure all addresses are correctly formatted and transferred.
I'm looking for an experienced app designer with expertise in PowerApps, MS Office 365, and Excel. Key Requirements: - The app should be compatible with Windows, iOS, and Android. - The app should include functionalities such as data visualization with charts and automated workflows. Ideal Skills: - Proficient in PowerApps, MS Office 365, and Excel. - Experience in designing cross-platform apps. - Ability to incorporate data visualization and automated workflows into app design.
...using personal capital. - Conduct in-depth analysis of assets available on , including cost per square foot and typical expense percentages. Data Sources: - You will be provided with brochures from sellers, personal notes and research, as well as country-specific information including taxes and other relevant factors. Ideal Skills and Experience: - Extensive knowledge and experience in Excel financial modeling. - Familiarity with commercial real estate assets preferred but not mandatory. - Ability to learn quickly and understand new assets. - Strong analytical skills and attention to detail. This project requires someone who can not only crunch numbers but also develop a good understanding of the assets being evaluated. Your expertise will be key in determining the most suita...
I need a freelancer to help me transcribe 2-3 pages of my bank statement into an Excel file. Please format the data into separate columns for Date, Description, and Amount. Additionally, I need the balance after each transaction included in the Excel file. Specific Requirements: - The data should be transcribed into columns for Date, Description, and Amount. - The balance after each transaction should be included. Formatting: - The Excel file should use standard grid lines and font. Ideal Skills: - Proficiency in Excel - Attention to detail - Data entry experience
This program is to be an unpublished, separate tool for my website for asset valuation: www.maskinvurdering.dk. I have prepared a 6 page description of the project, which I have attached. I am interested in firm bids only. Placeholder bids are not to be considered genuine bids and such bids will not be considered.
...Demonstrated skill in conducting comprehensive research on diverse topics such as AI, stock markets, and market trends. • Advanced knowledge and use of Generative AI models such as ChatGPT. • Proficient in managing personal tasks, including booking appointments, organizing family holidays, and developing personal branding initiatives. • High proficiency in Microsoft Office applications (mainly Word, Excel, and PowerPoint), ChatGPT, and familiarity with digital content management systems for maintaining websites (WordPress). • Experience in handling confidential information with the utmost discretion and integrity. • Educational background in business administration, marketing, or related fields is preferred. Working Hours and Duration: • This is a re...
I'm looking for an Excel VBA expert to help me with a local Excel file. The task involves creating a script that will filter data in a pivot table based on specific criteria. Ideal skills and experience: - Proficient in Excel VBA - Experienced in working with pivot tables - Strong understanding of data filtering techniques - Ability to write clean, efficient code
I'm looking for a skilled VBA programmer to create a dynamic filter function for my Excel pivot table. The data source is an Excel workbook and the pivot table is primarily dealing with numeric data. Key Requirements: - Create a VBA code that allows the pivot table to filter numeric data based on custom criteria. - The filter should be dynamic, adjusting as the data changes. Ideal Skills and Experience: - Proficiency in VBA programming with a strong understanding of Excel pivot tables. - Experience in creating dynamic Excel functions. - Ability to understand and implement custom filtering criteria.
...appended to the database without overwriting existing records. • Implement deduplication processes to avoid redundant data entries. • Maintain timestamps to indicate when data was last updated. 4. Optimization and User Access • Optimize the database for high-speed querying using indexing, normalization, and caching. • Include features for filtering, sorting, and exporting data (e.g., CSV or Excel formats). • Develop a user-friendly interface (if required) for accessing and analyzing data. • Ensure secure authentication and access control mechanisms. 5. Testing and Maintenance • Conduct thorough testing of the database and web scrapers under multiple scenarios to ensure reliability. • Establish a maintenance plan to handle: &bull...
...fillable PDF form incorporating numerical data from Excel. The form will require several advanced functionalities including: - Formulas for calculations: This is crucial as the form needs to carry out certain computations based on the input data. - Conditional formatting: The form should be able to visually represent changes based on different conditions. - Data validation: The form must ensure that the inputs meet certain criteria, helping to maintain the integrity of the data. The integration of the Excel data into the PDF form will be done through manual input. Therefore, the design should facilitate ease of use and accuracy during this process. Ideal skills and experience for this job include: - Proficiency in Adobe Acrobat and Excel - Experience in creatin...
We are working on a project that collects data through surveys aimed at understanding trends, traveler preferences, and satisfaction levels within the tourism sector. Currently, the process involves manual work using Excel, which is time-consuming and inefficient. To address this, we aim to develop a system that automates data preparation, classification, and visualization (using POWER QUERY), thereby enhancing accuracy and decision-making capabilities. The overarching goals of the project are: of Dashboards in Power BI Building interactive dashboard(s) to present various analyses, key questions, and insights, supported by constructed indicators, DAX formulas, and other advanced features. Statistical Indicators Generating descriptive statistical measures (e.g.,
I'm in need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Back Office Support.
I need to work in a excel doc to do a macro to calculate new prices and add some other information.
*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.
I'm looking for a script or API that can export my Active Campaign Deal Notes into a CSV/Excel file. Key Requirements: - The script/API must export the Deal Notes in a CSV/Excel format. - The output should include the note content, the date created, and the username of the note creator. Ideal Skills: - Proficient in scripting and API integrations, especially with Active Campaign. - Strong understanding of data export and manipulation. - Experience in generating CSV files from API data. Please, do not apply if you do not have the required skills and experience.
Hello! I’m looking for a professional to build a fully functional dropshipping store on Shopify using the DSers app. The goal is to allow products from AliExpress to be automatically fulfilled and shipped directly to customers without my involvement. Tasks: 1. Set up a fully functional Shopify store. 2. Install and configure DSers for seamless integration with AliExpress. 3. Select and import 20–50 products for the store (products can be selected by me or based on your recommendations). 4. Automate order processing: Synchronize orders between Shopify and AliExpress. Set up order tracking and delivery notifications for customers. 5. Design a clean and modern store layout (logo, banners, categories). 6. Optimize the store for SEO (product titles, descriptio...
Pull all data of each publisher as we discussed + create an excel file as you did in the previous job. Delivery in on january 20th
I'...need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Key Responsibilities: - Data entry of customer information - Email management - Spreadsheet work, including the use of pivot tables and advanced functions in Excel Ideal Candidate: - Familiar with MS Excel and Outlook - Capable of handling basic to intermediate data entry tasks - Able to manage emails efficiently Please provide your hourly rate, inclusive of all fees. The workload might be ong...
I am seeking a Mail Merge expert to assist with document creation from Excel or CSV files. The project involves: - Utilizing a non-specific mail merge platform to execute the task efficiently. - Creating a variety of documents using Mail Merge. - Working primarily with data sourced from Excel or CSV files. Ideal candidates should have extensive experience with Mail Merge, particularly with non-Microsoft or non-Google platforms. Proficiency in handling Excel and CSV files is essential.
I have multiple CSV files containing data downloaded fro...is on extracting specific sales data from these files. Ultimately, I need someone to create a chart or dashboard based on this data, comparing sales across different regions. Key Requirements: - Extract specific sales data from multiple CSV files - Create a chart or dashboard comparing regional sales - Use either Power BI or Excel for the analysis and visualization Ideal Skills: - Proficient in data extraction from CSV files - Experienced in using Power BI or Excel for data visualization - Able to create insightful and easy-to-understand charts or dashboards. Please note, the purpose of this project is to visualize regional sales comparisons. Your expertise and attention to detail will be crucial for the success...
I have a PDF file containing financial data that needs to be converted into an Excel spreadsheet. The data is structured in tables within the document. Ideal Skills: - Proficiency in Excel - Data conversion from PDF - Attention to detail Experience: - Prior projects involving financial data preferred - Experience with PDF to Excel conversion
I'm seeking an Excel expert to enhance a self-grading Excel sheet for beginner students. The goal is to make it more visually appealing and user-friendly based on an example file I have. Key Requirements: - Quick turnaround time (within 2 hours) - Experience in Excel - Ability to implement visual improvements such as color coding, formatting, and graphical elements - Potential for future projects if work is satisfactory The primary function of the Excel sheet will be visual data representation. Please apply if you can meet the requirements and deliver promptly.
I'm in need of a freelancer who can extract text from a PDF into an Excel Spreadsheet. The job requires basic cleaning and formatting of the data in the spreadsheet. Key Tasks: - Text extraction from PDF - Inputting data into Excel - Basic cleaning and formatting of the data Ideal Skills: - Proficient in Excel - Attention to detail - Previous experience with data extraction from PDF Looking forward to your bids.
Hi there, I need someone to manually copy and paste text and numbers from tables in a 90-page PDF document into an Excel template with five predefined columns. Key Requirements: - Combine split sentences into a single line. - Leave a blank line between paragraphs. - Adhere to specific formatting requirements as per the predefined template. Ideal Skills: - Excellent attention to detail. - Proficient in Excel. - Able to follow specific instructions meticulously. Flat rate 5 NZD Bonus: 5 NZD bonus for error-free, on-time delivery. Deadline - one day i.e. 15 Jan 25 Please start your bid "5NZD" I appreciate you reading my post
I'm in need of a professional data scraper to extract contact information from 1400 profiles on a particular website and import it into an Excel CSV file. Key Requirements: - Scraping of 7 specific fields of contact information from each profile, including: - First name - Last name - Email address - Phone numbers - Social media links - Opponent - Win or loss/method Ideal Skills: - Proficient in web scraping tools and techniques. - Excellent attention to detail to ensure data accuracy. - Experience with data processing and Excel. Please bid if you have prior experience in this type of project.
...a skilled Power BI freelancer to assist with creating interactive dashboards, reports, and data visualizations. The ideal candidate will have a strong understanding of Power BI, data modeling, and business intelligence tools, with the ability to turn complex data into clear insights. Key Responsibilities: Design and develop Power BI dashboards and reports. Connect to various data sources (SQL, Excel, cloud databases, etc.) and transform data for reporting purposes. Implement DAX queries and functions for calculated measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dashboards for performance and user experience. Collaborate with stakeholders to gather requirements and deliver solutions. Required Skills: Proficiency in Power BI and ...
...can see all these frequencies? The device needs to be handheld portable that is inexpensive and easy to assemble and get working. You will provide and easy to assemble and use power source that is portable and will last at least 8 hours. Record all data in realtime and monitor and analyze at any given time simultaneous frequency combinations. You will teach me how to assemble the technology, install the program, use the technology, and get it working properly. I will need to know how many SDR's would be needed to provide direction, locations, and depths. Integrate signal into a 3D geo-position terrain map with camera overlay with GPS for precise geolocation. I would like manual and automated calibration system for syncing multiple SDRs. I need to be able to record all dat...
I am looking for a way to automatically export and sort timesheet data from Microsoft Teams/Shifts. The timesheet needs to be exported weekly based on our pay period (Friday - Thursday). A new Excel document should be created for each supervisor or team leader, and each staff member should have their own sheet within their teams relevant Excel document. All data in the supervisor documents should be easily readable. If automatic exporting is not possible, the minimum requirement is for someone to manually export the timesheet and copy it into a location where it can be automatically processed, with no additional input required from the staff member exporting the timesheets. The data that needs to be extracted from the timesheet export includes: Date Clock-in Clock-out ...
...Implementing negative keywords effectively. • Improving Quality Scores and ad positions. • Reducing CPC while maintaining or improving performance. • Ad Extensions: Setup and optimization. • Landing Page Optimization: Provide actionable suggestions to improve conversions. • Content Creation: Deliver high-quality content that aligns with campaign objectives. • Analytics and Tracking: 1. Install tracking codes. 2. Set up and analyze Google Analytics accounts. 3. Monitor traffic and campaign performance. New Campaign Setup Process Agencies must demonstrate expertise in: 1. Conducting thorough keyword analysis. 2. Writing and testing impactful ad copy. 3. Setting up campaigns with attention to detail. 4. Ongoing campaign monitoring and optim...
...understand: we are not separate from the world’s rhythm; we are its echo. Harmony is not perfection. It is the truth of interconnection. It is the story of life itself."* Scene Descriptions Opening Scene (0–10 seconds): A slow, aerial shot of a vast desert, the sun low on the horizon casting long shadows. The camera pans to reveal a single tree thriving in isolation. Transition (10–20 seconds): A macro shot of dew forming on the edge of a leaf, each droplet trembling before falling. The camera follows the drop as it merges with others in a flowing stream. Middle Scene (20–40 seconds): A montage of natural contrasts: A volcano erupting, its fiery glow mirrored by the calm ocean nearby. A close-up of a lion’s eye, followed by an image of an a...
I'm seeking an expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I ... Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide First Name, Last Name, Title, Company Address, Company Name, Email, Mobile Phone, Linkedin acount
I need a visual dashboard created from my Excel financial data. This dashboard will primarily be used by executives, so it needs to clearly display cash flow and ROI information. Key Requirements: - Proficient in Excel and dashboard creation - Ability to visualize complex data simply and effectively - Prior experience working with financial data Ideal Skills: - Data analysis - Financial literacy - Excel expert - Dashboard design
I'm seeking a skilled professional to perform a detailed takeoff from my bluepr...comprehensive material list of quantities and costs breakdown for all trades, including electrical, plumbing, and carpentry. The final output should be an Excel spreadsheet, as I prefer this format for data analysis and budgeting. Key Requirements: - Proficient in reading and interpreting blueprints - Experience with construction material takeoffs - Familiarity with costs associated with various trades - Excel spreadsheet creation and data organization skills I do not have a specific template for you to follow, so creativity and an understanding of how to best structure the data will be key to your success in this project. Please ensure the Excel document is clear, logically organ...
I'm looking for a skilled Excel professional to help automate my spreadsheet, which I've been manually updating with annual measurement data (3D coordinates). The spreadsheet involves regression analysis and generating charts. Key tasks that need automation: - Updating formulas: Currently, I have to re-input the formula to accommodate the new data each year. - Data input: I want it to be as simple as entering the new data and the spreadsheet updates itself. - Chart generation: The spreadsheet produces various charts from the data, which currently requires manual intervention. - Running regression analysis: The spreadsheet includes regression analysis which needs to be automated as well. Ideal skills for this project include: - Proficiency in Excel, especially with...
I am in need of an expert who can assist me with the installation and activation of the "OpenRemote" platform on a DigitalOcean Virtual Machine. I already have an account Or you can create one for me and transfer ownership later. Now I require support with the initial setup and configuration of the VM. Key Responsibilities: - Install and configure OpenRemote on a DigitalOcean VM - Ensure the platform is accessible via browser - Provide initial setup support Skills and Experience Required: - Proficient in DigitalOcean VM management - Experienced with OpenRemote installation - Strong troubleshooting skills - Excellent communication skills for providing clear instructions on access and usage
We have a platform in PHP and MySQL to manage the services we provide but we have never used it. Currently we manage everything with Excel but there are already many records and various people who work on the file. I need to load our excel database into the MySQL database and start using the tool. The excel database has 20.440 rows and 43 columns.
...Plugin Settings Review & Adjustments - Evaluate installed plugins for relevance, compatibility, and efficiency. - Adjust plugin settings to meet the site’s needs. - Resolve any conflicts or redundancies in plugin configurations. 4. Branded Merchandise Store Setup - Build out the "shop" section of the website using WooCommerce. - Integrate payment gateways for seamless transactions. - Recommend and install either: Gutenberg Page Builder + Kadence Theme, or Elementor + Astra Theme (Provide your recommendation and rationale.) Advise on URL structure (subdomains vs. subdirectories) with a clear rationale, considering: A home page content design to cross-sell and upsell to key sections: - The "Shop" (branded merchandise), - The "Newsletter Subscrip...
I'm seeking an expert in financial modeling with Excel to help construct a comprehensive analysis model for a retail center development project. This project will involve a construction loan, refinancing, and utilizing land equity from the landowner. Key Requirements: - Develop cash flow projections on a monthly basis. - Include critical financial components such as the Profit and Loss statement and Loan amortization schedule. - Conduct sensitivity analyses for interest rate changes, construction cost variations, and market rental rate fluctuations. Ideal Skills: - Proficiency in Excel, with advanced financial modeling skills. - Experience in retail development project analysis. - Ability to conduct and interpret sensitivity analyses.
I have an Excel sheet containing financial data including income and expense ledgers, as well as indicators of the company's growth. I need someone to transform this data into detailed management accounts. The project requires the creation of clear and insightful charts, as well as the data being presented in an easy-to-read format. Key Requirements: - Bar charts, Pie charts, and Line charts to be created from the data - Focus of the charts on income and expenses - Data presented in a Quarterly comparison format. - profit growth Ideal Skills: - Proficiency in Excel - Experience in financial analysis and creating management accounts - Ability to create clear and insightful charts and graphs - Skills in presenting data in an easy-to-read format.