Status 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
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 13/22
October 9, 2024
Outlining 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.
Progress 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?
Introduction 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.
Sum by Color in Excel VBA
Below we will look at a program in Excel VBA that sums numbers by color.
Kg 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 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.
Time Sheet in Excel
This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow.
Decimal 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.
Goal 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.
Count 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.
Compare 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.
Currency 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.
Compare 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.
Find Second Highest Value in Excel VBA
Below we will look at a program in Excel VBA that finds the second highest value.
Files 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.
Excel Functions
Discover how functions in Excel help you save time. If you are new to functions in Excel we recommend you to read our introduction to formulas and functions first.
Two-way Lookup in Excel
To lookup a value in a two-dimensional range use INDEX and MATCH in Excel. Below you can find the sales of different ice cream flavors in each month.
Center on Page in Excel
To center a range of cells on a printed page in Excel automatically execute the following steps.
Delete Blank Rows in Excel
To delete blank rows in Excel use Go To Special Blanks. You can also use the COUNTA function and a filter to remove empty rows.
Reject Invalid Dates in Excel
This example teaches you how to use data validation in Excel to reject invalid dates.
Test a Selection in Excel VBA
This program in Excel VBA uses the Count property IsNumeric function IsEmpty function and Intersect method to test a selection.
Automated Invoice in Excel
This article describes how to automate the generation of invoices in Excel. If you are in a hurry simply download the Excel file.
How to use the Excel AVERAGE function
The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values empty cells and cells that contain text.