July 25, 2017

How to Find circular reference in Excel

In Excel, Circular reference warning is received with raised eyebrows and terrified looks most of the time. But from our experience, we know it to be all smoke and no fire, which we will prove to you right here. So what really is a circular reference? It simply means that your formula includes a cell which is...
Read More

Remove Gridlines In Excel – Turn ON/OFF

How to Remove Gridlines in Excel? Or How to add gridlines in excel? It’s a task in itself when we want to print content in Excel. So we tried to hack this task and made it easy for you. [Don’t forget to check the video at the end of the post] Now when I look at this...
Read More

7 formula error in Excel that make you look dumb

In this blog, I will try to help you to debug your Excel Formula. As soon as you will use excel formula, you will likely need to know how to correct the error in excel formula. First of all, we need to know how many types of error, we can get we are applying excel formula...
Read More

Find & Replace – using wildcard Character (*)

This time we’ll talk about “Find and Replace” and we’ll see its importance in the context of data cleaning. In fact, I have to start with the data which is going to illustrate how is this going to be used. For example, if I have a set of names with certain extra data with respect...
Read More

Create Drop Down List in Excel using Conditional Formatting in Excel

Introduction Let’s say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines, conditional formatting provides another way to visualize data and make worksheets easier to understand. Best features of conditional formatting in excel which if coupled...
Read More

Learn how to customized Header & Footer in printing excel sheet

This time under printing setting we will talk about headers and footers. Specially customized header and footer. Let me go to page layout. Under which let me click on the small icon which will lead me to page setup. Let me now access the tab of header & footer. Now there are some predefined templates of header. So one of them says page 1 of 10. The question mark stands for...
Read More

How to print titles and columns on the left in Excel? | Printing in Excel

One of the ignored areas in Excel is how to print a workbook or a worksheet. In this blog, I’ll talk about some of the tips and tricks like how can you make the printing in Excel look easy, better and more functional. Starting with above case study with a raw data which spans over multiple rows. So I have...
Read More

10 Ninja Tips in Excel

Excel Tips We have made this infographic on Top 10 useful Ninja Tips in Excel. A quick reference point for busy professional working on big financial Data models. Take a look at these Excel Shortcuts to improve your efficiency and productivity in excel. Subscribe now and Get a handbook on Excel Tips and Tricks: I...
Read More

How to Automate Mail Merge through VBA in Microsoft Excel | VBA

In this blog, I will try to cover how to get rid of Mail Merge by using the sample Excel VBA code. We all know how to do the mail merge in MS Word. But today I will discuss on mail merge in Excel. The data in your spreadsheet and you want to send the...
Read More