How to use Excel
October 10, 2024How 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.
Library
Page 6 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 6/29
How to use Excel
October 10, 2024Delete 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.
How to use Excel
October 10, 2024Highlight 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.
How to use Excel
October 10, 2024Sparklines 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.
How to use Excel
October 10, 2024Not 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.
How to use Excel
October 10, 2024Apply 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.
Glossary
October 10, 2024Compound Interest Formula in Excel
What's compound interest and what's the formula for compound interest in Excel? This example gives you the answers to these questions.
How to use Excel
October 10, 2024How 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.
How to use Excel
October 10, 2024Customize the Ribbon in Excel
The ribbon in Excel can be customized. You can easily create your own tab and add commands to it.
How to use Excel
October 10, 2024Create 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.
How to use Excel
October 10, 2024Consolidate Data in Excel
You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet.
How to use Excel
October 10, 2024Show 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).
How to use Excel
October 10, 2024Moving 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.
How to use Excel
October 10, 2024Date 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.
How to use Excel
October 10, 2024Case-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.
How to use Excel
October 10, 2024Date 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 Excel
October 10, 2024How 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.
How to use Excel
October 10, 2024Create 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.
How to use Excel
October 10, 2024List 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 use Excel
October 10, 2024How 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 Excel
October 10, 2024How 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.
How to use Excel
October 10, 2024Add 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.
How to use Excel
October 10, 2024String Manipulation in Excel VBA
In this chapter you'll find the most important functions to manipulate strings in Excel VBA.
How to use Excel
October 10, 2024Excel 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.