The VLOOKUP function in Excel is a powerful tool that allows you to search for a specific value in a table and return a corresponding value from a different column in the same row. The function takes four arguments: the value you want to search for (called the “lookup value”), the range of cells that … Read more
Why convert an XLSX to PDF? Very often we’re presented with an XLSX file that needs to somehow be sent to others as a PDF. Perhaps the other person is not as well versed in Excel and you want to simplify the process. Other time you may want a more polished version of the document … Read more
What is an XLSX file? An XLSX file is the file format of a Microsoft Excel spreadsheet. Excel files are used to store data as simple as an address list to complex data analysis, charts, and diagrams. In the hands of skilled users an, XLSX documents are powerful tools of analysis and organization. XLSX … Read more
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