Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.

Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.

I have been called the LeBron James of spreadsheets, but I try not to take myself too seriously Growing up in Waterford, south-east Ireland, I was always good at maths. I first used Excel at ...

Here we will go through how Excel is structured, where you will find important and smart functions, and various peculiarities you should know. In short, we’ll show you how to make the program work for ...

Pittcon’s professional quality online Short Courses are an affordable opportunity for continuing education. All courses count towards building your Professional Hours. Courses take place on Wednesdays ...

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...

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 ...

Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...

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 ...

Artificial Intelligence (AI) tools are reshaping the landscape of software development, particularly in the realm of generating Visual Basic for Applications (VBA) code. These innovative solutions are ...

Workplace visualization tools make the world go round, and will definitely liven up your before-lunch presentation. If you’ve got hard numbers to display to the masses, or graph-scribed projections ...