Q. Can you tell me how to use the linked data types in Microsoft Excel? A. You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected ...

With the functions I'll discuss here, you can make data cleanup much easier in Excel. They allow you to extract, style, split, and join text to get what you need without wasting hours doing it ...

Stop manually inserting rows and columns—use Excel's "secret" right-click-drag menu to move, swap, and convert data instantly ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

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

Q. My supervisor wants me to include more data visualizations in my projects. Do you have any suggestions? A. Data visualization transforms raw data into graphical representations, making complex ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

Not only does Excel keep information organized in spreadsheets, it can also save you from manually typing data for each cell separately. Formulas compute information directly in Excel and ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...

A few months ago, I speculated on what a then-rumored Office 365 "Life Edition" might end up looking like. Ultimately, Microsoft chose to abandon the "Life Edition" moniker in favor of much more ...