Count Errors in Excel
This example shows you how to create an array formula that counts the number of errors in an Excel range.
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 8/22
October 10, 2024
Macro Recorder in Excel
The Macro Recorder a very useful tool included in Excel VBA records every task you perform with Excel. All you have to do is record a specific task once. Next you can execute the task over and over with the click of a button. The Macro Recorder is also a great help when you don't know how to program a specific task in Excel VBA. Simply open the Visual Basic Editor after recording the task to see how it can be programmed.
Convert Text to Numbers in Excel
In Excel text is left-aligned and numbers are right-aligned. This example teaches you how to convert 'text strings that represent numbers' to numbers.
How to Split Cells in Excel
To split a cell in Excel add a new column change the column widths and merge cells. To split the contents of a cell into multiple cells use the Text to Columns wizard flash fill or formulas.
MAXIFS and MINIFS in Excel
Use MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.
Password Protect an Excel Macro
Just like you can password protect workbooks and worksheets you can password protect a macro in Excel from being viewed (and executed).
How to use GETPIVOTDATA in Excel
To quickly enter a GETPIVOTDATA function in Excel type an equal sign (=) and click a cell in a pivot table. The GETPIVOTDATA function can be quite useful.
Remove Leading Zeros in Excel
This guide teaches you how to remove leading zeros in Excel. The first method uses Paste Special to remove leading zeros from numbers affected by text formatting. The second method uses a simple formula to strip leading zeros from text while preserving other zeros.
Share Workbooks - Excel Tutorial
If you share a workbook in Excel 2016 or older versions you can work with other people on the same workbook at the same time. The workbook should be saved to a network location where other people can open it. You can keep track of the changes other people make and accept or reject those changes.
Format Painter in Excel
The Format Painter is one of the most underused features of Excel. The Format Painter copies formatting from one place and applies it to another.
Multiple List Box Selections in Excel VBA
The MultiSelect property in Excel VBA allows a user to select multiple items in a list box.
Delay a Macro in Excel
To execute a sub in Excel VBA after a specific time use onTime Now and the TimeValue function.
Check Box in Excel VBA
A check box is a field which can be checked to store information. To create a check box in Excel VBA execute the following steps.
Add Error Bars in Excel
This page teaches you how to quickly add error bars to a chart in Excel followed by instructions for adding custom error bars. First select the chart. Next click the + button on the right side of the chart click the arrow next to Error Bars and then click More Options.
Left Lookup in Excel
The VLOOKUP function only looks to the right. To look up a value in any column and return the corresponding value to the left simply use INDEX and MATCH.
Combo Box in Excel VBA
A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To create a combo box in Excel VBA execute the following steps.
How to use FREQUENCY in Excel
The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table. You can also use the COUNTIFS function to create a frequency distribution.
Set a Print Area in Excel
If you set a print area in Excel only that area will be printed. The print area is saved when you save the workbook.
Protect a Sheet in Excel
When you share an Excel file with other users you may want to protect a worksheet to help prevent it from being changed.
Remove Table Formatting in Excel
This article will explain how to remove two types of table formatting in Excel. You'll learn how to remove formatting from Excel tables and manually formatted data ranges.
Update a Pivot Table in Excel
Any changes you make to the data set are not automatically picked up by a pivot table in Excel. Refresh the pivot table or change the data source to update the pivot table with the applied changes.
Structured References in Excel
When working with tables in Excel you can use structured references to make your formulas easier to understand.
Create Drop-down Lists in Excel
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list instead of typing their own values.
Month Names in Excel VBA
Below we will look at a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of the months.