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

Lookup and Reference Examples

  • How to get last row in mixed data with blanks in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Extract all partial matches in Excel
  • Perform case-sensitive Lookup in Excel
  • How to get relative row numbers in a range in Excel

Data Analysis Examples

  • How To Insert and Customize Sparklines in Excel
  • Excel Pie Chart
  • How to create dynamic reference table name in Excel
  • How to create running total in an Excel Table
  • How to sum a total in multiple Excel tables

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation date in specific year
  • Excel Data validation date in next 30 days
  • How To Create Drop-down List in Excel
  • Excel Data validation must begin with

Tag: INFO function

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

by

What is INFO function in Excel? INFO function is one of the Information functions in Microsoft Excel that returns information about the current operating environment. Syntax of INFO function INFO(type_text) The INFO function syntax has the following arguments: Type_text: Text that specifies what type of information you want returned. Type_text Returns “directory” Path of the current …

Continue Reading

Add line break based on OS in Excel

by

To add a line break taking into account the current OS (Mac or Windows), you can use the INFO function to test the system and then return the correct break character — CHAR(10) for Windows, CHAR(13) for Mac. Note: make sure you have text wrap enabled on cells that contain line breaks. Formula =IF(INFO(“system”)=”mac”,CHAR(13),CHAR(10)) Explanation The character …

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
  • How to count specific words in a cell in Excel
  • How to extract domain from email address in Excel
  • Remove last characters from right in a cell in Excel
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • RIGHT, RIGHTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to get same date next year or previous year in Excel
  • How to calculate nth day of year in Excel
  • Get project end date in Excel
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Add days to date in Excel
  • How to calculate present value of annuity in excel
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate periods for annuity in Excel
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles