Categories Menu
Repair Center
24 hours online support we repair all types of laptops and relating to LCD screen,motherboard, DC adapter, power supplies and so much more! The shop reliable laptop repair in Ottawa area since 1995. Repair your laptop as easy as 1-2-3 !
computer_25
Services for your location
Database Tips from an Excel Training Course | Computers
print
report error
add to favorites
write a review
send to friends
suggest a topic
register

The benefit of an Excel training course is not just learning new things but also learning new ways to do old things. An experienced instructor provides hints and shortcuts that have you designing spreadsheets in new ways.

For example, let's look at tips from Excel training courses that can help in maintaining a database. Excel is an easy way to keep a simple database and a few design steps can save you huge headaches later.

Hide Blank Formulas
The simplest databases are a collection of data records but some have formulas off to the side providing analysis of each entry. However if any data is missing from the record then these formulas clutter up the sheet with "#NUM!" and "#DIV/0!" and other errors.

Consider a database of payments from a client, a typical example in an Excel training course. Each line contains, among other information, the date of invoice and the date of payment. You have a formula on each line that calculates the time between invoice and payment using a formula like "=G2-F2" to subtract the invoice date (F2) from the payment date (G2). Until you have a payment date, this field will read as a very large negative number.

Instead, enter this formula: =IF(G2="","",G2-F2). This says "If there is no payment date, leave this field blank otherwise calculate the payment delay". Even better, try "=IF(OR(F2="",G2=""),"",G2-F2) which leaves the payment time field blank if either date field is blank.

Mark Blank Formulas

prev
1
Other newly Articles from the Laptop Repair Tips and Tricks - Database Tips Category:
  1. How to Do Batch Decrypting With GnuPG
  2. Accessing ODBC Databases from Lotus Notes/Domino
  3. Fix RUNDLL Error; RUNDLL32 Error Messages at Startup on Windows XP or Vista
  4. Create a Database Search Page Using Expression Web
  5. SQL Tuning Tutorial - Understanding a Database Execution Plan
  6. Microsoft Access Stored Queries and VBscript
  7. How to Find a Hidden File on Your Computer
  8. Ways To Stop Runtime Error 424
  9. Getting Started: Oracle SQL Developer Release 2.1
  10. Databases from scratch II: Simple Database Design
  11. SQL Server DO's and DON'Ts
  12. How to Create an Access Database with VBScript
  13. How to Install PostgreSQL Using the Source Code
  14. Lotus Notes Database Tips
  15. How to Reinstall Windows Without Losing Your Data
Custom Search
Examples: HP,laptop Rapair,LCD,DC Backlight,Inverter,solder
Article Comment:Replies(0)Views
Name(required):        Email(required):  
Verify: key
Use the above information at your own risk
Loading ... Loading ...