The popular data entry form was removed from the Ribbon in Excel 2010. I am often asked where this feature went. So what is this feature? And where can it be found? Find out in this Excel tutorial.
The Excel data entry form makes it easy to;
The data entry form is very user friendly and is a must for anyone who performs alot of data entry, especially in a large table.
I was asked yesterday how to highlight dates that were over 30 days old. The situation was that the date of a transaction is recorded and the team need to be alerted when that date is older than 30 days.
Because they wish to highlight the cell, Conditional Formatting will be used. A new rule will be created with criteria to find those dates older than 30 days.
Once you are familiar with how to compare dates in Excel and highlight the dates that meet specific criteria, you can adjust the formula used in this tutorial to meet your needs. For example, to highlight overdue dates, or those due within the next 7 days.
[Read more…] about Highlight Dates Over 30 Days OldDue to popular demand, I have created an Excel fixture and league table generator.
Following on from my fixture list creator and league table generator files, I was asked to create a combined file to create a fixture list and also generate a league table from results entered.
Download the Excel fixtures and league table generator.
To use the file;
It is possible to perform quick calculations in Excel without having to write any formulas. This technique is brilliant and provides the formula result you need quickly and easily.
You can count, sum, average and find the maximum or minimum number in a range simply by selecting the numbers you want to calculate.
[Read more…] about Perform Quick Calculations in ExcelIf you collect email addresses in your spreadsheet. You may want to validate an email address in Excel.
Using Data Validation you can check the syntax of an email address to ensure it is legitimate. It cannot check the existence of an address, or who it belongs to. But it will ensure the existence of the @ symbol, a period (.) and no spaces in the address.
[Read more…] about Validate an Email Address in Excel
