Here you will find various cases, with a varying degree of awareness, showing the symptoms of someone who needs to switch from Excel to a database, which could become the basis of a CRM, a particular database. Or they no longer need Excel’s programming language, VBA, to do routine operations. Or the extensions can no longer process the amount of data on Excel sheets.
We are seeking a capable, detail-oriented data classification expert to assist us in segmenting a large dataset consisting of approximately 15,000 company accounts. These accounts are currently collected in an Excel file, with each record containing information about the company, such as company description, website URL, and more. Some rows do not have descriptions; in this case, you need to do a quick Google search or visit the website to find out what the company is about.
I have an excel document on the sales process that I use to project my company’s future sales. One of the factors is the “probability of closing.” I often assign a percentage to this factor. This percentage, to be honest, is a gut impression. This impression is composed of a few components: intimacy with the customer, whether my customer has already won a contract for my subcontract, the urgency of the need, where we are in the sales process (negotiation stage), and other factors. The above components may not even all be weighted equally (intimacy with the customer should be weighted less than “where we are in the sales process,” for example). I am looking for a mathematician who can help me devise a system that more accurately accounts for these factors to generate a more accurate “probability of closing.”
I need a multifunctional excel sheet to be used for data coding with automatic production of summaries and reports, for monitoring with ease, with multiple users accessing at the same time, with security features to hide confidential information in specific tabs. This excel sheet must: 1 – Provide daily, weekly, and monthly collection reports 2 – Provide statistical reports and figures on unique and matching factors, such as (a) country of origin figures, (b) supplier name, (c) importer name, and similar factors. 3 – Simplify tracking across multiple devices and multiple users.
We are looking for an Excel specialist to create an excel sheet, for our growing road transport company. The candidate will need to be proficient in data analysis, advanced Excel formulas, and creating automated reports to streamline various activities related to fleet management and driver operations.
We are a small startup with a data problem. We have a lot of experimental data collected in Excel spreadsheets (years of experiments) and we want to be able to collect and collate this information into a central database (possibly for the use of artificial intelligence and machine learning). We are looking for someone who is able to: 1. Open multiple Excel sheets and detect any anomalies in the data (e.g., anything that is obviously wrong). Design a good structure for a data lake 3. Migrate our data into the data lake 4. Help us design selected dashboards/modes of interaction with data for people who have basic/limited skills.
We are looking for a highly skilled Excel data analyst to help us refine our company’s sales database . This database includes critical information such as sales revenue broken down by delivery locations, customers, delivery dates, amounts, and other factors.
[…]
I have three .csv files that need to be aggregated (3M rows total, about 3-4 columns) and then I need to run a pivot table for quick analysis. I also need a percentile analysis.
We are looking for an experienced self-employed person to convert large Excel macros to Python scripts and data structures. The ideal candidate will have a strong understanding of Excel functions and Python programming, ensuring accurate and efficient data migration.
We are looking for an experienced data analyst or developer to transform a 300 MB Excel (XLSM) file into a more efficient format using Python or Power BI. The goal is to improve computational speed and optimize data processing. The ideal candidate should have experience in data transformation, performance optimization, and a strong knowledge of Excel and programming tools. If you have the skills needed to optimize our data processing processes, we would be happy to hear from you.
We currently analyze sales data using Excel. This is a useful, but cumbersome and time-consuming method (not to mention the possibility of errors). As a first step, we would like to replicate and perhaps slightly improve our processes by manipulating the data more “programmatically,” via Python. The input would be an Excel file, the output an Excel file. The “magic” would happen in the middle, when the notebook would perform all the steps that are now performed by hand.
We need a consultant with experience in the @Risk Excel plugin to help us migrate financial modeling from @Risk to Python
Do you identify yourself in any cases? Let’s get in touch for a free call.
In the past I have also written an article along the same lines on statistical models