Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Create a Dropdown List by using Data Validation Command Creating a drop-down list by using Data Validation Command is easy and useful. It reduces the input time and maintains the data integrity. There are actually four ways to create a drop-down list depending … Read more Create a Dropdown List by using Data Validation Command
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Count duplicates as one item Requirement: Knowledge of Excel Array Functions File to download: None Related articles: Data Transposing I have a list of duplicate entries as shown in the left picture. There are 19 entries altogether with duplicates. For example, China in … Read more Count duplicates as one item
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Using Switchboard for easy navigation Requirement: Visual Basic Knowledge File to download: None The benefits of using a Switchboard Switchboard in Microsoft Access is a wonderful navigation tool. It’s versatile and user-friendly. Most of the users I encountered have some sort of phobia … Read more Using Switchboard for easy navigation
We all know that Bing Ads is a great way to expand successful paid search campaigns. While autotagging makes sharing AdWords data with Google Anlaytics easy as pie, tracking Bing Ads analytics data requires a bit more effort. The Google Campaigns URL Builder is a nice reference, but takes far too long to use on any … Read more Excel Bing Ads URL and Analytics Tagging
I’m a firm believer in the power of one’s own resourcefulness. This is especially true in the word of online marketing. SEM managers have a natural tendency to love any tool that can help get the job done quickly and effectively. What’s even better is having the ability to roll your own tools when necessary. … Read more Excel Formulas for PPC Keyword Match Type Manipulation