Accounting excel formulas jobs

I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project will require attention to detail and a high level of accuracy. If you have the r...

I'm looking for an accountant(Freelance / Intern / Permanent Employment) who is well-versed in Zoho Books and Zoho Payroll to set up and manage the financial aspects of my startup. Key Responsibilities: - Initial setup of Zoho Books & Payroll software - Bank account reconciliation - Bookkeeping - Managing payroll and salaries Additio...Preferably no specific requirements for the initial setup. You can set up the software based on the needs of my business. - The tasks will need to be managed on a weekly basis. Ideal Candidate: - Proficient in Zoho Books and Zoho Payroll - Experience in bank account reconciliation, bookkeeping, and payroll management - Strong organizational skills and attention to detail - Good understanding of accounting principles Looking forward t...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm looking for a talented WordPress developer to revamp my current website to provide detailed information on our services, especially tax preparation and bookkeeping, in a modern and sleek design. Key project requirements include: - Modern and sleek design: The new site should have a contemporary and visually appealing look and feel to engage our audience. - Comprehensive service pages: The site must effectively showcase our tax preparation and bookkeeping services. Each service page should provide in-depth information to help potential clients understand our offerings. The ideal candidate should have experience in: - WordPress development - Designing modern and sleek websites - Creating effective service pages with a focus on tax preparation and bookkeeping. We have an existing...

I have a data entry task that involves inputting text data into a digital format (e.g., Excel, Word). The primary goal of this task is record keeping. Key Points: - Data Type: The task involves handling text data only. - Data Source: The data will be provided in a digital format. - Task Goal: The primary objective is to maintain records in a systematic way. Ideal Freelancer: - Proficient in Text Data Entry: The ideal freelancer should have experience with accurately and efficiently entering text data. - Familiarity with Excel/Word: Proficiency in using Excel and Word is necessary for the task. - Attention to Detail: Given that the task involves record keeping, the freelancer should have good attention to detail to ensure the accuracy of the entries.

I'm in need of a professional who can build a tool that scrapes product data from Walmart and exports it into an Excel spreadsheet. Key Requirements: - Develop a web scraping tool specifically for Walmart website - Extract essentials (price, upc, title) Skills and Experience: - Proficiency in web scraping using Python, Scrapy, or similar tools Please let me know your availability and estimated time for completion. This is an urgent project, so a quick turnaround would be highly appreciated.

I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Wor...Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas,...

...a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience wit...

I'm seeking help with creating line charts in Excel. My dataset is small but involving multiple data series. Requirements: - Generate line charts from provided multi-series data - Ensure the charts are clear and visually engaging - Basic understanding of trendlines and data labels would be a plus, though not mandatory Ideal Skills: - Proficiency in Excel, with a focus on charting - Prior experience working with complex, multi-series datasets - Strong attention to detail and an eye for creating visually appealing charts

Please Sign Up or Login to see details.

I'm in need of an experienced freelancer to help me develop a prototype. The main goal of the project is to improve transaction management, focusing on data integrity particularly, using Spring and Hibernate with Oracle Database. Key Tasks: - Help build a prototype emphasizing data i...track record of ensuring successful integration of Oracle databases with Spring and Hibernate. Attached is a detailed write-up of the specific technical problem we are trying to solve, along with some prototype code that may or may not be needed. Deliverable: - A simple prototype which can write to 2 databases in 1 atomic transaction, using Spring, Hibernate, JPA, Narayana and Oracle RDBMS, accounting for the dynamic nature of data source management and transaction management described the at...

I'm in search of a robotics expert with advanced experience in working with Vex V5 parts. The goal of this project is to build a robot that strikes the right balance between speed and strength, specifically for a high school robotics competition. Key Responsibilities: - Building a competitive robot that can excel in a high school robotics competition - Optimizing the robot for a balance between speed and strength Ideal Skills: - Proficiency in working with Vex V5 parts - Previous experience in high school robotics competitions - Strong understanding of robot design principles Communication for this project is crucial, and I would prefer to have in-person meetings to discuss progress and updates. Please consider that you must be able to meet in person in Connecticut west ha...

...bank transactions from PDF format into a spreadsheet. My accountant needs this data to be organized and easily accessible. Tasks for the freelancer include: • Extracting transaction information from my downloaded PDF bank statements • Compiling this data into an Excel spreadsheet • The project will need to include the date, transaction description, transaction amount, resulting account balance, and transaction category The ideal candidate needs: • Strong attention to detail • Proven experience working with both PDF and Excel files • Fluent in English for effective communication Expectations: • Maintain rigorous data accuracy • Finished product will closely replicate the information found in the original bank statements using...

As a small organization, we are delving into Odoo and seek expertise in i... - Customization and Module Development: Adapting Odoo to fit our unique business requirements. Not just basics, we need significant customization, especially within modules tailored for CRM, Accounting & Finance, Point of Sale, and Inventory. - Training and Documentation: Our team is fairly new to this, hence we count on your descriptive training sessions and comprehensive documentation to bolster our in-house competencies. Your affinity with small-sized teams and hands-on experience in extensive Odoo development and customization will make you the perfect addition. Familiarity with CRM, Accounting & Finance, Point of Sale, and Inventory modules is a must. Join us to make our Odoo journey ha...

I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is highly beneficial.

Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.

I'm looking for a full stack developer to make several key improvements and integrations to my existing spreadsheet editor. - **Adding New Formulas:** The first key task is to introduce new formulas to the existing spreadsheet editor. I need a professional who is well-versed in developing and integrating custom formulas to spreadsheets. - **Improving User Interface:** The editor's current interface needs a major upgrade. Your role will include enhancing the visual design to make it more modern and user-friendly. We also need to simplify the navigation within the editor, ensuring it's intuitive for our users. Drag-and-drop functionality is another key aspect that needs to be integrated. - **Integrating with External APIs:** The editor needs to be seaml...

I need a skilled Arabic typist to enter data from PDF, into a single excel table .

I am in need of a professional academic translator with expertise in the field of Social Sciences, to translate a proposal from English to Turkish. Key Requirements: - Specialization in Social Sciences: An academic background in Social Sciences is preferred to ensure accurate and contextually appropriate translations. - English to Turkish Translation: The project involves translating academic documents written in English into Turkish. Proficiency in both languages is essential to maintain the integrity of the content. - Attention to Detail: The translator should be meticulous in their work, ensuring that the translated documents are error-free and convey the original meaning accurately. Ideal Skills: - Proven experience in academic translation, particularly in the field of Social Scienc...

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.

I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly integrated into a report.

Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.

I'm in need of a skilled developer to create a web-based accounting app mimicking functionalities of excel for my business. Key Features: - Accounting functionality: This app must allow me to insert product details and their price, record the amount they were sold for, and at each day's end, it must generate a profit and loss table. - Inventory tracking: The application should effectively manage my inventory, keeping a track of products, their quantities, and changes over time. - Customer Database: The app should store customer information in an organized and easily accessible manner. - Invoice Generation: It should also have the capability to generate invoices for customers. Design Aesthetics: The preferred design is minimalistic. It must be clean, clear ...

I am seeking a savvy and experienced freelancer who can meticulously reconcile my entire accounting ledger and accurately track any pending payments. Here's a snapshot of what I need: - Accounting reconciliation: Thoroughly reconcile my entire accounting ledger, identifying and correcting any discrepancies. - Payment Tracking: Identify any outstanding payments and create a simple, effective system for future tracking. Although I did not specify an accounting software, familiarity with common systems like QuickBooks, Xero, and Zoho Books will be advantageous. You should excel in number-crunching, have a keen eye for detail, and a track record in similar projects. Advanced knowledge of accounting principles is also expected. Applying fr...

...professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. ...

...Tracer. A newly established bank is seeking to set up its IT infrastructure promptly, and you are one of the contenders for this project. The bank requires a simulated version of the proposed plan before making a final decision. The bank has provided you with the building's blueprint (see attached image), indicating it is a three-story structure with the following layout: First Floor: - Room 1: Accounting Department (3 employees) - Room 2: Checking and Savings Department (4 employees) - Central Hall: Public area where clients can connect to a separate network Second Floor: - General Manager’s Office - IT Infrastructure Room: Dedicated to IT operations (2 IT personnel) - Food Court: Open dining area for all employees Third Floor: - Conference Hall: Used for importan...

I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts...

We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...

As discussed I have delivered the excel workbook. Thanks!

I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of client nee...

About Us: Culprit Underwear is a dynamic, online DTC brand b...directly impact our growth and efficiency. Key Responsibilities: - Expertly handle financial records via QuickBooks and Bill.com. - Develop accurate cash flow projections and P&L statements. - Manage accounts payable/receivable and budgeting processes. Must-Haves: - Proven track record as a freelancer in accounting/bookkeeping. - Proficiency in QuickBooks and is non-negotiable. - Bachelor’s degree in Accounting, Finance, or related field. - At least 2 years of relevant accounting or bookkeeping experience. - Stellar organizational skills, with an analytical mindset. Why Us? Be part of a bold, creative community reshaping the underwear industry. Enjoy the freedom of freelancing with the suppor...

... Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system should have a vast and well-organized cost database. - Calculation Formulas: It should accommodate complex estimation formulas. - Reporting and Analytics: The ability to generate detailed reports and analytics is crucial. Ideal Candidate: - Should have a strong background in PHP development. - Extensive experience in developing ERP solutions, particularly for construction. - Knowledge of project management and cost estimation methodologies. - Ability to think critically and...

...tasks for this project include: - Data analysis and visualization: I require someone who can understand the dataset thoroughly and present insights in a visually appealing manner. - Formulas and functions calculations: You should be able to create complex formulas and functions to derive the necessary insights from the data. Ideal candidates should possess the following skills and experience: - Proven track record in data analysis and visualization using Google Sheets. - Strong expertise in working with large datasets (1000+ rows) within Google Sheets. - Proficiency in creating and implementing complex formulas and functions within Google Sheets for accurate analysis. - Excellent understanding of data analysis techniques and best practices. Please note, though th...

We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...

...with a variety of tasks. Your primary responsibilities will include managing my emails and messages, inputting information into my Wave accounting software, and updating my social media accounts. Key Responsibilities: - Monitor and reply to messages in my primary email account - Handle data entry tasks on Wave accounting software. Experience with Wave is preferred but not mandatory. - Regularly update my social media accounts on Facebook, Twitter, and Instagram. I am looking for an individual who is highly organized, detail-oriented, and has excellent communication skills. You should have experience as a virtual assistant, and some familiarity with accounting software would be a plus. Additionally, knowledge of popular social media platforms and their respective ...

Data entry work from home part Tim e

I need help with creating invoices using Wave accounting software. The templates are already prepared, but I need assistance in filling them with the provided information. The main responsibilities will include: - Filling in client name and contact information - Filling in an itemized list of products/services - Ensuring the payment terms and details are correctly included Given that the templates are already set up, this is more about data entry and ensuring the correct placement of information. Ideal Skills and Experience: - Proficiency with Wave accounting software - Experience in invoice creation and management - Attention to detail and accuracy in data entry - Strong communication to ensure understanding of requirements and incorporation of all necessary data All ...

You need to build a power app for a business process of onboarding, offboarding customers. There is a data...customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient digital ...

I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.

Copy typingy data entry excel world

We are seeking a Business Data Analyst for our team who is willing to work with... Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...

...rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Familiar with the nightlife industry...

...proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share which can form basis of design. Ideal candidates will have experienc...

I am in need of a freelancer to assist with handling the invoices generated from our proprietary accounting system. Here's what I'm looking for: - Experience with diverse invoice and accounting systems. - Ability to manage less than 50 invoices per month. - Capability to take responsibility for dispatching invoices to our clients. - Persistence in chasing unpaid invoices and ensuring collection. Understanding of our own bespoke system would be a bonus. Your primary role will be to send out and follow up on invoices. Efficiency, dedication, and excellent communication skills are a must for this role.

I require a professional freelancer with extensive experience in Microsoft Office 365 to develop a set of Word, Excel, and PowerPoint templates for my business. Key Details: - Each template needs to incorporate our company's logo, color scheme, and slogan in a visually appealing manner. - I am looking to have 1 to 3 distinct templates created for each platform – Word, Excel, and PowerPoint - so I need someone versatile and creative. Ideal Skills: - Strong knowledge of Microsoft Office 365 - Graphic Design Skills - Branding Experience Please provide some examples of the branded content you have created in the past, especially any corporate identity materials. Looking forward to your bids. Thank you.

I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project will require attention to detail and a high level of accuracy. If you have the r...

I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to preserve original formatting in Excel - Excellent English language understa...

I'm in need of a skilled professional who can help me generate leads. Unfort...some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency in understanding both B2B and B2C lead generation methodologies is also important. Looking f...

I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.