Discover 5 advanced Excel drop-down techniques to create dynamic, auto-updating lists and improve your data management skills.

Discover eight practical ways to multiply in Excel, from basic formulas to advanced tips. Perfect for beginners and Excel ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Have you ever found yourself staring at a massive spreadsheet, wondering how to extract just the right information without getting lost in a sea of data? Whether you’re a seasoned Excel user or just ...

This powerful Excel feature cuts the time you spend on formulas in half. In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to ...

Whether you’re aggregating or analyzing data, there are a few basic Excel shortcuts that will save time and help you work faster (check out my advanced Excel tricks here). Anyone who’s a regular ...

Averaging isn’t always a simple total divided by the number of items totaled. Fortunately, Microsoft Excel offers several averaging functions, and one of them will probably get the job done. In this ...

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