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 !
Services for your location
Database Tips from an Excel Training Course | Computers
report error
add to favorites
write a review
send to friends
suggest a topic

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

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. SQL Server DO's and DON'Ts
  10. Databases from scratch II: Simple Database Design
  11. Getting Started: Oracle SQL Developer Release 2.1
  12. How to Create an Access Database with VBScript
  13. How to Install PostgreSQL Using the Source Code
  14. Lotus Notes Database Tips
  15. Top Ten Tips for Tackling Tricky Database Queries
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 ...