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. In this tutorial, we learn 3 cool steps to...
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

How to Use Excel VLOOKUP Formula

What is Excel VLOOKUP & How to Use? Excel VLOOKUP is an Excel function to lookup and retrieves data from a specific column in the 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...
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