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

Data Analysis

  • Filter Data Based on Date in Excel
  • How To Filter Data in Excel
  • Conditional Formatting Rules in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Everything about Charts in Excel

References

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel OFFSET function
  • To count total rows in a range in Excel
  • Get nth match with INDEX / MATCH in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Validations

  • Excel Data validation allow weekday only
  • Data validation must not exist in list
  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • How To Create Drop-down List in Excel

Tag: Sparklines

How To Insert and Customize Sparklines in Excel

by

Sparklines in Excel are graphs that fit in one cell and give you information about the data. Insert Sparklines To insert sparklines, execute the following steps. 1. Select the cells where you want the sparklines to appear. In this example, we select the range G2:G4.   2. On the Insert tab, in the Sparklines group, click Line. 3. …

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

  • OR function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • Check multiple cells are equal in Excel
  • How to use IFS function in Excel
  • How to use Excel AND Function

Date Time

  • Get work hours between dates in Excel
  • How to get workdays between dates in Excel
  • Display the current date in Excel
  • Count day of week between dates in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into unequal buckets in Excel

General

  • How to fill cell ranges with random text values in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Count cells less than in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • How to make excel worksheets print on one page?
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning