Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use Excel Pivot Table to create a Crosstab Table File to download: None Related article: Convert a Crosstab Table to Database data format Pivot Table is extremely useful for massive data analysis. It allows users to slice and dice the data in many … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use Data Table for Scenario Analysis File to download: Goal Seek and Data Table Example.xlsx Related Article: Use Goal Seek command to reverse engineer desired results Scenario Analysis is a very useful financial decision tool. It is a vital part for strategic planning. … Read more

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Guidelines of using PowerPoint to make effective presentations File to download: None Related articles: Create video by using PowerPoint, Use Animations to energize your PowerPoint presentations, Use Audio Clips to make a powerful impact to your PowerPoint Presentations Microsoft PowerPoint is a great … Read more

  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