Microsoft Office Suite

Data Referencing by using VLOOKUP, HLOOKUP, MATCH, and INDEX functions

by
data-referencing-by-using-vlookup

  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 Data Referencing by using VLOOKUP, HLOOKUP, MATCH, and INDEX functions

Use graphical functions in Microsoft Office to create impressive graphics

by
use-graphical-functions-in-microsoft-office-to-create-impressive-graphics

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 Use graphical functions in Microsoft Office to create impressive graphics

Use Task Scheduler to automatically run a file or a program

by
use-task-scheduler-to-automatically-run-a-file-or-a-program

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 Use Task Scheduler to automatically run a file or a program

Use Audio Clips to make a powerful impact to your PowerPoint Presentations

by
use-audio-clips-to-make-a-powerful-impact-to-your-powerpoint-presentations

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 Use Audio Clips to make a powerful impact to your PowerPoint Presentations

Prime Factoring using a Visual Basic Module

by
prime-factoring-using-a-visual-basic-module

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 Prime Factoring using a Visual Basic Module

Create a personalized signature in Microsoft Outlook

by
create-a-personalized-signature-in-microsoft-outlook

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 Create a personalized signature in Microsoft Outlook