Tuesday, April 13, 2021
Home Excel Methods

Excel Methods

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

    Random
    Excel includes many outstanding features that you probably don't know even exist. Here's how to find those features and to use the ones you need.

    How to Find and Use Excel’s Best Hidden Features

    Worksheet Interaction Charley Kyd -
    0
    Excel has many outstanding hidden features. Here are a few that I use frequently… In Excel 2013 and above, when you close Excel's last...
    When you're refinancing, this chart allows you to use the tip of your finger trade off your monthly payments and your total payments as you consider the term of your loan.

    Calculate Mortgage Payments and Your ROA with an Excel CalcPlot Chart

    Excel Methods Charley Kyd -
    0
    An Excel CalcPlot Chart allows you to plot values in three dimensions, not merely two. Here are two examples. Mortgage Paments Mortgage interest rates are at...
    Summary tables in Excel reports have always been difficult to format so they don't LOOK like Excel tables. Here's one extreme method you might want to try.

    Add Some Style to Your Tables in Excel Reports

    Excel Methods Charley Kyd -
    0
    Excel tables in reports have always been difficult for me to format professionally. So every once in a while, I experiment with them. The two...
    Use these little-known Excel charting tricks in your management reports to compare many categories of your business performance...clearly.

    Compare Metrics by Category Using Excel Dot Plot Charts

    Charting Methods Charley Kyd -
    0
    Management reports often must compare measures of performance by some type of category. For example, reports could compare sales by product, variance by department, sales...

    Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1

    Analytical Charting Charley Kyd -
    0
    It all seems so simple... To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...
    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...
    When you record VBA macros, Excel records each item you select. Here's why and how to avoid selecting those objects in your actual macro.

    You Usually Don’t Need to Select an Object in Excel VBA

    VBA Charley Kyd -
    0
    An Excel VBA user asked in a forum recently how to select a sheet in VBA when the sheet name is stored as a...
    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 second of two methods.

    How to Delete Blank or Unneeded Rows, Method 2

    Shortcuts Charley Kyd -
    0
    Data copied from a web site or imported from a variety of sources often include irrelevant rows of data. For example, the only way to...
    When you document your Excel worksheets, give your readers complete information by including row and column headings in your figures.

    Document Excel Worksheets with Pictures that Include Row and Column Headings

    Printing Charley Kyd -
    0
    This image is a picture of a section of an Excel worksheet. Be sure to include pictures like this when you create your own...
    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,...
    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.