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

Data Analysis

  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How To Create Frequency Distribution in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Get column index in Excel Table
  • Filter Data Based on Date in Excel

References

  • How to use Excel LOOKUP Function
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • How to get address of first cell in range in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • How to reference named range different sheet in Excel

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation number multiple 100
  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • Excel Data validation with conditional list

Tag: Ribbon

Customize Ribbon In Excel

by

Excel Ribbon: Navigation, Customizing and Collapsing.  Navigate through Excel Ribbon Excel Ribbon are directly below File, Home, Insert, Page layout, Formulas, Data, Review and View tabs. Excel selects the ribbon’s Home tab when you open a workbook. You can checkout our previous post on Working with Excel ribbon. Customize Excel Ribbon The essence of customizing the ribbon is mainly …

Continue Reading

Excel Ribbon Quick Overview For Beginners

by

Ribbon in Excel Function Excel ribbon is a strip of buttons and icons located above the work area that was first introduced in Excel 2007 version. The ribbon replaces the menus and toolbars found in earlier versions of Excel. Working with and Understanding Excel Ribbon Above the ribbon are a number of tabs, such as …

Continue Reading

Add Developer Tab in Excel

by

Turn on the Developer tab in Excel if you want to create a macro, export and import XML files or insert controls. To turn on the Developer tab, execute the following steps. 1. Right click anywhere on the ribbon, and then click Customize the Ribbon. 2. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary). …

Continue Reading

Save file in 97-2003 Format

by

If you save your Excel files in 97-2003 format (.xls instead of the new .xlsx format), users who do not have Excel 2007 or later installed on their computer, can still open your Excel files. 1. Open a workbook. 2. On the File tab, click Save As. 3. Select Excel 97-2003 Workbook (*.xls) from the drop-down list. 4. Click Save. To …

Continue Reading

Customize Quick Access Toolbar in Excel

by

Quick Access Toolbar holds commands that a user uses frequently that is not in the ribbon. By default, the Quick Access Toolbar, located above the ribbon, contains the Save, Undo and Redo button. If you use an Excel command frequently, you can add it to the Quick Access Toolbar. You can even add commands to the Quick Access Toolbar …

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 function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel XOR Function
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Display Days until expiration date in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Series of dates by day
  • Two ways to sum time over 30 minutes in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • Map inputs to arbitrary values in Excel

General

  • Find Most Frequently Occurring Word in Excel Worksheet
  • How to create dynamic worksheet reference in Excel
  • Creating and Opening an existing file in Excel
  • Automatically fill series of cells in Excel using AutoFill
  • Delete Blank Rows at Once in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning