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

Data Analysis

  • Working With Tables in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Use Data Form to input, edit and delete records in Excel
  • How to calculate current stock or inventory in Excel
  • How to calculate average last N values in a table in Excel

References

  • Extract all partial matches in Excel
  • Last row number in range
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel VLOOKUP Function
  • How to get first column number in range in Excel

Data Validations

  • Excel Data validation specific characters only
  • Excel Data validation with conditional list
  • Excel Data validation number multiple 100
  • Excel Data validation must begin with
  • Excel Data validation unique values only

Tag: Custom Number Format

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 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

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

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

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

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

Add Leading Zeros, Text And Colours Custom Number Format

by

Excel Custom Number Format with Leading Zeros, Add Text, Colours Example How to add a leading zero in excel Beyond the built-in options: 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 …

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
  • How to use Excel TRUE Function
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get work hours between dates custom schedule in Excel
  • Convert Unix time stamp to Excel date
  • Convert Excel time to Unix time in Excel
  • Get last working day in month in Excel
  • How to determine year is a leap year in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • If cell contains one of many things in Excel
  • Running count group by n size in Excel
  • Categorize text with keywords in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Currency vs Accounting Format in Excel
  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
  • How to calculate percentage discount in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • Check if multiple cells have same value in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning