fbpx

Day

December 12, 2019

Learn How to Create Index Column Using Power Query

There is one more interesting feature of Power Query where it lets you add an index column that serves as a row counter to your data. Power Query Helps To Create Index Column Let’s go through the steps in detail with an example. Our sample data consists of Months and revenue data as shown in the...
Read More

How to Display Formulas in Excel

If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells instead of the result. This Excel Trick will help you to Display Formulas in Excel without any...
Read More

How to do Duplicate Columns in Power Query

You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have columns that you want to duplicate & make some temporary/permanent alterations to it in the Power Query Editor but not to your source data. Duplicate Columns Using The Power Query Editor Suppose you...
Read More

How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Protech formula in Excel? Confused? Here is the blog to know how to lock excel formulas. Imagine Your boss wants you to protect a workbook, but she also wants to be able to change a few cells after you are done. So, before you password protected the workbook (or...
Read More

Excel Security | How to lock cells in excel

How to Keep my excel secured? Excel Security To lock cells 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...
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 a pivot table for sales data analysis is an important aspect of any business. Unless you are able to measure and analyze 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...
Read More

MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys 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....
Read More