Resources
How to create a stream graph in Excel
A stream graph is a form of stacked area chart in a flowing, organic shape. The graph is displaced around a central axis to visualize the data without expressing positive or negative values. In this guide, we’re going to show you how to create a stream graph in Excel....
How to show a message on Status Bar in Excel
In this guide, we’re going to show you how to show a message on Status Bar in Excel. What is Status...
How to generate numbers without dragging the mouse in Excel
It is almost impossible to think of Excel without autofill feature. It allows you to generate numbers or dates and copy formulas with a single mouse movement. However, this single action can be a burden when you need to generate numbers in a large range. In this...
How to Group Worksheets and How to Manage in Excel
Welcome to our comprehensive guide on how to group worksheets in Excel! Grouping worksheets in Excel is a valuable technique for managing and organizing your workbook efficiently. In this tutorial, we'll explore various methods and best practices for grouping...
How to use Data Table in Excel
A data table can show the results for all possible outcomes at once and saves you from testing against variables individually in your Excel models. In this guide, we’re going to show you how to use Data Table in Excel with one and two variables. [button...
How to calculate simple interest in Excel
In this guide, we’re going to show you how to calculate simple interest in Excel. What is Simple...
How to calculate compound interest in Excel
In this guide, we’re going to show you how to calculate compound interest in Excel. Compound...
How to create a step chart in Excel
A step chart is a type of line chart that displays the changes over time in data. Unlike a regular line chart, step charts connect data points with vertical and horizontal lines. Although Excel does not have step chart support by default, you can follow our guide to...
How to convert string to number in Excel using VBA
Numeric values are defined by data types like integer or byte. These data types are used for optimizing the processing and memory allocation in Excel. In this guide, we’re going to show you how to convert string into number in Excel VBA. [button...