exceljet.net Open in urlscan Pro
2600:3c00::f03c:91ff:fee7:ea6e  Public Scan

Form analysis
5 forms found in the DOM

GET /search

<form class="search-form" action="/search" method="get" id="header-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

---

GET /search

<form class="search-form" action="/search" method="get" id="header-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

---

GET /search

<form class="search-form" action="/search" method="get" id="hero-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

---

POST https://sendy.exceljet.net/subscribe

<form id="newsletter_signup" class="newsletter-signup-form" action="https://sendy.exceljet.net/subscribe" method="POST" accept-charset="utf-8">
  <label for="email" hidden="">Email</label>
  <input type="email" name="email" placeholder="email address" id="email" class="newsletter-signup-email text-input" required="">
  <div style="display:none;">
    <label for="hp">HP</label>
    <input type="text" name="hp" id="hp">
  </div>
  <input type="hidden" name="SignupLocation" id="SignupLocation" value="block">
  <input type="hidden" name="list" value="T1JX0z264YewQdKf7gXIig">
  <input type="hidden" name="subform" value="yes">
  <input type="submit" name="submit" id="submit" class="newsletter-signup-submit form-submit" value="Subscribe">
</form>

---

POST https://sendy.exceljet.net/subscribe

<form id="newsletter_signup_footer" class="newsletter-signup-form newsletter-signup-footer-form" action="https://sendy.exceljet.net/subscribe" method="POST" accept-charset="utf-8">
  <label for="email" hidden="">Email</label>
  <input type="email" name="email" placeholder="email address" id="newsletter-signup-footer-email" class="newsletter-signup-footer-email newsletter-signup-email text-input" required="">
  <div style="display:none;">
    <label for="hp">HP</label>
    <input type="text" name="hp" id="newsletter-signup-footer-hp">
  </div>
  <input type="hidden" name="SignupLocation" id="newsletter-signup-footer-SignupLocation" value="footer">
  <input type="hidden" name="list" value="T1JX0z264YewQdKf7gXIig">
  <input type="hidden" name="subform" value="yes">
  <input type="submit" name="submit" id="newsletter-signup-footer-submit" class="newsletter-signup-footer-submit form-submit" value="Subscribe">
</form>

---

Text Content

Skip to main content
 * Login

Cart
Exceljet
 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles


Cart
 * Login

Main menu toggle
 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles

 * Login


LEARN EXCEL WITH CLEAR EXAMPLES AND BITE-SIZED VIDEOS.




FEATURED FORMULAS

Count


COUNT CELLS NOT BETWEEN TWO NUMBERS

The goal of this example is to count the number of values recorded over 5 days
that do not fall between two numbers, a low value, and a high value. In other
words, to count values that are "out of range". Note that each row, labeled A-G,
has its own low and high...Read more

Text


MAKE WORDS PLURAL

Count


COUNT CELLS THAT CONTAIN ERRORS

More Formulas


FEATURED VIDEOS

Conditional Formatting
3:10


HOW TO USE DATA BARS WITH CONDITIONAL FORMATTING

Dynamic Array Formulas
2:53


WHAT IS AN ARRAY FORMULA?

Core Charts
3:37


HOW TO CHART GENERATIONS WITH FLOATING BARS

Core Pivot
3:27


HOW TO ADD UNIQUE COUNT TO A PIVOT TABLE

More Videos


FEATURED FUNCTIONS

Date and time


WORKDAY FUNCTION

The WORKDAY function returns the nearest working day n days in the future or
past. WORKDAY can be used to calculate due dates, delivery dates, and other
dates that should exclude non-working days.

The WORKDAY function takes three arguments...Read more

Date and time


EOMONTH FUNCTION

Date and time


EDATE FUNCTION

More Functions


RECENT ARTICLES

Formulas


XLOOKUP VS INDEX AND MATCH

For many years, INDEX and MATCH have been the go-to solution for difficult
lookup problems in Excel. While more complicated to configure, the
two-function combination of INDEX + MATCH is flexible and powerful. But now
that...Read more

Formulas


XLOOKUP VS VLOOKUP

Formulas


WHY SUMPRODUCT?

Formulas


HOW TO CONCATENATE IN EXCEL

Formulas


WHAT IS AN ARRAY FORMULA?

More Articles


TOPICS BY CATEGORY


FORMULAS

 * Count
 * Sum
 * Average
 * Dynamic array
 * Min and Max
 * Lookup
 * If
 * Grouping
 * Conditional formatting
 * Data validation
 * Rank
 * Round
 * Date and Time
 * Date series
 * Text
 * Financial
 * Geometry
 * Workbook
 * Internet
 * Names
 * Percentage
 * Random
 * Range
 * Tables
 * Errors
 * Miscellaneous


SHORTCUTS

 * File
 * Ribbon
 * General
 * Tables and Filters
 * Drag and Drop
 * Navigation
 * Selection
 * Active Cell
 * Extend Selection
 * Select Special
 * Cell edit mode
 * Entering data
 * Formatting
 * Number Formatting
 * Borders
 * Formulas
 * Grid Operations
 * Pivot Tables
 * Workbook
 * Dialog boxes
 * Other


FUNCTIONS

 * Logical
 * Date and time
 * Lookup and reference
 * Text
 * Dynamic array
 * Engineering
 * Financial
 * Information
 * Math
 * Trigonometry
 * Statistical
 * Web
 * Database


USER TESTIMONIALS

I just want to say that I LOVE your website! It's put together very well and
easy to navigate. This is my "go-to" site for Excel help. Thank you so much
putting this together.
Scot
I really like these videos. They are short, simple, and to the point. Makes for
easy understanding.
Lee
This is the best Excel training site I have ever seen.
Kedy
More Testimonials


NEWSLETTER SIGN-UP

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.


CONQUER EXCEL

Email
HP


GET TRAINING


WE OFFER FREE RESOURCES AND PAID TRAINING.

Learn Excel with high quality video training. Our videos are quick, clean, and
to the point, so you can learn Excel in less time, and easily review key topics
when needed.

View Paid Training & Bundles

Just show me the free stuff


Exceljet
Quick, clean, and to the point


RESOURCES

 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles


ABOUT US

 * About
 * Testimonials
 * Topics
 * Contact


NEWSLETTER SIGN-UP

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
Email
HP
© 2012-2023 Exceljet. Terms of use
 * Visit our Twitter page