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

Data Analysis

  • Conditional Formatting Color Scales Examples in Excel
  • How to Create Area Chart in Excel
  • Subtotal function in Excel
  • Example of COUNTIFS with variable table column in Excel
  • How To Sort One Column or Multiple Columns in Excel

References

  • How to use Excel MATCH Function
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Merge tables with VLOOKUP in Excel
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation exists in list
  • Excel Data validation must not contain
  • Excel Data validation with conditional list
  • Excel Data validation must contain specific text

Tag: MUNIT function

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

by

What is MUNIT function in Excel? MUNIT function is one of the Math and Trig functions in Microsoft Excel that returns the unit matrix for the specified dimension. Syntax of MUNIT function MUNIT(dimension) The MUNIT function syntax has the following arguments. Dimension: Dimension is an integer specifying the dimension of the unit matrix that you want …

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 Excel TRUE Function
  • How to use IFS function in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • Invoice status with nested if in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • Get project end date in Excel
  • Count birthdays by month in Excel
  • Calculate time difference in hours as decimal value in Excel
  • Get project midpoint in Excel
  • Count day of week between dates in Excel

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Map text to numbers in Excel
  • Group arbitrary text values in Excel
  • Group times into unequal buckets in Excel

General

  • How to calculate percent sold in Excel
  • How to test a range for numbers in Excel
  • How to Create Calendar in Excel
  • How to get original price from percentage discount in Excel
  • How to calculate percent of students absent in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning