SpreadsheetWeb blog
Practical thinking for spreadsheet-powered teams
Deep guides on Excel, Google Sheets, web applications, product workflows, and the quiet technical traps worth knowing about.
Page 51 of 55 · 1312 articles
How to return an entire row
Learn how to return an entire row. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to return an entire column
Learn how to return an entire column. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to convert a URL into a hyperlink automatically
Learn how to convert a URL into a hyperlink automatically. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to Transpose The Rows and Columns of a Data Table
To transpose rows and columns in Excel in a data set, transpose table using single formula, also works with dynamic ranges.
Manage Tasks Better by Visualizing the Data in Gantt Chart
Gantt charts are very helpful for project management and time tracking purposes. Even though Excel doesn’t have a built-in Gantt chart, it’s possible to get the same result using workarounds like this one.
How to create a random secure password in Excel
Learn how to create a random secure password in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to shuffle a list of items in a random order
Learn how to shuffle a list of items in a random order. This practical guide covers the required setup, step-by-step process, and useful Excel options.
How to add comments into formulas
Learn how to add comments into formulas. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a calendar that only contain workdays
Learn how to create a calendar that only contain workdays. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to find the power of a number
Learn how to find the power of a number. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to get the column index of a cell using the COLUMN function
Learn how to get the column index of a cell using the COLUMN function. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to get the row index of a cell using the ROW function
Learn how to get the row index of a cell using the ROW function. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate payments for a loan
Learn how to calculate payments for a loan. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to Get The Worksheet Name, File Name, and Its Path
This simple trick in this article will help you to organize your data, and label workbook details like filename in Excel.
How to shorten a number and get the integer value
Learn how to shorten a number and get the integer value. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Comparison of VLOOKUP, HLOOKUP, and LOOKUP
Ultimately, all three lookup formulas do the same thing. Their operating logic, however, is something you should keep in mind when choosing which one to use in your data models.
Human Resources Dashboard
This Human Resources Dashboard template visualizes various employee related measures including payroll, sick days, and employee performances.
How to rank data in Excel tables
Learn how to rank data in Excel tables. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Number Formatting in Excel - All You Need to Know
The main advantage of custom number formatting is that you can alter the look of your data without changing the actual values. This means that you do not need to use additional spaces or formulas to create the layout you want and preserve the raw data.
How to calculate weighted average with SUMPRODUCT
Learn how to calculate weighted average with SUMPRODUCT. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to COUNT values between two dates
Learn how to cOUNT values between two dates. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to SUM values if date is less than
SUMIF and SUMIFS functions can be used to sum values that meet a criteria. They search a given criteria in a criteria range, this processes result is an array of TRUE/FALSE.
How to SUM values if date is greater than
Learn how to sUM values if date is greater than. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to SUM values between two dates using SUMIFS formula
Learn how to sUM values between two dates using SUMIFS formula. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.