george

When we automate the Excel worksheets by using Visual Basic (VB) codes, we frequently have to make the cursor moved to pre-determined locations to do calculations, copy, cut, paste, sort, and filter data. If you know how to combine the movements with the looping, you have an ultimate tool for automation. The payoff is tremendous … Read more

Internal Rate of Return (abbreviated as “IRR”, also called “Yield”). In this article, “Internal Rate of Return” “IRR”, and “Yield” will be used interchangeably. IRR is one of the most important tools in the financial world. It measures how well an investment or a project performs over time. It is an essential part of benefit/cost … Read more

Ideally, all the reports should be generated from the system itself. However, we are living in a world with limited resources. The IT Department always has different priorities from you. Your urgent request may turn out to be the lowest priority of your IT Department. If you don’t know how to do some programming yourself, … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Create a Watermark Create Watermark for your document is easy. Click the “Page Layout” on the ribbon and choose “Watermark” command. Pick the one that you want from the drop-down menu. If the drop-down menu does not have the pre-set watermark that you … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts US Map with Smiley Faces This example use Simley Faces as the statistical indicators. The size of each Simley Face indicates the relative performance or the strength of each US State. The statistics can be sales amount, sales revenue, product sales, returned items, … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts How to hide the Navigation Pane in Microsoft Access Requirement: Visual Basic Knowledge File to download: None Related Articles: Macros vs Visual Basic Modules, Using Switchboard for easy navigation, Hide Visual Basic Modules by saving your Access Files in MDE or ACCDE file … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Macros vs. Visual Basic Modules Requirement: Visual Basic Knowledge File to download: None Related Articles: Use Input Form for Parameter Query, Use Embedded SQL Query for better efficiency and security Introduction If you are a frequent Excel user, you certainly have encountered some … Read more

Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use Animations to energize your PowerPoint Presentations File to download: None Related articles: Guidelines of using PowerPoint, Create video by using PowerPoint, Use Audio Clips to make a powerful impact to your PowerPoint Presentations Animations can make your presentations livelier and more interesting, thus … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Run Adobe Reader in Desktop Mode with Window 8 File to download: None There are two application modes in Window 8: the traditional desktop mode and the new metro mode. The metro mode is created primarily for touch screen applications (even though you … Read more

Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts US Holidays Calculations Requirement: Visual Basic Knowledge File to download: Holiday.xlsm Related Articles: Date Functions, WORKDAY and NETWORKDAYS functions, Calculation of Bond Payment Dates Calculating the holidays is no easy task. This article addresses only the United States holidays because I am not familiar … Read more