exceluser.com Open in urlscan Pro
70.32.23.71  Public Scan

Form analysis
2 forms found in the DOM

GET https://exceluser.com/

<form method="get" class="td-search-form" action="https://exceluser.com/">
  <!-- close button -->
  <div class="td-search-close">
    <a href="#"><i class="td-icon-close-mobile"></i></a>
  </div>
  <div role="search" class="td-search-input">
    <span>Search</span>
    <input id="td-header-search-mob" type="text" value="" name="s" autocomplete="off">
  </div>
</form>

GET https://exceluser.com/

<form method="get" class="td-search-form" action="https://exceluser.com/">
  <div role="search" class="td-head-form-search-wrap">
    <input id="td-header-search" type="text" value="" name="s" autocomplete="off"><input class="wpb_button wpb_btn-inverse btn" type="submit" id="td-header-search-top" value="Search">
  </div>
</form>

Text Content

Sign in
 * Blog
 * All Posts
 * Business & Economics
   * Accounting & Finance
   * Analytical Charting
   * Analytical Methods
   * Business Statistics
   * Cash Flow
   * Data Management
   * Data Visualization
   * Economic Indicators
   * Financial Analysis
   * Forecasting & Simulation
   * Inflation & Deflation
   * Public Company Data
   * Reporting
   * Tests & Validations
   * Time Value of Money
 * Excel Methods
   * Charting Methods
   * Conditional Formatting
   * Data Management
   * Error Reduction
   * Excel Dashboards
   * Excel Tables
   * Excel’s Graphic Tools
   * Printing
   * Report Tables
   * Shortcuts
   * VBA
   * Worksheet Interaction
 * Formulas & Functions
   * Aggregation Functions
   * Array Formulas
   * Counting Functions
   * Date-Time Functions
   * Dates and Times
   * Dynamic Array Formulas
   * Financial Functions
   * Functions Explained
   * Logical Functions
   * Lookup Formulas and Functions
   * Math Functions
   * Range Names
   * Rounding Functions
   * Statistical Functions
   * Text Functions
 * Excel Strategies
   * Analytical Methods
   * Excel Productivity
   * Excel-Friendly OLAP
   * Visualization
 * Training & Solutions
 * Downloads

Sign in

Welcome!Log into your account

your username
your password
Forgot your password?
Password recovery
Recover your password

your email

Search

Friday, May 20, 2022
 * Sign in / Join

 * Contact


Sign in
Welcome! Log into your account

your username
your password
Forgot your password? Get help
Password recovery
Recover your password

your email
A password will be e-mailed to you.
 * Blog
 * All Posts
 * Business & Economics
   * AllAccounting & FinanceAnalytical ChartingAnalytical MethodsBusiness
     StatisticsCash FlowData ManagementData VisualizationEconomic
     IndicatorsFinancial AnalysisForecasting & SimulationInflation &
     DeflationPublic Company DataReportingTests & ValidationsTime Value of Money
     
     Aggregation Functions
     
     
     HOW TO SMOOTH DATA BY USING THE TREND FUNCTION
     
     
     Charting Methods
     
     
     CONSUMER SENTIMENT SUGGESTS A 2022 RECESSION
     
     
     Analytical Methods
     
     
     SIMPLE TRANSFORMATIONS CAN REVEAL HIDDEN PATTERNS IN YOUR DATA
     
     
     Blog
     
     
     HERE’S HOW INFLATION COULD AFFECT THE VALUE OF YOUR HOME
     
     
     
 * Excel Methods
   * AllCharting MethodsConditional FormattingData ManagementError
     ReductionExcel DashboardsExcel TablesExcel’s Graphic ToolsPrintingReport
     TablesShortcutsVBAWorksheet Interaction
     
     Aggregation Functions
     
     
     HOW TO SMOOTH DATA BY USING THE TREND FUNCTION
     
     
     Charting Methods
     
     
     CONSUMER SENTIMENT SUGGESTS A 2022 RECESSION
     
     
     Analytical Methods
     
     
     SIMPLE TRANSFORMATIONS CAN REVEAL HIDDEN PATTERNS IN YOUR DATA
     
     
     Blog
     
     
     AN EXCEL CHART OF A MAJOR U.S. SUPPLY CHAIN PROBLEM
     
     
     
 * Formulas & Functions
   * AllAggregation FunctionsArray FormulasCounting FunctionsDate-Time
     FunctionsDates and TimesDynamic Array FormulasFinancial FunctionsFunctions
     ExplainedLogical FunctionsLookup Formulas and FunctionsMath FunctionsRange
     NamesRounding FunctionsStatistical FunctionsText Functions
     
     Aggregation Functions
     
     
     HOW TO SMOOTH DATA BY USING THE TREND FUNCTION
     
     
     Blog
     
     
     HERE’S HOW INFLATION COULD AFFECT THE VALUE OF YOUR HOME
     
     
     Aggregation Functions
     
     
     HOW TO SMOOTH MONTHLY TRENDS WITH CENTERED MOVING AVERAGES
     
     
     Error Reduction
     
     
     HOW TO FOOT AND CROSS-FOOT EXCEL REPORTS IN A FLOATING-POINT WORLD
     
     
     
 * Excel Strategies
   * AllAnalytical MethodsExcel ProductivityExcel-Friendly OLAPVisualization
     
     Aggregation Functions
     
     
     HOW TO SMOOTH DATA BY USING THE TREND FUNCTION
     
     
     Charting Methods
     
     
     CONSUMER SENTIMENT SUGGESTS A 2022 RECESSION
     
     
     Analytical Methods
     
     
     SIMPLE TRANSFORMATIONS CAN REVEAL HIDDEN PATTERNS IN YOUR DATA
     
     
     Aggregation Functions
     
     
     HOW TO SMOOTH MONTHLY TRENDS WITH CENTERED MOVING AVERAGES
     
     
     
 * Training & Solutions
   * 
     Business & Economics
     
     
     INFLATION TRACKER EXCEL DASHBOARD WITH CONSUMER PRICES
     
     
     Training & Solutions
     
     
     MORTGAGE RATES EXCEL DASHBOARD
     
     
     Training & Solutions
     
     
     LEARN HOW TO USE EXCEL TO TRACK THE US RECOVERY FROM…
     
     
     Training & Solutions
     
     
     TRACK KEY ECONOMIC INDICATORS EVERY WEEKDAY WITH THIS EXCEL DASHBOARD
     
     
     
 * Downloads





EXCELUSER.COM



RECENT CONTENT


Aggregation Functions


HOW TO SMOOTH DATA BY USING THE TREND FUNCTION

Charley Kyd - January 17, 2022
0
Years ago, I read that Prof. William S. Cleveland had suggested that data could
be smoothed by calculating a centered trendline through adjacent data—a...


CONSUMER SENTIMENT SUGGESTS A 2022 RECESSION

December 17, 2021


SIMPLE TRANSFORMATIONS CAN REVEAL HIDDEN PATTERNS IN YOUR DATA

November 29, 2021


HERE’S HOW INFLATION COULD AFFECT THE VALUE OF YOUR HOME

November 5, 2021


AN EXCEL CHART OF A MAJOR U.S. SUPPLY CHAIN PROBLEM

October 23, 2021

FEATURED ARTICLES


SIMPLE TRANSFORMATIONS CAN REVEAL HIDDEN PATTERNS IN YOUR DATA

Analytical Methods Charley Kyd - November 29, 2021
0
Excel users have at least two significant advantages over business professionals
who rely on other analytical and reporting tools. First advantage: We Excel
users can...


INFLATION TRACKER EXCEL DASHBOARD WITH CONSUMER PRICES

Business & Economics Charley Kyd - September 13, 2021
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...


HOW TO REPORT TOP AND BOTTOM RESULTS USING DYNAMIC ARRAYS IN EXCEL

Array Formulas Charley Kyd - April 5, 2021
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...


HOW TO REPORT GL ACCOUNT GROUPS IN EXCEL

Accounting & Finance Charley Kyd - January 17, 2021
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...


HOW TO USE ARRAY FORMULAS TO REPORT GROUPS OF ACCOUNTS

Accounting & Finance Charley Kyd - December 29, 2020
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...

BLOG


Blog


HERE’S HOW INFLATION COULD AFFECT THE VALUE OF YOUR HOME

Charley Kyd - November 5, 2021
0
November 5, 2021 Inflation is rising in the U.S. And that made me wonder how a
higher rate of inflation could affect the price of...


AN EXCEL CHART OF A MAJOR U.S. SUPPLY CHAIN PROBLEM

October 23, 2021


A LESSON IN EXCEL ANALYSIS LEARNED FROM RISING US INFLATION

May 13, 2021


HOW TO SPLIT AND INDEX DELIMITED TEXT WITH EXCEL FORMULAS

May 5, 2021


WARREN BUFFETT, INFLATION, AND EXCEL

May 5, 2021

BUSINESS & ECONOMICS


Accounting & Finance


MAP COSTS AND SALES IN EXCEL WITH A CLASSIC BREAKEVEN CHART

Charley Kyd - February 17, 2020
0
When I worked as a CFO, my monthly reports always included a breakeven chart. It
was one of the most popular reports I produced. But...


HOW TO USE EXCEL FORMULAS TO CALCULATE A TERM-LOAN AMORTIZATION SCHEDULE

August 25, 2018


DO YOUR EXCEL REPORTS DOCUMENT PERFORMANCE? OR COMMUNICATE IT?

February 17, 2020


HOW FAST IS TOO FAST?

February 17, 2020


THE EXCEL-FRIENDLY DATABASE STRATEGY

August 27, 2018

FORMULAS & FUNCTIONS


Charting Methods


GOOD EXAMPLES OF BAD CHARTS: CHART JUNK FROM A SURPRISING SOURCE

Charley Kyd - February 17, 2020
0
For years, I’ve written that we Excel users should create “magazine-quality”
charts for our reports and analyses. However, we must be very careful of the...


TWO WAYS TO SET UP MULTI-CRITERIA LOOKUP FORMULAS IN EXCEL

February 17, 2020


DOCUMENT EXCEL WORKSHEETS WITH PICTURES THAT INCLUDE ROW AND COLUMN HEADINGS

February 17, 2020


HOW TO USE EXCEL SLICERS TO CONTROL SETTINGS IN YOUR REPORTS...

September 3, 2018


WARREN BUFFETT, INFLATION, AND EXCEL

May 5, 2021

EXCEL METHODS


Accounting & Finance


HOW TO USE SUMIFS WITH CRITERIA LISTS, SUMMARIZING SALES

Charley Kyd - August 29, 2018
0
With one exception, SUMIFS is a very powerful function. And it's very fast. To
understand the one exception, suppose you have a table of sales...


HOW TO USE EXCEL FORMULAS TO CALCULATE A TERM-LOAN AMORTIZATION SCHEDULE

August 25, 2018


COMPARE LOAN PAYMENT OPTIONS IN EXCEL

September 3, 2018


HOW TO USE EXCEL’S LET FUNCTION

February 14, 2021


EXCEL’S CLEAN FUNCTION IS MORE POWERFUL THAN YOU THINK

February 17, 2020

ALL CATEGORIES

 * Formulas & Functions60
 * Charting Methods57
 * Reporting52
 * Business & Economics34
 * Excel Methods33
 * Downloads22

POPULAR


HOW TO DELETE BLANK OR UNNEEDED ROWS, METHOD 1

Worksheet Interaction Charley Kyd - February 17, 2020
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...


WHY INDEX-MATCH IS FAR BETTER THAN VLOOKUP OR HLOOKUP IN EXCEL

Downloads Charley Kyd - August 25, 2018
0
(Download the workbook.) Excel’s VLOOKUP function is more popular than
the INDEX-MATCH function combination, probably because when Excel users need to
look up data then a "lookup" function...


AN INTRODUCTION TO EXCEL’S NORMAL DISTRIBUTION FUNCTIONS

Business Statistics Charley Kyd - August 20, 2018
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...



ABOUT US
ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.
Content, graphics, and HTML code are protected by US and International Copyright
Laws, and may not be copied, reprinted, published, translated, hosted, or
otherwise distributed by any means without explicit permission.
FOLLOW US
 * Contact
 * Terms of Use
 * Privacy Policy
 * Disclaimer
 * Earnings Policy
 * Reprints and Reposts

© ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights
reserved.
Edit with Live CSS


Save
Write CSS OR LESS and hit save. CTRL + SPACE for auto-complete.