Most used excel formulas in accounting jobs

I need a freelancer who possesses exceptional skills in data entry and Excel for my project. Your primary role will be - Typing data from my files into a structured Excel spreadsheet. - Applying data functions and formulas. An in-depth knowledge of Excel functions is crucial as you will need to implement them to maintain the structure and manipulate the data that will be transferred to the Excel spreadsheet. A knack for accuracy is also crucial as I strive to maintain the highest data integrity.

I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure...

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora

...teams Takes on the most challenging development projects. Identifies and proactively tackles these major challenges. Leads adoption of new tools, methodologies, and systems. Gives guidance, unblocks others, and may function as team lead May function as a team or segment lead Mentors more junior developers Follow standard software development life cycle processes Develop, test and maintain enterprise applications Design and implement complex enterprise applications Continuously innovate and modernize applicable software development technologies and trends Perform code reviews Create and maintain appropriate documentation Communicate effectively with operational teams with complex software concepts Translate technical requirements, develop application interface Manage time in...

For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.

Hello there, Currently, we are looking for Native Polish Speakers with professional language skills to translate English texts into Polish and Polish texts into E...meet deadlines The only requirement is that the translations must be done manually (Human), not by machines, Google, or DeepL. Otherwise, it will be rejected. It can be an ongoing project if you do a great job. ⭐ Invited freelancers ⭐ are most welcome in advance also the fastest response would be appreciated since we're going to start the project right away. Note: We will talk to all candidates, whether they are new, experienced, or placed their BID after closing or awarding the project. We are looking for several speakers. Project details will be shared in the chatbox. We are looking forward to y...

...will be used in correlation with sales data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analys...

- Your past experience does NOT matter! - Any social media marketing experience does NOT matter! - Your education certainly does NOT matter! - Your knowledge of any oth...experience does NOT matter! - Any social media marketing experience does NOT matter! - Your education certainly does NOT matter! - Your knowledge of any other field definitely Does NOT matter! - Your age, location, speech, looks, ethnicity, etc. does NOT matter! What matter is : You should know how simple advertising on Linkedin can be done to generate relevant leads. And, you must do this for me in the most competitive rate. My fixed price is low but if I get result I will continue to use your services and of course you will be given incentive remuneration too! :-) REQUEST: IRRELEVANT FOLKS KINDLY DO NOT...

...expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. I would like to to be able to divide each sections in strip section to be then cut on my plasma. I have included a YouTube video to show what i am looking for . I want to have a reference line that i can curve on every axis along the length required in order to follow the curved and straight section needed. - On that line I want to have adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs

...and perform a Discounted Cash Flow (DCF) analysis for Marico, leveraging historical data from their Investor Relations (IR) presentation and Annual Report. This will include a thorough examination of revenue and cost factors along with balance sheet and cash flow analysis. Task 2: Potential Acquisition or Investment in the 'Foods' Category by Dabur Objective: Draft two to three slides outlining the opportunity and rationale for Dabur's potential acquisition or investment in the 'Foods' category. Suggestive Approach for Task 1 1. Data Collection: - Gather historical financial data from Marico's IR presentation and Annual Report, focusing on the income statement, balance sheet, and cash flow statement. - Supplement this data with relev...

...financial stability. Experience in real estate accounting and financial management is a must. - Maintenance and Repair Coordination: You will be responsible for organizing and supervising maintenance and repair work across the properties. Effective problem-solving skills and a strong network of reliable contractors are essential. - Bylaw Enforcement: Familiarity with local property laws and strata bylaws is crucial. You will be responsible for ensuring that residents comply with the rules and regulations set by the strata. Moreover, you will also be required to: - Keep thorough and accurate Minutes of Meetings. - Communicate effectively with property owners and tenants. I'm looking for someone with: - Prior experience in strata management (specifically in...

Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.

I re...tech start-up. Our primary goal is not only to guide operations but most importantly, secure funding. - First, we operate in the technology industry, giving the task an innovative feel. So, a flair for crafting compelling narratives around technology projects is a must. - Secondly, we're at the start-up stage. Consequently, the potential for growth and scalability is immense. Candidates should be able to effectively communicate this potential onto paper. - Lastly, I would like to attract investors. Your experience in pitching businesses to investors, understanding their expectations and key concerns, will be highly appreciated. Skills ideal for this job would be advanced understanding of the technology industry, experience in start-up developmen...

We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks

I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.

I need a skilled accounting professional who's experienced with ZOHO to help me reconcile my business's bank account for the past 5 months. Key Details: - Accounting Software: ZOHO - Bank Accounts: 1 - Timeframe: ASAP The ideal candidate for this project should: - Have a strong understanding of ZOHO - Possess extensive experience in bank reconciliation - Be able to work quickly and accurately to meet the urgent deadline Please provide your relevant experience in your proposal.

I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.

...be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big plus. Your previous succ...

I am seeking a seasoned and highly efficient accountant to assist with bookkeeping, tax preparation, and financial analysis in a long-term capacity. Key Responsibilities: - Manage and maintain our financial records with rigorous bookkeeping - Conduct tax preparation and ensure all regulations are adhered to - Complete a financial analysis tailored to our business strategies Required Skills and Experience: - Proven accounting experience, particularly with bookkeeping, tax preparation, and financial analysis - Familiarity with Tally accounting software - Ability to work effectively in a long-term role The ideal candidate will ensure our finances are accurate, up-to-date, and compliant with legal regulations. You should be experienced, meticulous, and dependab...

In need of an experienced freelance photographer with a keen eye for candid photography to capture one of the most precious moments of my life - when I propose to my girlfriend in Florence. Key Details: • Date of occasion: 22/05/2024 or 23/05/24You will need to be available in the afternoon for the shoot. • Setting: The session will take place amidst Florence's . Required Photographer Experience: • Background in candid photography • Local or familiar with the city of Florence and its enchanting streets would be a plus. • Reliability to be present at the right time • Ability to work discreetly to maintain the surprise element Your role will not only be just to document, but to capture the moment through your shot...

I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.

**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...

I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will ...

I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.

I'm in need of a talented developer who can create an AI-driven web application. This application will be controlled through voice commands, utilizing avatars, and incorporating a chatbot. - The main features of this project are: - Voice Control: The app should be able to comprehend user's voice commands. - Avatars: It should include a feature that uses avatars for user interaction. - Chatbot: The application should integrate a chatbot to handle user interactions. - The application should be compatible with web browsers, ensuring it can be accessed and operated smoothly without the need for a separate mobile application. - The most important aspect of this project is the bidirectional voice conversion functionality. It should seamlessly con...

I'd like to have a Google Sheets-based Fixed-rate mortgage EMI calculator created. The calculator should require users to input the lo...have a Google Sheets-based Fixed-rate mortgage EMI calculator created. The calculator should require users to input the loan amount, interest rate, and loan term, and then provide the EMI for that mortgage. In addition, the calculator should also include: - An Amortization Schedule - An Extra Payment Calculator - An Affordability Calculator I am looking for an experienced spreadsheet professional who can create these functionalities in an easily understandable and user-friendly format. This project requires a strong understanding of mortgage calculations, Google Sheets and financial formulas. Please reach out if you have the re...

I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a ca...

I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.

I am in need of a tool that can effectively extract information from Telegram groups and channels for lead generation purposes. Key Requirements: - Extracting phone numbers: The most crucial information I need are phone numbers for potential leads. Purpose: - The extracted phone numbers will be used for WhatsApp marketing. Ideal Skills: - Proficient in data extraction from Telegram - Experience in lead generation - Knowledge of WhatsApp marketing Looking forward to receiving bids from experienced freelancers who can fulfill these requirements.

I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for da...

We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system s...

I'm in need of a proficient Power BI developer with a keen understanding of data modeling and transformation for the purpose of creating an intuitive dashboard. This dashboard will primarily focus on showcasing our sales and market data. Most of the data would be related to Transportation and Logistics Domain, for eg : Port Wise Performance Customer Support Analysis Database would be PostgreSQL Key Components: - Incorporation of various visuals such as line and bar graphs, pie and doughnut charts and maps to effectively represent geographical data. - Advanced skills in handling complex sales and market data, and ability to visualize this in a digestible manner are essential for this task. - Familiarity with creating reporting tools using similar datasets...

I need a seasoned professional with expertise in .Net Core to assist with integrating and retrieving data from the Amazon Selling Partner API. The key tasks for this project will revolve around API integration and product data retrieval. Key Requirements: - Proficiency in .Net Core - Proven experience with API integration - Strong background in product data retrieval - Familiarity with Amazon Selling Partner API would be advantageous The ideal candidate should be able to guide the most effective ways to extract product data from Amazon's API and implement this process seamlessly. I need help of expert on hourly bases with my team. The person who we will hire they need to seat with my team and give solution where we have facing problem. The main problems ...

I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.

The need a track and train parameter basis inputs interface to talk to the different formulas that calculate the forces for different situations. In addition to this the train and track parameters should generate the desired track design parameters from the inputs tables for cross referencing the current track conditions to what the desired track should be

I'm looking for a skilled designer to create a modern, sleek brochure that will be used to inform about a product or service. The brochure will be distributed in both print and digital formats. Key Requirements: - Modern, sleek design to attract the target audience - Strong understanding of layout and typography - Experience in creating effective marketing materials - Proficiency in design software and tools Your role will be to design a visually appealing brochure that effectively communicates the desired information about our product or service, in line with our brand tone and style. The end result should be suitable for both print and digital distribution. Folded Size: DL (99 x 210 mm) Fold: Tri-fold Most of the text will come an exis...

I'm looking for a professional who can help me design a custom formula for a car shampoo. The shampoo is intended for everyday consumer use, so it should be both effective and safe for regular...must be safe and gentle on car paint to avoid any damage and ensure a long product lifespan. - Eco-friendly: The car shampoo should be completely biodegradable to align with sustainability goals and cater to environmentally-conscious consumers. The ideal candidate for this project should have a strong background in chemical formulation, particularly in the automotive or cleaning product industry. Experience with creating high foaming, gentle-on-surface and eco-friendly formulas is a significant advantage. The ability to balance these properties effectively will be key to...

...promotional video for our esteemed "Postgraduate Diploma in Counselling Psychology" program. The video will target career changers specifically. Key requirements and details: - The video should effectively highlight the program's three main selling points: its course recognition by Singapore Association of Counselling, our experienced faculty, and the hands-on practical training the students receive. - Aim for a balance of engaging visuals, compelling narrative, and informative content that appeals to individuals considering a career shift into counselling psychology. - We'll need the final video to be high-quality and suitable for promotional purposes across various online platforms. The ideal candidate for this job will have: - Proven experience in ...

Excel Report Template + VB6 Function

...an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are correctly matched to the amenity titles. • Ability to deliver the task w...

I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.

I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.

...records to ensure they accurately represent our corporation's financial position. - Regulatory Compliance: Understanding of Canadian financial regulations is essential to ensure our financial statements are compliant. - Communication: It's important that you can clearly communicate your findings and sign off on our statements in a timely manner. Ideal candidates should be: - Certified Accountants: You must be a certified accountant in Canada. - Experience in Corporate Accounting: Previous experience with corporate financial statements is preferred. - Knowledge of Canadian Financial Regulations: An understanding of Canadian financial laws and regulations is crucial for this role....

Please Sign Up or Login to see details.

I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.

I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.

I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.