How to use Excel
October 9, 2024How to Move Columns in Excel
To move columns in Excel use the shift key or use Insert Cut Cells. You can also change the order of all columns in one magic move.
Library
Page 15 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 15/29
How to use Excel
October 9, 2024Icon Sets in Excel
Icon Sets in Excel make it very easy to visualize values in a range of cells. Each icon represents a range of values.
How to use Excel
October 9, 2024Array Formulas in Excel
This chapter helps you understand array formulas in Excel. Single cell array formulas perform multiple calculations in one cell.
How to use Excel
October 9, 2024How to use the Excel RANK function
The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.
How to use Excel
October 9, 2024How to Create Tables in Excel
Master Excel tables and analyze your data quickly and easily. Learn how to create a table sort a table filter a table and much more.
How to use Excel
October 9, 2024Pivot Tables in Excel
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large detailed data set.
How to use Excel
October 9, 2024How to Merge Excel Files
To merge Excel files into one use the 'Move or Copy' feature. If you need to merge many Excel files consider using VBA to automate the process.
How to use Excel
October 9, 2024Histogram in Excel
This example teaches you how to make a histogram in Excel. You can use the Analysis Toolpak or the Histogram chart type. First enter the bin numbers (upper levels).
How to use Excel
October 9, 2024Transpose 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
October 8, 2024Loop 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.
How to use Excel
October 8, 2024Size of an Array in Excel VBA
To get the size of an array in Excel VBA you can use the UBound and LBound functions.
How to use Excel
October 8, 2024Embed 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.
How to use Excel
October 8, 2024Interactive Userform in Excel VBA
Below we will look at a program in Excel VBA that creates an interactive Userform.
How to use Excel
October 8, 2024Investment 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.
How to use Excel
October 8, 2024Range 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.
How to use Excel
October 8, 2024Create 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.
Glossary
October 8, 2024Profit Margin Formula in Excel
Calculating gross profit margin operating profit margin and net profit margin in Excel is easy. Simply use the formulas explained on this page.
How to use Excel
October 8, 2024If 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.
How to use Excel
October 8, 2024Rolling Average in Excel VBA
Below we will look at a program in Excel VBA that creates a rolling average table.
How to use Excel
October 8, 2024How 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.
How to use Excel
October 8, 2024Name 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).
How to use Excel
October 8, 2024Count 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.
How to use Excel
October 8, 2024Variable 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 use Excel
October 8, 2024How to Round in Excel (Easy Functions)
This chapter illustrates three functions to round numbers in Excel. ROUND ROUNDUP and ROUNDDOWN.