Developing advanced Excel features may even help you score raises and promotions. If one of your new year's resolutions is to work more efficiently, it might be time to learn how to use Microsoft ...

Search is a pervasive feature of Windows 7, but few really know how to use it to its fullest extent. This short guide to Windows' Advanced Query Syntax will make you a search power-user.

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

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet. There are several ways to find duplicates in a Microsoft Excel sheet. You ...

Microsoft introduced the Query Store when they released SQL Server 2016 and it can track statement performances, pinpoint queries and more. DBTA recently held a webinar focused on the new features and ...