Posts in Tutorials

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines, […]

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. Learn how to use PowerPoint graphs based on real-life cases: Situation: A senior level […]

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 […]

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.

Working with Excel 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.

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.

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 […]

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.

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:

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 […]