Microsoft excel certificationproiecte

I would like to create a solution (can be EXCEL, etc.) for creating working schedule, your solution must have these features: 1. Allow multiple locations, with different schedules and number of workers; 2. Setup multiple workers, set dayoff, hours per week, min hours per day and max hours per day; Example: The worker can have 2 days off (w2 = Monday, w3 = Tuesday, …), should work 48 hours per week, and 5 until 8 hours per day (in sequence, 10:00 – 15:00). 3. Views per week, per month (and per location or per worker) – generate a week / month schedule per location and per worker. 4. A random button to regenerate all again 5. And a button to make equilibrium (YES or NO), with YES on this button, your solution will try to adjust the schedule to ensure the &ldquo...

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.

In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purpose of the project is...

...API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data extraction - Proficiency in bulk data processing and manipulation - Strong understanding of d...

I'm in need of a professional who can put together comprehensive cold form steel shop drawings for my construction project. The ideal candidate should have a strong background in cold form steel detailing and can provide clear, detailed and accurate drawings that will be used for the construction and fabrication of the steel components. The pro...drawings should provide clear and accurate details on how various steel components are to be fastened together. Experience in cold form steel detailing and familiarity with the Alberta Building Code would be a requirement. A background in construction and fabrication would also be a plus. The drawings will be used for the construction and fabrication of the steel components. Alberta P.Eng. certification and Certificate of Authorizati...

...containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data retrieval from QR scans. This entails a complex task, requiring ...

I'm looking for an expert who can help develop a robust integration between QuickBooks and Microsoft Planner via the Quickbooks Web Connector. The main aim of this project is to open QuickBooks to a customer or invoice via a hyperlink from Microsoft Planner. Key tasks include: - Creating features that allow viewing and editing of customer and invoice details - Establishing a function to create new customers and invoices Ideally, freelancers bidding on this project should have the following skills and experience: - Proven experience in integration projects involving QuickBooks and Microsoft Planner - Proficiency in data synchronization and creating customizable reports - Deep understanding of how to embed features for viewing, creating, and editing customers and ...

...project completion. Ability to add HTTPS protocol to EC2 Instance: Demonstrated experience in implementing secure applications on AWS, particularly with HTTPS configurations. Domain Management Experience: Experience with DNS and domain transfer processes, especially within the AWS environment Availability for Immediate Start: Availability to commence work immediately upon contract award. AWS Certification: Vendors having AWS Certified Solutions Architect or AWS Certified DevOps Engineer credentials will have an added advantage. PROPOSAL SUBMISSION In order to account for the urgency, the proposal should be short and to the point and should include the following points: Quotation Relevant Experience with similar work The deadline of the proposal should be 24 hours from the issuan...

I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python

I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I am seeking expertise in moving data from our current on-premise SQL Database to Microsoft Azure. Here are the specifics required: - Experience in data migration with a focus on Microsoft SQL databases. - Expertise in handling and ensuring entity relationship correctness during the migration process. - Proven ability to maintain data integrity and quality throughout the migration process. - Availability for possible follow-ups after migration. Your bid should demonstrate a clear understanding of the task and experience with similar projects. When responding, kindly provide examples of related projects you've handled.

I am seeking expertise in moving data from our current on-premise SQL Database to Microsoft Azure. Here are the specifics required: - Experience in data migration with a focus on Microsoft SQL databases. - Expertise in handling and ensuring entity relationship correctness during the migration process. - Proven ability to maintain data integrity and quality throughout the migration process. - Availability for possible follow-ups after migration. Your bid should demonstrate a clear understanding of the task and experience with similar projects. When responding, kindly provide examples of related projects you've handled.

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

I'm looking for an experienced graphic designer to create a professional estimate cover page template on Microsoft Word. This template exclusively has to be in the Letter format (8.5in x 11in). The created template must be easy-to-edit and should contain the following elements: • My company logo • Space for contact details • Space to include a project title • A designated location to place a project photo Ideally, the design should incorporate my company logo and colors to maintain brand consistency. Proficiency in Microsoft Word and graphic design are critical for this role. An understanding of design aesthetics would also be beneficial. The completed project should deliver a finished template file that is ready for use. Your creativity in presenti...

...me develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency ...

I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.

Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?

You'll need to customize your UET tag tracking code to report a custom event. To do so, copy and modify the code attached and add to your UET tag tracking code. Needs to be done via GMT

I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding -...

...details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline ...

I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.

I need to convert scanned PDF pages into a simple, text-only Word document. The original PDF...to convert scanned PDF pages into a simple, text-only Word document. The original PDFs contain images with text. Key Requirements: - Extracting text from scanned PDFs - Converting extracted text to Word - Maintaining the text only, no formatting required Ideal Freelancer: - Experience with OCR (Optical Character Recognition) tools for extracting text from scanned documents - Proficiency in Microsoft Word for converting the extracted text - Familiarity with handling PDFs containing images with text - Attention to detail to ensure accurate extraction of text Please note that the final deliverable should be a clean, text-only Word document that accurately captures the content from the sca...

Excel to PDF Entry Work need to be done

1- Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the user wit...

I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.

I'm looking for a freelancer who can conv...looking for a freelancer who can convert my existing Google Document into a Word document, ensuring that the finished product is identical to the original in terms of formatting and layout. This includes, but is not limited to: - Preserving the structure, font styles, and general format. - Carefully replicating charts and graphs. The successful candidate will be proficient in both Google Docs and Microsoft Word, and will have a thorough understanding of document conversion processes. Knowledge of how to effectively realize charts and graphs in Word is desirable. The final Word document needs to be downloaded to my local computer. Overall, the emphasis is on attention to detail to ensure a high-quality Word document matching the Goog...

I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.

It just suddenly started happening. Shutdown and Restart don't change it. Windows 10 Microsoft Office Home and Student 2016 The attached jpg DID shows: 1. What ChatGPT told me to do. 2. I did it. 3. The huge Caps Lock On/Off image still appears when I press the Caps Lock key. I also checked Word Options - Advanced - Editing Options but there's apparently nothing related to the Caps Lock key (see other attached jpeg.)

Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.

Wir sind ein Gastronomiebetrieb und möchten die Kontrollen und Übersichten über diverse Verkäufe, Arbeitszeiten der Mitarbeiter und ähnlichem vereinfacht und am besten mit Automationen in Excel-Listen eintragen. Auswertungen der Verkäufe usw. werden per Mail des Kassensystem-Dienstleisters an uns gesendet. Diese Auswertungen sollen dann in die Excel-Listen eingefügt werden. Mit wenig oder am Besten, durch Automationen, mit keinem Aufwand. Sinn ist es Arbeitszeit zu sparen und Fehler zu vermeiden.

...analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies. ### Scope of Work 1. **Data Org...

I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in touch with the successful candidate soon.

...Proven experience in social media management - Strong understanding of email marketing best practices - Excellent communication and copywriting skills - Ability to analyze data and draw insights - Familiarity with social media analytics tools - Experience: 4 to 5 years, must be a self-starter and motivated. Preferred if worked for companies offering B2B or Online services. - Qualification: Certification in SEO & Digital Marketing must. Must have good knowledge of Moz, SEMrush, Sales Navigator, Search Engine optimsation & Social Media Marketing platforms. - Language: English, Hindi, Native language. Please provide examples of previous work and results achieved....

I need a Google document converted into a Word document (.docx). The key details of the project include: - Converting a Google document to a Word document while preserving the original formatting. This means that...Converting a Google document to a Word document while preserving the original formatting. This means that the final Word document should look exactly like the original Google document. - No content updates or edits are required during the conversion process. The focus is solely on the correct and accurate conversion of the existing content. Ideal Skills & Experience: - Proficiency in Google Docs and Microsoft Word - Strong understanding of formatting preservation - Experience with document conversion - Attention to detail to ensure accuracy - Timely delivery of the ...

...streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating exc...

I am looking for an experienced freelancer to assist with a data entry project. The task includes entering both text and image data taken from a medium-sized collection of Word documents. This is not a minor task as it involves inputting between 100 and 1000 entries. The ideal candidate should have: - Familiarity with Microsoft Word and data entry practices - The capability to handle both text and image data effectively - Strong attention to detail for accuracy - Ability to commit until project completion Please ensure your bid reflects your experience and your expected completion time. With the right set of skills, this task can be accomplished effectively and in a timely manner. Looking forward to your proposals.

...for uncovering insights and unraveling complex issues. · Analytical Prowess: The ability to dive deep into data and emerge with actionable intelligence. · Effective Communication: Articulate your findings with clarity, both in writing and verbally. · Adaptability: Stay nimble in a fast-paced environment, responding to evolving challenges with ease. · Tech Savvy: Proficiency in tools like Microsoft Office and Analyst's Notebook is a plus. Requirements: · A Bachelor's degree in a related field or equivalent experience. · Strong communication skills and a knack for information gathering. Compensation: · Enjoy project-based payments ranging from approximately $3000 to $5000 per project. Job Types: Full-time, Part-ti...

I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Co...Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instruct...

I am seeking a seasoned content creator(female) who can bring my fashion brand to life with engaging articles, captivating videos, thought-provoking infographics, and innovative stor...responsibility: - Deliver fresh, stylish, and relevant content on a weekly basis, tailored towards fashion - Creativity and an in-depth understanding of fashion trends is a must - Ideal skills: - Exceptional writing and editing skills - Proficient photography and videography skills - Ability to convey fashion narratives in a compelling, authentic way - Proficient in Adobe Suite, Canva, Microsoft designer for creating infographics Experience in both the fashion and digital content creation space will be highly regarded. Express your flair and make your mark in the fashion indus...

DESEO HACER UN CAMBIO DE TARIFAS DE UN DOCUMENTO EN WORD DONDE ACTUALIZAR EN BASE AL TEXTO INICIAL SOLAMENTE MODIFICAR LOS IMPORTES QUE SE INDICAN CON LOS CONCEPTOS E IGUALMENTE A EXCEL POR APARTADOS

I'm seeking a skilled individual to accurately convert a PDF document into a Word document. The prime purpose of this conversion is for extracting text. - The project demands the highest level of precision, with a requirement for 100% accuracy in the extracted text. Any mistakes in conversion could result in significant inaccuracies, hence meticulous atten...is vital. - It's imperative that the Word document maintains the original format of the PDF for consistency and ease of navigation. The freelancer must be well-versed with advanced Word formatting to accurately replicate the original PDF layout. Ideal skills: - Proven experience in data entry and document conversion - High level of accuracy and attention to detail - Strong understanding of Microsoft Word's adva...

...stands only one motto--pick up on every opportunity to develop innovative applications for startups and enterprises to grow and advance in the digital space. If the challenge is digital transformation, the solution is TRooTech and nothing less. Please visit our website Linked-in profile Detailed Job Descriptions - Strong proficiency in Microsoft Dynamics 365 for Finance and Operations (D365 FinOps), including experience with retail functionality - Experience in customizing and extending D365 FinOps retail solutions using X++ and .NET technologies - Proficiency in developing and maintaining retail management systems, point-of-sale (POS) systems, and inventory management systems - Demonstrated expertise in designing and implementing retail

I am seeking a creative professional to create a company letterhead that aligns with my brand. The letterhead should be sophisticated and professional. We already have a brief. We already have all the brand colours and elements but just need someone to put everything together on illustrator. There are 6 points on the brief. Key elements to be included: - Company logo - C...final design should be delivered in a Word document. Color Scheme: - The color scheme should match the company's brand colors. (colour code to be advised) Ideal Candidate: - A graphic designer with experience in creating company letterheads and a strong understanding of consistent branding. Your portfolio should display your ability to create professional and clean designs. Understanding of Microsoft Wor...

I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting templates in Wor...

I am in need of an experienced and knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design ...particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skills and the ability to explain complex technical concepts in a clear and concise manner. The goal of this project is to equip participants with the necessary skills, knowledge, and practical experience to excel as advanced pentesters in a professiona...

...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work  Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categorizing online me...