Please note: This item is from our archives and was published in 2019. It is provided for historical reference. The content may be out of date and links may no longer function. Editor’s note: As the ...

If you want to be a master at Microsoft Excel then one of the things you must know are keyboard shortcuts. Not all of them, but mostly the best or more important ones. A lot of Excel users take ...

Excel can be a time sink. If you are tired of wrestling with VLOOKUPs, filtering data, and text manipulation, it’s time to ...

Typing entire expressions from the keyboard is tedious. Instead, use these 9 shortcuts to enter and work with expressions more efficiently. Most of us spend a lot of time entering expressions–they’re ...

You can sum up entire columns or rows in Microsoft Excel using the AutoSum feature. The AutoSum tool automatically selects a column or row of numbers, but you can select any set of numbers by clicking ...

Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as a basic tool for adding numbers, but what if I told you it could do so much more?

1. The SUM function. Pressing Alt+= in the cell below a column of numbers inserts the SUM function and highlights that column of numbers. 2. Select a range of data. Pressing Ctrl+A inside a range of ...