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

WE VALUE YOUR PRIVACY

We and our partners store and/or access information on a device, such as cookies
and process personal data, such as unique identifiers and standard information
sent by a device for personalised ads and content, ad and content measurement,
and audience insights, as well as to develop and improve products. With your
permission we and our partners may use precise geolocation data and
identification through device scanning. You may click to consent to our and our
787 partners’ processing as described above. Alternatively you may click to
refuse to consent or access more detailed information and change your
preferences before consenting. Please note that some processing of your personal
data may not require your consent, but you have a right to object to such
processing. Your preferences will apply to this website only. You can change
your preferences at any time by returning to this site or visit our privacy
policy.
MORE OPTIONSDISAGREEAGREE
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


BASIC FILTER EXAMPLE

In this example the goal is to return rows in the range B5:E15 that have a
specific state value in column E. To make the example dynamic, the state is a
variable entered in cell H4. When the state in H4 is changed, the formula should
return a new set of records. This is a perfect...Read more

Lookup


RANK AND SCORE WITH INDEX AND MATCH

Count


COUNT CELLS THAT BEGIN WITH

More Formulas


FEATURED VIDEOS

Excel Tables
3:44


HOW TO SET UP A RUNNING TOTAL IN A TABLE

Core Formula
3:30


HOW TO CALCULATE DUE DATES WITH WORKDAY

Core Formula
3:02


IF THIS OR THAT

Core Formula
3:07


HOW TO PICK NAMES OUT OF A HAT WITH EXCEL

More Videos


FEATURED FUNCTIONS

Dynamic array


TEXTAFTER FUNCTION

The Excel TEXTAFTER function extracts text that occurs after a given delimiter.
When multiple delimiters appear in the text, TEXTAFTER can return text that
occurs after the nth instance of the delimiter. TEXTAFTER can also extract text
after a specific delimiter when counting...Read more

Date and time


EDATE 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 work in IT support for a big law firm. Since I started with your lessons, the
amount of Excel requests in my daily work increased tremendously. I get so much
positive feedback and my colleague asked me the other day not to go on vacation
simultaneously with the head of the Excel-Team again.... Thank you very much for
your excellent work!
Carolin
excellent! just started my first pivot! I was scared to try initially but your
video is so simple and clear that it got me started! Thanks!
Heidi
I would like to thank you for putting the Exceljet website together. It's really
well done and has got me out of a few scrapes at work and college.
Graham
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
 * Donate


NEWSLETTER SIGN-UP

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