How to use Excel
October 9, 2024Running Total (Cumulative Sum) in Excel
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.
Library
Page 11 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 11/29
How to use Excel
October 9, 2024How to use the Excel SEARCH function
Use the SEARCH function in Excel to find the position of a substring in a string. The SEARCH function is case-insensitive and supports wildcards.
How to use Excel
October 9, 2024ByRef and ByVal in Excel VBA
You can pass arguments to a procedure (function or sub) by reference or by value. By default Excel VBA passes arguments by reference. As always we will use an easy example to make things more clear.
How to use Excel
October 9, 2024Custom Sort Order in Excel
You can use Excel to sort data in a custom order. In the example below we would like to sort by Priority (High Normal Low).
How to use Excel
October 9, 2024Conditional Formatting in Excel
Use conditional formatting in Excel to automatically highlight cells based on their content. Apply a rule or use a formula to determine which cells to format.
How to use Excel
October 9, 2024Sort Numbers in Excel VBA
Below we will look at a program in Excel VBA that sorts numbers.
How to use Excel
October 9, 2024How to use the Excel SUBTOTAL function
Use the SUBTOTAL function in Excel (instead of SUM COUNT MAX etc.) to ignore rows hidden by a filter or to ignore manually hidden rows.
How to use Excel
October 9, 2024Assignment Problem in Excel
Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost.
How to use Excel
October 9, 2024Print Gridlines and Headings in Excel
Print gridlines (the horizontal and vertical lines on your worksheet) and row/column headers (1 2 3 etc. and A B C etc.) to make your printed copy easier to read. To print gridlines and headings in Excel execute the following steps.
How to use Excel
October 9, 2024Insert a Checkbox in Excel
Inserting a checkbox in Excel is easy. For example use checkboxes to create a checklist or a dynamic chart. You can also insert a check mark symbol.
Glossary
October 9, 2024Convert Formula to Value in Excel
To quickly convert a formula to a value in Excel or to convert multiple formulas to values execute the following steps.
How to use Excel
October 9, 2024How to use the Excel AVERAGEIF function
The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria.
How to use Excel
October 9, 2024Days between Dates in Excel
To calculate the number of days between two dates in Excel subtract the start date from the end date use DAYS or use DATEDIF.
How to use Excel
October 9, 2024Resize Property in Excel VBA
The Resize property in Excel VBA makes a range a specific number of rows and columns smaller or larger. The Resize property always takes the top left cell of a range as the starting point.
Financial Planning
October 9, 2024Loan Amortization Schedule in Excel
This example teaches you how to create a loan amortization schedule in Excel.
How to use Excel
October 9, 2024Calculate Time Difference in Excel
Calculating the difference between two times in Excel can be tricky. Times are handled internally as numbers between 0 and 1.
How to use Excel
October 9, 2024Dynamic Array in Excel VBA
If the size of your array increases and you don't want to fix the size of the array you can use the ReDim keyword. Excel VBA then changes the size of the array automatically.
How to use Excel
October 9, 2024Bills and Coins in Excel VBA
Below we will look at a program in Excel VBA that splits an amount of money into bills and coins.
How to use Excel
October 9, 2024How to Enter Fractions in Excel
This example teaches you how to enter a fraction in Excel and how to change the format of a fraction.
How to use Excel
October 9, 2024Table Styles in Excel
Quickly format a range of cells by choosing a table style. You can also create your own table style in Excel. Quickly format a cell by choosing a cell style.
How to use Excel
October 9, 2024For Loop in Excel VBA
Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.
How to use Excel
October 9, 2024How to use Slicers in Excel
Use slicers in Excel to quickly and easily filter pivot tables. Connect multiple slicers to multiple pivot tables to create awesome reports.
How to use Excel
October 9, 2024How to Create a Macro in Excel
With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter learn how to create a simple macro which will be executed after clicking on a command button. First turn on the Developer tab.
How to use Excel
October 9, 20243D-reference in Excel
A 3D-reference in Excel refers to the same cell or range on multiple worksheets. First we'll look at the alternative.