BLOG ARCHIVES

Automatic Calculations in Excel for Web

In partnership with Experts Exchange. Another excellent feature Microsoft added to Excel is automatic calculations! It doesn’t mean you don’t have to write any formulas anymore, but it can figure out some of them for you, not just simple ones. If you’re familiar with Flash Fill, you might think of

Read More »

How to use the new Scan function in Excel

In partnership with Experts Exchange. Creating a running total is a common task but it can get complicated. So Microsoft is introducing a function to streamline it: the Scan function for both the Windows and Mac versions of Excel. Scan uses the Lambda function nested inside it. We covered the

Read More »

Get in touch

AI Workshop Inquiry/Booking