Create Flow Chart by using SmartArt

  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

US Thermal Map

  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

World Map with Population Indicators

  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

VLOOKUP and HLOOKUP functions

  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

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 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

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 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

World Map with Bar Charts

  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

Animation in Excel using VBA

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

Use Conditional Formatting to create Quick Graphical Presentations

  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