There are several functions can do data referencing: LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX, and OFFSET. VLOOKUP and HLOOKUP are partly covered in this article (VLOOKUP and HLOOKUP functions). OFFSET function is covered in another article (Dynamic Referencing for Excel). This article primarily focuses on the MATCH and INDEX functions. This article primarily focuses on … Read more
The graphical functions in Microsoft Office may not be as robust as many other commercial graphical software, but they are more than adequate to create impressive graphics if you know how to use them. Your imagination is your limit. The graphical functions are available in Word, Excel, and PowerPoint. Let’s get some ideas how to … Read more
A meter is an ideal visual tool to indicate the progress of a project, the usage of a resource, or the level of achievement. It is one of the most useful items on a dashboard. If you know graphic designs and some visual basic codes, it is not too difficult to make one. You need … Read more
Most people have daily, weekly, or monthly tasks that needed to be done on a regular basis. You can automate such process by using Microsoft’s Task Scheduler. For example, you have a daily report in Excel that links to the Oracle database through ODBC connection. You can schedule the Excel report to be run in … Read more
Adding sounds, voices, and music can have a powerful impact on your PowerPoint presentations. They can deliver messages, convey moods, and make your presentations livelier, more interesting, and more appealing. Sound and music affects human emotions, such as joy, sadness, fear, and fondness. Researches have confirmed that such impact on emotions is cross-culture and cross-backgrounds. … Read more
Why Create a Microsoft Access Search Form? There can be hundreds, thousands, or even millions of records in a database. Therefore, a search mechanism in a Microsoft Access database is a “must-have” item. For data integrity purpose, you may not want the users to query a table directly. in fact, it may be a good … Read more
A prime number (or just “prime”) is a natural number greater than 1 that has no positive divisors other than 1 and itself. A natural number greater than 1 that is not a prime number is called a composite number. Theoretically, the number of primes should be infinite. Primes are utmost importance to number theorists … Read more
The inclusion of holidays is critical in calculating the “Bond Payment Dates”. There are bonds that accrue interest on the basis of Actual/360 or Actual/Actual. For example, if a bond has a payment date of 25th of each month, the accrual days for a period will be from 25th of this month to 24th of … Read more
Having a personalized signature in your email is an “etiquette” in the business world. It conveys a professional image and facilitates the communications. Many companies mandate their employees to create email signature adhering to certain company standards. The signature usually includes certain items such as name, title, company name, company address, phone #, fax #, … Read more
When you work on Microsoft Access queries or SQL queries, it is necessary to understand the concept join properties. There are inner join, left outer join, and right outer join. In Microsoft Access, queries are created with inner joins by default. Inner join produces a result with data appear in both tables that match with … Read more