Sunday, October 25, 2020
Home Excel Methods

Excel Methods

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

    Most popular
    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...
    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...
    Spreadsheet users in businesses have distributed management dashboard reports for more than 30 years. Here's an example from the early days of spreadsheets.

    The First Spreadsheet Dashboard: Mini-Graph Reports in Lotus 1-2-3

    Charting Methods Charley Kyd -
    0
    This is the first dashboard report ever created with spreadsheets. I worked on this reporting technique in the early 1980s, then included this report...
    On Valentine's Day, 2018, tens of thousands of major sites warned their readers that inflation is rising. But that might not be true. These analytical Excel charts suggest a different conclusion.

    What Inflation? How Excel Charts Can Help You Avoid Fake Economic News

    Analytical Methods Charley Kyd -
    0
    The business news on Valentine's Day, 2018, was dominated by talk of rising inflation. A search of Google News showed 67,100 results for the...

    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...
    These example dashboards—prepared by an Excel-using employee—use charts and tables to show top-ten results for a medical device company.

    Weekly & Monthly Top-Ten Activity Reports

    Charting Methods Charley Kyd -
    0
    When one of my readers, Chris Helfrecht, sent the two sample Excel dashboards below, he wrote that he tried to follow my methods for...
    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...
    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...
    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...
    123...12Page 1 of 12

    Latest Articles

    If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the strategy that will make it happen.

    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...
    Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

    How to Be Significantly More Productive in Excel

    Training & Services Charley Kyd -
    0
    The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
    Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

    Learn How to Use Excel to Track the US Recovery from the Covid Recession

    Training & Services Charley Kyd -
    0
    The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.