Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

Inside the dialog box in the Reference box, enter a cell or cell range. Click OK; it will go to the cell or cell range you entered. Read: Microsoft Excel Tutorial for Beginners.

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell ...

Filters organize and prepare data for Excel reports and visualizations by selecting only relevant data for display. If you are working with a filter in an Excel worksheet, you can extend the range ...

Where conditional formatting is concerned, this is often the case. In this Excel tutorial, I’ll show you how to apply conditional formatting to a filtered PivotTable in Excel.

Cutting and pasting ranges of cells is a common operation in Excel, and Microsoft's Visual Basic offers streamlined functionality to easily automate the process.