This is a practical problem I faced recently. Found a simple but useful solution. So I am sharing it with you. I am sure you will also find it useful…
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up the unwanted things which also got pasted.
If you have Excel 2010 or above (Professional Plus or Office 365 edition),
you have a miraculously simple method available now : Power Query…
How to keep the audience awake? That is the biggest problem we have while presenting. The less boredom you create, the higher is the chance of people being awake
Boring Slide Makeover: Screenshots from Excel explains how to make Excel data look better in PowerPoint. In this article we learn another technique to make small amount of summary data look better. Today I learnt a new additional technique to enhance the content even further.
Using PowerPoint you can convert simple bullets to high-impact diagrams in seconds. Refer to these articles to learn a great feature called SmartArt:
Boring to Exciting ppt – in few clicks!
Marketing: Arranging multiple pictures in few clicks!
Show Off and Learn: Picture Organization Chart in 2 minutes
Video Tutorial: How to show collaboration in PowerPoint
Marketing: How to create “Our Customers” Slide in seconds
Recently I was working on PEST analysis with my good friend Ms. Faith. That is when I thought of writing this article. We will see how SWOT and PEST analysis diagrams can be created instantly using PowerPoint. These topics are commonly used in strategic management and situational analysis.
Please read the previous article so that you understand the context of this article.
In the previous article we saw how to divide available data into three categories: High, Medium, Small. In this article we will explore how to refine this process and have up to 5 categories of classification. We will also see how business context helps you decide the type of visualization.