Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 21 of 60 · 540 articles
How to generate numbers without dragging the mouse in Excel
In this guide, we’re going to show you how to generate numbers without dragging mouse in Excel.
How to Group Worksheets and How to Manage in Excel
In this guide, we’ll show you how to manage worksheets in Excel with tips and mouse and keyboard shortcuts and to group worksheets in excel.
How to use Data Table in Excel
In this guide, we’re going to show you how to use Data Table in Excel. Data Table is a What-If Analysis tool to test your based on variables.
How to calculate simple interest in Excel
Learn how to calculate simple interest in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate compound interest in Excel
Excel is a powerhouse for financial calculations. In this guide, we’re going to show you how to calculate compound interest in Excel.
How to create a step chart in Excel
Although Excel does not have step chart support by default, in this guide, we’re going to show you how to create a step chart in Excel.
How to convert string to number in Excel using VBA
In this guide, we’re going to show you how to convert string into number in Excel VBA.
How to use Scenario Manager in Excel
In this guide, we’re going to show you how to use Scenario Manager in Excel to keep set of input values for specific cells.
How to print header row and column in Excel
In this guide, we’re going to show you how to print header row and column in Excel.