Staring at gray grids all day? Same here—until I learned a one-step visual hack for Excel. It’s fast, doesn’t need fancy add-ons, and instantly makes data clearer and more fun to work with. There's a ...

Inserting a pivot table in a sheet in Excel 2013. Image: Screenshot by Susan Harkins/TechRepublic When is the last time you opened Microsoft Excel to do some data science? If it's been a while, you're ...

Data can often feel overwhelming—rows upon rows of numbers, scattered information, and endless spreadsheets that seem to blur together. If you’ve ever stared at a dataset wondering how to make sense ...

New columns are always added to the right edge of the dataset. Simply click and drag a column by its header to move it. Also, ...

Save time on status decks with a reusable Excel timeline chart. Data lives in a table, so new milestones update the timeline automatically.

Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...