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

Lookup and Reference Examples

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel FORMULATEXT function
  • Convert text string to valid reference in Excel using Indirect function
  • How to get last row in numeric data in Excel
  • Get nth match with INDEX / MATCH in Excel

Data Analysis Examples

  • Data Series in Excel
  • How to create Gauge Chart in Excel
  • How To Load Analysis ToolPak in Excel
  • How to Create Area Chart in Excel
  • Remove Duplicates Example in Excel

Data Validation Examples

  • Excel Data validation must begin with
  • Excel Data validation unique values only
  • Excel Data validation allow uppercase only
  • Excel Data validation require unique number
  • Prevent invalid data entering in specific cells

Tag: Format Cell

Sum race time splits in Excel

by

If you need to add up (sum) up race time splits that are some combination of hours, minutes, and seconds, you can simply use the SUM function. However, you must take care to enter times with the right syntax and use a suitable time format to display results, as explained below. Formula =SUM(range) Explanation The …

Continue Reading

Clean and reformat telephone numbers using SUBSTITUTE function in Excel

by

One way to clean up and reformat telephone numbers is to strip out all extraneous characters, then apply Excel’s built-in telephone number format. Formula =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE (SUBSTITUTE(SUBSTITUTE(A1,”(“,””), “)”,””),”-“,””),” “,””),”.”,””)+0 Note that the cell appears in the middle, with function names above and substitutions below. Not only does this make the formula easier to read, it also …

Continue Reading

How to create simple Time Sheet in Excel

by

This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. 1. To automatically calculate the next 4 days and dates when you enter a start date, use the formulas below. 2. Select the cells containing the times. 3. Right click, click Format Cells, and select the right …

Continue Reading

Convert Text to Numbers in Excel

by

By default, text is left-aligned and numbers are right-aligned in Excel. Atimes user enter inverted comma before inputting data values in a cell which automatically converts a number to text. This example teaches you how to convert ‘text strings that represent numbers’ to numbers. 1. Select the range A1:A4 and change the number format to General. 2. Numbers preceded by …

Continue Reading

Currency vs Accounting Format in Excel

by

The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference. 1. Enter the following values. 2. The Currency format places the dollar sign right next to the number. 3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values. Note: …

Continue Reading

Change Fractions Format in Excel

by

Excel always reduces fractions to its smallest denominator. This example teaches you how to enter a fraction in Excel and how change the format of a fraction. 1. To enter the mixed fraction 1 4/7 (one and four sevenths), type 1 4/7. To enter the fraction 4/7 (four sevenths) into cell A1, select cell A1 and type …

Continue Reading

Apply Previous Cell Styles Using Format Painter in Excel

by

The Format Painter is one of the most underused features of Excel. The Format Painter copies formatting from one place and applies it to another. 1. For example, select cell B2 below.  2. On the Home tab, in the Clipboard group, click Format Painter. A moving dashed border appears around cell B2 and the mouse pointer changes to …

Continue Reading

Convert Numbers to Text in Excel

by

By default, numbers are right-aligned and text is left-aligned in Excel. This example teaches you how to convert numbers to ‘text strings that represent numbers’. 1. Select the range A1:A4 and change the number format  to Text. 2. Precede a number by an apostrophe and it will also be treated as text. 3a. If you add text to a number and …

Continue Reading

Merge Cells in Excel

by

This page illustrates how to merge selected cells into one large cell. Why Merge Cells in Excel? This can be useful if you want to make clear that a label in Excel applies to multiple columns. Before you start: this feature only keeps the value in the upper-left cell and deletes all other values. Go here to concatenate (join) strings in Excel. …

Continue Reading

Strikethrough in Excel

by

Apply or remove strikethrough text formatting This example teaches you how to apply a strikethrough effect to text in Excel. In other words, learn how to draw a line through text in Excel. You can still read text with a strikethrough effect. 1. For example, select the range A2:A4. 2. Right click, and then click Format Cells (or press …

Continue Reading

Number Decimal Places in Excel

by

Learn how to show fewer decimal places in Excel without changing the number itself. You can also round a number. 1. Enter the value 2.175 into cell A1. 2. On the Home tab, in the Number group, click the Decrease Decimal button twice. Result: Note: if you look at the formula bar, you can see that cell A1 still contains the …

Continue Reading

Change Cell Styles in Excel

by

Quickly format a cell by choosing a cell style. Quickly format a range of cells by choosing a table style. You can also create your own cell style. 1. For example, select cell B2 below. 2. On the Home tab, in the Styles group, choose a cell style. Result. To create your own cell style, execute the …

Continue Reading

How to change Excel Workbook Themes

by

Excel workbooks come with free built in themes. The themes are used to change the look of your workbook with the click of a button. Each theme consists of 12 colors, two fonts (Headings and Body) and effects for shapes and SmartArt. Easy ways to format a worksheet 1. On the Page Layout tab, in the Themes group, …

Continue Reading

Wrap Text Automatically vs Manual Line Break in Excel

by

Wrap text in Excel if you want to display long text on multiple lines in a single cell. You can format the cell so the text wraps automatically, or enter a manual line break. Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically. Wrap Text …

Continue Reading

Superscript and Subscript in Excel

by

Superscript or Subscript generally is a number, figure, symbol, or indicator that is smaller than the normal line of type and is set slightly below it (subscript) or above it (superscript). It’s easy to format a character as superscript  or subscript in Excel. 1. For example, double click cell A1. 2. Select the value 2. 3. Right click, and then click Format …

Continue Reading

How To Create To Do List Using Fancy Check Mark in Excel

by

To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2 font. You can also create a check list that uses check boxes. 1. Select cell A1 and press SHIFT + P to insert a capital P. 2. On the Home tab, in the Font group, select the Wingdings 2 font. To insert …

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

Advanced Number Formats in Excel

by

Excel has many built-in formats. You can select standard number formats such as General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text on the home tab of the ribbon using the Number Format menu. If you cannot find the right format, you can create a custom number format. N/B: A custom number …

Continue Reading

Format Cells and Numbers in Excel

by

Format Cells simply refers to style; font, font colour, font size, borders and more while Format Numbers refer to data pattern, ie percentage, currency and more. Format Numbers We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc). 1. Enter the value 0.8 into cell B2. By default, Excel …

Continue Reading

Excel Custom Number Format with Leading Zeros, Add Text, Colors Example

by

Beyond the built-in options: custom formatting The Format Cells dialog offers so many options available “out-of-the-box.” The available format category and type options go far beyond the basics. But, if what is available still doesn’t meet your requirements, you can always create a custom format. Let’s consider a set of numbers. We start by opening the Format …

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
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • Two ways to Compare Text in Excel
  • How to create email address with name and domain in Excel
  • Extract most frequently occurring text in Excel
  • How to abbreviate names or words in Excel
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Excel Date & Time Functions Example
  • Get last weekday in month in Excel
  • How to calculate nth day of year in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • Example of Future value of annuity in Excel
  • How to calculate compound interest in Excel
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles