Posts by yoda

Advanced Charts

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

May 11th, 2017 Posted by Tutorials 0 thoughts on “I saved a board meeting…using Powerpoint Graphs | Powerpoint tips”

One day I received a call from one of my client companies (a prominent non-banking financial service,) which receive applications for loans and processes it for further action – approved & disbursed vs. rejected. Read along know what you can do with powerpoint graphs.

Situation: A senior level meeting had been called and they had to quickly assemble a PowerPoint deck. One of the hurdles were that some of the key performance factors, when put into powerpoint graphs were not showing any meaningful information or trend.

Complication: The same chart type had been used in the last meeting and it was pointed by the Senior Management that it wasn’t satisfactory.

powerpoint graphs

picture 1 : Simple bar powerpoint graphs- which is boring

Question: How can we present 3 variables of one scale and 2 variables of another scale without cluttering the slide and losing the essence of the data?

Variable Set 1 – Logins (no. of accounts), No. of Files Approved & No. of Files Disbursed.

Variable Set 2 – Loan Approved (Value) & Loan Disbursed (Value).

Answer:  Finally, I used the combination of Thermometer Chart with line graph (markers only) on primary axis for Set 1. For set 2 I used simple line graph on the secondary axis. This is how it looked.

powerpoint graphs

Picture 2: The powerpoint graphs which I used

powerpoint graphs

picture 3: The smart and changed powerpoint graphs

Summary: The bosses were delighted to see some fresh look. The trend was noticeable and clear. I was happier :). Powerpoint Graphs , when used right can work wonders for you and also for your boss.

You can learn all this and more from our newly launched “PowerPoint Graphs Ninja” online program. Click here to know more about benefits course.

NB – I wrote the post in SCQA format – Situation, Complication, Question, Answer. It’s one of the ways to draft a report.

Want to know more about our other extremely effortless programs go through the following blogs.

Advanced Excel Courses

Excel Security | How to lock cells in excel | Protect Sheet

April 12th, 2017 Posted by Tutorials 0 thoughts on “Excel Security | How to lock cells in excel | Protect Sheet”

Maintaining the integrity of an excel file that has to be shared with peers is a challenging job. Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy to crack. However, the latest versions have fortified the security and password features to protect your file from external attacks and alterations.
(more…)

How to make original Good-looking Presentation slides

April 12th, 2017 Posted by Tutorials 0 thoughts on “How to make original Good-looking Presentation slides”

Guide to make original Good-looking Presentation slides

Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides. (more…)

Working with VLOOKUP Formula

April 12th, 2017 Posted by Tutorials 0 thoughts on “Working with VLOOKUP Formula”

Today, I have noticed every Professional working with Microsoft Excel using Vlookup formula. What I have experienced while interacting with my workshop participants is that they could tremendously magnify its application power if they learn two associated techniques of VLookup.

(more…)

Excel Dashboard using What-if Analysis, Indirect Function & more

April 12th, 2017 Posted by Tutorials 0 thoughts on “Excel Dashboard using What-if Analysis, Indirect Function & more”

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. (more…)

Working with Excel INDEX Formula

April 12th, 2017 Posted by Tutorials 0 thoughts on “Working with Excel INDEX Formula”

Excel Index is probably one of the most favourite Excel formulae of many. In my previous post, I had mentioned about my favourite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer to be either VLOOKUP() formula or INDEX() or MATCH().

(more…)

Create Magnifier Glass Effect in Powerpoint Picture

April 12th, 2017 Posted by Tutorials 0 thoughts on “Create Magnifier Glass Effect in Powerpoint Picture”

I frequently visit “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerised by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides.
(more…)

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

April 12th, 2017 Posted by Tutorials 0 thoughts on “Drag and Drop: 5 Simple MS Excel Shortcuts that really Work”

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts:

(more…)

PowerPoint Tips on converting text to graphics using Smartart

April 12th, 2017 Posted by Tutorials 0 thoughts on “PowerPoint Tips on converting text to graphics using Smartart”

MS Word & PowerPoint Tips on how to convert a simple ordered or unordered List like converting text to graphics.

Microsoft Word & PowerPoint has built-in shapes and designs in SmartArt Tool which can be used directly; while preparing project report or presentation you may need to design some charts, lists, graphs, shapes etc. In order to meet the standard of good reports, use of ms word or powerpoint SmartArt is a must.

(more…)

Create a report in excel for sales data analysis using Pivot Table Techniques

April 12th, 2017 Posted by Tutorials 0 thoughts on “Create a report in excel for sales data analysis using Pivot Table Techniques”

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the next level. (more…)

error: Content is protected !!