Percentage Discount in Excel
If you know the original price and the discounted price you can calculate the percentage discount. If you know the original price and the percentage discount you can calculate the discounted price etc.
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 7/22
October 10, 2024
StatusBar Property in Excel VBA
The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way you can let the user know that a macro is still running.
Convert Numbers to Text in Excel
In Excel numbers are right-aligned and text is left-aligned. This example teaches you how to convert numbers to 'text strings that represent numbers'.
Create a Calendar in Excel
This example describes how to create a calendar in Excel (2024 calendar 2025 calendar etc). If you are in a hurry simply download the Excel file.
How to AutoFit Columns in Excel
You probably know how to change the width of a column in Excel but do you also know how to automatically fit the widest entry in a column?
Loan Calculator in Excel VBA
This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons.
How to use the Excel SWITCH function
The SWITCH function in Excel looks up a specified value in a list of values and returns the result corresponding to the first match found.
Share Excel Data with Word Documents
Learn how to share Excel data with Word documents and other files.
Option Explicit in Excel VBA
We strongly recommend to use Option Explicit at the start of your Excel VBA code. Using Option Explicit forces you to declare all your variables.
Negative Numbers to Zero - Excel Formula
A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
Step Keyword in Excel VBA (Easy For Loop)
You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop.
Zoom in and out in Excel
In most cases you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.
Freeze Panes in Excel
If you have a large table of data in Excel it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
How to Calculate Age in Excel
To calculate age in Excel use the DATEDIF function and TODAY. You can also use the age formula further down to calculate a person’s exact age in years months and days. Enter the date of birth into cell A2.
Password Protect an Excel File
Encrypt an Excel file with a password so that it requires a password to open it. To password protect an Excel file execute the following steps.
Days until Birthday in Excel
To calculate the number of days until your birthday in Excel execute the following steps.
Custom Average Function in Excel VBA
Below we will look at a program in Excel VBA which creates a user defined function that calculates the average of a randomly selected range excluding one or more values that are outliers and shouldn't be averaged.
Create a Bar Chart in Excel
A bar chart is the horizontal version of a column chart. Use a bar chart if you have large text labels. To create a bar chart in Excel execute the following steps.
Formula Errors in Excel
This chapter teaches you how to deal with some common formula errors in Excel. Let's start simple.
Absolute Value in Excel
The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number making it positive.
CurrentRegion Property in Excel VBA
This example illustrates the CurrentRegion property in Excel VBA. The current region is a range bounded by any combination of blank rows and blank columns.
AutoRecover in Excel
Excel periodically saves a copy of your Excel file. Learn how to recover a file that was never saved and how to recover a file that has been saved at least once.
Cell Background Colors in Excel VBA
Changing background colors in Excel VBA is easy. Use the Interior property to return an Interior object. Then use the ColorIndex property of the Interior object to set the background color of a cell.
Add Headers and Footers in Excel
This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel.