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

Dynamic array


LIST UPCOMING BIRTHDAYS

In this example, the goal is to list the next n upcoming birthdays from a larger
set of 25 birthdays based on the current date. The set of birthdays are in an
Excel Table named data in the range B5:C29. In the example shown, we are using 7
for...Read more

Count


COUNT CELLS THAT CONTAIN N CHARACTERS

Count


COUNT CELLS THAT CONTAIN ERRORS

More Formulas


FEATURED VIDEOS

Core Pivot
3:14


HOW TO ADD SLICERS TO A PIVOT TABLE

Core Formula
2:56


WHY VLOOKUP IS BETTER THAN NESTED IFS

Excel Tables
3:44


HOW TO SET UP A RUNNING TOTAL IN A TABLE

Core Charts
3:22


HOW TO BUILD A COLUMN CHART

More Videos


FEATURED FUNCTIONS

Date and time


NETWORKDAYS FUNCTION

The NETWORKDAYS function returns the number of working days between two dates,
automatically excluding weekends (Saturday and Sunday) and optionally
excluding holidays provided as a list of dates. NETWORKDAYS can be used to
calculate employee benefits that accrue...Read more

Date and time


WORKDAY FUNCTION

Text


SEARCH 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 really appreciate your web site as there is an enormous amount of hit & miss
on a Google search. Most all of those hits are targeted at basic Excel formula
syntax. As a software developer, I relish robust examples much more than
paragraphs of text explanation. Your site is the best one I have found that
combines both.
Nelson
Dave and Lisa, can't imagine enough how much effort you take to give us these
free tips online. Really wonderful thought of yours to help people like me for
quick tips.
Durga
LOVE your site... wow... you have helped me quickly do a lot of things that
would have taken me forever to figure out on my own. And I love that your search
feature actually knows what I'm looking for... lol
Morgan
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