### Working with Excel Sumif Formula

Excel Sumif Formula When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you...

### Realign your data by sorting in Excel | Excel tips and Tricks | Excel shortcut

Realigning 100s of columns without manually Cut/insert columns. Thereby, reducing the task time by minimum 90%. Thus sorting in excel is an important weapon in your hand. Watch this video for a hassle free column realignment and sorting in excel: I hope you have liked our tip on Realign your data by sorting in Excel. Do...

### Working with Excel Date Functions

In this article, let us learn more about Excel date functions and Excel date format. It will help you in areas of calculations such as due dates, project deadline & warranty expiry date. Here is a summary of what we will explain:  How is a date stored in Excel (Hint: Every valid date is a...

### Find circular reference for dummies

What is all that noise about Circular Reference? 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...

### 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...

### 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...

### 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...

### Conditional Formatting in Excel w. Drop-down list based Input

Best features of conditional formatting in excel which if coupled with drop down data validation list gives you wonderful reports. Let me show you an example: In this case, I want to allot divisions to these particular newly joined employees. Whenever I want to select a drop down value which says HFD, it should then get...

### 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...