Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Create Flow Chart by using SmartArt File to download: None Related article: Create Organization Chart by using SmartArt It becomes very easy to create Flow chart in the later versions of Microsoft Office Suite by using the SmartArt features. You can do it … Read more Create Flow Chart by using SmartArt

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts US Thermal Map Thermal Map is also called Choropleth Map or Heat Map. The US Thermal Map is one of the most complicated programs to write. It involves creating a map by slicing out each individual state and then put the states back … Read more US Thermal Map

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Use RAND or RANDBETWEEN Functions to generate test data When you create an Excel model or template, the best way is to use the actual data to test if your model is working. But if you don’t have the actual data, you can … Read more Use RAND or RANDBETWEEN Functions to generate test data

  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 World Map with Population Indicators

  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 VLOOKUP and HLOOKUP functions

  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 Use Rules in Microsoft Outlook to organize your emails and alert you for special events

  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 Find the largest or smallest numbers in a range of data using LARGE and SMALL functions

  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 World Map with Bar Charts

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 Animation in Excel using VBA

  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 Use Conditional Formatting to create Quick Graphical Presentations