Excel refresh data secured sheet jobs
I need a professional grant writer with experience in applying for business grants from government agencies. The project is currently in the idea/concept stage, so the ideal professional will have the following qualities: - Excellent communication and research skills - Experience in business grant writing - Knowledge of the current trends in obtaining grants from government agencies -...Excellent communication and research skills - Experience in business grant writing - Knowledge of the current trends in obtaining grants from government agencies - Ability to work well within a team and follow deadlines I would require a successful proposal that can secure funding for my project. Please provide examples of your past work in this area and any successful grant applications you have se...
Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me...
I am looking to have a discounted cash flow model created in Excel for property valuation analysis This task should not take long to complete as all data and parameters are given Key Requirements: - Input Data: The project will require the use of the property data, - Model Parameters:DCF model will be for 10 years - Excel Model: The freelancer is expected to use the document provided and complete the rest of the remaining data. They will then be required to fill this in the Key Assumptions (Sheet 1) The ideal candidate for this project will have: - Proficiency in financial modeling, specifically in creating discounted cash flow analyses. - Expertise with Excel and a strong understanding of property investment principles. - Clear c...
...sequence of "AAA" substring images they wish to view—either the first, second, or third occurrence. The program will enable users to assess the quality of the Part B images and proceed to update both the Part A image and its associated Part B images by selecting and clicking "Next". This iterative process will continue until all images have been reviewed. Subsequently, the program will generate an Excel sheet containing the user's quality assessments in the third column. Overall, the program aims to streamline the evaluation process, allowing users to conveniently navigate and assess image associations while providing a comprehensive overview of their quality assessments for further analysis. - Using Python and CherryPy to develop the tool - ...
I'm looking for a capable designer who can create a modern ...must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Number Title and Artist text. Ideally, I would like to fit 2 to a...
...large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Australian Time Zone (NSW) 4pm to 1am (1hr OR 2 x 30min unpaid lunch or dinner break) Monday to Friday / possible weekend work. Personality traits for this role is someone who has a high value on the following: - very organised and likes following processes to complete a task - Someone who cares about strong attention to detail in...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I am in need of an excellently crafted web form that can ...various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand...
...The script should be robust and reliable, able to handle a large number of files efficiently. Ideal Skills and Experience: - Proficient in Google Apps Scripting - Experience with Google Drive API - Strong understanding of file management on Google Drive - Familiarity with skip tracing methodologies - Ability to write robust, efficient code - Experience with handling and processing large sets of data Please note that the handling of files that already exist in the specified folder will need to be discussed with me directly. I will provide more information on this when the project begins....
Hello. I have a written song draft and would like to have someone to sing it and record it in acoustic version, either accompanied by piano or a guitar. Some parts perhaps need modification, so it would be ideal to work with someone who has experience in this domain. The output does not need to be high production, but still a good demo. ...record it in acoustic version, either accompanied by piano or a guitar. Some parts perhaps need modification, so it would be ideal to work with someone who has experience in this domain. The output does not need to be high production, but still a good demo. The lyric are in Croatian, therefore it needs to be someone from the surrounding countries or living abroad but speaking the languages. The sheet music is in the attachment and a sample of s...
I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...
...task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel ...
...feature within this plugin. The main feature of this plugin is Cargo Logistic, focusing on detailed shipment tracking. This feature should provide a comprehensive view of the shipment's journey, including its current location and expected delays & the warehouse rental fees Features: Shipment Management,Shipment Status Update,Shipping Charges,Shipment Tracking Shipment Documents,Shipment Labels,Excel Import and Export,Multiple Shipment Management Users and Permissions,Internal Messaging,Shipment Barcode,Payment Gateways Global Configurations,Shipping Rate,Proof of Delivery,Bulk Scanning,Real Time Notifications Google Map Integration,Manage shipment fields,Branch Manager,Containers and Manifest Shipment Consolidation,Item Consolidation,Parcel Consolidation Whatsapp Notif...
I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time manag...
I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance ...
I'm looking for a developer who can establish a connection between a wireless barcode scanner and Google Sheets. On my sheet I have: Serial number - Client name - Product process 1 - Product process 2 - Product process 3 - Delivered. I'd like to be able to put the Barcodes on my products and once they moved through production, scan them and the sheet will update itself to show progress. I'm currently doing it manually.
...looking for someone who can write script to automate daily data importing from csv files into a google sheet. We use a new google sheet each week to calculate production for each day, see example here: We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers. For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached (product-tally-bf
I need a Google App Sheet designed for inventory tracking of retail products with specifics on quantity and location. The sheet should offer real-time updates and be easy-to-use. Ideal Skills and Experience: - Prior experience with Google App Sheets - Experience in developing inventory tracking systems - Knowledge of retail product tracking Job Includes: - Setting up a comprehensive Google App Sheet - Implementing features for tracking product quantity and location - Testing for accuracy and ease of use Please ensure to demonstrate your previous experience on similar projects in your proposals.
I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.
We are seeking an experienced web developer to create an advanced instant quote form on our WordPress-based trucking company website. The form will integrate Google Maps for autocomplete suggestions and pull real-time data from Google Sheets to provide visitors with instant truckload quotes. Key Features Required: Google Maps Integration: Autocomplete suggestions for 'Pickup City, State' and 'Delivery City, State' using Google Maps API. Google Sheets Integration: Dynamically pull data from a Google Sheet that includes truckload rates, which are updated weekly. The data includes Pickup and Delivery points, Dead head radius, Max weight, Rate, and Rate per mile. Form Requirements: Fields for Pickup City, State; Delivery City, State; Pickup ...
...Sheets. The task involves successively linking and customizing one of my Google Forms to a Google Sheet in order to obtain graphical data representation. Key Responsibilities: - Identify and link my Google Forms to the corresponding Google Sheet. - Customize the Google Sheet to visually represent its data as a line graph. - Note that the data provided for this task will be multiple choice responses. Ideal Skills: - Proficiency in Google Forms and Google Sheets - Data Visualization expertise - Ability to deliver clear, concise, and intuitive line graphs - Strong understanding of data representation and analysis This project is suited to a freelancer who values precision and has a sound grasp on data visualization. I valu...
I have already prepared my Balance sheet, P&L, and Cashflow so that CPA Certified this statement. Ideal Candidate: - Must have a CPA and certified statement.
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues...
I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the ...
I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and...
I need an experienced and knowledgeable professional developer to customize my existing website which is built on Laravel and Vue.js. The required customizations are mainly focused on design and functionality improvements. Key requirements: - **Design Changes**: I need to refresh the design of my website. This includes altering the color scheme and layout structure. The goal is to make the site more visually appealing and user-friendly. - **Functionality Improvements**: There are certain aspects of the site's functionality that need enhancement. This could involve making the user experience smoother, improving the site's navigation, or adding features that will make the site more engaging for users. Discussion Required to describe the actual features required.
...knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and ...
I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. ...
Ideally, you are the freelancer that created the existing Power Point presentation and have all the backup files. I would like you to refresh the existing Power Point presentation for Electric Metals, initially created in November 2023. It's crucial that the professional possess a keen eye for design and excellent knowledge of PowerPoint. The updated presentation needs to be delivered as a PowerPoint file. Even though the content will remain as is, the entire design needs a face-lift for our target audience - Investors. Following are the skills I am looking for: - Proficiency in PowerPoint - Strong design capabilities - Understanding of corporate presentation needs - Experience with investor relations content would be advantageous The successful freelancer will be ready to ...
I am seeking a skilled freelancer who has significant experience in building WordPress landing pages. The purpose of this landing page and its specific features are left open for creative interpretation, as I have not specified any particular elements, color schemes, or branding guidelines. None...essential in order to create a high-quality page. Ideal skills and experience: - Expertise in WordPress - Exceptional creativity and ability to work within broad parameters - Understanding of best practices for landing page design - Willingness to provide design recommendations and insight based on previous success in similar projects. This project offers an excellent opportunity for those who excel at employing their creative judgment and WordPress capabilities. I will need a...
...recognize that our brand identity is more than just a logo—it’s the heartbeat of our organization. We invite passionate professionals to join us in shaping a fresh, memorable, and impactful brand that resonates with our audience. Requirements: - The new design should have a modern, fresh and clean look - The color scheme should be green and brown - The main goal of this rebranding is to refresh the company's image. Ideal skills and Experience: - Proven experience in logo design - A strong sense of modern design trends - A good understanding of color theory, particularly in the use of green and brown - Excellent typography skills, particularly for modern styles. Please include samples of your past logo designs in your bid....
...features: Token Purchase: Upon initiating the process (by typing "/start" again), users' wallets refresh with the deposited balance. Users can buy tokens using the deposited amount by simply pressing the "Buy" button. They are prompted to reply with the token address or name and specify the desired amount to purchase. Transactions are executed instantly, providing users with a seamless buying experience. A congratulatory message confirms the successful purchase, marking the beginning of their trading journey on the platform. Managing Positions: After successfully purchasing tokens, users can manage their positions by accessing the "Manage Positions" menu. The platform offers curated data to assist traders in making informed decisions,...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each pi...
I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.
I'm looking for a proficient web designer to update and enhance my website's design, with a focus on restoring some of its original elements. Key responsibilities involve: - Updating the website to improve user-friendly navigation and visual attractiveness. - Reinstating essential original design elements to retain some of my website's original essence. The ideal seeker should: - Possess a keen sense of visual aesthetics and excellent understanding of web design principles. - Have proven experience in restoring and revamping websites. - Be knowledgeable about the latest trends in web design for an updated and modern look. - Have a meticulous eye for detail, especially with regards to restoring original design elements. I value clear and consistent communication. Plea...
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.
...need of a highly skilled data entry operator to assist with my Tally entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly...
Hi, This project is for a refresh of the front page of Strom Ltd's A4 brochure. Once we have a front page design we like, we will have our whole range of literature and brochures refreshed and redesigned in the chosen new style. The whole refresh of all our printed material will be a separate project in the coming weeks and months. The new design should be modern and minimalist in nature, and incorporate shades of blues, turquoise, greens, and possibly a subtle hint of yellow. The primary focus should be our products and services, and our company strapline is "No Gas No Problem". Here's what we're looking for: - Four different conceptual designs to choose from. JPEGs for proofing, and PSD files also please. - A clean, minimalist design aest...
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.
...select the same brand from a category) and study in detail the brand’s marketing program. The primary thrust is on the explicit communication of the brand (advertisement, sales promotion, personal selling, direct marketing, public relations, word-of-mouth, and event sponsorship). The student is also expected to the implicit communication like price, product, and distribution. They shall include a ½ sheet pictorial depiction of the Marketing program as the first page (immediately after the cover) Based on their understanding, they are to explain/ elucidate on the following. Instructions: The students may do good to adhere to the following • Use illustrations more than the texts (70% should be used for illustrative demonstration and rest 30% for written) • U...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Invento...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll hav...and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your de...
I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if y...
I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific ne...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a ro...
