検索

18826 件のプロンプト

• Highlight Employees with Over 5 Years Tenure

  Formula for conditional formatting to highlight employees with tenure over 5 years.

  生産性ChatGPT👁 0
• Prevent #REF! Errors in Excel

  Advice to use named ranges or tables to avoid reference errors.

  生産性ChatGPT👁 0
• Look Up Department with XLOOKUP

  Use XLOOKUP to retrieve department based on employee ID.

  生産性ChatGPT👁 0
• Combine First and Last Names in Excel

  Formula to concatenate first and last names into a single full name cell.

  生産性ChatGPT👁 0
• Excel Formula for Counting Hired Candidates

  A simple COUNTIF formula to count candidates with a specific status in a column.

  生産性ChatGPT👁 0
• Calculate Years of Service in Excel

  Formula to calculate tenure in years from a start date to today.

  生産性ChatGPT👁 0
• Generate Sample Employee Data in Excel

  Prompt to generate a sample dataset for testing or demonstration.

  生産性Model-agnostic👁 0
• Check for Missing Values in Excel

  Formula to identify empty cells and return a custom message.

  生産性ChatGPT👁 0
• Format Dates as Month and Year in Excel

  Format a date to display only month and year using TEXT function.

  生産性ChatGPT👁 0
• Create Dropdown List of Departments

  Set up a data validation dropdown using unique department names.

  生産性Model-agnostic👁 0
• Calculate Average Salary by Department in Excel

  Use AVERAGEIFS to compute average salary for a specific department.

  生産性Model-agnostic👁 0
• Sum Training Hours for Specific Course

  Sum values based on a condition using SUMIFS.

  生産性Model-agnostic👁 0
• Flag Employees with High Score and Low Salary

  Use IF with AND to flag rows meeting two conditions.

  生産性ChatGPT👁 0
• Sum Only Visible Filtered Rows

  Use SUBTOTAL to sum only visible cells after filtering.

  生産性ChatGPT👁 0
• Extract Department Code from Employee ID

  Extract text before a hyphen using LEFT and FIND.

  生産性ChatGPT👁 0
• Rank Employees by Performance Score

  Rank values in a column using RANK.EQ function.

  生産性ChatGPT👁 0
• Calculate Days Since a Date in Excel

  Simple subtraction to calculate days elapsed since a given date.

  生産性ChatGPT👁 0
• Add Sparklines for Quarterly Engagement

  Create a sparkline to visualize quarterly engagement trends.

  生産性ChatGPT👁 0
• 標準校正プロンプト

  文法、綴り、句読点、明瞭さに焦点を当てた基本プロンプトで、トーンは維持する。

  生産性Model-agnostic👁 0
• Infographic: How a Rocket Launches

  A prompt for generating a labeled, step-by-step infographic about rocket launches, suitable for educational or explanatory visuals.

  クリエイティブUni-1 (Luma AI)👁 0