Sunday, June 20, 2021
Home Excel Strategies

Excel Strategies

    Sometimes, the most-productive thing you can do with Excel is to THINK about how you intend to use Excel to achieve your information goals. That’s what this category is all about.

    Random

    A Lesson in Excel Analysis Learned from Rising US Inflation

    Excel Strategies Charley Kyd -
    0
    Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...
    Here's how select a value from a list of values from a worksheet's a Validation List. You can use the list to display interactive data in reports.

    How to Select Values from a Validation List in Excel

    Excel Strategies Charley Kyd -
    0
    Excel provides two ways to select a value from a list of values. I often use this feature in interactive Excel reports to select dates,...
    Many Excel reports leave managers knowing less than they did before. Here are five best practices to follow in planning your management reports.

    Five Best Practices in Your Excel Reporting Strategies

    Excel Strategies Charley Kyd -
    0
    Most Excel reports, forecasts, and analyses I've seen in my career could serve as excellent examples of what NOT to do in Excel. These reports...
    Here's how to help your readers gain more insight from your Excel reports and analyses, base on an article in the Harvard Business Review.

    Five Ways to Improve Business Insight in Your Excel Reports

    Excel Strategies Charley Kyd -
    0
    Is there a systematic way that you can help your readers to gain more insight from your Excel reports? There just might be. The November,...
    A reader asked how to generate the same report for 27 different divisions. If you have a similar challenge, here's how to get started.

    Interactive Excel Reporting

    Excel Strategies Charley Kyd -
    0
    Several years ago, a reader asked me to help him with an Excel-reporting challenge that might sound familiar. His challenge, he said, was that he...
    Excel offers two powerful worksheet functions that can return just the data you need from Excel Tables.

    The Excel-Friendly Database Strategy

    Excel Strategies Charley Kyd -
    0
    Here's the key to slashing both your Excel errors and the time it takes you to create and update your Excel reports... Get your plumbing...
    An Excel-Friendly Database is defined as an organized collection of data from which worksheet formulas can return values. Here are five Excel-friendly databases.

    Introducing Excel-Friendly Databases

    Excel Strategies Charley Kyd -
    0
    The most productive way to flow data to your Excel reports and analyses is to use Excel formulas to flow data from an Excel-Friendly...
    How to aggregate named groups of GL accounts.

    How to Report GL Account Groups in Excel

    Excel Strategies 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...
    In Excel, you can report named groups of GL account numbers, product codes, and so on—just as you report one such number. Here’s how.

    How to Use Array Formulas to Report Groups of Accounts

    Accounting & Finance Charley Kyd -
    0
    Often, in accounting, marketing, and other departments, we'd like to report and analyze groups of items rather than one item at a time. In Part...
    Excel databases can be Tables of data, Pivot Tables, or even lists that your reports and analyses can use easily. This introduction will get you started.

    What the Heck is an Excel Database?

    Excel Strategies Charley Kyd -
    0
    You can raise your Excel productivity significantly and slash your Excel errors—if you keep your data in an Excel database. Microsoft, Oracle, IBM, and others...
    12Page 1 of 2

    Latest Articles

    A Lesson in Excel Analysis Learned from Rising US Inflation

    Excel Strategies Charley Kyd -
    0
    Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...
    Here's how you can split delimited text into an array with a short Excel formula, and then wrap the formula with the INDEX function to return any value from the array.

    How to Split and Index Delimited Text with Excel Formulas

    Blog Charley Kyd -
    0
    For the longest time I've wished that Microsoft would add a SPLIT function to Excel. The function would have a syntax like this... =SPLIT(text, delimiter,...
    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...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.