Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 25 of 60 · 540 articles
Function: PROB
In this guide, we’re going to show you how to use the PROB function and also go over some tips and error handling methods.
How to add error bars in Excel
rror bars are graphical representations of data variability. In this guide, we’re going to show you how to add error bars in Excel.
How to alternate row color based on group in Excel
In this guide, we’re going to show you how to alternate row color based on group in Excel bu using conditional formatting.
How to calculate variance in Excel
Variance is an important metric in statistics In this guide, we’re going to show you how to calculate variance in Excel.
How to create and name a worksheet with VBA in Excel
Learn how to create and name a worksheet with VBA in Excel. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to generate a normally distributed set of random numbers in Excel
In this guide, we're going to show you how to generate a normally distributed set of random numbers in Excel.
How to create a Milestone Chart in Excel
In this guide, we're going to show how to create a milestone chart in Excel. Milestone Charts show significant events during a time period.
How to find all combinations of two lists in Excel
Learn how to find all combinations of two lists in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to compare two tables using Get & Transform Data in Excel
Learn how to compare two tables using Get & Transform Data in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.