Excel Examples
CategoriesTagsAbout
  • How to use no SUBSTRING function in Excel

    Nov 06, 2020

    There's no SUBSTRING function in Excel.

    #Tutorial#How To#Functions#Text

  • How to use Substitute vs Replace in Excel

    Nov 06, 2020

    This example shows the difference between the SUBSTITUTE function and the REPLACE function.

    #Tutorial#How To#Functions#Text

  • How to use Sum Every nth Row in Excel

    Nov 06, 2020

    This example shows you how to create an array formula that sums every nth row in Excel.

    #Tutorial#How To#Functions#Array Formulas

  • How to use Sum Largest Numbers in Excel

    Nov 06, 2020

    This example shows you how to create an array formula that sums the largest numbers in a range.

    #Tutorial#How To#Functions#Array Formulas

  • How to use Sum Range with Errors in Excel

    Nov 06, 2020

    This example shows you how to create an array formula that sums a range with errors.

    #Tutorial#How To#Functions#Array Formulas

  • How to use Sum with Or Criteria in Excel

    Nov 06, 2020

    Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples.

    #Tutorial#How To#Functions#Array Formulas

  • How to use Switch function in Excel

    Nov 06, 2020

    This example teaches you how to use the SWITCH function in Excel 2016 or later instead of the IFS function.

    #Tutorial#How To#Functions#Count and Sum

  • How to use System of Linear Equations in Excel

    Nov 06, 2020

    This example shows you how to solve a system of linear equations in Excel.

    #Tutorial#How To#Functions#Array Formulas

  • How to use Tax Rates in Excel

    Nov 06, 2020

    This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.

    #Tutorial#How To#Functions#Lookup & Reference

  • How to use Text Function in Excel

    Nov 06, 2020

    When joining text and a number, use the TEXT function in Excel to format that number.

    #Tutorial#How To#Functions#Text

  • 1
  • 2
  • 3
  • 4
  • 5
  • »

©2020 Excel Examples.