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

Data Analysis

  • How to Create Gantt Chart in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Understanding Anova in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How to add Trendline to a chart in Excel

References

  • Multi-criteria lookup and transpose in Excel
  • Merge tables with VLOOKUP in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Two-column Lookup in Excel
  • How to get last column number in range in Excel

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation specific characters only
  • Excel Data validation whole percentage only
  • Excel Data validation exists in list
  • Data validation must not exist in list

Category: Others

Excel Tutorials for beginners, Intermediates and experts.

Mark Workbook as Final in Excel

by

To help prevent changes to a final version of an excel file, you Mark a workbook as final. Only use this feature to discourage editing. Users can still edit the workbook. Here are steps to Mark a workbook as final below: 1. Open a workbook. 2. On the File tab, click Info. 3. Click Protect Workbook, Mark as …

Continue Reading

Split Cell Content Using Text to Columns in Excel

by

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full names into last and first names. 1. Select the range with full names. 2. On the Data tab, in the Data Tools group, click Text to Columns. …

Continue Reading

How to Delete Cells, Row and Rows in Excel

by

To quickly delete a row in Excel, select a row and use the shortcut key CTRL – (minus sign). To quickly delete multiple rows, select multiple rows and use the same shortcut. Delete Row To delete a row in Excel, execute the following steps. 1. Select a row. 2. Right click, and then click Delete. Result: Note: …

Continue Reading

How to Insert Cells, Row and Rows in Excel

by

To quickly insert a row in Excel, select a row and use the shortcut keys CTRL SHIFT +. To quickly insert multiple rows, select multiple rows and use the same shortcut. Insert Row To insert a row in Excel, execute the following steps. 1. Select a row. 2. Right click, and then click Insert. Result: Note: instead of …

Continue Reading

Spell Check in Excel

by

Learn how to check the spelling of text in Excel. You can also add words to your custom dictionary or AutoCorrect list. 1. Open a worksheet with some spelling errors. 2. On the Review tab, in the Proofing group, click Spelling. 3. Select a suggestion and click Change to correct the misspelling in cell A2. 4. Click Change …

Continue Reading

Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’

by

Formula auditing in Excel allows you find and correct errors in formulas. Also, displays the relationship between formulas and cells using Trace Precedents, Remove Arrows, Trace Dependents, Show Formulas, Error Checking and Evaluate Formula. The example below helps you master Formula Auditing quickly and easily. Trace Precedents You have to pay $96.00. To show arrows that indicate which cells are used …

Continue Reading

Find Most Frequently Occurring Word in Excel Worksheet

by

Example of how to find the most frequently occurring word in an Excel Worksheet. You can use the MODE function to find the most frequently occurring number. However, the MODE function only works with numbers. You can use the COUNTIF function to count the number of occurrences of each word. However, we are looking for a single formula that returns the most …

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

Delete Blank Rows at Once in Excel

by

When you have empty rows cluttering your spreadsheet and you need to tighten it up, easy and fast? Removing blank rows is the first thing you should do! This example teaches you how to delete blank rows or rows that contain blank cells. 1. On the Home tab, in the Editing group, click Find & Select. 2. …

Continue Reading

Freeze and Unfreeze Panes in Excel

by

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet. Freeze Top Row To freeze the top row, execute the following steps. 1. On the View tab, in the Window group, click …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3

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 with boolean logic in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel OR Function
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel

Date Time

  • Add decimal hours to time in Excel
  • Add days exclude certain days of week in Excel
  • Get last weekday in month in Excel
  • Convert text to date in Excel
  • How to calculate workdays per month in Excel

Grouping

  • Categorize text with keywords in Excel
  • How to randomly assign people to groups in Excel
  • Group numbers at uneven intervals in Excel
  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel

General

  • How to test a range for numbers in Excel
  • Mark Workbook as Final in Excel
  • How to calculate total from percentage in Excel
  • Excel Default Templates
  • Count cells that do not contain many strings in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning