Our customized Excel training courses are designed to help you to be a comfortable Microsoft Excel user at any level.
Now learn Excel and other courses @hourly payments starting as low as ₹100.
29/10/2020
For more such tips, visit and subscribe to -
www.excelyogi.net
10 Most Useful Excel Tips – Part 1 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
10 Most Useful Excel Tips – Part 2 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
10 Most Useful Excel Tips – Part 3 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
10 Most Useful Excel Tips – Part 4 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
10 Most Useful Excel Tips – Part 5 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
For more such tips, visit and subscribe to -
www.excelyogi.net
Validate User Input 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
Excel’s Conditional Formatting 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
Hide Worksheets 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
Make Data Invisible 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
Formulas with Paste Special 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%