Tuesday, April 13, 2021
Home Excel Methods

Excel Methods

    Articles that explain or illustrate Excel’s features, functions, and methods.

    Most popular
    Excel provides several worksheet functions for working with normal distributions or 'bell-shaped curves.' This introduction to Excel's Normal Distribution functions offers help for the statistically challenged.

    An Introduction to Excel’s Normal Distribution Functions

    Business Statistics Charley Kyd -
    0
    (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...
    When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Here's the first of two methods.

    How to Delete Blank or Unneeded Rows, Method 1

    Worksheet Interaction Charley Kyd -
    0
    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...
    Excel offers at least three ways to set up data so your reports and analyses can use it easily as a reliable data source.

    Introducing Excel’s Three Types of Spreadsheet Databases

    Data Management Charley Kyd -
    0
    Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas: Simple...
    Although Excel provides two worksheet functions that ignore filtered rows in a Table, nearly any function can ignore those hidden rows if you use this new trick.

    Use a ‘Visible’ Column in Formulas to Ignore Hidden Rows in Filtered Tables

    Excel Methods Charley Kyd -
    0
    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...
    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 for many items.

    How to Perform Multiple Table Searches Using the SEARCH & SUMPRODUCT Functions in Excel

    Excel Tables Charley Kyd -
    0
    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

    How to Work with Dates Before 1900 in Excel

    Excel Methods Charley Kyd -
    0
    (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...
    Excel ranges can work like relational tables. You can join them by common fields. Query them with SQL. And use queries in PivotTables. Here's how.

    Use MS Query to Treat Excel as a Relational Data Source

    Data Management Charley Kyd -
    0
    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,...
    Excel's FREQUENCY function was first created to calculate frequency distribution tables, which are needed for charting histograms. But the COUNTIFS function offers more power, and it's easier to use.

    Use COUNTIFS, not FREQUENCY, to Calculate Frequency Distribution Tables for Charting Histograms

    Charting Methods Charley Kyd -
    0
    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...
    Do you need to update your Excel reports with daily, weekly, or monthly data? Here's a low-maintenance way to do it, using one type of Excel database.

    How to Report Periodic Data from Excel Databases

    Data Management Charley Kyd -
    0
    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....
    Here's how to use a formula that returns TRUE or FALSE in Excel's conditional formatting feature to highlight rows that contain specific numbers or text.

    How to Use Conditional-Format Formulas to Change Background Colors

    Conditional Formatting Charley Kyd -
    0
    "I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...
    123...12Page 1 of 12

    Latest Articles

    Using Excel's LET, SORTBY, and SEQUENCE functions, and dynamic arrays, you easily can list any number of top and bottom results from a Table.

    How to Report Top and Bottom Results Using Dynamic Arrays in Excel

    Array Formulas Charley Kyd -
    0
    In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...
    The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

    How to Use Excel’s LET Function

    Array Formulas Charley Kyd -
    0
    In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
    You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

    How to Set Up an Automatic Error-Checking System in Excel Reports

    Accounting & Finance Charley Kyd -
    0
    Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.