Excel is my database, Python is my brain.

When Andrew Grigolyunovich first started using Excel more than two decades ago, he never imagined the spreadsheet program would land him in Las Vegas or on ESPN. The Latvian financial consultant ...

You’ve probably noticed it before: that tiny strip of fabric stitched into the upper back of a button-down. It sits right between the shoulders, usually just below the collar, and it’s one of those ...

Google removed outdated structured data documentation, but instead of returning a 404 response, they have chosen to redirect the old URLs to a changelog that links to the old URL, thereby causing an ...

The new ‘COPILOT’ function uses AI to generate summaries, tags, tables, and more based on a group of cells. The new ‘COPILOT’ function uses AI to generate summaries, tags, tables, and more based on a ...

Microsoft Excel receives new features on a regular basis, which is important considering how widely it is utilized for various use cases, including data crunching, visualizations, and organization. A ...

Have you ever stared at a tangled web of Excel formulas, wondering if there’s a better way to make sense of it all? For many, Excel’s LAMBDA function feels like a cryptic puzzle—powerful but ...

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

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...