Conditional 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
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 11/22
October 9, 2024
Sort Numbers in Excel VBA
Below we will look at a program in Excel VBA that sorts numbers.
How 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.
Assignment Problem in Excel
Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost.
Print 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.
Insert 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.
How 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.
Days 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.
Resize 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.
Calculate 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.
Dynamic 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.
Bills 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 Enter Fractions in Excel
This example teaches you how to enter a fraction in Excel and how to change the format of a fraction.
Table 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.
For 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 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 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.
3D-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.
Protect a Workbook in Excel
This example teaches you how to protect the workbook structure in Excel.
Array Manipulation Functions in Excel
Use the new array manipulation functions in Excel 365 to quickly combine shape and resize arrays.
Wildcards in Excel
Excel has 3 wildcards. A question mark (?) matches exactly one character. An asterisk (*) matches zero or more characters. And a tilde (~).
Product Codes in Excel
Use data validation to only allow the input of specific product codes. For example only allow codes that are 4 characters long start with a C etc.
Shortest Path Problem in Excel
Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S A B C D E and T). Lines in a network are called arcs (SA SB SC AC etc).
Dynamic Range in Excel VBA
Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.