Gain the edge and take your Microsoft Excel skills to the next level. Learn the necessary skills to supercharge your workflow with powerful formulas and functions.
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 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
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,
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.
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
There can be hundreds, thousands, or even millions of records in a database. Therefore, a search mechanism in a 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