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 […]
Excel Tutorials
How to Make Named Ranges in Excel – Tutorial
Excel tutorial on how to make Named Ranges in Excel. So, what is a Named Range in Excel??? A Named Range is a feature in Excel that lets you assign a name to a range of cells that you select on your spreadsheet. You can then access and reference these cells by using the new […]
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 […]
How to Use the Watch Window in Excel – Tutorial
Excel tutorial on how to use the Watch Window in Excel. First, what is the Watch Window in Excel? The Excel Watch Window is a tool to help you monitor changes to cells that you select to watch. Once you specify the cells you want to watch, a new window will pop up displaying real-time […]
How to Make a Color Palette in Excel – Tutorial
Excel tutorial on how to make a color palette in Excel. You may want create a color palette for brand colors, for example, or other frequently used color combinations. You can then apply these to Excel tables, charts, dashboards, etc. In addition, you’ll also be able to use your custom color palette in other Microsoft […]