Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use OFFSET Function for Dynamic Referencing Excel has a powerful function called OFFSET. It allows dynamic referencing without using visual basic modules or macros to do the work. Please the below example. Please note that no VB module or macro is used. The … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Gain Efficiency by Customizing your Quick Access Tool Bar File to download: None You can save a lot of time by putting some of your frequent use commands to the Quick Access Toolbar. Don’t underestimate the power of “quick access”. Little things add … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use COUNTIF function and sorting to analyze the PowerBall Playout File to download: Powerball Analysis.xlsx Related article: Lottery Numbers Generator Even in a random world, something in somewhere at some time is happening more frequently than the others. The occurrence may even out … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Manipulate Text by using Excel Commands and Functions File to download: Manipulate Text by using Excel Commands and Functions.xlsx Related Article: Date Functions, Compare Multiple Numbers and Text in Microsoft Excel The attached file (Manipulate Text by using Excel Commands and Functions.xlsx) illustrates … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Using Transpose Function to change the Data Layout You may want to change the data layout in some occasions. For example, the data downloaded is in landscape mode but you want to change it to portrait mode. Or certain layout fits better with … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Create videos by using PowerPoint File to download: None Related article: Use Audio Clips to make a powerful impact to your PowerPoint Presentations, Use Animations to energize your PowerPoint presentations rYou can use a combination of video clips, animations, and transitions to create a … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Create an action trigger (Open or Close a file) for a Visual Basic Module Requirement: Excel Visual Basic Knowledge File to download: None Related articles: Press ENTER key to trigger a Visual Basic Module Excel Visual Basic modules can be triggered by an … Read more
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
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
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