Excel is incredibly powerful when your data is complete, but what happens when you need to solve for unknown variables? Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ...

Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get ...

Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using ...

Did you know that you can leave notes on specific Excel cells for people to read? It’s a great way to safeguard against data entry mistakes by putting in reminders or instructions. Here’s how to set ...

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