Transpose Data in Excel
Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.
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 15/22
October 9, 2024
Loop through Books and Sheets in Excel VBA
Below we will look at a program in Excel VBA that loops through all open workbooks and worksheets and displays all the names.
Size of an Array in Excel VBA
To get the size of an array in Excel VBA you can use the UBound and LBound functions.
Embed an Excel Worksheet in a Word Document
Embed an Excel worksheet in a Word document and work with Excel in Word. You can also embed files in Excel.
Interactive Userform in Excel VBA
Below we will look at a program in Excel VBA that creates an interactive Userform.
Investment or Annuity in Excel
This example teaches you how to calculate the future value of an investment or the present value of an annuity in Excel.
Range in Excel
A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.
Create a Pie Chart in Excel
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series. To create a pie chart in Excel execute the following steps.
If Cell Contains Specific Text - Excel Formulas
To check if a cell contains specific text use ISNUMBER and SEARCH in Excel. There's no CONTAINS function in Excel.
Rolling Average in Excel VBA
Below we will look at a program in Excel VBA that creates a rolling average table.
How to Group Worksheets in Excel
Group worksheets in Excel to edit multiple worksheets at the same time. Our workbook contains 3 similar worksheets (North Mid and South) and a blank fourth worksheet.
Name Box in Excel
You can use the name box in Excel to select a cell range or named range. You can also use the name box to quickly create a named range (important).
Count Unique Values in Excel
This example shows you how to create an array formula that counts unique values in Excel. In Excel 365/2021 use UNIQUE and COUNTA to count unique values.
Variable Scope in Excel VBA
The scope of a variable in Excel VBA determines where that variable may be used. You determine the scope of a variable when you declare it. There are three scoping levels: procedure level module level and public module level.
How to Round in Excel (Easy Functions)
This chapter illustrates three functions to round numbers in Excel. ROUND ROUNDUP and ROUNDDOWN.
Correlation in Excel
The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the correlation coefficient between two variables.
Find & Select in Excel
You can use Excel's Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel's Go To Special feature to quickly select all cells with formulas notes conditional formatting constants data validation etc.
How to use the Excel SUMIF function
The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples.
Running Total (Cumulative Sum) in Excel - Easy Tutorial
This page teaches you how to create a running total (cumulative sum) in Excel. A running total changes each time new data is added to a list.
How to use XMATCH in Excel
The XMATCH function in Excel enhances the MATCH function by adding new features making it ideal for finding the position of items within arrays or cell ranges. This guide will detail how to use XMATCH through practical examples and will highlight its advantages over MATCH.
Data Form in Excel
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.
How to use the Excel MOD function
The MOD function in Excel gives the remainder of a division. You can use the MOD (Modulus) function to determine whether a number is divisible by another number or to check if a number is even or odd.
Date and Time in Excel VBA
Learn how to work with dates and times in Excel VBA. The following macro gets the year of a date. To declare a date use the Dim statement. To initialize a date use the DateValue function.
Locate Maximum Value in Excel
To find the maximum value in Excel use the MAX function. To find the cell address of the maximum value in a column use MAX MATCH and ADDRESS.