How to use Excel
October 9, 2024How to use the Excel ROW function
The ROW function in Excel returns the row number of a reference. For example =ROW(C4) returns 4. The ROW function can be quite useful.
Library
Page 13 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 13/29
How to use Excel
October 9, 2024How to use the Excel SORT function
Use the magic SORT function in Excel 365/2021 to sort your Excel data by one column or multiple columns. Let's give it a try.
How to use Excel
October 9, 2024Data Tables in Excel
Instead of creating different scenarios you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table in Excel.
How to use Excel
October 9, 2024Year Occurrences in Excel VBA
Below we will look at a program in Excel VBA that counts the number of year occurrences.
How to use Excel
October 9, 2024Most Frequently Occurring Word - Excel Formula
This example teaches you how to find the most frequently occurring word in Excel.
How to use Excel
October 9, 2024EVEN and ODD in Excel
Use EVEN and ODD in Excel to round numbers. Use ISEVEN or ISODD in Excel to determine if a number is even or odd.
How to use Excel
October 9, 2024How to Divide in Excel - Easy Formulas
There's no DIVIDE function in Excel. Simply use the forward slash (/) to divide numbers in Excel. Don't forget always start a formula with an equal sign (=).
How to use Excel
October 9, 2024Status Bar in Excel
The status bar in Excel can be quite useful. By default the status bar at the bottom of the window displays the average count and sum of selected cells.
How to use Excel
October 9, 2024Outlining Data in Excel
Outlining data in Excel makes your data easier to view. In this example we will total rows of related data and collapse a group of columns.
How to use Excel
October 9, 2024Progress Indicator in Excel VBA
Below we will look at a program in Excel VBA that creates a progress indicator. We've kept the progress indicator as simple as possible yet it looks professional. Are you ready?
How to use Excel
October 9, 2024Introduction to Excel
If you're an Excel beginner this is the perfect place to start. Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel.
How to use Excel
October 9, 2024Sum by Color in Excel VBA
Below we will look at a program in Excel VBA that sums numbers by color.
How to use Excel
October 9, 2024Kg to lbs in Excel (Easy Converter)
1 kg = 2.20462 lbs (pounds) and 1 lb (pound) = 0.45359 kg. Use a simple formula the CONVERT function or download our free unit converter to convert from kg to lbs or vice versa.
How to use Excel
October 9, 2024How to Find Duplicates in Excel
This page teaches you how to find duplicate values (or triplicates) and how to find duplicate rows in Excel. Select a range of cells. On the Home tab in the Styles group click Conditional Formatting Highlight Cells Rules Duplicate Values.
How to use Excel
October 9, 2024Time Sheet in Excel
This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow.
How to use Excel
October 9, 2024Decimal Places in Excel
Learn how to show fewer or more decimal places in Excel without changing the number itself. You can also round a number.
How to use Excel
October 9, 2024Goal Seek in Excel
If you know the result you want from a formula use Goal Seek in Excel to find the input value that produces this formula result.
How to use Excel
October 9, 2024Count and Sum Functions in Excel
The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.
How to use Excel
October 9, 2024Compare Ranges in Excel VBA
Below we will look at a program in Excel VBA that compares randomly selected ranges and highlights cells that are unique. If you are not familiar with areas yet we highly recommend you to read this page first.
How to use Excel
October 9, 2024Currency vs Accounting Format in Excel (Easy Tutorial)
The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference.
How to use Excel
October 9, 2024Compare Dates and Times in Excel VBA
This example teaches you how to compare dates and times in Excel VBA. Dates and times are stored as numbers in Excel and count the number of days since January 0 1900. What you see depends on the number format.
Glossary
October 9, 2024How to Copy a Formula in Excel
When you copy a formula Excel automatically adjusts the cell references for each new cell the formula is copied to. Use the fill handle in Excel to quickly copy a formula to other cells.
How to use Excel
October 9, 2024Find Second Highest Value in Excel VBA
Below we will look at a program in Excel VBA that finds the second highest value.
How to use Excel
October 9, 2024Files in a Directory in Excel VBA
Below we will look at a program in Excel VBA that loops through all closed workbooks and worksheets in a directory and displays all the names.