How to Use Excel: 14 Simple Excel Tips, Tricks, and Shortcuts

Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I’d ever need to do manually can be done automatically. Need to merge two sheets with similar data? Excel can do it. Need to do simple math? Excel can do it. Need to combine information in multiple cells? Excel can do it.

 

If you encounter a situation where you need to manually update your data, you’re probably missing out on a formula that can do it for you. Before spending hours and hours counting cells or copying and pasting data, look for a quick fix on Excel — you’ll likely find one.

 

In the spirit of working more efficiently and avoiding tedious, manual work, here are a few Excel tricks to get you started with how to use Excel. (And to all the Harry Potter fans out there … you’re welcome in advance.)

 

Continue reading this article here: https://blog.hubspot.com/marketing/how-to-use-excel-tips