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
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
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts US Thermal Map Thermal Map is also called Choropleth Map or Heat Map. The US Thermal Map is one of the most complicated programs to write. It involves creating a map by slicing out each individual state and then put the states back … Read more
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