Alan is a technology author based in Nova Scotia, Canada. A computer enthusiast since his youth, Alan stays current on what is new and what is next. With over 30 years of experience in computer, video ...

Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, but well-designed formulas or other tools like Power Query often handle ...

Have you ever found yourself drowning in a sea of repetitive tasks, wishing there was a way to make Excel do the heavy lifting for you? From cleaning up messy datasets to applying the same formatting ...

Hagop is passionate about smart home products, especially when it comes to making life easier. He's always eager to try out new technologies to make life easier, in terms of cleaning, automation, and ...

Automating Excel tasks with ChatGPT has become a highly effective way to simplify workflows, especially when creating VBA (Visual Basic for Applications) macros. By using artificial intelligence, you ...

Click to download a workbook and open in Excel; make sure to enable macros for full functionality. The workbooks contain screencasts that explain what to do and include tasks that can be assigned.

Microsoft Excel is practically unavoidable in the modern working world, but unfortunately, learning to use Excel beyond the most basic functions can be difficult on your own. Tutorials are available, ...

Learn how to create useful spreadsheets. TL;DR: Through July 21, master the much-loved, much-hated Microsoft app with this Microsoft Excel training bundle. It's on sale for just £23.60 (reg. £314.14) ...

Workers have used OpenAI's ChatGPT for dozens of tasks since its November release. While some fear AI may replace their job, others have embraced the technology to improve their productivity. One ...

Right now, I'm working off one of Microsoft's infamous giant press releases. The company has a tendency to do brain dumps in press release form, so we both have to sift through the release to give you ...

The Excel Workbooks, Excel Add-ins, and screencasts on this site will be updated and corrected regularly so head there if you are merely looking for the latest versions of a file. As far as mistakes ...