Excel resources

Excel Tips & Tricks

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 18 of 60 · 540 articles

Ilker · Dec 20, 2021

How to create pill charts in Excel

In this guide, we’re going to show you How to create pill charts in Excel to make your dashboards catchier.

How to insert chess piece symbols in Excel
Ilker · Dec 13, 2021

How to insert chess symbols in Excel

Learn how to insert chess symbols in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.

How to generate random data in Excel
Ilker · Dec 13, 2021

How to generate random data in Excel

In this article will show you How to generate random data in Excel. You can generate numbers, dates, time values and names.

How to use Greek Letters in Excel
Ilker · Dec 9, 2021

How to use Greek Letters in Excel

Greek letters are used in various areas, like mathematics and science. In this article will show you how to use Greek Letters in Excel.

How to create a progress chart in Excel
Ilker · Nov 29, 2021

How to create a progress chart in Excel

Learn how to create a progress chart in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.

How to calculate area under curve in Excel
Ilker · Nov 29, 2021

How to calculate area under curve in Excel

Learn how to calculate area under curve in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.

How to round date values in Excel
Ilker · Nov 11, 2021

How to round date values in Excel

In this guide, we’re going to show you how to round date values in Excel.

How to round time values in Excel
Ilker · Nov 10, 2021

How to round time values in Excel

In this guide, we’re going to show you how to round time values in Excel with MROUND, CEILING.MATH and FLOOR.MATH.

How to export each sheet as CSV in Excel
Ilker · Nov 9, 2021

How to save each sheet as CSV in Excel

Learn how to save each sheet as CSV in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.