Excel tutorial on how to insert a Spin Button in Excel and how to add a Slider to a chart in Excel. We’ll do this to make our example chart more interactive. The Spin Button will help us update our example chart by allowing us to update the year chosen by simply clicking up or […]
Excel tutorial on how add Option Buttons to filter a chart. One of the Form Control tools, the Option Buttons will also help make the chart interactive. In the example in this tutorial, we’ll assign macros to the Option Buttons, or Radio Buttons, to filter the chart just by selecting a button.
Excel tutorial on how to make an organizational chart in Excel using SmartArt. We’ll also create a link from some positions in the org chart to a team bio. SmartArt works something like a “wizard” for Shapes in Excel and other programs. It helps you create more visually appealing graphics faster through the use of […]
Excel tutorial on how to use the Forecast Sheet in Excel. The Forecast Sheet button quickly analyzes the data on your spreadsheet and then creates a chart of its forecast. You can then use this chart as a visual to help you understand the forecasted results better or as a visual for a presentation. Watch […]
Excel tutorial on how to make a Flow Chart in Excel. We’ll go over how to create a flowchart using Shapes. We’ll add arrows to connect each step in the process and then format each step so that the flow chart is easier to follow. We’ll also add a hyperlink to a process step. It’s […]
Excel tutorial on how to use Sparklines in Excel. These mini charts can help spreadsheets look more professional by adding a quick visual to data. Take a look as we go over what a Sparkline chart is and how to use them. First, what is a Sparkline? Excel Sparklines are mini charts that show how […]