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

Tuesday, April 5, 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


Aggregation Functions


HOW TO SMOOTH MONTHLY TRENDS WITH CENTERED MOVING AVERAGES

Charley Kyd - October 18, 2021
0
I recently read an article in the Wall Street Journal about the expected
increase of electric vehicles in the US. That made me wonder...


HOW TO CREATE A ROLLING FORECAST OF SEASONAL SALES IN...

February 17, 2020


TWO BUSINESS USES FOR EXCEL’S NEW CHART FEATURE

August 28, 2018


THE FIRST SPREADSHEET DASHBOARD: MINI-GRAPH REPORTS IN LOTUS 1-2-3

February 17, 2020


DOCUMENT EXCEL WORKSHEETS WITH PICTURES THAT INCLUDE ROW AND COLUMN HEADINGS

February 17, 2020

FORMULAS & FUNCTIONS


Excel Methods


HOW TO STRUCTURE YOUR REPORT WORKBOOK

Charley Kyd - July 22, 2020
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 SET UP A SQUARE-FORMAT U.S. MAP IN EXCEL

August 7, 2021


HOW TO SET UP AN AUTOMATIC ERROR-CHECKING SYSTEM IN EXCEL REPORTS

February 9, 2021


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

February 17, 2020


HOW TO SET UP A PIVOT TABLE AS AN EXCEL-FRIENDLY DATABASE

August 29, 2018

EXCEL METHODS


Formulas & Functions


HOW TO USE EXCEL’S BETTER-KNOWN ROUNDING FUNCTIONS: INT, ROUNDUP, ROUNDDOWN,...

Charley Kyd - February 17, 2020
0
Excel has one way to round up or down from the first generation. In recent
generations it has also offered a second method. And...


THE SUMPRODUCT FUNCTION’S UNDOCUMENTED METHOD

February 17, 2020


USE EXCEL’S INDEX-MATCH OR VLOOKUP FUNCTIONS TO POPULATE INVOICES AND POS

August 25, 2018


AN INTRODUCTION TO EXCEL’S NORMAL DISTRIBUTION FUNCTIONS

August 20, 2018


HOW TO USE ARRAY FORMULAS TO REPORT GROUPS OF ACCOUNTS

December 29, 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.