Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 9 of 60 · 540 articles
How to create an Excel absolute reference and relative reference
In this article, we’re going to show you how to create Excel absolute references and relative references using the dollar ($) sign.
How to highlight a row
Learn how to highlight rows in Excel. It can be tricky because there is no built-in option in Excel's Conditional Formatting feature.
How to Speed Up Lookup Formulas
Lookup functions are very useful when working with large data sets, but things can get rough for lookup performance.
How to find nth largest value in a data table
SpreadsheetWeb • This article shows you how to find the nth largest value by using the LARGE function in Excel.
How to select a random item by distribution in Excel
What if you have discrete distribution? In this article, we are going to show you how to select a random item by distribution in Excel.
How to use ROMAN numbers in Excel
In this guide, we will explore the intricacies of using Roman numbers in Excel.
How to get the decimal value of a number in a data set
SpreadsheetWeb • Excel Tips & Tricks • Identifying the decimal value of a number in a data set can be useful for analysis of results.
Implicit vs Explicit Intersections in Excel
SpreadsheetWeb Explore Intersection in Excel—from basic techniques to advanced formulas. Simplify calculations, and boost your efficiency.
How to convert Excel into PDF using 4 different methods
PDF is a popular file type for sharing documents. In this article, we are going to show you how to convert Excel into PDF using 4 methods.