A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y. By calculating a function at a large number of set intervals, it is ...

Microsoft Excel is designed to organize and interpret small and large amounts of data. Building a curved graph in Excel based on X and Y data points is fairly simple. You begin by adding the data ...

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

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

Excel is probably Microsoft’s most popular developer tool. With a built-in functional programming language that now supports lambdas and variables, Excel has become a tool that people build businesses ...

Excel looks at the dates and assumes that all dates form part of the series, whether or not they are entered in the spreadsheet. Assuming that the dates form the X-axis, as you create the chart and ...

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how. A people chart is an infographic, which leads me to a second definition. An infographic tells a story, ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window. When ...