12 Basic Excel Formulas & Functions To Supercharge Your Reporting Skills
Below are 12 basic functions and formulas that everyone should know.
I have an existing project which includes a simulation, data analytics charts, and text. I need all of these to be redone and improved. Here's what I'm looking for...the project needs to be revised. This includes ensuring that the text is clear, concise, and well-structured. Ideal Skills and Experience: - Proficiency in simulation design and refinement - Strong background in data analytics and visualization - Experience with creating charts in Microsoft Excel - Ability to edit and revise technical texts Please note that the original project is available in PDF form, containing all the solutions, which can serve as a guide for the redo. If you're confident in your ability to refine the simulation, enhance the data analytics charts, and revise the text effectively, I...
رسم مخططات المشروع المرفق مع تنفييذ معظم المتطلبات الموجود ب pdf
The project is to create Inverter automation to start export, stop export and charge the battery automatically using a microcontroller that can subscribe to the server to get spot prices to run the automation. Objectives: 1. Modbus read and write 2. ESP32 Webserver 3. Spot price subscribe 4. Calculation / rules 5. MQTT Service (Server) 6. Price Service (Server) 7. Device Dashboard (Serve...using a microcontroller that can subscribe to the server to get spot prices to run the automation. Objectives: 1. Modbus read and write 2. ESP32 Webserver 3. Spot price subscribe 4. Calculation / rules 5. MQTT Service (Server) 6. Price Service (Server) 7. Device Dashboard (Server) Project scope and system architecture are referred to the project brief documentation "Inverter Automation Project...
As an employee, ...advice to manage and address an ongoing situation of corporate harassment at my workplace. The sooner this can be addressed, the better, as the situation is escalating and impacting my mental and emotional well-being. Key Tasks: - Providing sound legal advice and strategies to tackle the harassment. - Guiding on the best course of action to protect my rights and address the issue effectively. - Document the harassment correctly to address it to the company HR / Harassment departments Ideal Candidate: - Legal professional with a focus on employment law and experience in dealing with corporate harassment cases. - Strong communicator who can explain complex legal matters in an understandable manner. - Proven ability to act swiftly and be available for immediate con...
...both HTML and PDF. The PDF version should be static, without interactive elements. - The conversion process can be done manually, using HTML and PDF editors, or automatically, for which you can suggest a suitable script or tool. You're also welcome to combine both methods if you believe it would be more efficient. - The HTML output should be easy to read and navigate. The PDF should retain this readability in a static format, making it suitable for printing and viewing but without interactive features. - You will have creative control over how to best represent the JSON form in these two formats. The end goal is to make the content accessible and user-friendly. I'm looking for a professional with prior experience in data conversion, specificall...
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the...and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communication skills to understand the specific requirements for the instruction manual. Looking for a freelancer who can deliver accurate, visually appealing Excel tables and a well-structured Word document. The ability to understand and follow instructions thoro...
I'm looking for a skilled graphic designer to help with edits to my trifold design. The project involves: - Making specific text modifications - Replacing some images Ideally, I would like the final trifold in PDF and JPEG formats. Your application should emphasize your experience in graphic design and working on similar projects. Please include relevant examples of your past work in your application.
I'm in need of a skilled translator to convert technical manuals from English to Vietnamese. The translation should be precise, accurate and consistent with the industry standards. Key requirements: - Proficiency in both Englis...skilled translator to convert technical manuals from English to Vietnamese. The translation should be precise, accurate and consistent with the industry standards. Key requirements: - Proficiency in both English and Vietnamese - Previous experience in translating technical content - Attention to detail to ensure accuracy and consistency - Ability to meet deadlines and deliver the translation in a PDF file Experience with technical terminology and familiarity with the industry is a bonus. Please include samples of your previous work to showcase y...
Creative: We want a design that stands out and conveys our brand's identity. We want something unique and intriguing. While innovation is crucial, the design must radiate professionalism and fit our brand image. We strive to mix inventiveness with credibility. Two-sided Design: The business card must use both sides to provide contact information and a q...that stands out and conveys our brand's identity. We want something unique and intriguing. While innovation is crucial, the design must radiate professionalism and fit our brand image. We strive to mix inventiveness with credibility. Two-sided Design: The business card must use both sides to provide contact information and a quick summary of our services. Sides should blend seamlessly. I need the PDF and AI versions o...
I need an detail-oriented and meticulous freelancer who can help me retype an old court document. This will require keen attention to detail to ensure that no content is altered as the document needs to be retyped exactly as it is. Key tasks involve: - Retyping a document that is clear and easily readable - Ensuring that the final output is a Word document Ideal candidates should be proficient in English, have a strong background in document editing and processing, and have excellent typing skills. The goal here is to reproduce this document in an electronic format while preserving its original content. Therefore, an individual who pays keen attention to detail would be ideal for this project. Having legal knowledge or a legal background would be...
...in-house, offline admin application. The core functionality of this application should revolve around customer management, including but not limited to: - Creating and managing customer profiles - Uploading and storing customer-related PDF documents - Printing customer documents and profile details - Generating reports from collected customer data In terms of skills and experience, proficiency in software development, particularly for offline applications, is paramount. Experience with database management, report generation, as well as familiarity with handling PDF files is also desirable. Further project specifics, including total cost and timelines, will be discussed upon initial interest. Please also note that providing source code certificate and signing a Non-Dis...
I am in need of an experienced copyeditor to review and correct grammatical and syntax errors in a 23-page USCIS Petition. The text is precisely 5462 words. Key Requirements: - Completion within 1 week - Proficiency in American English - Experience with formal or official document editing. The goal is to provide a polished, professional, and error-free document. Your keen attention to detail and your exceptional command over American English will be crucial for this project. Experience in correcting immigration petition texts would be an added advantage.
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient i...data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I need a skilled draftsman to convert my hand-drawn sketches of building ventilation systems into professional, detailed technical drawings. Here's what the job entails: - ...professional drawings: You will need to accurately transpose and refine my hand-drawn designs into detailed, technical drawings. - Providing the drawings in two formats: I require these drawings in two different formats: PDF for my personal use and an AutoCAD file for my clients. You should be comfortable working in both environments. - Attention to detail is key: These are not rudimentary sketches but detailed, technical drawings. I expect a high level of precision and meticulousness. Ideal candidates have experience with technical drawing, a keen eye for detail, and proficiency in both PDF and...
Project Details: We are looking to find a way to match extracted data from a document to certain specific fields in our own system. For example, a data extracted from a document can be [Customer Name: Company ABC PVT LTD], but in our system the field may be called [Client Name]. We want the LLM to help match Customer name and Client name, so that the data gets filled into the field in our system. I am looking for a long term freelancer with database development, LLM and AI experience to help us achieve highly accurate results using OpenAI API, and ideally speaking some experience in google cloud AI products. Specific requirements for the project include: - Experience with LLM models, particularly the specified model - Strong understanding of programming languages and d...
Looking for an experienced DevOps Engineer to set up & document a 3-node HA Vault cluster (Linux Ubuntu) using Docker Compose (not Swarm, not k8s) with Consul as the storage backend (plus ensuring SSL/TLS self-renewing certs & snapshotted backups to an S3 bucket (on ) every time a new policy or secret added). You'll get sudo-level account access on all nodes which are already up and running on Contabo. You'll need to use the latest versions of Docker & Docker Compose. Your Experience + Multiple Docker-based Vault cluster deployments + Proficiency in Linux shell scripting and Docker Compose + Ability to document setup process clearly disaster recovery Summary acceptance criteria + I follow docs & rebuild cluster & recover existing backup + I r...
I need a meticulous and skillful proofreader, grammar checker, and spell corrector for a 10-50 pages creative writing document. The document is of considerable length, hence the need for a thorough review. Key Requirements: - Extensive experience with proofreading, grammar correction, and spell checking - A keen eye for detail and exceptional English language skills - Prior experience with creative writing is a big plus Responsibilities: - Proofread and correct any grammar issues, spelling errors, and improve overall readability - Maintain the original creative writing style and ensure the content flows smoothly Ideal Candidate: - Proficient in English language - Experienced in proofreading and editing - Creative writing background is a bonus - Able to deliver high-quality...
I need immediate expert help to troubleshoot my blockchain project. There's a problem uploading PDF files to InterPlanetary File System (IPFS) specifically. To clarify, the project is already built and operates on a local server. However, the issue lies in the inability to upload documents using IPFS. I believe this requires an expert with: - Profound knowledge in Solidity - Familiarity with MetaMask - Experience in dealing with blockchain projects - Specific experience in IPFS for document uploads and validation - Ability to work quickly, as I need this resolved ASAP The task involves uploading PDF files, so adeptness with this document type is paramount. Please bid if you're confident you can solve this promptly.
I need assistance in preparing the following discovery legal documents: - Interrogatories - Requests for production of documents - Requests for admission The ideal freelancer should have experience in legal document preparation, specifically with the aforementioned types of discovery documents. A deep understanding of legal terminology and principles is also required. Attention to detail is extremely crucial in this project. Your skills should ensure the produced documents are comprehensive, unambiguous, and adhere to the legal guidelines. This is a serious task that can greatly impact the direction of legal proceedings, hence, a demonstrated work history in similar projects will be a big plus.
I'm looking for a skilled web developer to design a movie ticket booking website as part of a college mini-project. This project requires: - A user registration and login feature, allowing regular users to create accounts. - A schedule section showcasing movie showtimes. - A booking system for selecting and reserving seats for a specific showtime. - Gantt charts, SRS document, COCOMO calculations, github experience Ideally, candidates will have experience with e-commerce sites and may suggest additional features to improve user experience. Prior experience with similar projects will be heavily favored.
...in need of a professional passionate in blockchain technology who can build a robust smart contract. Goal of the project: The smart contract lets users buy and sell several different coins at once with just one click, with the smart contract handling all the approvals for them. This makes it quicker and easier than having to approve each coin separately. Easy overview: Deliverables: Smart contract code on Solana Simple Front-end website to check the smart contract functionalities - user submit - user buy - user sell Smart contract functioanlity: User Submit: User Action: The user submits a fee of exactly 0.01 SOL to the smart contract and provides the address of Coin A. This fee is a fixed amount and is
Looking for a NextJS developer to build a dynamic landing page with animations and a simple backend for document management within 1 week. Ideal for someone who enjoys creating engaging web experiences and simple, effective backend solutions. Tasks: • Build a landing page with animations using NextJS and Gsap animation plugin. • Develop a simple backend for uploading and accessing lecture documents. Requirements: • Experience with NextJS and basic backend development. • Ability to complete the landing page in 1week. To Apply: Send your resume and examples of past work.
...business card 4- Mockup letterhead 5- The logo in action, e.g., on work clothing or on banners in front of a company Feedback and Communication: - Submissions will be reviewed daily, and there will always be feedback for improvement. Freelancers can submit multiple proposals. There are several rounds of approval. File Formats and Specifications: - All necessary working files in formats such as PSD, PDF, EPS, SVG, etc., must be made accessible. The files must be high resolution suitable for production. Language Requirements: - All text elements can be in English, but later on, must be translated into German. Management's Vision: (Just to give you a better understanding) - Michel Walter, CEO of DASMO GmbH, envisions walking up to a modern company where flags bearing the DA...
...specifically Python and should be familiar with task management systems. The system should have the following features: - Task Management: This feature should allow users to create and assign tasks to team members and monitor progress. - Team Collaboration: Users should be able to communicate effectively amongst themselves. This feature should enable tasks discussions, updates and feedback sharing. - Document Sharing: This feature needs to enable users to share relevant documents seamlessly. - Chat Functionality: A real-time chat feature for instant communication is also essential. This system should cater to project managers, team members, and clients. Please ensure that the user interface is smooth and easy to navigate. Experience designing sleek user interfaces is prefe...
Proofread and edit a 975 word article. Audience is a senior level executives in the fintech and banking sector. Change wording liberally as you see fit to make the article more sophisticated, avoiding cliches and unnecessary wording. Some comments are already added with track changes. The article could even be shortened. Seeking a final document without any track changes.
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
Hi, we need the attached document to be translated from Arabic to Italian. No specific deadline.
Reproduce and reformat these 6 data sheets in Indesign format. Translate from Polish to English using chat GPT. The drawings of the sofas must be 1/50th scale (1000mm = 20mm). A new layout is expected to use as few pages as possible while respecting the scale. 1/50th. For each product, you will have to add a price that will be communicated. The sample freelancer document is a model of expected result. please edit in indd format.
...current certificate is criticized for its design/layout and color scheme. The new design should rectify these issues. - Your design should impart a sense of accomplishment and professionalism to those who receive it. Ideal Freelancer: - Graphic designer with experience in professional document design. - Appreciation for health and safety and compliance-related aesthetics. - Ability to create a harmonious, visually pleasing layout. - Understanding of the impact of color schemes on the perception of the document. - Strong portfolio showcasing past certificates or similar professional documents is a plus. Please include relevant samples of your previous work in your application. I would like the attached included within the certificate Wording should be around Certific...
...images you need and a rough mock up of what we are looking for as well as a list of what MUST be added to the posters. The tag line is not like the mock up shown - instead we want it to be ''Making Life Easier'' All fonts should be Futura BK BT and our colours are red and green, their colour codes are: Green - #7AC143 Red - #ED1C24 Once the project is complete, you will send the graphics via PDF for review and print as well as the AI file for our company to keep on file for future needs. Ideal Skills and Experience: - Proven experience designing POS Material, particularly posters - Strong visual and creative skills - Knowledge of printing processes and requirements - Experience in product promotion designs - Proven Adobe Illustrator skills - Excellent p...
I'm in need of a talented frontend developer to create a robust and user-friendly search frontend for document base. The documents are already indexed in an Opensearch database with various custom fields (Speaker, Place, Theme, Keywords,... ) apart from the standard ones (document format, creation date, update date, size, link to document,...). So the frontend will be sending queries to opensearch and displaying the results. Key Features: - Filter Options: Users should be able to filter their searches based on multiple criteria, such as date, location, category, etc. - Sorting Options: The search results need to be able to be sorted by relevance, date, or other relevant parameters to enhance user experience. It should be possible to sort the documents by multipl...
We are in need of a highly skilled Laravel expert team to continue development on existing web application, specifically with a focus on reporting and analytics. The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones), total 12. Selected team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Data...
We are in need of a highly skilled Laravel expert team to continue development on existing web application, specifically with a focus on reporting and analytics. The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones), total 12. Selected team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Data...
...personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to ...
Hi Designertec, I would like to offer you a my flyer reformatting. Unlimited changes and delivery in jpeg, pdf and ai
I need a professional translator to convert a moderately technical Italian equipment installation sheet into English. The p...sheet into English. The purpose of the translation is to provide clear instructions for the installation process. The original document is in Word format, making it easily editable for translation. The ideal candidate for this project should have the following skills and experience: - Native-level proficiency in both Italian and English - Proven experience in translating technical documents, especially in the equipment installation field - Strong attention to detail to ensure all technical terms are appropriately translated The quality of the translation is crucial to ensure that the English version retains the clarity and accuracy of the original Italian...
We are in need of a highly skilled Laravel expert team to continue development on existing web application, specifically with a focus on reporting and analytics. The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones), total 12. Selected team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Data...
I need a shirt design for a Baseball tournament in New Albany ohio on June 6 2024 I have attached a PDF with all the instructions and inspirations files for design. PLEASE OPEN THE PDF to understand the colors, wording, and design inspiration that I have shown. ALL THE INSTRUCTIONS are on the PDF. I have also attached shirt mockups that I would like to be used. PLEASE PLACE YOUR DESIGN ON THE SHIRT MOCKUPS PROVIDED. I have attached a few vector files of the team logo that you can use within the design IF YOU WOULD LIKE (not required). ILLUSTRATOR FILES ONLY. I CANNOT USE PHOTOSHOP FILES. VECTOR FILES ONLY. Ideal Skills and Experience: - Proven experience in shirt design - Ability to deliver quality work within a tight deadline - Strong portfolio showcasing...
+++PDF with details enclosed+++ Dear Freelancer: I need an experienced game artist to create 4 (FOUR PCS) unique 3D scenes for a mobile game aimed at children aged 6 to 12. Here's what I'm looking for: - You can choose the themes. Be creative and make them standout and interesting. - All scenes should have a 3D pop-up effect. This will help grab the attention of the kids who will be playing the game. ALWAYS understand that its a background scene so leave the PLAYFIELD free for characters!!! It needs to be very present but in a very modest way if u understand what I mean. Ideal Skills and Experience: - Prior experience in creating game scenes, particularly for children - Proficient in 3D design - Ability to make scenes distinctive and engaging - Familiarity with cre...
I have two PDFs that I need expertly transformed into PowerPoint presentations. The first PDF is the main presentation, and the second PDF is to be used solely as a graphic design reference. The PowerPoint must be an exact replica of the main PDF, in terms of layout, colors, fonts, and every graphic element. - You have to create an editable PowerPoint presentation from a PDF, keeping the exact same graphic design as another PDF reference. - No additional elements are required in the PowerPoint presentation. Experience with PowerPoint and graphic design is crucial. You must be able to deliver a professional and polished result that is identical to the original PDF. It's important that you are detail-oriented and have a good eye for design.
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry ve...judgments o Significant news on the individual(s) or Party(s) as well as related family members (if any) PROJECT DURATION: 4 hrs – 8 hrs (maximum) SKILLSETS: -Experienced in internet research, related to the local law; -Experienced in Pre-employment background checks, legal check or HR is a plus -Strong in both local and English language proficiency DELIVERY ELEMENTS: -All relevant document and news, if reported in native language must be translated into English -Social media handle of the targets -Weblink of the news, together with + Source link + News date + Summary of the news/information
The task is to convert the Wordpress site to Shopify considering the requirement document and reference link.
I'm seeking an experienced professional who can help me verify specific documents from the European Sleep Research Society in Germany. - The task involves collecting and validating particular docu...experienced professional who can help me verify specific documents from the European Sleep Research Society in Germany. - The task involves collecting and validating particular documents from this organization. - You should have detailed knowledge of the procedures and requirements for document verification, ideally from the European Sleep Research Society or similar organizations. The purpose of these verifications will be disclosed to the successful applicant. Please share your past experiences in document verification, especially in a similar context. Looking forw...
...water usage, steel production, and wastewater treatment processes within the industry. 2. Quantitative Analysis: Conduct extensive analysis on the gathered data. Key metrics of interest are water consumption per ton of steel produced, water recycling rates, and energy consumption for water treatment. 3. Life Cycle Assessment (LCA): Delve into the steel manufacturing processes. Understand and document the usage and flow of water within these procedures. 4. Qualitative Analysis: After the metrics have been crunched, I want an interpretation and presentation of the data in an understandable and accessible format. 5. Case Studies: Find and present case studies that would help illustrate your findings and assertions. Ideal candidates should have prior experience in conducting com...
I have a PDF document that I need typed out exactly as it is in the PDF. I want the final version to be used for printing purposes. Key requirements are: - Ability to read and understand PDF files - High attention to detail - Proficiency in copy typing - Understanding of print formatting I plan to use the document for print, so it's critical that it looks exactly like the PDF in terms of content, spacing and layout. Please let me know if you have experience in this area.
I have an existing simple Android app written in Kotlin. I have a need to make some minor adjustments to it. It in...recorder,. It loads a driver's "diary" from firebase and allows the driver to mark that he has arrived. The driver can capture some photographs of the delivery and then mark that he has finished. This data is then sent back to firebase. I need a few small enhancements: 1. mark a job as "completed" in a separate date/time field 2. allow the user to "scan" a document rather than taking a photo. This would then be stored as a PDF. a scanned document provides better clarity than a photograph. This would be mandatory and photos optional 3. ensure it operates correctly "offline" ie in areas without mobile coverage...
...personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to ...
...in Brazil for the purpose of verifying a previous employment certificate. This involves: - Confirming the work experience stated. - Validating the job title and responsibilities provided. - Ensuring the employment dates align with what's recorded. Targeted Address for Visit: Usiminas, Ipatinga - State of Minas Gerais, Brazil Issuing Authority Name :Usiminas Brazil Task : Verify the provided document by form filling and get geo-tagged pictures Please note, you'll only be authenticating one certificate. A background in HR, employment screening, or due diligence would be helpful for this project. Strong attention to detail is essential, alongside fluency in Portuguese and English. Familiarity with Brazilian business etiquette is a plus. This task needs to be conduct...
Below are 12 basic functions and formulas that everyone should know.