You can see that we simply use a plus sign to add the cell values. That formula performs the same operation as this one that uses the SUM function: =SUM(A1,B1) .

Step 1: Go ahead and open the Excel spreadsheet you want to use. In our example, we have a simple table of products, services, projected prices, and their actual prices.

Although we use Excel and Tableau as the primary examples, the principles we discuss apply more broadly to spreadsheets and data visualization programs in general. Here are some names to know: ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

We use the Office 365 version of Excel for Windows in the descriptions below; some features may not be available if you use a different version. Charts.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Let’s use the UNIQUE function in one more example. This time the dataset we have been using has the first and last names in different columns. We would still like to identify unique customers from the ...

We are seeking y, which is the period of time we are forecasting a specific dollar value for. This gives you one point; Excel moves this through multiple points, seeking data points potential for ...