There might be times when Excel takes what should be a number and treats it as text. This could happen after importing data, or entering data in a custom form. You might see a #NaN error (Not a Number). It’s sometimes fixable by formatting the cells as numbers, but Excel can be stubborn. The good news is it’s gotten better at not doing this, and there are three functions to use when it does. This video shows you how to use them.
Between the Sheets, Episode 80.
Last year, I did a TikTok video blog post about Excel’s =ROMAN function (watch it here). It will convert any regular Arabic number to Roman.
Microsoft will remove the experimental =COPILOT function from the Excel beta. They said they want functions to be more dependable and precise.
Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance
From The Guardian: “Users posing as would-be school shooters find AI tools offer detailed advice on how to perpetrate violence. Tests of 10 chatbots carried
I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,
