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

Data Analysis

  • How to Sort by Color in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • Add Outline to Data in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • Understanding Anova in Excel

References

  • Basic INDEX MATCH approximate in Excel
  • How to use Excel COLUMN Function
  • To count total rows in a range in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to get relative row numbers in a range in Excel

Data Validations

  • Excel Data validation only dates between
  • Excel Data validation specific characters only
  • Excel Data validation exists in list
  • Excel Data validation no punctuation
  • Data validation must not exist in list

Tag: ISTEXT function

Count cells that contain text in Excel

by

This tutorial shows how to Count cells that contain text in Excel using the example below; Formula =COUNTIF(range,”*”) Explanation To count the number of cells that contain text (i.e. not numbers, not errors, not blank), use the COUNTIF function and a wildcard. “*” is a wildcard matching any number of characters. Do you want to count …

Continue Reading

IS functions: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT

by

What is IS function in Excel? IS functions, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT are under the Information functions in Microsoft Excel. Each of these functions, referred to collectively as the IS functions, checks the specified value and returns TRUE or FALSE depending on the outcome. For example, the ISBLANK function returns the logical value TRUE if the …

Continue Reading

Excel Data validation allow text only

by

This tutorial shows how to create Data validation to allow text only in Excel using the example below; Formula =ISTEXT(A1) Explanation To allow only text in a cell, you can use data validation with a custom formula based on the ISTEXT function. In the example shown, the data validation applied to C5:C9 is: =ISTEXT(C5) How this …

Continue Reading

Excel Data validation allow uppercase only

by

Using the example below, this tutorial shows how to create Excel Data validation to allow uppercase only. Formula =AND(EXACT(A1,UPPER(A1)),ISTEXT(A1)) Explanation To allow a user to enter only uppercase TEXT,  you can use data validation with a custom formula based on the UPPER, EXACT, and AND functions. In the example shown, the data validation applied to C5:C7 is: …

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

  • Check multiple cells are equal in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function
  • How to use Excel OR Function
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate nth day of week in month in Excel
  • Get month from date in Excel
  • Get days between dates ignoring years in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • How to randomly assign people to groups in Excel
  • Map text to numbers in Excel
  • Running count group by n size in Excel
  • Group times into 3 hour buckets in Excel

General

  • Convert column letter to number in Excel
  • How to set or clear a print area in Excel Worksheet
  • Lock Cells in a Worksheet Excel
  • Spell Check in Excel
  • How to calculate project complete percentage in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning