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 […]
Charts
How to Use Option Buttons to Filter a Chart in Excel – Tutorial
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.
How to Make an Organizational Chart in Excel – Tutorial
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 […]
How to Use the Forecast Sheet in Excel (+ video tutorial)
The Forecast Sheet tool in Excel helps you quickly create a data forecast at the click of a button. Using your existing data, this tool creates a forecast that even includes a chart! This is perfect if you need to make a presentation of your forecast! The Forecast Sheet tool is available in Office 365 […]
How to Make a Flow Chart in Excel – Tutorial
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 […]
How to Use Sparklines in Excel – Tutorial
https://youtu.be/6aUv1E9IZnc 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 […]