With a pivot table, you can create one pool of information and then easily change your focus from one thing to another — an analysis that would be tedious to perform manually.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

You can create a sparkline from data in a table or a PivotTable. Select the data range, such as sales for a 12-month period, then go to the Insert tab on the Ribbon and select Line, Column or Win ...

To create a data validation drop-down list in Excel, you need two things: A list of values and a blank cell to use as the data entry cell. The list is in B3:B6 and the data entry cell is D2.

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

In Excel, syntax for this function is NORMINV (probability,mean,standard deviation). Using the sales example, with a weekly sales average of $2,000 that fluctuates about $500 up or down, you know ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.