Newest blog posts about Excel

­
  • Excel IF featured image

Let’s take a look at IF, Nested IF and IFS

Let's take a look at IF, Nested IF and IFS One of the most commonly used functions in Excel is the ‘IF’ function. Its usefulness and application are quite broad due to its simplicity. It is a logical function that basically allows the user to specify results based on whether or not a specific [...]

  • Zapier and Excel

Excel and Zapier sitting in a tree

Excel and Zapier sitting in a tree... A few weeks ago, we were contacted by Jose Proenca, who wrote us the following: I figured you'd be interested in a new release we're super excited about. Zapier is one of the first to make use of Excel Online's new API, meaning users of the spreadsheet [...]

  • SUMIF SUMIFS featured image

How to Use the Excel Functions SUMIF and SUMIFS (tutorial)

How to Use the Excel Functions: SUMIF and SUMIFS (tutorial) In this article, we take a look at the ‘SUMIF’ and ‘SUMIFS’ functions in Excel. Both are quite useful in allowing us to sum data based on related criteria within the same data set. To differentiate, the SUMIF function allows for imposing some single criteria [...]

  • MAXIFS and MINIFS (Spreadsheeto)

How To Use MAXIFS and MINIFS To Find Maximum/Minimum Values Specified By Certain Criteria

How to Use Excel's New Functions: MAXIFS and MINIFS Find Maximum/Minimum Values Specified By Certain Criteria Microsoft recently released 2 new functions, ‘MAXIFS’ and ‘MINIFS’, that will forever change the way you find minimum and maximum values in a range of cells (based on specific criteria). The way it used to be: If we [...]

  • TEXTJOIN Featured Image

TEXTJOIN: Combining Strings Of Data In An Instant

TEXTJOIN: Combining Strings Of Data In An Instant With the release of Excel 2016 (as well as Excel Online, Mobile and Android versions), Microsoft has added six new functions to the line up. One of those brand-new functions is: ‘TEXTJOIN’. Up until now, if we wanted to join text strings from a range of [...]

  • Excel Function INDEX

The Excel Function INDEX Explained (+Free Exercise File)

The Excel Function INDEX Explained Microsoft Excel offers some very powerful functions for finding values within a data set based on some specified criteria. Often times, looking for specific data in smaller data sets is a simple task that we can perform visually without the need for a function. However, this becomes less feasible [...]

  • excel match function

How to Use The Excel Function MATCH for Excel 2016

How to Use The Excel Function MATCH for Excel 2016 If you have ever needed the position of an item in a range rather than the actual item itself, you could use the ‘MATCH’ function. This can be very useful, for instance, when you need the ‘row_num’ parameter for the ‘INDEX’ function. ‘MATCH’ is [...]

  • RIGHT, LEFT, MID, LEN (Spreadsheeto)

The Text Functions: LEFT, RIGHT and MID (also LEN!)

The Excel Text Functions: LEFT, RIGHT and MID (also LEN!) Have you ever needed to pull just the first several digits or characters from a string in a particular cell? Maybe you needed just the last 4 characters in a column of cells.  Maybe you needed neither, but rather the characters or digits right [...]

  • VLOOKUP Featured Blog Image

The Last Guide to VLOOKUP You’ll Ever Need

VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.

  • Drop Down Featured Blog Image

The 1 Minute Drop-Down: How To Easily Create A Drop-Down List in 60 seconds (or less)

The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.