How to Use Excel like a Pro
Part 1 on below link
• Use Excel In PROFESSIO...
6. Split up text information between columns.
7. Use these formulas for simple calculations.
• To add, use the + sign.
• To subtract, use the - sign.
• To multiply, use the * sign.
• To divide, use the / sign.
8. Get the average of numbers in your cells.
=AVERAGE(Cell1:Cell2).
9. Use conditional formatting to make cells automatically change color based on data.
10. Use IF Excel formula to automate certain Excel functions.