CTRL+Enter to type same formula in a bunch of cells: If you want to have same formula applied to a bunch of different cells, just select them all and type the formula.Bingo, Excel will auto-fill the formula all the way down (as long as there are values in adjacent columns). To do this, just select the formula cell, double-click at bottom-right corner of selection. Corner click to auto-fill: Once you have a formula, chances are you want to fill down that formula for rest of the table / range.This will dramatically speed up your formula writing process. Once the list is small enough, you can use arrow keys (up / down) to pick the function or name you want and press TAB to let Excel type the thing for you.
![data analysis excel 2018 data analysis excel 2018](https://www.fm-magazine.com/content/fmm-home/news/2020/mar/excel-data-analysis-ideas-23189/_jcr_content/article/articleparsys/image.img.png)
![data analysis excel 2018 data analysis excel 2018](https://techbillow.com/wp-content/uploads/2018/11/Data-Analysis-in-Excel.jpg)
Use below tricks to cut the time you spend writing Excel formulas. Writing formulas is a big part of analyst life. So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.
![data analysis excel 2018 data analysis excel 2018](https://i.ytimg.com/vi/mtmrAXwLcuU/maxresdefault.jpg)
We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.