Friday, January 22, 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...
    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,...
    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....
    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'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...
    Although Excel's FREQUENCY function was designed to calculate frequency distributions, you also can use the SUM-IF, SUMPRODUCT, INDEX-FREQUENCY, and COUNTIFS functions. Here's a summary of the methods and your options.

    Five Ways to Calculate Frequency Distributions in Excel

    Charting Methods Charley Kyd -
    0
    Walt captures blood-pressure readings and wants to find how often the readings fall into various ranges of values. This is a common need for a...
    123...12Page 1 of 12

    Latest Articles

    We compare Excel's five columnar lookup functions.

    XLOOKUP vs VLOOKUP vs INDEX-MATCH vs SUMIFS

    Downloads Charley Kyd -
    0
    SUMIFS? Really? Why is SUMIFS included among those lookup methods? I'll explain in a few minutes. But first, let's look at the lookup methods shown in...
    How to aggregate named groups of GL accounts.

    How to Report GL Account Groups in Excel

    Accounting & Finance Charley Kyd -
    0
    Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
    If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the only strategy that will work for you.

    An Introduction to Excel Data Plumbing

    Business & Economics Charley Kyd -
    0
    Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.