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.
We get lot of data and reports every day. Usually, to understand the information easily, we draw charts. Nothing wrong with that. Except that there are other methods available which may be more effective. Here is one such method which divides the data into three categories – high, medium and low.
Fourth article in Error Handling (Background Error Checking or Green mark) series. Read these articles first to maintain continuity.
Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
Green Marks Part 2: Formulas showing wrong results!
Green Marks Part 3: More error handling and Green Marks Part 4: Inconsistent Formulas
In this article, we cover the remaining three types of errors: Unprotected Formula, Formula refers to empty cells and Data Validation Error.