In order to deal with tons of data, we can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked.

Here are some useful Excel spreadsheet secrets we may not know.

1. Use tables to format data quickly

• Excel Tables are an incredibly powerful way to handle a bunch of related data. 
• Just select any cell within the data and press CTRL+T and then Enter. 
• And bingo, our data looks slick in no time. 

2. Change colors in a snap

• So we have made a spreadsheet model or dashboard. And we want to change colors to something fresh. 
• Just go to the Page Layout ribbon and choose a color scheme from the Colors box on the top left. 
• We can also define our own color schemes. 
• What's more, we can even define schemes for fonts or combine both and create a new theme.

3. Use cell styles

• Consistency is an important aspect of formatting. By using cell styles, we can ensure that all similar information in our workbook is formatted in the same way.

For example, we can color all input cells in orange color, all notes in light gray, etc.

To apply cell styles, just select all the cells you want to have the same style and from the Home ribbon, select the style you want (from the styles area).\

4. Use the format painter

• Format painter is a beautiful tool part of all Office programs. We can use this to copy formatting from one area to another. 
• See the below demo to understand how this works. 
• We can locate the format painter in the Home ribbon, top left.

5. Clear formats in a click

Sometimes, we just want to start with a clean slate.

Simple, just select all the cells, and go to Home > Clear > Clear Formats.

 And we will have only values left so that we can format everything the way we want.