Use Excel Pivot Table to create a Crosstab Table

  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 Use Excel Pivot Table to create a Crosstab Table

Use Data Table for Scenario Analysis

  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 Use Data Table for Scenario Analysis

Guidelines of using PowerPoint to make effective presentations

  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 Guidelines of using PowerPoint to make effective presentations

Use OFFSET Function for Dynamic Referencing

  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 Use OFFSET Function for Dynamic Referencing

Gain Efficiency by Customizing your Quick Access Tool Bar

  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 Gain Efficiency by Customizing your Quick Access Tool Bar

Use COUNTIF function and sorting to analyze the PowerBall Playout

  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 Use COUNTIF function and sorting to analyze the PowerBall Playout

Manipulate Text by using Excel Commands and Functions 

  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 Manipulate Text by using Excel Commands and Functions 

Using Transpose Function to change the Data Layout

  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 Using Transpose Function to change the Data Layout

Create videos by using PowerPoint

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 Create videos by using PowerPoint

Create an action trigger (Open or Close a file) for a Visual Basic Module

  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 Create an action trigger (Open or Close a file) for a Visual Basic Module