Excel Yogi

29/10/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

Even after its inception 33 years back, Microsoft Excel remains the most powerful and widely used business software. Unfortunately, even after so many years, the full capabilities of Excel are still poorly understood. In this new series of blog, distributed across 5 articles, Excel yogi brings you t...

29/10/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

Continuing our series of 1o most useful excel tips, today we are going to learn Flash Fill and Fill Formula/Values. Let’s get started! 1. Flash Fill 2013 onwards, Excel developed a mind of its own where it started filling the information you otherwise would have typed in, automatically. For exampl...

29/10/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

In this third batch of 10 most useful Excel tips, we are going to learn about – 1. Print, 2. Absolute Reference 1. Print Optimization Clicking on File -> Print gives you a variety of options that can help you print the data just how you wanted. You can – Choose to print the active sheet or the e...

29/10/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

Today we will learn about Adding rows and paste special features of Excel. 1. Adding multiple rows Adding rows or columns to the existing data is one of the most frequent tasks that we do. To insert multiple rows or columns at a time, simply select the number of rows or columns that you want to inse...

29/10/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

In this last batch, we will learn about- 1. Conditional Formatting, 2. Pivot Tables 1. Conditional formatting Making sense out of huge data can be a difficult task. Pictorial representation of data is easier to comprehend than simple numbers. Conditional formatting is one of such tools in Excel that...

28/09/2020

28/09/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

It is important that the inputs received / entered by these users are monitored and validated

28/09/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

The formatting that is based on condition (s) is called conditional formatting.

28/09/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

The excel file you work on can get loaded with lot of worksheets making it difficult to navigate through the sheets

28/09/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

How about hiding just a little section of data you want to hide, but you still want to be able to work with

28/09/2020

For more such tips, visit and subscribe to -
www.excelyogi.net

we all know that Excel can easily convert a number to percent by changing the format of the cell. The problem is, it will convert 1 to 100%