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

Data Analysis

  • Everything about Charts in Excel
  • Filter Data Based on Date in Excel
  • How to count table rows in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS

References

  • Basic INDEX MATCH approximate in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get address of named range in Excel
  • How to create dynamic named range with OFFSET in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation no punctuation
  • Excel Data validation with conditional list
  • Excel Data validation must contain specific text
  • Excel Data validation specific characters only

Tag: Find & Select

Advanced Find Features in Excel

by

This chapter teaches how to incorporate special characters with find option. A question mark (?) matches exactly one character. For example, F?rrari will find Ferrari, Forrari, Farrari, etc. An asterisk (*) matches a series of zero or more characters. For example, F*rrari will find Ferrari, Foorrari, Faaaaaarrari, etc. To access some more advanced find features in Excel, execute the …

Continue Reading

Delete Blank Rows at Once in Excel

by

When you have empty rows cluttering your spreadsheet and you need to tighten it up, easy and fast? Removing blank rows is the first thing you should do! This example teaches you how to delete blank rows or rows that contain blank cells. 1. On the Home tab, in the Editing group, click Find & Select. 2. …

Continue Reading

Quickly Highlight Cells Containing Different Content in a Row

by

This example teaches you how to quickly highlight cells whose contents are different from the comparison cell in each row. 1. To select the range A1:C15, click on cell A1 and drag it to cell C15. Note: because we selected the range A1:C15 by clicking on cell A1 first, cell A1 is the active cell …

Continue Reading

How to Copy Visible Cells Only in Excel

by

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this example, row 2 is hidden. When you copy/paste this range, this is the result: To copy visible cells only, execute the following easy steps. 1. Select the range A1:A4. 2. On the Home tab, in the Editing group, …

Continue Reading

Find, Select, Replace and Go To Special in Excel

by

Detailed steps on how to use Excel Find, Select, Replace & Go To Features You can use Excel’s Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel’s Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. Find To quickly find …

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

  • IF with boolean logic in Excel
  • How to use Excel NOT Function
  • SWITCH function example in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to return blank in place of #DIV/0! error in Excel

Date Time

  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate most recent day of week in Excel
  • Add workdays to date custom weekends in Excel
  • Get week number from date in Excel
  • Basic timesheet formula with breaks in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into unequal buckets in Excel
  • Calculate conditional mode with criteria in Excel
  • How to randomly assign people to groups in Excel

General

  • How to make excel worksheets print on one page?
  • Basic numeric sort formula in Excel
  • How to Insert Cells, Row and Rows in Excel
  • How to generate random number between two numbers in Excel
  • Check if multiple cells have same value in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning