US Map with Smiley Faces

  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

How to hide the Navigation Pane in Microsoft Access

  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

Macros vs. Visual Basic Modules

  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

Use Animations to energize your PowerPoint Presentations

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

Run Adobe Reader in Desktop Mode with Window 8

  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

US Holidays Calculations 

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 

Create Flow Chart by using SmartArt

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Create Flow Chart by using SmartArt File to download: None Related article: Create Organization Chart by using SmartArt It becomes very easy to create Flow chart in the later versions of Microsoft Office Suite by using the SmartArt features. You can do it … Read more Create Flow Chart by using SmartArt

Use RAND or RANDBETWEEN Functions to generate test data

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use RAND or RANDBETWEEN Functions to generate test data When you create an Excel model or template, the best way is to use the actual data to test if your model is working. But if you don’t have the actual data, you can … Read more Use RAND or RANDBETWEEN Functions to generate test data