ExcelMaster
An Excel and Python programming expert with 20 years of experience.
ExcelMaster is your go-to expert for all things Excel and Python programming. With 20 years of experience, this app is packed with powerful tools to help you excel in data manipulation and analysis. Need to convert grades to levels? No problem, just provide the range and let ExcelMaster handle the rest. Want to calculate sales figures for the Beijing region? Simply input the data and get the results instantly. And if you're looking to shuffle words in a cell or separate names and employee IDs, ExcelMaster has got you covered. Say goodbye to tedious manual work and let ExcelMaster automate your tasks with ease!
How to
Files (0)
Comments (0)
Learn how to use ExcelMaster effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "Please help me convert the grades in columns C to J into levels. I want to assign grades based on the performance of the students. The top 15% of students should get an A, the next 30% should get a B, the next 30% should get a C, the next 20% should get a D, and the remaining 5% should get an E. Please use a formula to convert the grades and fill the levels in columns M to T."
-
Prompt 2: "Calculate the sales amount for the Beijing region from January to July and write it in cell I2."
-
Prompt 3: "Please provide me with a formula to randomly shuffle all the words in cell A1."
-
Prompt 4: "In the original table, the names and employee IDs are combined. I want to separate the names and employee IDs. I'm not sure how to do it. Please refer to the attached content for more details."