Most used excel formulas in accounting jobs

We need someone to re build this PDF brochure in PPT. The original InDesign files are lost but we have all the individual files, fonts, images ready to share together with our brand ID style guidelines. Need a fairly quick turnaround. If well done we have ongoing brand and design work requirements weekly throughout most of the year.

I am in need of an experienced music video artist to create an energetic and compelling indoor music video. Key Project Details: - The video's theme is energetic and your work should reflect this emotion. - One of the most critical elements to be incorporated in the video is significant camera movement. - The shoot will take place indoors, so experience with indoor filming and understanding of lighting and space optimization is necessary. Relevant Skills and Experience: - Experience in filming and editing music videos particularly with energetic themes. - Mastery at capturing and creating dynamic camera movements. - Proven track record with indoor shoots, managing space and lighting effectively.

I'm seeking an experienced software developer to create an accounting application that is compatible with the Windows operating system. It's a high priority that this application seamlessly integrates with Zoho Books. Key Features: - Integration with Zoho Books Required Skills and Experience: - Software development - Familiarity with accounting software - Knowledge in developing Windows applications - Experience working with Zoho Books API would be a significant advantage Timeline: - The project needs to be completed within a month. This role is perfect for a problem solver who has an eye for detail and understands the importance of creating user-friendly applications. If you think this project aligns with your skills, I'd love to hear from you.

I need an experienced Android game developer to design a minimalistic, Tetris-like game. The unique twist is that the speed of the falling blocks should dynamically respond to the player's heart rate variability. Skills & Experience: - Experience in mobile game development. - Experience in designing minimalistic visual interfaces. - Ability to integrate wearable health monitors. - Familiarity with Tetris or similar games is desired. Regarding the platform, you're free to suggest the most suitable one for such a project.

Here is the quote of the work I did.

As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financial acumen are also a plus.

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forw...

I need a minimal working example of PPPOS in IDF framework v4.4.7. The requeriments are: - Minimal example with SIM800L modem. - Create and configure esp_netif for PPP (create the driver, and task to receive data from modem and send to esp_netif) - Configure the modem via AT commands (PPP conection ATD*99#) - After succesfull connection, make a http request for testing. The most important thing: DO NOT USE esp_modem component. The example must do not use any component, simply the esp_netif API.

I'm eager to dive into music production, particularly focused on the world of dubstep and trap. As a total begin...beginner with Ableton, I'm looking for a knowledgeable and patient tutor to guide me through the process. Specifically, I'm most interested in mastering the art of beat making, and polishing my tracks through mixing and mastering techniques. Key Points: - No prior experience with Ableton, so the teaching needs to start from the basics. - The focus will be on the drill/trap subgenre of dubstep and trap. - The ideal candidate should be able to explain concepts clearly and have a good understanding of beat making and mixing/mastering in the context of drill/trap. Your guidance is crucial, as my aim is to eventually produce high-quality, prof...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to...

I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel...

...includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work so ideally I need a web based solution rather than one installed on my computer but on my phone would be ok. Ideal Skills: - Proficient in da...

Please note that this is not for a particular role, this for representation. We work with all Casting Directors in Australia on all productions. We are seeking talented individuals to play varying roles. We receive briefs for Film, TV, and Commercials. We left the project duration field blank, this means there are opportunities for both short-term and long-term collaboration. Most jobs are between 4-8 hours or can be multiple days on larger productions. As experience is needed for some productions, inexperience actors are also welcome as there are allot of roles you don't need experience for as long as you feel comfortable in front of the camera. Please contact me if you have any questions. Regards Brad Walks Talent Management

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that whil...

...the login details, and you can then transfer it there and continue the work. and I will also award you the job at that time. 3) The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. I need ONE PAGE created for web store (wordpress/woocommerce). Must have a visual product customizer. Meaning that a customer will have the option to customize the item and see the changes they make in real time. Not just colors and sizes though, but entering texts and choosing adornments, etc. Here is an example of what I am needing (not my website, just one I found online). If ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility...

...to assist in implementing specific modules in Odoo and integrating third-party apps in a bid to significantly improve the customer experience as well as streamline our business systems. You should have: - Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales data. 2. Odoo Implementation: - Doing initial...

I'm in need of a knowledgeable expert to help manage my bookkeeping using FreshBooks. Your tasks will primarily involve: - Maintaining financial records and handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBooks and have profound experience in accurate bookkeeping. A strong comprehension of financial statements and the ability to organize large amounts of data are also critical. Previous accounting experience would be a bonus. Prompt, reliable, and detail-oriented professionals are preferred.

I require a skilled animator to create a 1-2 minute, engaging 2D animation. It should display a love story, rendered in a cartoon-style aesthetic, imaginative and colorful. - Essential Skills: * Expertise in 2D animation * Creative cartoon-style animation design * Ability to create animations that convey a love story Furthermore, freelancers who have experience working on similar projects are most likely to be considered for this job. Demonstrating previous work with animations of a similar style or theme would be advantageous. I look forward to seeing your previous works and bids. Let's bring this romantic cartoon to life!

I'm in need of a Quasar framework developer to build a project. Before I give you the details of the project, let me take a moment to tell you what you can do in order to get your bid to be awarded this project REJECTED. Yes, this is a list of all the different things you can do if you want to PERMANENTLY END your hopes for being awarded this project. 1. Place your bid with an auto-bid. Yeah, blind bids with no consideration for what it’s going to take to actually do the project just tick me off. 2. Don’t read this document carefully. After all, I only put a ton of work into it, and it will only answer 99% of your questions. Why should you respect that? Just skim the document and then try to get me to talk about it in detail. That’s ...

I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.

...ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifically in language understanding. - Familiarity with integrating text-to-speech features for the AI assistant would be a plus. I'm looking for a professional who can deliver a high-quality, user-friendly app that meets these key requirements. Please include relevant examples of your previo...

I'm in need of a professional who not only understands the concept of accrual accounting but can also create captivating PowerPoint presentations. Here are some specifics about the job: - Content: The presentation will solely focus on accrual accounting. It should be educational in nature, but also engaging for the target audience. - Purpose: This is not for a conference or business meeting. The main goal here is to educate the employees in my company who utilize accruals in their day-to-day work. - Design: The PowerPoint should be visually appealing and professional, with a good balance of text and visual elements. Ideal skills for this job include: - Strong understanding of accrual accounting - Previous experience creating education...

I'm in need of a skilled Matlab expert that can assist me with an image detection project. The particularities of the images, real-time versus offline processing, and the output format are all flexible and can be discussed according to your expertise and recommendations. Key Requirements: - Proficiency in Matlab - Previous experience in image detection - Ability to discuss and decide on the most suitable approach and output format Feel free to share your relevant experience and suggestions to ensure the project goes smoothly. Looking forward to working with you.

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I am in need of a skilled web developer to create a web application to display my events and deadlines. I'm looking for a monthly view for a personal user experience. The project will require a developer who's experienced in creating user-friendly, visually appealing web applications. Key requirements: - A monthly calendar view, that is easily navigable and intuitive for personal use - Ability to clearly display a range of different events and deadlines - A clean and modern design that is mobile responsive, as most of my users will be accessing the app on their phones - Some experience with event scheduling software would be a plus I appreciate any insights or ideas that you can bring to the table. I'm looking forward to seeing your proposals.

I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functio...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm looking for a wizard developer who can create an enterprise API. I do not have a preferred programming language, therefore, use the one you find most suitable and efficient. I need the API to include the following features: I am seeking a skilled developer to create a API to act as a third party implementation to serve clients such a service oriented businesses as Massage Therapists for client booking via scheduling calendar of showing available appointments ( this calendar shall also be utilized by the client to create time blocks when required ) in addition require online credit card initial deposits at time of scheduling and final payments featuring Vaulting to retain credit card details for future or ongoing appointments. A feature automation to fwd notificat...

A project is to find a better idea to overcome ozforensicsBiometric verification without the presence of the person concerned

I'm seeki...high-quality backlinks from reputable websites in the finance industry. - Ensuring global reach: The backlinks must be strategically placed in a manner that enhances my website's visibility on a global scale. Ideal Candidate: - Proven experience in SEO and backlink building: You should have a track record of successful backlink campaigns that have led to improved search engine rankings. - Strong understanding of the finance industry: Knowledge of the finance sector will be advantageous in selecting the most relevant websites for backlinking. - Creative and strategic thinker: The ability to think outside the box and develop a comprehensive backlink strategy is crucial for this project. If you have the necessary skills and experie...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and ...

...seeking an expert in designing and prototyping to help bring my innovative concept in the field of industrial electronics to life. Key tasks include: - Refining the initial design sketches: The product is in the initial design sketch stage, and I require someone who can take the concept and develop it into a detailed, workable design. - Prototyping: The next step will be developing a prototype. The ideal candidate will have experience in taking designs through to this stage, and will be able to advise on the most effective and efficient way to do this. The freelancer most suitable for this job will have experience in: - Industrial or electronics design and prototyping: It is essential that this individual has a strong track record of s...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for ...for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience ...

I'm in need of a skilled Android developer to create a bespoke news aggregator app specifically focusing on commodity news. The app should have the following features and functionalities: - Aggregation: The app should aggregate news from reputable sources for commodities such as Oil, Gold, and Silver. - Real-time Updates: The news content should be updated hourly, ensuring users have access to the most recent information. - User-friendly Interface: A clean, intuitive interface that ensures easy navigation and a pleasant user experience. - AdMob Integration: The app should support AdMob for monetization purposes. Ideal skills and experience for this project include: - Proficiency in Android app development, especially with a focus on news aggregation. - Experienc...

Warning: This project is for advanced developers. Those that can read complex code structures ...fluently. We have enough work for over a year. On the top, after "ReactJS developer", please tell me what was your most difficult ReactJS project you completed and why. Also, how many years of ReactJS experience do you have? Read this job description carefully, as it serves as an indicator to me if you pay attention to detail. The project consists of connecting to a Drupal project via REST endpoints. We're saving data to the PWA using IndexedDB, encrypting sensitive data, and by default refreshing the UI only when there's new data via push notifications (which come from the server using Web Push API), we're also using Android to load the PWA. Is this something ...

...and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requested quotation to anyone. 6. Admin can create multiple sub admins and can assign different rights to them as he wants. 7. After approval of the quotation of the customer, he can place the order and unique order id must be generated against each order. 8. Admin can see the order history and filter the data as required. In order history cust...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I'm searching for a skilled Python developer with a solid background in machine learning and image recognition to work on a project to help me write a python code that can detect the questions on a scanned image and crop them into different images. You can use any library or package. Key Tasks: - Object Detection: I require the developer to implement object detection capabilities within my image recognition system. - Text Blocks Detection: I need a method to accurately detect and interpret text blocks within images. The ideal candidate should have: - A strong background in Machine Learning, especially with Python. - Extensive experience in object detection and image classification. - Expertise in text blocks detection would be a great advantage. The d...

I have an excel file, need add product categorie on a column - budget 100€

As the creator of a YouTube channel called J-Tact, I am in need of a modern and minimalistic logo that properly communicates the focus of the channel - Tactical Gear. • I want the logo to essentially reflect a professional vibe when seen. • The logo should ideally have a sleek, modern design. • Knowledge of design trends and what best suits a channel focused on Tactical Gear is beneficial. • Your creativity will be a great asset to bring my vision to life. • Experience in logo design, particularly for YouTube or similar platforms, would be most helpful. I just create one and I would like that he seem like mine Anyone with expertise in these areas is warmly encouraged to bid. Looking forward to seeing your ideas.

Copy Paste Instagram Outreach text and get paid 5$ per booked meeting and 50$ per closed clients. No skill needed just a laptop and an Internet connection, We will teach you everything. PS: Our most recent hire made 350$ this week

...adapting to our detailed design * Seamless integration with a specific cloud service * Maintain code and fix bugs when required * Create functional, responsive, and smooth UI Skills and Experience: * Proven experience as an Ionic developer * Fluency in mobile platforms: iOS and Android, and web * Proficiency in cloud services integration * In-depth understanding of coding and the ability to troubleshoot and analyze websites for speed, functionality, and aesthetics * Knowledge in making architectural recommendations To be most successful in this position you should have a keen eye for detail, be committed to meeting deadlines, and be eager to fix bugs so that the final product is error-free. I'm looking for someone who will be committed...

...dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be...

Hello, I need complet the Amazon categories catalogue excel in french

I'm seeking a creative graphic designer to create a unique, aesthetically pleasing ...unique, aesthetically pleasing logo for my esthetics healthcare business. Key Requirements: - Must incorporate brown and nude tones, reflecting the calm, warm, and welcoming atmosphere of the business - Experienced in designing logos for health services or retail businesses - Understands the importance of the logo on business cards and can optimize the design for such a format - Uses a modern and clean design aesthetic Ideal Skills: - Graphic Design - Adobe Illustrator - Logo Design - Brand Identity The most suitable candidate will have previous experience with logo designs in the healthcare industry and a portfolio showcasing their style and ability. Looking forward to rec...