April 12, 2017

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.
Read More

How to Use Excel VLOOKUP Formula

What is Excel VLOOKUP & How to Use? Excel VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching. The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right. you will...
Read More

What-if Analysis using Excel Dashboard, Indirect Function

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. Before we start...
Read More

INDEX Formula in Excel

Excel Index Formula is probably one of the most favorite Excel Formulae of many. In my previous post, I had mentioned about my favorite 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...
Read More