In this video, you’ll learn how to sort names by last name in Excel, even when first and last names are in the same cell. We ...

TikTok's Excel community is vast, with some stars garnering millions of followers making tutorials. Some of the biggest Excel influencers are "Miss Excel," "Your Excel Friend," and "Excel Daddy." They ...

You can establish links across multiple spreadsheets and workbooks in Microsoft Excel to streamline data management. A link enables a cell in one spreadsheet – the ...

Have you ever found yourself endlessly scrolling through a sprawling Excel workbook, struggling to locate the exact worksheet you need? For those managing complex datasets or collaborative projects, ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

The open source community has created many open source Java projects, which range from charting software to game frameworks to word processors. In this post, I introduce an open source library project ...