An Introduction to Excel’s Normal Distribution Functions
(Download the workbook.)
When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
How to Delete Blank or Unneeded Rows, Method 1
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Often, you’ll want...
Introducing Excel’s Three Types of Spreadsheet Databases
Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas:
Simple...
Use a ‘Visible’ Column in Formulas to Ignore Hidden Rows in Filtered Tables
Excel Tables, introduced in Version 2007, give us the ability to use column filters to hide rows in a Table.
And slicers for Tables, introduced...
How to Perform Multiple Table Searches Using the SEARCH & SUMPRODUCT Functions in Excel
SUMPRODUCT is one of Excel's most-powerful worksheet functions. Here, for example, you can use it in one formula to search text in one cell...
How to Work with Dates Before 1900 in Excel
(Download the workbook.)
If you work with dates prior to the year 1900, Excel's standard date-handling system will be no help. However, there are several...
Use MS Query to Treat Excel as a Relational Data Source
Charley's Note: Because MS Query hasn't changed much since Marty Ryerson wrote this article years ago, his instructions are still quite accurate. I have,...
Use COUNTIFS, not FREQUENCY, to Calculate Frequency Distribution Tables for Charting Histograms
Because the Texas and California governors have been bickering over the Texan's attempt to poach California employers, I got curious about the distribution of...
How to Report Periodic Data from Excel Databases
Sometimes, the best way to solve your Excel problem is to redesign your workbook.
Ron G. brought this thought to mind with a recent question....
How to Use Conditional-Format Formulas to Change Background Colors
"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...