Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts World Map with Population Indicators If your company is a multinational corporation, you may be requested to generate reports to show the international performance. It comes in handy to have a world map and icons to show the relative performance on your dashboard. … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts VLOOKUP and HLOOKUP functions Both VLOOKUP and HLOOKUP are simple and easy to learn. They are good to match data. However, they are not very suitable for data referencing because of their several limitations. VLOOKUP is similar to HLOOKUP in syntax and uses. … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use Rules in Microsoft Outlook to organize your emails and alert you for special events File to download: None Using Rules in Microsoft Outlook is an easy and effective way to organize your emails. There are some people, companies, or events bear specific … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Find the largest or smallest numbers in a range of data using LARGE and SMALL functions You have a new report assignment that requires you to do it on a daily basis. You need to identify the top three salespersons and show their … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts World Map with Bar Charts File to download: World Map with Bar Charts.xlsx Related Articles: World Map with Population Indicators, US Map with Smiley Faces, US Thermal Map If your company is a multinational corporation, you may be requested to generate reports to … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Animation in Excel using VBA Requirement: Visual Basic Knowledge File to download: Excel Animation.xlsm Related article: Different Looping Mechanisms in Excel VBA, Use graphical functions in Microsoft Office to create impressive graphics Excel does not offer supports to animation as good as PowerPoint does, … Read more
Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use Conditional Formatting to create Quick Graphical Presentations File to download: None Conditional Formatting in Excel allows users to create visual graphical presentations. It is quick and easy to do so and it provides informative illustrations. Please follow the below steps to do … Read more
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