DO NOT copy paste data from browser. Use Power Query.

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

stop copy pasting from browser - by Dr. Nitin Paranjape

Continue reading DO NOT copy paste data from browser. Use Power Query.

What did I learn today? 3D effects for PowerPoint

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

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.

3d effects in PowerPoint by Dr. Nitin Paranjape

Continue reading What did I learn today? 3D effects for PowerPoint

Applied Knowledge: SWOT and PEST analysis (PowerPoint)

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.

image

Continue reading Applied Knowledge: SWOT and PEST analysis (PowerPoint)

High, Medium, Low – visual categories – In-Depth

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.

image

Continue reading High, Medium, Low – visual categories – In-Depth

Show High, Medium, Low values in few clicks

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.

image

Continue reading Show High, Medium, Low values in few clicks

Green Marks Part 5/5 (Background Error Checking in Excel)

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.

image

Continue reading Green Marks Part 5/5 (Background Error Checking in Excel)