Saturday, September 25, 2021
Home Excel Methods

Excel Methods

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

    Latest
    Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

    How I Set Up SEARCH and FIND Formulas on Steroids

    Data Management Charley Kyd -
    0
    I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
    Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

    Eight Great Tools for Your Quick Access Toolbar

    Excel Productivity Charley Kyd -
    0
    I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...

    How to Set Up Multiple Conditional Formats with Formulas

    Excel Methods Charley Kyd -
    0
    In How to Set Up a Square-Format U.S. Map in Excel, I showed how to create a square-format US map in Excel. I also...
    When conditional formatting rules conflict, Excel can deliver unexpected formatting results. These two guidelines make Excel's logic clear.

    How Excel Manages Conflicting Conditional Formats with Formulas

    Excel Methods Charley Kyd -
    0
    When we're working with conditional formatting with formulas, how does Excel manage conditional formatting rules that conflict with each other? And how does the "Stop...
    This Excel map relies on conditional formatting to highlight areas of interest.

    How to Set Up a Square-Format U.S. Map in Excel

    Excel Methods Charley Kyd -
    0
    For several years, the Wall Street Journal has occasionally used a square-format US map like the following image. But when I noticed a recent...
    Berkshire Hathaway is raising prices, and their costs are increasing. Inflation is on the rise. These Excel charts illustrate the the problem.

    Warren Buffett, Inflation, and Excel

    Blog Charley Kyd -
    0
    On May 3, 2021, CNBC quoted Warren Buffett saying, “We are seeing very substantial inflation. We are raising prices. People are raising prices to...
    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...
    To use Account Groups in Excel formulas, you first must define the groups. Here’s how to do it using either simple lists or Dynamic Arrays.

    How to Define General Ledger Account Groups in Excel

    Array Formulas Charley Kyd -
    0
    In Part 1 of this series, How to Report GL Account Groups in Excel, we explored the strategy for creating financial reports that use...
    All Excel reports perform at least four tasks. Good reports assign these tasks to four sections, with specific worksheets defining each section.

    How to Structure Your Report Workbook

    Excel Methods Charley Kyd -
    0
    In Weekly & Monthly Top-Ten Activity Reports I introduced two Excel dashboard reports created by Chris Helfrecht. In this post, I’ll describe a critical aspect of...
    Excel's Linked Picture feature (Camera tool) allows us to position a table in reports while ignoring the row and column settings in the report worksheet.

    Ideas about Using Excel’s Linked-Picture (Camera) Tool

    Excel's Graphic Tools Charley Kyd -
    0
    Of all the Excel features that users don’t use very often, Excel's Linked Picture tool probably is the most powerful. This tool, known in...
    Load more

    Latest Articles

    Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

    How I Set Up SEARCH and FIND Formulas on Steroids

    Data Management Charley Kyd -
    0
    I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
    Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

    Inflation Tracker Excel Dashboard with Consumer Prices

    Business & Economics Charley Kyd -
    0
    U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
    Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

    Eight Great Tools for Your Quick Access Toolbar

    Excel Productivity Charley Kyd -
    0
    I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.