Basic Tips & Tricks for Excel

Excel tips and tricks from a business professional/everyday Excel user.

I use Excel everyday at work. Excel can do so many things but I found I only use a small portion of them repeatedly. I shared small tips and tricks on that portion, the parts that make my life easier in this app.

I included here:
- Favorites section where you can save a tip for quick reference in the future.
-Tips and tricks to make your life easier.
-Shortcut section to use Excel faster.
-Formulas section where I included formulas I use often.
-And an extra section on pivot tables to analyze data easier.

I also included how to use tips in Mac when it differs from PC version.

I had inexperienced Excel users in my mind while creating and writing these tips. However, experienced users might find something interesting/useful for them here and there as well.

***I use Excel 2007 at work and I tested all tips I included here on my personal Mac with Excel 2011. However, I did not test them in older or newer versions of Excel.