Excel Examples Excel Examples
Basics
Rows Columns Formulas Worksheets Ribbon Workbook Templates Format Cells Shortcuts Print Share Protect Find Flowcharts Formula Errors Round Range AutoFill Union and Intersect Skip Blanks Comments Lists Calculator Invoice
Functions
Text Array Formulas Count and Sum Lookup & Reference Date & Time Statistical Logical Cell References Financial Formula Errors Round Characters Count
VBA
Loop Userform String Manipulation Range Object Events Function Date and Time Macro Errors If Then Statement Array Worksheet Workbook ActiveX Controls MsgBox Variables Create a Macro Function and Sub Application Object
Data Analysis
Pivot Tables Analysis ToolPak Charts Filter What-If Analysis Sort Solver Conditional Formatting Tables
About

How to use no SUBSTRING function in Excel

2020-11-6
Functions Text
There’s no SUBSTRING function in Excel.

How to use Substitute vs Replace in Excel

2020-11-6
Functions Text
This example shows the difference between the SUBSTITUTE function and the REPLACE function.

How to use Sum Every nth Row in Excel

2020-11-6
Functions Array Formulas
This example shows you how to create an array formula that sums every nth row in Excel.

How to use Sum Largest Numbers in Excel

2020-11-6
Functions Array Formulas
This example shows you how to create an array formula that sums the largest numbers in a range.

How to use Sum Range with Errors in Excel

2020-11-6
Functions Array Formulas
This example shows you how to create an array formula that sums a range with errors.

How to use Sum with Or Criteria in Excel

2020-11-6
Functions Array Formulas
Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples.

How to use Switch function in Excel

2020-11-6
Functions Count and Sum
This example teaches you how to use the SWITCH function in Excel 2016 or later instead of the IFS function.

How to use System of Linear Equations in Excel

2020-11-6
Functions Array Formulas
This example shows you how to solve a system of linear equations in Excel.

How to use Tax Rates in Excel

2020-11-6
Functions Lookup & Reference
This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.

How to use Text Function in Excel

2020-11-6
Functions Text
When joining text and a number, use the TEXT function in Excel to format that number.

How to use Text to Columns in Excel

2020-11-6
Functions Text
To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.

How to use Time Difference in Excel

2020-11-6
Functions Date & Time
Calculating the difference between two times in Excel can be tricky.

How to use Time Sheet in Excel

2020-11-6
Functions
This example teaches you how to create a simple timesheet calculator in Excel.

How to use Today's Date in Excel

2020-11-6
Functions Date & Time
To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.

How to use Two-way Lookup in Excel

2020-11-6
Functions Lookup & Reference
This example teaches you how to lookup a value in a two-dimensional range.
  1. 1
  2. 2
  3. 3
  4. ...
  5. 26
  6. Next Page

Recent

  • How to use no SUBSTRING function in Excel
  • How to use Substitute vs Replace in Excel
  • How to use Sum Every nth Row in Excel
  • How to use Sum Largest Numbers in Excel
  • How to use Sum Range with Errors in Excel
  • How to use Sum with Or Criteria in Excel
  • How to use Switch function in Excel
  • How to use System of Linear Equations in Excel
  • How to use Tax Rates in Excel
  • How to use Text Function in Excel

Categories

  • How To (349)
  • Tips (20)
  • Tutorial (358)
Jquery Plugins Free  |  Books Awesome  |  Windows Awesome  |  Wordpress Themes   |  Boat Cup Holders
© 2021 Excel Examples