January 1, 2025

Between the Sheets, Episode 71: How to Run SQL in an Excel Worksheet

Between the Sheets, Episode 71: How to Run SQL in an Excel Worksheet
It’s now possible to run Structured Query Language (SQL) directly in an Excel worksheet. It requires a free add-in that installs with just one click. In this video, we create a few Select queries, create an alias, use Where, Sortby and Or operators and see a couple of other cool features.

Categories

Share:

Related Posts

Excel formula: convert Roman numerals to regular Arabic numbers

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 removed the =COPILOT function from Excel

Microsoft will remove the experimental =COPILOT function from the Excel beta. They said they want functions to be more dependable and precise.

Now certified in AI Ethics

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

AI chatbots helped researchers plot deadly attacks

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

Earned another AI certification

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,