Excel for Business

 

Read the article Using Excel for Business 10 tips (Links to an external site.)Links to an external site.. Next, you will choose 4 of the 10 tips and summarize, in a paragraph for each tip, how they can increase a business’s productivity. Lastly, you will create a spreadsheet that demonstrates how to properly use the 4 tips you summarized.

Note: A paragraph is considered at least 7 sentences.

1. Audit tool bar. 

2. Quickly sum up numbers. 

3. Auto fill series. 

4. Freezing highlighted panes. 

5. Conditional formatting.  

6. Pivot Tables. 

7. Change the name of the "Sheet" page.  

8. Keyboard shortcuts 

9. The new Sparkline feature,  

10. Text to columns