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

Data Analysis

  • Use Data Form to input, edit and delete records in Excel
  • Excel Pie Chart
  • How To Create Pareto Chart in Excel
  • How To Create Frequency Distribution in Excel
  • Randomize/ Shuffle List in Excel

References

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Find closest match in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Extract all partial matches in Excel
  • How to get relative row numbers in a range in Excel

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation must not contain
  • Excel Data validation must begin with
  • Excel Data validation date in specific year
  • Excel Data validation don’t exceed total

Tag: SEARCHB function

SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation

by

What are SEARCH, SEARCHB functions in Excel? SEARCH, SEARCHB functions are TEXT functions in Microsoft Excel that locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. Syntax of SEARCH, SEARCHB functions SEARCH(find_text,within_text,[start_num]) SEARCHB(find_text,within_text,[start_num]) The SEARCH and …

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

  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function
  • Excel If, Nested If, And/Or Criteria Examples
  • Not Equal To ‘<>‘ operator in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of month in Excel
  • Convert decimal hours to Excel time
  • Calculate number of hours between two times in Excel
  • Get last working day in month in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • If cell contains one of many things in Excel
  • Map text to numbers in Excel
  • Group arbitrary text values in Excel
  • Group times into unequal buckets in Excel

General

  • How to password protect excel sheet?
  • How to fill cell ranges with random number from fixed set of options in Excel
  • How to generate random number weighted probability in Excel
  • How to get original price from percentage discount in Excel
  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning