There are so many features for Microsoft Excel. Many features I have used for years and many I just discovered. As a small business owner, I may use Excel differently than say the corporate companies.
Here are three tips in Microsoft Excel that I like to use:
- If you need to have a data transferred from one sheet to another, create the formula on the sheet you want and then click on the other sheet and select the field you wish to use. Excel automatically includes the field in your formula. You can do this with several fields and sheets to get the correct totals you want. Then, press Enter.
- Ctrl +C and Ctrl+V are my favorite. I use them often. Ctrl+C is copy and Ctrl+V is paste. It helps when information needs to be used in several sheets or files.
- “Print Titles” under “Page Layout” allows you to include the header at the top of each page so you do not forget what the columns represent when you print out your pages. After you select “Print Titles” then go “Rows to Repeat” and select the number row or “Column to repeat at left” and select letter column to repeat. Then press ” OK”.
When working with Excel, first think of what you want to use the file for, if it involves numbers or data, Excel is your best bet.
Visit these additional posts to help you with other Microsoft Excel tips.
How to Use Excel: 14 Simple Excel Tips, Tricks, and Shortcuts
20 Tricks That Can Make Anyone An Excel Expert
Please note these are affiliate links through Amazon and at no additional cost to you, I will earn affiliate fees if you decide to make a purchase.