Name Box
The Name Box in Excel is placed on the left side of the formula bar. Learn how to use names in your Workbook!
Formulas
Excel Formulas and Examples – This section gives easy-to-understand help for the most used formulas. String manipulation functions play an important role in Excel. Discover how to replace the regular LEN, LEFT, RIGHT, MID, and SUBSTITUTE functions and use stunning user-defined functions! Learn more about XLOOKUP!
Click on the below sections to get started!
Formula Bar
Learn all about the Excel Formula Bar. Look at how to use, expand, show, and hide quickly through examples.
Structured reference
Excel structured reference is a syntax that applies table names in easy-to-read formulas instead of regular cell references.
Subtraction Formula in Excel
The tutorial shows how to use the subtraction formula in Excel. Learn how to subtract numbers, percentages, dates, and times easily.
Fix Excel found a problem with formula references in this Worksheet
Learn how to fix issues in Excel when one or more formula references in the worksheet cause errors during saving, modifying, or opening.
Absolute Reference
An absolute reference in Excel is a powerful tool that locks your formula to a specific cell or range of cells.
How to Add Leading Zeros in Excel
To add leading zeros in Excel, you can use the RIGHT or ZFILL function, which keeps the zeros before the numeric values.
Remove Special Characters in Excel
Today’s tutorial will explain how to remove special characters in Excel using the most efficient functions and formulas.
Count cells based on color
You can count cells based on color using a custom formula in Excel. In the example, we’ll show you how to do that!
Percentile Rank Formula
Learn how to use the percentile rank formula to classify data based on criteria.