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

Data Analysis

  • How To Compare Two Lists in Excel
  • Example of COUNTIFS with variable table column in Excel
  • How to add Trendline to a chart in Excel
  • Move chart to a separate worksheet in Excel
  • Conditional Formatting Color Scales Examples in Excel

References

  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Count unique text values with criteria
  • Create hyperlink with VLOOKUP in Excel
  • Offset in Excel
  • How to get last row in mixed data with blanks in Excel

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation require unique number
  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel
  • Excel Data validation allow weekday only

Tag: Sort and Filter

How To Remove Duplicates In Excel Column Or Row?

by

Remove Duplicate Rows Using the Excel Remove Duplicates Command. In Excel, the Remove Duplicates command can help you to remove duplicated records in a column. The Remove Duplicates command is located in the ‘Data Tools’ group, within the Data tab of the Excel ribbon. Follow the steps below: Data Tab → Data Tools Group → Remove Duplicate …

Continue Reading

How To Sort One Column or Multiple Columns in Excel

by

You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order. Navigation: Data Tab → Sort & Filter Group → Sort One Column To sort on one column, execute the following steps. 1. Click any cell in the column you want to sort. 2. To sort in ascending order, on the Data tab, …

Continue Reading

How To Filter Data in Excel

by

Filter your Excel data if you only want to display records that meet certain criteria. By filtering data in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to see, but what you want to exclude. You can filter …

Continue Reading

Remove Duplicates Example in Excel

by

When duplicates are removed in Excel, the first occurrence of the value in the list is kept, but other identical values are deleted. This example teaches you how to remove duplicates in Excel. Go here to only find duplicates. 1. Click any single cell inside the data set. 2. On the Data tab, in the Data Tools group, click …

Continue Reading

Advanced Filter in Excel

by

Filter setting using — And Criteria, Or Criteria or Formula as Criteria This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria. When you use the Advanced Filter, you need to enter the criteria on the worksheet. Create a Criteria range (blue border below for illustration only) above your data set. Use …

Continue Reading

Use Data Form to input, edit and delete records in Excel

by

The data form in Excel allows you to add, edit and delete records (rows) and display only those records that meet certain criteria. Especially when you have wide rows and you want to avoid repeated scrolling to the right and left, the data form can be useful. 1. Open the downloadable Excel file. 2. Add the Form command to the …

Continue Reading

How to Sort by Color in Excel

by

Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons. This example teaches you how to sort data by color in Excel. 1. Click any single cell inside a data set. 2. …

Continue Reading

Add Outline to Data in Excel

by

Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns. 1. First, sort the data on the Company column. 2. On the Data tab, in the Outline group, click Subtotal. 3. Select the Company column, the column we use to outline our worksheet. 4. Use …

Continue Reading

Subtotal function in Excel

by

The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function_num value you use. The SUBTOTAL function is designed for columns of data, or vertical ranges. Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or manually hidden rows. Rows …

Continue Reading

Filter Data Based on Date in Excel

by

This example teaches you how to apply a date filter to only display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On the Data tab, in the Sort & Filter group, click Filter. Arrows in the column headers appear. 3. Click the arrow next to Date. 4. Click on Select …

Continue Reading

Number and Text Filters Examples in Excel

by

How to apply a number filter and a text filter to only display records that meet certain criteria. Follow the steps below: 1. Click any single cell inside a data set. 2. On the Data tab, in the Sort & Filter group, click Filter. Arrows in the column headers appear. Number Filter To apply a number filter, execute the …

Continue Reading

Randomize/ Shuffle List in Excel

by

How to randomize / shuffle a list in Excel. For example, we want to randomize the list in column A below. 1. Select cell B1 and insert the RAND() function. 2. Click on the lower right corner of cell B1 and drag it down to cell B8. 3. Click any number in the list in column B. 4. To …

Continue Reading

Reverse List in Excel

by

This chapter teaches you an easy way to reverse a list in Excel. For example, we want to reverse the list in column A below. 1. Enter the value 1 into cell B1 and the value 2 into cell B2. 2. Select the range B1:B2, click the lower right corner of this range, and drag it down to cell B8. 3. …

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 Examples in Excel
  • SWITCH function example in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • How to get Holiday Date from Year in Excel
  • Convert Excel time to decimal hours in Excel
  • Convert date to Julian format in Excel
  • Display the current date and time in Excel
  • Convert Excel time to decimal minutes

Grouping

  • Running count group by n size in Excel
  • Group arbitrary text values in Excel
  • How to randomly assign data to groups in Excel
  • Map text to numbers in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to generate random date between two dates in Excel
  • Subtotal by color in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • 3D SUMIF for multiple worksheets in Excel
  • How to Delete Cells, Row and Rows in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning