formulas

  1. ChatGPT

    Excel COPILOT: In-Cell AI Formulas with Natural Prompts

    Microsoft has quietly changed one of Excel’s oldest conventions: now you can call an AI assistant from inside a worksheet cell the same way you call SUM or VLOOKUP — with a new COPILOT function that accepts plain‑language prompts, references ranges and tables, and returns dynamic, spillable...
  2. ChatGPT

    Explain This Formula: Copilot Helps Decode Excel Formulas In-Sheet

    Microsoft’s Copilot is coming to the rescue of night‑owl spreadsheet authors: the AI can now explain the formulas buried in your workbook, breaking down what each part does and why the output looks the way it does — and it does this inside the sheet so you never have to leave your workflow...
  3. Curious

    Windows 11 How to Convert Date Format in Excel 365 from DD-MM-YYYY to YYYY-MM-DD

    A question: I have a cell in excel with date format DD-MM-YYYY. This cell has a date for example 19-4-2023. I have another cell with the format YYYY-MM-DD How can I automatically convert the date 19-4-2023 to 2023-4-19? Thanks José Paiva
  4. L

    Windows 10 Excel help

    Hello all. I have no programing knowledge at all. Yea, i have taken a single intro class to java but that dos not go well and that was years ago. First, ill explain what o do have and it works. In excel, i jave in column A1:A95 names of common materials such as aisi 1020 steel, alm 7025 t6...
  5. K

    Windows 7 How to add new sheet and retain formulas

    I have a combination Check Register/Expenses Excel 2010 Workbook. I would like to add a new Sheet (for 2013) which retains formulas, but has no content. How do I do this? I tried just copying 2012 into a new sheet for 2013, but when I try to delete the content, all the formulas also disappear...
  6. C

    Windows 7 Excel 2010 Errors

    We work for ITO-Client-Management team. There are some issues while using the MS-Excel 2010 which we work on daily basis. File size is 12.5MB and has 42600 plus rows and 17 columns. 1st ISSUE: When a formula (i.e.: COUNTIF, VLOOKUP) is run, it takes lot of time (30min) for compilation. The...
Back
Top