How to count by month and year in excel jobs

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I'm seeking a skilled writer with solid knowledge in basketball, baseball, and National Hockey League (NHL), to produce captivating articles or blog posts focusing on historic performances and rivalries. The aim is to illustrate the dynamics of these sports as they've evolved overtime, highlighting remarkable events. Key Requirements: - Must have in-depth knowledge of basketball, baseball, and NHL - Proven experience in sports writing - Ability to deliver work within a month - Ability to analyze and comment on historical data effectively - Excellent storytelling skills, ability to spark reader interest This writer must be passionate about these sports and have a knack for unc...

* Must have atleast 1 year experience working with on-page/off-page optimization, link-building, directory submissions, blog/forum commenting, article submissions, back link strategy implementation and link wheeling. * Develop and execute SEO strategies to increase organic search rankings and traffic. * Perform keyword research and identify target keywords for optimization. * Optimize website content, meta-tags, and other on-page factors. * Conduct regular SEO audits to identify technical issues and opportunities for improvement. * Analyze website data and provide insights into SEO performance. * Understand and stay current on industry trends, search engine algorithm updates, competitive landscape, and inte...

I'm looking to have a new website created. The key task involved in this is harvesting photos and data from Website A, and using this to create our site. The following details outline the project requirements: - Downloading photos and data from Website A. - Upload these photos and data to the corresponding sections on our website. The new site should mirror the content placement of Website A. Ideal skills for this job include website creation, data extraction, and efficient data input methods. Experience with content migration is highly desirable. Deadline for completion is within a month from the project start date. All data need to be updated each day

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can ...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure th...

...experienced Sourcing and Procurement Specialist who can be part of our team. Salary: $525 - $850 (negotiable depending on experience) / month Contract: Full time - 40 hrs. / week (flexible schedule with at least 3 hrs. overlap with US Pacific business hours) Position Overview: The Sourcing and Procurement Specialist will play a pivotal role in our operations, responsible for managing client accounts and sourcing materials from various platforms and suppliers. The ideal candidate will be fluent in English and have strong Mandarin skills, as a significant portion of our supplier base is located in China. They will have a strong background in mechanical engineering, sourcing, negotiating contracts, and coordinat...

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been wo...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you ...

Thanks for considering us for the project. We agreed on 1350 USD per month rate and you are going to bear 50% freelancer fee as well. We are going to provide full time flutter resource for the requirements as well. He is going to work 8 hours in a day for full month.

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience ...

I'm in need of freelancers who can assist with live streaming on Kwai. The streams are to be public and will primarily focus on entertainment content. Live content: casual games. During the live broadcast, introduce the game you are playing to the audience. Live broadcast platform: Kwai platform Live time: Live broadcast time: 7:00-10:00 in the evening local time in Brazil, two hours of continuous broadcast every day. Rest: 4 days off a month. Basic requirements： computer equipment and Internet in Portuguese (and preferably in English) and cheerful the face live Job salary: Fixed part: 2 hours of live broadcast every day, 10 US dollars per hour. If you are willing to broadcast for ...

...written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , in...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

...currently in search of trendy fashion models with a social media presence on Instagram and TikTok. Ever wanted to launch a creator/model/influencer career or exponentially grow your existing social media fanbase now is your chance. The right applicant will benefit from being supported by a professional business consultancy team and marketing experts who will provide everything you need to succeed. Requirements include: Must have a professional attitude and focus. Able to commit 10 hours per week producing content. Able produce content for Instagram & TikTok every day. Comfortable creating various themes aimed at an older audience. Benefits include: Home based remote. Weekly salary. Earn commission of all content sales. A...

...looking for an experienced Google Ads specialist to manage a campaign promoting our company. The ideal professional should possess a good understanding of both Google Search and Display networks, as well as experience in video advertising on YouTube. Key Requirements: - Proficiency in Google Ads: Extensive experience in setting up, managing and optimizing campaigns across Google Search, Display, and Youtube is crucial. - Creative approach: Ability to create compelling ad copy and engaging video content. - Results-driven: Capable of increasing website traffic, generating leads, and improving brand awareness through the campaign. - Weekly updates on the ads. - Time-management: The project should be completed within a...

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries r...

Re-Design and Add to our Product Labels (See Attached Examples). Use Different Golf Cart Pictures And/Or Colors To Differentiate Between The Different Models. Each Label Will measure 5 Inch (127MM) Height x 8 Inch (203MM) Width. Key Points For Each Label Are: CanLiFe Lithium Golf Cart Battery * A Single Drop In CanLiFe Lithium Battery Replaces An Entire Set Of Conventional Lead Acid Batteries & Can Operate A Stock Golfcart In Any Terrain. * Assembled In Canada * Backed By A 6 Year Limited Warranty * Estimated Range And Capacity To Be Displayed Prominently * Bluetooth Enabled - Monitor State Of Charge From Your Phone Total of 12 Labels to be created: Front Plaques: CanLiFe Lithium Golf Cart Batt...

...searching for a skilled and creative book editor who can assist with editing a range of professional textbooks across various subjects including finance, taxation, and costing. Key Qualifications and Experience: - Experience in editing textbooks is a must. - A Creative approach to editing is highly valued. The project is on a tight schedule, and ideally, I'd like the editing work to be completed in less than a month. The level of editing required is Substantive or structural editing, along with Rewriting to enhance clarity and style. Your task will be to: - Edit and enhance the text of professional textbooks. - Ensure the content is engaging and clear for the reader. - Implement ...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I am in need of a competent translator who can accurately translate a set of vaccination cards from Kurdish to English (US). Precision and a strong grasp of relevant terminology in both languages is essential. The total word count of the documents falls in the range of 600 to 1200 words. Key Requirements: - Fluent in English and Kurdish - Proven experience in professional translation - Familiarity with relevant language and terminology - Attention to detail and commitment to quality - Ability to meet deadlines Ideal Candidates: - Kurdish native speakers with a rich translation background - Professionals with experience in personal document translation - Individuals who can dem...

I need someone to help me with my weekly projects that involve Quality Assurance Testing and Consultancy services for a few major international tech firms. Projects and work are continuously available so there is plenty of work weekly We will work through remote working software to connect to our local machines using this software, not the other way around so there is nothing to worry about your privacy. Testing will be done on Windows desktop and will mainly involve QA checks and regression Testing of certain software. All testing done are on confidential pre-release test builds so discretion of what you test IS IMPORTANT. Please acknowledge this in your proposal. An NDA will be signed in this regard. I require someo...

...administrative, research, and customer support tasks. The ideal candidate will work part-time and have great communication skills. Key Tasks: - Help with administrative tasks: This includes managing my calendar, setting up meetings, and handling basic bookkeeping. - Conducting Research: I need someone who can gather information for me on topics that I provide. - Assisting with Customer Support: You will need to handle customer inquiries and provide basic support. Communication is key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtual assistant or ...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

...unique and eye-catching logo for my roller skating group, the "Bad Boys Skate Crew", as we are gearing up to celebrate our 5th year anniversary under the theme "B5". Your design will be pivotal in helping us commemorate this milestone in a special way, so we're looking for something truly special. Key requirements for the logo: - Design Style: I'm seeking a blend of urban flair and cleanliness. The logo should have a bold and eye-catching appeal, reflecting our group's dynamic spirit. - Branding: Options for branding could include the following words - B5, Bad Boys Skate Crew, Bad Boys, 5th Year Anniversary, BBSC - Color Scheme: The logo should primarily feature the colors black, white, and...

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and...

I am searchi...graphic designer with experience in vehicle wraps. I need a design for my mobile veterinary van - a teal-based color scheme is preferred. Key points for the design: - There should be an illustration of a vet with a dog. - Include the text: 'Talk to me about once a year tick and flea prevention'. I also want to feature the services I offer, so potential clients can see what's on off at a glance. Services being; Health checks, Vaccinations, Desexing, Heartworm prevention, Once off yearly flea and tick prevention, - A Bravecto Quantum logo needs to be visible somewhere on the wrap. Effective experience in van wrap design and a good understanding of incorporating brand identity into design are ad...

...Where we do player analysis, match recaps, narratives on different topics in the tennis world. If you do not watch/pay attention to tennis on an almost daily basis then this is not the right job for you. We also have a host for our channel so the script needs to be cohesive and casual enough for someone to read off of it without it sounding like a script. You will be responsible for writing (3,000~) word scripts 1-3 times a month, with reasonable turn around times if you are interested in applying, please show us examples of your previous work. We are looking for someone who is self-driven and makes sure that 100% of their information is correct and turns in scripts on time consistently. The scripts should contain...

More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP

More details: Do you have any specific design preferences for your WordPress website? Professional and corporate Which of the following functionalities are essential for your website? Contact form, Blog section How soon do you need your project completed? Within a month

...reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Pow...

My Company is SEO Right Now and I need that listed on the flyer (maybe in top left corner or similar) NOT TOO LARGE but just somewhere on the flyer nicely please, along with the URL and say: For SEO Services and Google Page 1 Results, visit - PLUS it needs my phone number: (206) 395-6759. I like layers on layers, icons and bright beautiful color, not pastels. I'm in need of a professional flyer that will promote my SEO service specifically targeted towards small and medium businesses. Key Points: - I'm looking for a creative, bright and colorful design which can competently attract potential clients. - The flyer should be able to clearly communicate my SEO services and differentiate my offerings from com...

...between 17 to 20 illustrations. - The preferred style is realistic, ensuring that the visual elements resonate with children aged 6-10. The ideal candidate will have: - Proven experience in illustrating children's books, with a focus on conveying emotions and relationships. - A portfolio that showcases a realistic illustrative style. - Strong communication skills to understand and incorporate my vision into the illustrations. The illustrations shall not have previously been used anywhere, nor can they be used in the future. I am requesting copyright/ commercial rights. A transfer of copyright agreement will be signed. In addition to the source files, and JPG files for all illustrations for the final submission. Paym...

...seeking a skilled video editor to help with my monthly Youtube uploads. The video is always under 10 minutes and then broken into 3 other 3-4min videos using the same 10min video content. The required editing style is that which is consistent with my previous content. Key Responsibilities: - Edit monthly Youtube videos (10 minutes in length) - Keep the editing style consistent with previous videos -Break 10min video into 3. Ideal Skills and Experience: - Proven experience in video editing, ideally on Youtube content - Ability to mimic and maintain a consistent editing style - Strong attention to detail - Good communication skills, ensuring you understand my vision and direction. What will be provided each month. -...

Hello Andre, sorry for replying this late. After reading your requirements, I can make a shorter version of your needs over here, to see if I'm understanding your request right or not: Objective: Redesign the input page for your users (manufacturers) to document their supply chain process, making it more user-friendly and easy to follow. Current Problem: The existing input page has become overly technical and difficult to navigate. Deliverables: Figma file for desktop and tablet view, that includes a high-quality design and all design components Style: Blue-ish color scheme, professional style If everything is correct, you can accept my proposal and I can start asap ?

I'm seeking a talented graphic designer to create a flyer that promotes my event. The flyer is for a 12 year olds birthday sleepover Key Requirements: - Design a flyer - The design should be kid friendly Details: Join us for a GAME NIGHT sleepover to celebrate Rauf's 12 Birthday Drop Off: Saturday, June 1st, 2024 at 5:00 PM Pick Up: Sunday, June 2nd, 2024 at 11:00 AM For address and RSVP contact Rashemma(mom) at 267-902-0114 by Tuesday, May 27th, 2024 Please bring pajamas

I'm seeking an experienced Facebook Advertiser, well versed wi...an experienced Facebook Advertiser, well versed with promoting products to specific audience demographics. I intend to use this campaign as a tool to drive significant sales growth. Key Tasks & Skills required: * Craft engaging, sales-centric ad content * Experience in optimizing Facebook ads for sales * Detailed understanding of Facebook's ad targeting capabilities * Familiarity with the behaviors and consumption habits of 25-34-year-old demographics. Your mission, if you choose to accept it, is to create and implement a strategic ad campaign that will effectively reach my target audience and significantly increase sales. Previous experie...

...experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and a proven track record of successfully raising equity capital for companies and funds in the growth stage. SKILLS AND EXPERIENCE REQUIRED: 1. Proven experience in lead generation within the financial services sector. 2. Successful track record in raising equity capital for growth-stage companies. 3. This project requires a proactive and results-oriented approach. 4. The successful freelancer will work closely with our executive team to develop and execute a comprehensive capital-raisin...

I'm in need of a skilled professional to layout my non-fiction book to meet the formatting requirements of Amazon. Here's what I'm looking for: - Layout: I need a professional layout and formatting for a non-fiction book according to Amazon standards. - Elements: The book will have footnotes or endnotes which need to be incorporated into the design. - Word Count: The book is under 50,000 words which should make the task easier and less time-consuming. The ideal freelancer for this project would have: - Experience in book layout and formatting, particularly for non-fiction genres. - Familiarity with Amazon's book formatting standards. - Ability to seamlessly incorporate footnotes or endnotes. ...

I'm looking for an experienced graphic designer to create a professional logo. The intention is to evoke brand recognition, professionalism, and visual appeal. Key requirements: - Use of blue, white, black, and silver colors predominantly. - The logo should be attractive and be easily remembered. - Designer who is creative, pays attention to fine details and has an understanding of brand identity. - Experience in creating logos in various formats is a must. The project should be completed within a month. A good eye for aesthetics and strong design fundamentals are the desired skills for this job. Looking forward to creating a captivating logo that enhances our brand image.

...stock trading. My goal is to target users who are interested in trading stocks, with the aim of improving: - Video Views - Likes and Shares - Follower Count I'm already quite advanced in my knowledge and experience with trading stocks. Therefore, the primary focus of this project will be to create content that will attract and engage this specific target audience. The ideal candidate for this project should have a deep understanding of the stock market and how to communicate complex trading concepts in a clear and engaging way. Key Responsibilities: - Develop a content strategy that resonates with a stock trading focused audience - Create engaging content that attracts and retains ...

...expert to seamlessly integrate the Gemini API within my existing app. This integration needs to facilitate real-time updates on specific information. Key Project Details: - The primary focus of this integration is to enable real-time chatbot updates and basic reporting. - The API should provide up-to-date data when I request a report. - This isn't for automating trades or portfolio performance monitoring but specifically for keeping the chatbot informed with the latest updates. Ideal Skills and Experience: - Proficiency in with a proven track record of API integrations. - Deep understanding of the Gemini API and its capabilities for real-time data. - Prior experience in developing chatbots or similar interactive fe...

...who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a...

...designer to create a minimalist logo and corresponding intro/outro video clips for my content. - The logo should be minimalistic in style, with a soft and pastel color scheme. - It should feature a specific icon, something to do with camping and/or caravanning, as the main element. I have added some ideas which I am not wedded to. - The intro and outro video clips should reflect the same minimalist aesthetic and soft, pastel color theme, incorporating the logo into a brief, engaging animation with a catchy tune. Outro should include social media links and invite the users to like, subscribe and even message us. The name will be 'A Life Less Ordinary' with a tag line of ' Living life...