Q. I use Excel to do traditional linear forecasting, but I would like to upgrade to exponential smoothing for more accurate forecasts. Is there a way to do this in Excel? A. Accurate forecasting is ...

Microsoft says Windows PowerShell now warns when running scripts that use the Invoke-WebRequest cmdlet to download web content, aiming to prevent potentially risky code from executing. As Microsoft ...

Anthropic is making its most aggressive push yet into the trillion-dollar financial services industry, unveiling a suite of tools that embed its Claude AI assistant directly into Microsoft Excel and ...

This program converts userforms created in Microsoft Excel VBA into PowerShell (WinForms) code. Note: SpinButton behaves differently in VBA and WinForms, so appearance may vary depending on placement.

Microsoft has announced that it will start disabling external workbook links to blocked file types by default between October 2025 and July 2026. After the rollout ...

A PowerShell script using WBAdmin can create full system backups of Windows 11, offering a simple, scriptable alternative for advanced users. Over the last couple of years, I have written a few blog ...

A hot potato: The controversial issue of companies training their AI models on user-generated content is once again under the spotlight. This time, the programs in question are the widely used ...

Many people working in the corporate world need at least a passing familiarity with Microsoft Excel. Maybe you only indicated that you're skilled with Excel on your resume because it feels like one of ...

Q. ChatGPT-4o was released in May 2024, and I heard it can interact with documents. Does this apply to Excel documents? A. In January 2023, I wrote my first column on ChatGPT for the JofA, and I was ...

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...