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 Navigate around cells, worksheets, and files by using Visual Basic Codes
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 Internal Rate of Return (IRR) Calculations with different Accrual Basis
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 Use ODBC to connect Oracle Database and Microsoft Access
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 Create a Watermark
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 US Map with Smiley Faces
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 How to hide the Navigation Pane in Microsoft Access
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 Macros vs. Visual Basic Modules
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 Use Animations to energize your PowerPoint Presentations
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 Run Adobe Reader in Desktop Mode with Window 8
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 US Holidays Calculations