Workbook Projects
Looking for freelance Workbook jobs and project work? PeoplePerHour has you covered.
opportunitypre-funded
Build an ROI Calculator with User Instructions into Excel
Impact-Centric ROI Calculator - Developer Brief We are seeking a skilled developer to create an Impact-Centric ROI Calculator that will accompany our sales training module. The calculator must be designed to have perfect utility across all Business-to-Business (B2B) sales environments, including products, services, hardware, and software (SaaS) sales. Key Requirements: Currency Options: The calculator must support three currency options – USD, British Pound Sterling, and Euro. Workbook Structure: The workbook should be organized into five main tabs: Home, Input, Calculations, Output, and Instructions. Home Tab: Create an introductory screen with a purpose statement and basic navigation instructions. Input Tab: Divide the tab into 'Cost Investment' and 'Gains from Investment' sections, each with relevant categories. Include a Rule of Thirds attribution section and a timeframe selection option. Data Validation: Implement data validation to ensure data integrity and minimize user input errors. Calculations Tab: Use Excel formulas to calculate key metrics such as ROI Percentage, Payback Period, and Break-even Point based on the selected timeframe. Include a Rule of Thirds attribution calculation. Output Tab: Display the calculated results in a user-friendly format, incorporating dynamic charts and graphs for visual representation. Instructions Tab: Provide step-by-step instructions on using the calculator, including timeframe selection and interpretation of key metrics. User Guide: Create a separate worksheet named "User Guide" that includes an introduction, overview of each worksheet's purpose, step-by-step instructions, guidance on timeframe selection, and explanation of key metrics. Testing: Ensure the calculator's utility across various B2B sales scenarios, including producers/manufacturers, resellers and distributors, professional service providers, and subscription software providers (SaaS). The ideal candidate should have strong experience in developing complex Excel workbooks, proficiency in Excel formulas and functions, and a deep understanding of data validation and user experience design. If you are interested in this project and possess the required skills, please submit your proposal, along with a portfolio showcasing relevant experience.
24 days ago23 proposalsRemote
Past "Workbook" Projects
I need a workbook creating from slides
A workbook is required to complement an online webinar, providing a visual step-by-step guide for users. The source material comprises existing presentation slides and/or a video tutorial. The commission involves designing professionally formatted workbook pages that translate and expand upon the content and structure of the source materials. Text, diagrams, screenshots and other illustrative elements must be carefully curated and laid out to enhance learning and ensure the workbook precisely complements and reinforces what is taught in the webinar. True to the client's branding, the finished interactive PDF deliverable will give users a supportive, visually engaging resource to reference during and after viewing the instructional presentation. Experience with instructional design and multimedia project management is preferable for this role.
Excel Pivot Worksheets Required
I require a comprehensive workbook created in order to analyses data from multiple suppliers by internal cost centres
urgent
Power Bi Dashboard - clean and replace data source
We produce Engagement surveys using Power Bi for the final analysis. Our data analyst is currently overloaded and we need someone to fill in for this project. We have a fully functioning Power BI dashboard of six pages (see screenshots attached) which connects to an Excel workbook stored in the same directory as the Power BI file. I will provide the Power BI file, the original Excel worksheet and the new Excel worksheet. I want the new Power BI file and new Worksheet to be connected in the same directory. We need to replace the current Excel workbook with the new workbook and make sure it works. The structure of the raw survey data is identical. There are only 120 rows in the data. This is not a big data project. The only difference is very minor in the number of statements and the number of demographic scale items. The number of demographics is identical and the layout of the dashboard should be identical (you are welcome to improve some of the slicing visuals but this is not important). It is very straightforward with standard dashboard features with two exceptions: The Cluster analysis - Make sure you are comfortable with this aspect of the analysis The Text analysis - This is not actually very difficult but it does take time. There are almost 200 text statements split into three categories. I would allow at least three hours to work your way through this manually (we usually allocate 50% of the time for this element) We would normally allow 5 hours for this but I am allowing up to 10 hours since there will be some learning for you on this project You must: 1) Convert/clean the new data source to ensure that it works with the dashboard 2) Check that all the logic works as it should including the qualitative (text) analysis. This can be done manually or via an AI device, but must be sense checked by a human being at some point We can discuss how you might wish to improve the design, once the project is complete (it would become another project) I am looking for someone who has: Excellent written and spoken English At least 3 to 5 years in data analysis and Power BI / Excel expertise It would be nice if you had experience with B2B surveys such as Engagement/Satisfaction/Diversity/Inclusion etc Please start your reply with the word "Blackpool" so that I know you have read to the end. I do not waste my time replying to anyone who does not fulfil this. Please DO NOT use AI to autofill your reply(or use it very judiciously) as I am getting very tired of overlong, hyper detailed replies that just waste my time and give me no idea as to how competent you are. Many thanks Chris
Writer for Self-Help Workbook for Teens
We are looking for an experienced writer to create a self-directed workbook for teens on a self-help/mental health topic. The ideal candidate will have nonfiction book experience and be available to start immediately. The workbook should be engaging, informative, and interactive, designed to help teens navigate and improve their mental health. The writer should have a strong understanding of the target audience, the topic, and the ability to research if needed, and deliver high-quality content. Relevant skills include: - Nonfiction writing - Experience with self-help or mental health topics - Ability to create engaging and interactive content for teens Candidates must provide writing samples and demonstrate their expertise in self-help writing for teenagers.
Expenses logged on Excel Sheet
I require expenses data from 3 PDF files entered into an Excel template. The PDFs contain receipts from the UK and Europe with minimal information to be logged, including date, vendor, brief description, total amount, and VAT where applicable. An example template is provided. The first PDF compilation involves 36 A4 receipts of expenses. The second contains 26 till receipts denoted in British pound sterling. The third incorporates 20 euro till receipts plus three additional A4 receipts in euros. In total, there are approximately 85 receipts requiring transcription. The goal is to have this data entry work completed swiftly and accurately. I am seeking a freelancer who can discuss the task and confirm understanding of the fields and format desired for the Excel output. Given the volume of receipts, this work lends itself well to completion remotely. Upon submission, I am prepared to review the compiled expenses data and note any needed corrections for revision. The aim is to have the receipts systematically logged for accounting purposes in an organized electronic workbook. Candidates should demonstrate data entry skills and capability for meticulous work. Many thanks, Dan
Excel help - creating a macro or Vlook up to bring data together
Hello We have 4 datasheets in an Excel workbook. We keep contact data (name, company & email address) on there, each sheet has the contacts split into groups that they attend across the columns. There are probably c800 contacts across the sheets. Periodically I am looking search and bring together on a separate sheet all the contacts with a specific company email domain + the group they are each in - as I want to show that company which of their staff are involved in our groups. I would do this at a point in time. We are currently do this manually. So I am looking to have something set up on an extra sheet where I can specify which email domain I am looking for this time and then to 'run' it, and it will pick up the relevant contacts on each of the sheets and also the title of the group they are in. I am thinking perhaps a macro would work? See my fake data sheet. I am not looking to change the format/layout of the worksheets if possible, as we are all used to working with them as they are. Can you please quote for this work, I just put in a figure. I will share the actual spreadsheet with the freelancer once I have accepted your proposal. Many thanks Abby
urgent
Tidy up a conference excel workbook
I have an Excel Worksheet that is out of control. it shouldn't be this hard. The front sheet is all data for conference attendees (costs for different types of attendance, single or double room, how many nights, flight details. the back sheet should all read from this sheet (hotel data on one sheet, flight arrivals on another, departures on another, meal choices on another...you get the drift?) Any chance we can work online together and I can ask for what I need as you work? Anything complicated you can take offline and complete, but I don't think it is too complicated, to be honest, just poorly managed.
Re design of current ebooks
I am seeking a skilled freelancer to redesign our existing eBooks and create accompanying workbooks that align with our branding. Our eBooks require a professional touch to enhance their appearance and professionalism. Additionally, we require assistance with creating slides for our upcoming master classes. The ideal candidate should have a strong understanding of design principles, be proficient in graphic design software, and possess attention to detail. If you have the required skills and experience, we would love to hear from you.
Excel automation using vd++ 2022
There are three initial requirements for this project: 1. use visual studio 2022 with a dialog based app using vc++ 2. use visual studio 2022 with a dialog based app using vc++ 3. use visual studio 2022 with a dialog based app using vc++ Do the following: 4. Have the app open excel (desktop not 365) 5. Add a worksheet to the workbook 6. Enter the following in the first work sheet: a. 1 in cell b2 b. 11 in cell c3 7. Enter the following in the second work sheet: a. 2 in cell e2 b. 22 in cell e3 c. 222 in cell e4 8. Save the workbook to c:\demo.xlsx 9. Close excel All this must be done without using any third party libraries
pre-fundedurgent
Market Research Survey Designer
Location: Working from home Hours: 4 hours per week Pay: £25 per hour Summary: Panelitix.ai are seeking a Market Research Survey Designer to join our team and play a crucial role in the development of market research surveys. The ideal candidate will be responsible for understanding the requirements of business-to-business surveys and writing good questions. This role requires a blend of creativity, analytical thinking, and a keen understanding of our clients' needs. Key Responsibilities: · Research and Analysis: Review meeting notes and listen to recordings to extract key themes and insights that will inform the survey design. · Client Interpretation: Understand and interpret the client's objectives to ensure the survey aligns with their goals and the information they seek to gather. · Survey Development: Craft survey questions that are clear, unbiased, and designed to elicit informative responses. This includes writing both questions and mock answers for each survey item. · Survey Formatting: Utilize Excel to organize survey questions and mock answers, ensuring consistency with previous formats and ease of use for data analysis. Skills and Qualifications: · Interpersonal Skills: Strong ability to interpret client needs and translate them into effective survey questions. · Communication: Excellent verbal and written communication skills for clear articulation of survey design and client interactions. · Analytical Thinking: Ability to analyze meeting notes and recordings to identify key points that should be addressed in the survey. Attention to Detail: Meticulous attention to detail to ensure the accuracy and relevance of survey questions and mock answers. The attached workbook shows questions written for a survey of school cooks. It is tricky to follow but it contains the infomration. The questions are in column B The type of question is in Column D Mock answers are in Column F We have a meeting with the client and from the meeting notes you have to update the list of questions to get the infomration that the client is looking for.
Formula to Find Duplicate Cell Allocation on a Summary
Hi, I have an Excel document for payroll hours that has a summary on the first sheet connecting to various sheets on the same workbook to work out the number of hours for each employee. I would like to know if there was a way that I can check the summary sheet for duplicated allocations where the total of hours in a certain cell for example has been allocated to 2 different employees.
Excel Automation
I have used VS2022 to create a dialog based mfc app in VC++. I will provide you that “roughed in” project. Your task is to modify the project so as to create a simple task of: • Opening excel • Opening a workbook • Reading a column of 3 numbers • Create a new worksheet • Write the data read in to the new sheet • Close the workbook • Exit excel I have indicated where in the ExcelAutomationDlg.cpp file: // TODO: Add extra initialization here // 0 - open excel // 1 - open up c:\temp\AutoTestIn.xlsx // 2 - read in the data in three rows of data - Sheet1- d4:d6 (x) // 3 - add a worksheet name "new" // 4 - in new write 3 rows 2 columns in f2:g6 // 5 - save workbook as c:\AutoTestOut.xlsx // 6 - exit excel return TRUE; // return TRUE unless you set the focus to a control I will provide a zip file with the project and the initial excel worksheet needed.
opportunity
Create a dashboard
Hi - I need someone who can support creating a dashboard using sets of data that is due to come into force 2024, if i list the headings just the dashboards to pick up the data from the workbook
Transform a document from AI to Canva
The Illustrator document is a workbook that is printed in A4 horizontal and each A4 page contains two pages. there are 31 pages in total that I need to move into Canva copying the exact text and mirroring the exact design and order. There are 16 pages, each split in two because when printed it folds like a little workbook. I will provide the AI document and a PDF and you will need to transfer to Canva by mirroring the design, as similar as possible and then pasting the text with attention to detail to not miss anything. This is a very small and easy job but it requires attention to detail and I will not approve invoice until I review the text properly.
Automated Excel Reporting: Machinery Data Consolidation
I am seeking an Excel expert to create an automated process for consolidating performance data from multiple workbooks into one comprehensive report. The primary focus will be on presenting this information via tables and numerical forms for ease of understanding, helping accelerate our reporting procedures. Relevant skills to this project include: - Strong Excel proficiency, especially with data automation. - Experience in handling and collating machinery performance records. - Familiarity with creating clear, concise table/numeric reports. The goal of this task is not only to build a functioning system but to design it optimally so for effortless future use. This would directly enhance our focus on performance evaluation and facilitate data-informed decision making.
pre-funded
Compile a guide from an educational video and PPT.
I need someone to watch a video and use the powerpoint of the slides, to compile a short user-friendly workbook using canva so it can be edited and tweaked. The guide needs to include the information from the slides and be added to using the information presented in the video recording. End goal is a short workbook that clients can use to recall the information from the course, this is to support the recording of the video. Must be competent in English. Turnaround time ideally 24-36 hours. https://youtu.be/h8VQSuvXgi8
opportunityurgent
Excel Model Fixings
I have an existing model that has broken and I require some help to fix it. The workbook could also do with some upgrades so looking to work with a excel developer on this and future projects.
Microsoft Word and Excel Specialist for Client-Facing Document
We are seeking a highly skilled Microsoft Word and Excel expert to create a professional, client-facing document template. This template will be an essential tool in our business operations, enabling us to efficiently present information to various clients. **Key Responsibilities:** - Develop a customisable Microsoft Word template that is easy to update and can be reused for multiple clients. - Integrate the ability to import and update data from Microsoft Excel workbooks into the Word document. - Design and incorporate visually appealing graphs and charts to enhance data presentation. - Ensure the template is user-friendly and adaptable to different types of content and data. - Provide guidance on best practices for maintaining and updating the template. **Required Skills:** - Proficient in Microsoft Word and Excel, with a strong understanding of template creation and data integration. - Experience in designing and implementing graphs and charts within Word documents. - Ability to create a user-friendly interface within the document, ensuring ease of use for non-technical staff. - Strong attention to detail and a commitment to producing high-quality, professional documents. - Excellent communication skills, with the ability to clearly understand and execute project requirements.
Excel automation
Excel Automation There are three initial requirements for this project: 1. use visual studio 2022 with a dialog based app using vc++ 2. use visual studio 2022 with a dialog based app using vc++ 3. use visual studio 2022 with a dialog based app using vc++ Do the following: 4. Have the app open excel (desktop not 365) 5. Add a worksheet to the workbook 6. Enter the following in the first work sheet: a. 1 in cell b2 b. 11 in cell c3 7. Enter the following in the second work sheet: a. 2 in cell e2 b. 22 in cell e3 c. 222 in cell ev 8. Save the workbook to c:\demo.xlsx 9. Close excel Or do what is outlined in article below https://learn.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-excel-from-mfc-fill-data