Glossary
October 10, 2024Quarter Formula in Excel
An easy formula that returns the quarter for a given date. There's no built-in function in Excel that can do this.
Library
Page 8 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 8/29
How to use Excel
October 10, 2024Add Headers and Footers in Excel
This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel.
How to use Excel
October 10, 2024Count 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
October 10, 2024Macro 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.
How to use Excel
October 10, 2024Convert 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 use Excel
October 10, 2024How 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.
How to use Excel
October 10, 2024MAXIFS 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.
How to use Excel
October 10, 2024Password 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 Excel
October 10, 2024How 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.
How to use Excel
October 10, 2024Remove 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.
How to use Excel
October 10, 2024Share 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.
How to use Excel
October 10, 2024Format 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.
How to use Excel
October 10, 2024Multiple List Box Selections in Excel VBA
The MultiSelect property in Excel VBA allows a user to select multiple items in a list box.
How to use Excel
October 10, 2024Delay a Macro in Excel
To execute a sub in Excel VBA after a specific time use onTime Now and the TimeValue function.
Financial Planning
October 10, 2024Budget Limit in Excel
To avoid exceeding a budget limit in Excel simply use data validation and the SUM function.
How to use Excel
October 10, 2024Check 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.
How to use Excel
October 10, 2024Add 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.
How to use Excel
October 10, 2024Left 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.
How to use Excel
October 10, 2024Combo 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 Excel
October 10, 2024How 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.
How to use Excel
October 10, 2024Set 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.
How to use Excel
October 10, 2024Protect 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.
How to use Excel
October 10, 2024Remove 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.
How to use Excel
October 10, 2024Update 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.