Day

April 12, 2017

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

How to lock cells in excel? while 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...
Read More

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 VLOOKUP Formula Excel

What is Excel VLOOKUP? 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 learn all this in...
Read More

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. There is three...
Read More

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

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 mesmerized by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides. The following picture...
Read More

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: 1. MS Excel Shortcut for Copying and Moving: Excel has a unique feature hidden somewhere in the “Paste Special” column which many people don’t know about. Values can be added, subtracted,...
Read More

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

Create report in excel using Pivot Table Techniques

Create a report in excel using pivot table 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...
Read More

20 Excel Shortcuts Keys For Beginners Using Keyboard 2017

Excel Shortcut Keys For Beginners When starting with Microsoft Excel, knowing a few excel shortcuts will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are a few shortcuts to use when you just begin working with Microsoft Excel. These...
Read More
Tips to create Sparkline: Creating a Miniature Chart in a Cell
December 18, 2017
How to create a Pivot Table in Excel
December 18, 2017
Tricks to create Hyperlink in Excel
December 6, 2017
How to Calculate Profit margin in Excel
December 6, 2017
How to Calculate a Percentage Increase in Excel
November 30, 2017
How to add Error Bars in Excel: Standard Deviation
November 30, 2017
How to convert invalid date formats into valid data formats?
November 29, 2017
Converting trailing minus sign into negative numbers. (Text to Column)
November 29, 2017
Text to Columns in Excel | Transfer Single Columnar Data into Multiple Columns.
November 29, 2017
4Excelshorcuts-workingwithformulas
Working with Excel Formula Shortcuts | Excel tips & tricks
September 27, 2017
Top 10 keyboard shortcuts that will help you master Microsoft Excel
September 26, 2017
freeze-panes-excel
Freeze row and column in Excel “How to”
August 26, 2017
How to Copy Text from Image
Copy Text from Image Using Microsoft OneNote
August 17, 2017
Excel VBA Macro Tutorial | What is VBA Macros in Microsoft Excel ?
July 26, 2017
online-courses
Improve Office Productivity with Online Courses
July 26, 2017
Add APA Page number in MS Word with 3 Easy Steps
July 26, 2017
googlecalneder
4 Super Productive Google Calendar Hacks
July 26, 2017
Chrome and Excel Shortcuts
July 26, 2017
Finalnancial
Create Financial Models For Business
July 26, 2017
Microsoft Excel Go To Data Cleaning Trick
July 26, 2017