How to use the Excel MODE function
Use the MODE function in Excel to find the most frequently occurring number in a list of numbers. Use MODE.MULT to find multiple modes.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 6/22
October 10, 2024
Delete Row Shortcut in Excel
To quickly delete a row in Excel select a row and use the shortcut CTRL - (minus sign). To quickly delete multiple rows select multiple rows and use the same shortcut.
Highlight Row Differences in Excel
This example teaches you how to quickly highlight cells in Excel whose contents are different from the comparison cell in each row.
Sparklines in Excel
Sparklines in Excel are graphs that fit in one cell. Sparklines are great for displaying trends. Excel offers three sparkline types: Line Column and Win/Loss.
Not Equal To Operator in Excel
In Excel <> means not equal to. The <> operator in Excel checks if two values are not equal to each other. Let's take a look at a few examples.
Apply Number and Text Filters in Excel
This example teaches you how to apply a number filter and a text filter in Excel to only display records that meet certain criteria.
How to Remove Spaces in Excel
The TRIM function in Excel removes leading spaces extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.
Customize the Ribbon in Excel
The ribbon in Excel can be customized. You can easily create your own tab and add commands to it.
Create a Search Box in Excel
This example teaches you how to create your own search box in Excel. If you are in a hurry simply download the Excel file.
Consolidate Data in Excel
You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet.
Show Formulas in Excel
By default Excel shows the results of formulas. To show the formulas instead of their results press CTRL + ` (you can find this key above the tab key).
Moving Average in Excel
This example teaches you how to calculate the moving average of a time series in Excel. A moving average is used to smooth out irregularities (peaks and valleys) to easily recognize trends.
Date and Time Formats in Excel
Dates and times in Excel can be displayed in a variety of ways. To apply a Date or Time format execute the following steps.
Case-sensitive Lookup in Excel
By default the VLOOKUP function performs a case-insensitive lookup. However you can use INDEX MATCH and EXACT in Excel to perform a case-sensitive lookup.
Date Format in Excel VBA
Changing the date format in Excel VBA is easy. Use the NumberFormat property in Excel VBA to set the desired date format. Below are simple examples and tips to find the right date format.
How to use the Excel TEXT function
When joining text and a number use the TEXT function in Excel to format that number. This page contains many easy to follow TEXT function examples.
Create a Footer Before Printing in Excel VBA
Below we will look at a program in Excel VBA that creates a footer before printing a workbook.
List Box in Excel VBA
A list box is a list from where a user can select an item. To create a list box in Excel VBA execute the following steps.
How to Remove Duplicates in Excel
To quickly remove duplicates in Excel use the tool on the Data tab. Use the Advanced Filter if you don't want to delete duplicates permanently.
How to use the Excel OR function
The OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false. Combine the OR function with other functions and become an Excel expert.
Add or Subtract Time in Excel
Use the TIME function in Excel to add or subtract hours minutes and seconds. To add up times in Excel simply use the SUM function.
String Manipulation in Excel VBA
In this chapter you'll find the most important functions to manipulate strings in Excel VBA.
Excel Macro Comments (Easy VBA)
A macro comment is a piece of text in a macro which will not be executed by Excel VBA. It is only there to provide you information about the macro.
Sort a Range in Excel VBA
You can use the Sort method in Excel VBA to sort ranges in Excel. This article provides clear and practical examples to help you get started with sorting ranges using Excel VBA.