The ability to write parts of SQL queries in natural language will help developers speed up their work, analysts say.

To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...

Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...