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

Lookup and Reference Examples

  • Count unique text values with criteria
  • Multi-criteria lookup and transpose in Excel
  • How to get address of first cell in range in Excel
  • Extract data with helper column in Excel
  • Last row number in range

Data Analysis Examples

  • How to create Checklist in Excel
  • How To Load Analysis ToolPak in Excel
  • How to create dynamic reference table name in Excel
  • Data Series in Excel
  • How To Create Frequency Distribution in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation specific characters only
  • Excel Data validation allow uppercase only
  • Excel Data validation number multiple 100
  • Excel Data validation no punctuation

Tag: Links

How to work on another Workbook in Excel — External References

by

This chapter shows how to Create External Reference, Alert , Edit Links in Excel. An external reference in Excel is a reference to a cell or range of cells in another workbook. Below you can find the workbooks of three divisions (North, Mid and South). Create External Reference To create an external reference, execute the following steps. 1. Open all workbooks. 2. In …

Continue Reading

Excel Hyperlinks

by

How to link to an existing file or web page, or link to the same work book in Excel. To create a hyperlink in Excel, execute the following steps. 1. On the Insert tab, in the Links group, click Hyperlink. The ‘Insert Hyperlink’ dialog box appears. Existing File or Web Page To create a link to an existing file or …

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
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • SUBSTITUTE function vs REPLACE function in Excel
  • How to convert numbers to text using TEXT function in Excel
  • How to extract domain name from URL in Excel
  • How to compare two text strings in Excel
  • Get first Monday before any date in Excel
  • Get first day of month in Excel
  • Assign points based on late time in Excel
  • How to get same date next year or previous year in Excel
  • Convert decimal hours to Excel time
  • ACCRINTM function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate simple interest in Excel
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles