- Business Analysis. The number 1 use of MS Excel in the workplace is to do business analysis.
- People Management.
- Managing Operations.
- Performance Reporting.
- Office Administration.
- Strategic Analysis.
- Project Management.
- Managing Programs.
What are the 5 functions in Excel?
- VLookup Formula.
- Concatenate Formula.
- Text to Columns.
- Remove Duplicates.
- Pivot Tables.
How do you get Excel to read out loud?
- Select a group of cells to that you want to hear as audible speech.
- Choose how the computer will read back your data by clicking By Rows or By Columns .
- Click Speak Cells .
- To correct an error, click Stop Speaking , and then use your mouse and keyboard to make the necessary changes.
How do you add voice in Excel?
- Position the insertion point where you want the message inserted.
- Choose Object from the Insert menu.
- Make sure the Create New tab is selected.
- In the list of object types, look for a type of sound object.
- Click on OK.
- Use the Sound Recorder to record your message.
How do I write a formula in Excel?
https://www.youtube.com/watch?v=qqU2xllewk4
How do I enter a formula in a cell in Excel?
- On the worksheet, click the cell in which you want to enter the formula.
- Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1. Notes:
- Press Enter (Windows) or Return (Mac).