Buscar

18826 prompts

• Filter Employees by Salary and Tenure

  Use FILTER with multiple conditions to display matching rows.

  ProductividadChatGPT👁 0
• Handle Division by Zero Errors in Excel

  Use IFERROR to return 0 when a division by zero occurs.

  ProductividadModel-agnostic👁 0
• Highlight Employees with Over 5 Years Tenure

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

  ProductividadChatGPT👁 0
• Prevent #REF! Errors in Excel

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

  ProductividadChatGPT👁 0
• Look Up Department with XLOOKUP

  Use XLOOKUP to retrieve department based on employee ID.

  ProductividadChatGPT👁 0
• Combine First and Last Names in Excel

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

  ProductividadChatGPT👁 0
• Excel Formula for Counting Hired Candidates

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

  ProductividadChatGPT👁 0
• Calculate Years of Service in Excel

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

  ProductividadChatGPT👁 0
• Generate Sample Employee Data in Excel

  Prompt to generate a sample dataset for testing or demonstration.

  ProductividadModel-agnostic👁 0
• Check for Missing Values in Excel

  Formula to identify empty cells and return a custom message.

  ProductividadChatGPT👁 0
• Format Dates as Month and Year in Excel

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

  ProductividadChatGPT👁 0
• Create Dropdown List of Departments

  Set up a data validation dropdown using unique department names.

  ProductividadModel-agnostic👁 0
• Calculate Average Salary by Department in Excel

  Use AVERAGEIFS to compute average salary for a specific department.

  ProductividadModel-agnostic👁 0
• Sum Training Hours for Specific Course

  Sum values based on a condition using SUMIFS.

  ProductividadModel-agnostic👁 0
• Flag Employees with High Score and Low Salary

  Use IF with AND to flag rows meeting two conditions.

  ProductividadChatGPT👁 0
• Sum Only Visible Filtered Rows

  Use SUBTOTAL to sum only visible cells after filtering.

  ProductividadChatGPT👁 0
• Extract Department Code from Employee ID

  Extract text before a hyphen using LEFT and FIND.

  ProductividadChatGPT👁 0
• Rank Employees by Performance Score

  Rank values in a column using RANK.EQ function.

  ProductividadChatGPT👁 0
• Calculate Days Since a Date in Excel

  Simple subtraction to calculate days elapsed since a given date.

  ProductividadChatGPT👁 0
• Add Sparklines for Quarterly Engagement

  Create a sparkline to visualize quarterly engagement trends.

  ProductividadChatGPT👁 0