Excel exact match jobs

I need an experienced social media video editor and content creator to produce short videos for a social media advertisement. The advertisement is for an upcoming Alumni Reunion/Networking event. The videos should be less than 1 minute in length, three different videos. You can use any music that you see fit but you need to have a...Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this sounds like a project you'd excel at, I'd love to see some examples of...

This project primarily involves editing a mouth to be either completely closed or slightly open. The exact look is yet to be decided, giving you some creative freedom. Additionally, color correction will be required to harmonize the image. Ideal Skills: - Expertise in photo editing and manipulation - Proficiency in software like Photoshop - Experience with color correction techniques - Ability to communicate effectively for potential revisions Please note: the overall mood of the image should remain neutral; the focus is strictly on the lips being closed.

...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...

Project Overview: I have an existing UI/UX design for a Point of Sale (POS) system that needs to be adjusted and extended to match the specifications outlined in my requirements sheet. This project involves updating the current design to enhance usability, functionality, and aesthetics based on detailed requirements. Key Responsibilities: Review the existing UI/UX design of the POS system. Analyze the requirements sheet to understand the specified enhancements and extensions. Update and extend the current design to align with the specified UI/UX requirements. Ensure the new design improves user experience, accessibility, and functionality. Collaborate with me to iterate on design changes and incorporate feedback. Deliver high-quality design assets and documentation. Requirements:...

...and sleek logo for my race car parts shop, ELVTD Performance. The primary colors I envision for the design are blue and silver. Key Points: - The logo should be a blend of both an icon and text. The icon should be simple, yet powerful and aligned with the themes of racing and performance. - The text included should reflect the store's name, "ELVTD Performance". It should be easily readable and match the modern and sleek style of the icon. - The overall design should be minimalistic, avoiding clutter, and with a high visual impact. - The blue and silver color scheme should be used in a way that enhances the logo's attractiveness and gives it a premium look. Ideal Skills and Experience: - Proven experience in logo design, particularly in creating modern, slee...

...explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools like Excel. If this sounds like your kind of project, get in touch and showcase your skills. The information to use is attached...

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

I have a PDF document that needs to be translated from English to Spanish. The document primarily contains marketing materials, and I'm lookin...have a PDF document that needs to be translated from English to Spanish. The document primarily contains marketing materials, and I'm looking for a skilled translator who can accurately convey the original message in Spanish. Key Requirements: - Translate the content from English to Spanish, maintaining the core marketing message. - Preserve the same format and layout as the original PDF. An exact match is not necessary, but a similar layout is expected. - Prior experience with marketing translation is preferred. Please note: - The document is relatively short, with about 3-4 pages of text. - The translation should be de...

I need a skilled professional who can transcribe my scanned Arabic PDF document into a Word document. Key Requirements: - The PDF is scanned, and the freelancer should have experience in converting scanned documents to text. - Ara...document. Key Requirements: - The PDF is scanned, and the freelancer should have experience in converting scanned documents to text. - Arabic language proficiency is a must for accurate transcription of the text. - The final Word document should be in the exact same format as the original PDF. - No images or charts need to be included, so the project is focused on text transcription. Ideal Skills: - Expertise in Arabic language - Proficiency in OCR software for scanned PDFs - Proficient in Microsoft Word - Attention to detail for an exact fo...

Hi guys we have a MERN stack website spillword.com. We would like to add the following functionalities within the subdomain Add : Same design, functionalities, credit system etc as fireflies.ai. Nothing needs to change. Including the left sidebar. You can use the html and page ripper to develop the frontend. ...spillword.com. We would like to add the following functionalities within the subdomain Add : Same design, functionalities, credit system etc as fireflies.ai. Nothing needs to change. Including the left sidebar. You can use the html and page ripper to develop the frontend. Pls view this video for further clarification. Please bid the exact amount you'll charge for this and the time required.

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

...Screening: The software should be able to effectively screen resumes for healthcare positions. - Candidate Ranking: Implement a system that ranks potential candidates based on their qualifications and experience. - Interview Scheduling: The tool should also have a built-in feature that enables easy and efficient interview scheduling. Preferred Resume Screening method: - Keyword Matching: A system to match keywords in resumes to job requirements - Machine Learning Algorithms: An algorithm to predict candidate suitability based on historical data Platform: - Web-based: The software should be accessible via any web browser for ease of use and accessibility - Mobile App: A mobile application should also be developed alongside the web version to allow recruiters and candidates to a...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 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. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...

...refined than either." – Sir William Jones (1746-1794), a renowned British philologist and scholar of ancient India. Sanskrit is one of the most ancient languages, with a rich history dating back over 3,500 years. A unique fact about Sanskrit is its highly systematic and scientific structure, which has influenced modern linguistic theory. The language’s phonetic precision and grammatical rules are so exact that NASA uses it as a model language for machine learning and artificial intelligence. I work in cybersecurity and risk management, with a deep interest in this fascinating language. This is a personal project, and I am looking to collaborate with the best video editor on this journey. To participate, produce a 3 - 5 minutes sample video showcasing your ide...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I need a website built, but I haven't decided on the exact purpose or target audience yet. I'm looking for a freelancer who can help me create a custom website from scratch. I need someone with a great design sense and the technical skills to build a fully functional website. Please let me know what specific experience you have with web development and any similar projects you've worked on.

I am in need of a portrait photographer, specializing specifically in corporate headshots. These professional images will serve a critical purpose in reinforcing our corporate identity. The ideal freelancer for this project should have: - A proven track record on capturing professional, high-quality corporate headshot...track record on capturing professional, high-quality corporate headshots - A solid understanding of lighting, composition, and editing techniques - The ability to create a comfortable environment to bring out the best in those being photographed. Remember, your professionalism and attention to detail can significantly impact the first impression our company makes. Hence, if you are confident and match above-mentioned criteria, I am looking forward to viewing your...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm looking for a skilled web designer from USA OR UK to implement some small but crucial changes to my website. Key Requirements: - Updating the design: This involves changing the color scheme and updating the fonts. I want to refresh the look and feel of my site to make it more engaging and modern. - Content modifications: While I didn't specify the exact details of the content modifications, I want the freelancer to have a keen eye for design and layout. Skills and Experience: - Proven experience in web design, particularly with solid understanding of color theory and typography. - Proficient with HTML/CSS and possibly website builders or CMS platforms. The ideal candidate must be detail-oriented and able to take direction effectively. I'm looking for someone...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

Hi Taras, can you remodel some parts and give them to me in both step and stl formats, there are 3x parts total. I have a base model you can work from but need to scale it up to match the new sizes.

...Y-combinator and Kickstarter if you are not familiar with them. Key Requirements: - The demo should be a high-level overview focusing on the most important features and functionalities of the software of platform: which allows people to raise money for creative projects. ----2. people to browse projects and pledge money ----3. networking messaging for entrepreneurs to connect with and match with other entrepreneurs based on needs like seeking teams mates and skills ----4. online courses - The content should be tailored to a non-technical audience, with a strong emphasis on the software's value proposition for potential customers. - The visual components should be designed to be visually appealing and engaging, while also being professional and business-oriented. - The ...

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...

I'm in need of a tool that, provided a list of words or phrases, the tool can comprehensi...available in a local number (API NOT available) - USPTO (TESS) - Check if the provided word or phrase shows up on Trademark search on USPTO website (API NOT available) - Check google organic search results and identify how many total search results come up for the provided word or phrase AND how many of the top 100 organic search results contain the exact word/phrase in the search result title AND how many of the top 100 organic search results contain the exact word/phrase in the search result description While the user may be able to upload a bulk word/phrase list into the tool, each word/phrase should be checked individually for each of these things and the results should be pr...

I am in need of a graphic designer who can help me with converting my existing logo into ...printing on shirts, so it's important to ensure that the converted files are high-quality and suitable for this purpose. Preferences: - I have specific color preferences for the logo and would like the designer to match the colors to the copy sent. - The font and typography used in the logo are the same as the image I've sent, please ensure this is kept consistent when converting to the different file formats. Ideal Skills: - Proficiency in graphic design and editing software - Experience in logo design and file conversion - Attention to detail to ensure colors and typography match the original Looking for a designer who can ensure a quick turnaround time and deliver high-...

I'm in need of a talented graphic designer to give my existing bold and colorful logo a fresh and modern look whilst still retaining the original essence and elements. recreate the same exact logo same colors and wording Key Requirements: - Modernize the logo: The primary objective is to give the current design a contemporary and updated appearance. - Maintain the Core Elements: It's important to keep the original color scheme, font style, and icon/symbol intact. The intent is not to start from scratch but to enhance the existing identity. Ideal Skills: - Proficiency in graphic design and branding. - Strong understanding of modern design trends. - Experience in logo redesign and brand identity work. - Ability to balance originality with a brand's established visu...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I have a 120MB JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structured data, I'd love to hear from you.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...

...PFD. There may be places where different symbols are used or improperly labeled. Ensure that these are fixed in the P&ID and all symbols and labels are consistent. - Add insulation specs and piping labels as necessary. You might see notes like "2" CS" or "1/4" SS". You need to create proper piping specs and labels. CS, SS, and PVC are piping materials. - We do NOT expect you to simply copy the exact symbols and layout of the PFD. We expect you to interpret the PFD and put everything in proper format and style for P&IDs. Workflow: 1. Use HYSYS simulation software to verify the specifications of the pipes (double jackets) and pumps provided. 2. Upload the P&ID in DWG format as it is completed, not at the last minute. 3. We expect the P&...

I'm seeking a skilled developer to create a form for my WordPress site that allows users to add a variety of colors. This form will need to be designed to match the provided example. - User Interaction: When a user adds or subtracts a color, the form should update in real-time and count up the number of colors selected. The user should be able to see a preview of the selected colors. Furthermore, the form should dynamically adjust the color options based on the user's selections. - Data Handling: The form should send me an email with the final count and types of colors selected. - Layout and Design: It is crucial that the form matches the design of the provided image. Ideal applicants should have: - Extensive experience developing custom forms for WordPress - Proficiency...

I'm lo...accurately reproduced and remain in their original positions. - Maintaining page numbering and headers/footers: The Word document should mirror the PDF in terms of its pagination and any header or footer content. Evaluation: - Accuracy of text conversion: I will compare the text of the original PDF with the Word document to ensure that there are no errors or omissions. - Layout and formatting match with the original PDF: The Word document should be a near-identical replica of the PDF in terms of its visual appearance. Ideal Skills and Experience: - Proven experience in PDF to Word conversions. - Proficient in handling complex documents with tables, images, and special formatting. - Attention to detail and a commitment to ensuring high levels of accuracy in the conv...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel a...

create a printable sheet for me. The sheet will need to be in standard A4 size (8.27 x 11.69 inches). The content of the printable sheet will be a mix of text and images, though exact details are yet to be determined. .

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

Each year we do a t-shirt for our American Football event called Champions for Charity. We need an illustrator to make us a new illustr...attached for reference. 3. The illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside to 2024. 5. The illustration of the mascot kicking the football should match our previous styles, I will send a zip file with reference images from past t-shirts. We want the illustration to have some motion with the mascot kicking the ball. 6. We need this done within 48 hours. Can provide any assistance needed to meet that deadline.

I'm on the lookout for skilled video editors to help bring a cinematic touch to my vlogs. These videos will be over 10 minutes long, so an eye for detail and a knack for maintaining viewer engagement is crucial. Key Requirements: - Proficiency in video editing software - Strong understanding of narrative flow - Ability to maintain visual coherence over long duratio...Trimming and sequencing footage to create a coherent story - Applying effects and transitions to enhance the cinematic feel - Ensuring the video remains engaging throughout its duration - Maintaining the creator's style and vision while offering creative input - Delivering in a timely manner without compromising on quality. If you're an editor with a passion for storytelling and the skills to match, I...

I'm in need of a simple website, to be completed by the end of the week. The main purpose of this site is to match people with a (private info) skill set with those seeking this skill set Basic match making style Key Functionalities: - Contact Form: I need a simple contact form so that visitors can get in touch with me easily. - Image Gallery: to show those with skill sets work, and previous projects Completed - Matchmaking for Skill Set/Hiring: This is a unique feature I'm looking for. I need a mechanism that can match the skills of my members with the needs of other members - Training Area: This will be different from a standard blog. I want to provide a platform for training resources where members can obtain free simple training videos or blogs to refe...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...

...a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and up...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...