The smartest thing Excel does happens in places you can't see.

Q. My supervisor wants me to include more data visualizations in my projects. Do you have any suggestions? A. Data visualization transforms raw data into graphical representations, making complex ...

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

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

I have a background that includes spreadsheets, programming, and electronics, so this book piqued my interest. I didn't run into any surprises until I thought a bit more about its contents and my ...

I usually prefer writing my own logic in Excel, so I was hesitant to start using the Formula by Example tool. But when it turned my manual patterns into a perfectly structured formula, it became the ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

Auditors know that journal-entry testing is one of many procedures they can use in addressing client data completeness and, hence, audit risk (see AU-C Section 240, Consideration of Fraud in a ...

There is a stark example this week of how things are changing in the race toward artificial intelligence. This involves a household-name model, and an administrative technology that’s instantly ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...