Open office calc use excel macros jobs
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
we need a logo for our office product brand "ARONRIYA" ,which is link management and link redirect tool. I have attached sample logo for your reference. Need source file with all the fonts and elements. If you have any questions, Please dm me. Thank you!
...files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders sheet to market 4- Genarate adress sheet to feed into shipping software 5- Upload shipping software sheet into system. 6- generate order sheet with tracking number to feed into external system. 7- Should be able to view pending, fullfillment orders on any dates, date range. 8- create monthly or year to date, cutom range date report for all orders etc. 9- Able to upload supplier inventory sheet in to system on daily basis to check the delta of supplier inventory specially prices and quantity check from back date of data or new inventory. We should be able to track the changes in daily supplier inventory sheet. For technology , we are ...
...information from three different websites: Website A, Website B, and Website C. The data to be extracted include: - Product details - Customer reviews - Pricing information The successful candidate should have proven experience in data scraping and should be proficient in navigating different types of websites seamlessly. The final output format I require for the scraped data is Excel. Proficiency in Excel or similar data organizing tools would be needed. The ideal candidate should be meticulous in ensuring the accuracy of data and adhere strictly to the provided format without missing details. This task may require repetitive data entry, hence patience, attention to detail, and a commitment to producing high-quality work are critical skills for this job. This proj...
...and data technologies to comprehensively capture the bank’s current state holistic data architecture and oversee target state design and implementation. The role will involve collaborating with Business, Data Management Office and internal and external IT stakeholders at all levels to ensure the enterprise data strategy and associated implementation is adding value to the business. Main Duties: Documenting the detailed holistic physical data architecture for both current and target state Capturing the physical enterprise data model, working with the Data Management Office to align to the conceptual and logical models Setting the strategy for data architecture to support the Business and IT strategies and maintaining the data architecture principles Creating the data...
...and data technologies to comprehensively capture the bank’s current state holistic data architecture and oversee target state design and implementation. The role will involve collaborating with Business, Data Management Office and internal and external IT stakeholders at all levels to ensure the enterprise data strategy and associated implementation is adding value to the business. Main Duties: Documenting the detailed holistic physical data architecture for both current and target state Capturing the physical enterprise data model, working with the Data Management Office to align to the conceptual and logical models Setting the strategy for data architecture to support the Business and IT strategies and maintaining the data architecture principles Creating the data...
Consolidated Sales Calendar report put in excel spread sheet.
I am lo...tasks. Here's a high-level overview of what the role will need: Responsibilities: - Email and calendar management - Data entry Working Hours: - The hours for this role are quite flexible, but it might require full time or part time commitment depending on the volume of tasks. Ideal Candidate: - You can be anywhere in the world, as this is a remote role. - Advanced proficiency with Microsoft Office Suite, Google Suite, and Adobe Acrobat is key to efficient task execution. - Proactive, organized, and detail oriented professional with excellent communication skills will succeed in this role. Note: If you did not answer certain optional information fields as mentioned above in the questionnaire, feel free to discuss it further upon sharing your proposals or in the int...
What marketing services are you looking for? Lead generator/marketer for Brooklyn, NY What specific industries do you want the lead generator/marketer to focus on? Medical (patients for Chiropractic/physical therapy office) How soon do you need your project completed? ASAP
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send reminders.
...skilled professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance my workflow. Please remember to include your relevant experience in Excel...
*** PLEASE DO NOT ASK "WHAT IS YOUR BUDGET" YOUR BID AMOUNT SHOULD BE THE AMOUNT YOU INTEND TO DO ... PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet showing duplicate entries highlighted Key Tasks: - Correct SQL query to eliminate duplicate entries Seeking someone proficient in MySQL database design and query optimization. Previous experience with troubleshooting and resolving similar query issues would be a si...
I'm in need of an expert in data visualization to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone who enjoys working with data, has a keen ...
I am looking for a Microsoft OneDrive consultant with extensive experience on file organization, sharing, syncing, backup, and collaboration features. I am especially interested in merging several OneDrive accounts into one and need your expertise to set up automatic synchronization. MUST BE A RESIDENT IN THE GREENVILLE, SC AREA AS AN OFFICE VISIT WOULD BE REQUIRED Your role would be: - Consolidating multiple OneDrive accounts into one single account - Ensuring all files are correctly organized, shared, backed-up, and set up for collaboration - Setting up automatic synchronization among all the files across the accounts It is crucial you have significant experience in managing and troubleshooting OneDrive. Quick and efficient work, with attention-to-detail in preserving file perm...
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
Need someone who can analize data from a excel and contact customer with missing data
...up an open-source ERP system specifically for inventory management of office supplies in our workplace. -Key Functions: 1. Inventory Tracking: The system should accurately track our inventory of office supplies, providing real-time updates on what's in stock. 2. Reporting and Analytics: I want the ability to generate useful reports and insights, such as inventory usage trends and re-order reminders. 3. Create bar codes for each item that contains info about the item, item location, age of item, manufacturer, retailer. -In terms of access, less than 10 users should be accommodated. It's crucial that the system you set up is user-friendly and easy to understand. -Ideal skills: You should have considerable experience in setting up open-source ERP ...
Hi Noman. I noticed your profile. I want to hire you so bid on project thanks
I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Excel and have a str...
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.
I'm seeking a proficient Microsoft Word VBA expert. Your responsibility will be: - Automating repetitive tasks to increase efficiency - Creating custom macros to fulfill specific needs - Developing interactive forms, enhancing our team’s productivity The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is def...
...to prioritize deadlines - Is energetic and has an always can-do attitude - Has excellent attendance (we will part ways as soon as I start hearing issues about power outages and nonworking or slow internet) Job responsibilities include: -Assisting customers in getting estimates -Resolving customer complaints -Responding to customer inquiries by phone/ email/ text -Assisting owner in day-to-day office tasks The position is for a 5-day, 40-hour shift. Time zone - EST NY. (GMT-4) Pay - depends on sales experience. Your Main Responsibilities: - Serve as our professional sales representative, advocating for our highly-rated moving company. - Execute effective sales techniques to contribute to overall company and customer growth. - Develop strategic sales plans that expand our compan...
I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this s...Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - Strong problem-solving skills and attention to detail. Looking forward to seeing your proposals!
I'm seeking a skilled developer to assist with the setup of a Virtual Private Server (VPS) running Ubuntu and the development of a simple RESTful API using Node.js for a back-office web application. --- VPS Setup and Configuration --- - Install and configure Ubuntu on a VPS, ensuring optimal performance. - Remove unnecessary services that are not needed - Configure a robust firewall --- Database and Server-side Environment Setup --- - Install and configure MariaDB - Install Node.js and any necessary environment dependencies for development. --- API Development --- - Develop a RESTful API using (or a similar library/framework) to handle user authentication. The authentication system should support email and password verification. - Implement CRUD (Create, Read, Update, Delet...
Thumbnail for my monetized/commercial/personal use YouTube video
...clear and simple logo to use to build a brand identity for a long-standing family medicine practice (general practice) working in the UK. The practice is based in a small village in a rural area. It is modern and forward thinking. It is a happy place to work and patients like it. We need a logo that can be used either in isolation or as part of a headed letter. It will be used on printed media such as professionally printed patient leaflets, posters around the surgery, etc. it will also be used in digital media on electronic documents and to a limited extent on social media. The logo should be simple and not distracting or excessively flashy. It needs to be something that will not date rapidly. It should work well in greyscale as well as in colour. Preferably it will use...
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...
As per requirement, I will deliver the required district's School details in Excel format
...Project Scope and Client's Requirements • Drafting Project Proposals, RFPs and Tender Documents • Project Scheduling, Timelines, and Budgeting • Monitor Tasks and Project Progress Along with Project Management, I am proficient in providing administrative support, including data entry, online research, phone calls, and email correspondence. Additionally, I use, do, and am familiar with the following Tools and Techniques: • Microsoft Office Suite • Microsoft 365 / Microsoft Teams • Google Workspace /Calendar/Drive/Sheets/Extensions • • Basecamp • Trello • Asana Moving forward, I can dedicate 20 hours/per week to your company, and my daily hours are negotiable by your terms. Please feel free to contact me directly to ...
I am looking for an experienced web developer or a digital content specialist who can revamp my website's content and images on various pages, which includes the Home page, About page, and Services page. The desired updates extend to adding new content, image replacements, and text updates. In parallel to this, there are some user interface updates, functionalit...a superior user experience. Ideal skills and experience for this project include: - Proven experience in web content management - Strong understanding of affiliate marketing portals - Expertise in UI/UX design - Proficiency in debugging and troubleshooting I anticipate a highly detail-oriented person with a keen understanding of how web content and functionality impact user engagement would excel in accomplishin...
...urgently seeking an experienced structural engineer to help complete the structural engineering on a 3000 square foot commercial building that will be used as office space. I am a building designer and the design is complete and ready to engineer. My usual engineer is booked and then going on vacation and I need to get this project done on a fast timeline. Key responsibilities will include but are not limited to: - providing structural calculations, sizing structural components, assigning fasteners and connection hardware.... - providing certified stamp for permitting Skills and experience needed: - Proven experience in commercial office building projects - Expertise in architectural principles and technology - Proficiency in engineering software Please note, im...
I'm seeking an experienced UI/UX designer who can enhance the interface and workflow of my current Open EMR system. I'm struggling with difficult navigation and slow performance which has been stalling my medical service operations. - Enhancements Needed: The ideal candidate should be able to streamline the current workflow, improve data visualization, and introduce intuitive UI elements for a better user experience. - New Features: Additionally, the newly designed platform should be capable of efficient management of appointments, invoicing, billing, and maintaining a robust patient portal. - Key Skills: Expertise in Open EMR, strong understanding of healthcare IT solutions, proficiency in UI/UX design, data visualization and performance optimization. I am ...
I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in ...number appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentation - A...
...data. -- Annual data use check up. I think you did this for me before. Urgent: Data Use Checkup for Transteam Here's what you need to do for Transteam before Apr 6, 2024 to maintain API access and avoid restrictions: Examine your previously approved or added permissions and features. Certify this app follows the allowed usage. Certify that you are following the Meta Platform Terms and Developer Policies , together with all other applicable terms and policies. Answer questions about your data handling practices. Learn about our data handling guidelines. Data Use Checkup is a requirement that must be completed once per year by an app admin. Make sure each app is connected to a verified business —this is required in order to submit Data Use Checku...
...analysis feature - The app should automate data import/export and manipulation tasks The application should also be capable of seamlessly integrating with various software tools. While Microsoft Excel and Access are a given, the ability to integrate with other tools is also vital. Having experience working with a variety of software packages is a considerable advantage. Skills and Experience Required: - Proven experience in VBA development, particularly applications for data analysis - Familiarity with automation of tasks using VBA - Proficiency in integrating VBA apps with different software like MS Excel and Access - Flexibility in working with other unspecified software tools This project is ideal for innovative developers who understand the importance of streamlinin...
I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.
I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.
I'm seeking a talented 3D animator to create a series of reali...enter the house and will be distributed directly from the upper ceiling to different rooms. - One hose will be distributed to the kitchen, another to another hotel room, another to another meeting room or office, other hoses will be distributed to other rooms and other offices and suite hotel rooms in the same way. - Again, there will be connection types and explanations as in the previous animation. I will send you the explanations - The last connection point here will be the sprinkler head. - Each hose will be connected directly to the sprinkler head in different rooms. Even if you use T's, you will see a hose and connection every 5 metres. - Our aim here is to show that these hoses save time and la...
I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.
I am currently seeking a seasoned Interior Designer who can bring a stunning, modern aesthetic to my commercial office space. Key Expectations: - Design Plan: Create a modern and efficient design for the office space, enriching its potential utility and appeal. - Expertise: Prior experience with commercial and modern interior design is essential. Ideal candidates will have a portfolio demonstrating similar achieved results. - Collaboration: Hands-on involvement throughout the project to establish an environment conducive to productivity and sophistication. Please disclose examples of work or projects that are similar in scope.
I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.
I need a straightforward internal order confirmation system to streamline the purchasing process and manage inventory. The ideal system for me would: - Create weekly order templates when at office - Open ordertemplate and write in customer and order - Generate automatic emails and printable PDF documents for order confirmations - Include detailed information in the confirmations such as products, quantities, prices, and customer's name and contact details - also save order on webserver in text file or database - installation on internal webserver See example of weekly order See order Freelancers with experience in inventory management systems and programming automatic emails would be a good fit for this job. Strong knowledge in creating PDF documents will be
I'm in need of an expert web scraping developer who can extract textual data from specific Wikipedia pages. This should be a one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skill...one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skills and experience: - Proven expertise in web scraping - Previous experience with Wikipedia or similar tasks preferred - Ability to deliver accurate data in a structured format such as CSV, Excel, etc. Please avoid any unnecessary or redunda...
I am in need of a personal assistant to professionally handle phone calls, answer emails, and meticulously track rental payments and expenses for 6-10 rental propertie...some responsibilities of a bookkeeper; hence, an understanding of and experience in basic to intermediate accounting is highly preferred. Key duties will involve: - Efficient management of rental properties - Timely tracking and recording of rental payments - Accurate accounting of expenses - Handling telephone and email communications A candidate with skills and experience in these areas will excel at this role: - Bookkeeping - Accounting (Intermediate level) - Property Management - Communication. For my peace of mind and the smooth operation of the rental properties, a meticulous, detail-oriented individual ...
I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuitive. - Experience ...
I need an expert in interior design and video animation to create a full, detailed representation of my 22*24 office space. The outcome should be a modern, minimalistic office design video animation that successfully highlights separate segments - one each for myself and my team. Key responsibilities include: - Creating an engaging, detailed animation video of the office layout - Showcasing the separate segments in the most effective light - Having the ability to add other specific areas, such as a meeting room, break area, reception area, etc., as per discussions during the project. The ideal freelancer for this project should have: - Proven experience in modern, minimalistic interior design - Proficiency in video animation, specifically for showcasing spaces - Exce...
