Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to calculate average last N values in a table in Excel
  • Conditional Formatting Rules in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Get column index in Excel Table
  • How To Insert and Customize Sparklines in Excel

References

  • Multi-criteria lookup and transpose in Excel
  • How to get last row in numeric data in Excel
  • To count total rows in a range in Excel
  • How to get address of last cell in range in Excel
  • Last row number in range

Data Validations

  • Excel Data validation don’t exceed total
  • Data validation must not exist in list
  • Excel Data validation date in next 30 days
  • Excel Data validation number multiple 100
  • Prevent invalid data entering in specific cells

Tag: ISEVEN function

Highlight every other row in Excel

by

This tutorial shows how to Highlight every other row in Excel using the example below; Formula =ISEVEN(ROW()) Explanation If you want to highlight every other row in a table (sometimes called zebra striping) with conditional formatting you can do so with a simple formula that uses either the ISEVEN or ISODD function. For example, if …

Continue Reading

Shade alternating groups of n rows in Excel

by

This tutorial shows how to Shade alternating groups of n rows in Excel using the example below; Formula =ISEVEN(CEILING(ROW()-offset,n)/n) Explanation To highlight rows in groups of “n” (i.e. shade every 3 rows, every 5 rows, etc.) you can apply conditional formatting with a formula based on the ROW, CEILING and ISEVEN functions. In the example …

Continue Reading

ISEVEN function: Description, Usage, Syntax, Examples and Explanation

by

What is ISEVEN function in Excel? ISEVEN function is one of the Information functions in Microsoft Excel that returns TRUE if number is even, or FALSE if number is odd. Syntax of ISEVEN function ISEVEN(number) The ISEVEN function syntax has the following arguments: Number: The value to test. If number is not an integer, it is truncated. …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use IFS function in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • Calculate series of dates by workdays in Excel
  • Get day from date in Excel
  • Get fiscal quarter from date in Excel
  • Add workdays no weekends in Excel
  • Get age from birthday in Excel

Grouping

  • If cell contains one of many things in Excel
  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into unequal buckets in Excel
  • Group times into 3 hour buckets in Excel

General

  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to generate random number weighted probability in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Count cells that contain errors in Excel
  • How to calculate percentage discount in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning