Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Count rows with at least n matching values
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Convert text string to valid reference in Excel using Indirect function
  • How to use Excel MATCH Function
  • Count unique text values with criteria

Data Analysis Examples

  • Conditional Formatting Rules in Excel
  • How to create dynamic reference table name in Excel
  • How to count table columns in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How to add Trendline to a chart in Excel

Data Validation Examples

  • How To Create Drop-down List in Excel
  • Excel Data validation exists in list
  • Excel Data validation don’t exceed total
  • Excel Data validation must begin with
  • Excel Data validation no punctuation

Tag: UNICODE function

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

by

What is UNICODE function in Excel? UNICODE function is one of TEXT functions in Microsoft Office Excel that returns the number (code point) corresponding to the first character of the text. Syntax of UNICODE function UNICODE(text) The UNICODE function syntax has the following arguments. Text: Text is the character for which you want the Unicode value. …

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
  • CHAR function: Description, Usage, Syntax, Examples and Explanation
  • Extract most frequently occurring text in Excel
  • Split numbers from units of measure in Excel
  • DOLLAR function: Description, Usage, Syntax, Examples and Explanation
  • Get first name from full name — Manipulating NAMES in Excel
  • Get work hours between dates in Excel
  • Get days, months, and years between dates in Excel
  • Find Last Day of the Month in Excel
  • Convert time to time zone in Excel
  • How to calculate nth day of year in Excel
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate principal for given period in Excel
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles