Newest blog posts about Excel

­
  • iserror-iferror-spreadsheeto

How to use ISERROR and IFERROR to solve your problems

How to use ISERROR and IFERROR When working in Excel, sometimes we will experience errors. In this tutorial, we will look at how to use ‘IFERROR’ and ‘ISERROR’ in Excel in order to deal with these errors constructively. All of the following examples will be performed using Excel 2016 for Windows. Table [...]

  • how-to-copy-and-paste-in-excel-spreadsheeto

How to Copy and Paste in Excel

How to Copy and Paste in Excel When we think of copy and paste in a general sense, we usually don’t consider any other needs than transferring a string value from source to destination. But there's so much more to it! We're going to show you the most powerful (and easiest) ways of copying [...]

  • wildcards-in-excel-spreadsheeto

The 3 Best Wildcards in Excel: Asteriks, Question Mark + Tilde

The 3 Best Wildcards in Excel: Asteriks (*), Question Mark (?), and Tilde (~) In this tutorial, you'll learn about the awesome wildcard characters in Excel. But, what exactly are "wildcards"? Wildcards are extremely helpful when you need to find results that are less than exact. As you'll see a bit later in this [...]

  • 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 [...]