How to enable Error Checking in Excel

How to enable Error Checking in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click “File”
  3. Click “Options”
  4. In the “Excel Options” box, click the “Formulas” tab
  5. Under “Error Checking”, check “Enable background error checking”
  6. Click “OK”

How to insert a SmartArt graphics and add text to it in Excel

How to insert a SmartArt graphics and add text to it in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click the “Insert” tab
  3. Go to the “Illustrations” group
  4. Click “SmartArt”
  5. In the “Choose a SmartArt Graphic” box, click the “type” that you want
  6. In the “Choose a SmartArt Graphic” box, click the “layout” that you want
  7. Click “OK”
  8. Click “Arrow Control” on the left side of the SmartArt graphic, if text pane is not visible
  9. Click [Text] in the Text pane and then type your text   
  10. Repeat the same for all text panes
  11. You have successfully inserted a SmartArt graphic and added text to it

How to insert threaded comments for discussions in Excel

How to insert threaded comments for discussions in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select a cell
  3. Right-click the cell and then click “New Comment”
  4. Type your comment in the textbox
  5. Click the “Post button” (or press Ctrl+Enter)
  6. You have successfully inserted threaded comment for discussions in Excel

How to change chart style of a Map Chart in Excel

How to change chart style of a Map Chart in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select the “Map”
  3. Go to the “Design” tab in the “Chart Tools” ribbon tab
  4. Go to the “Chart Styles” group
  5. Select a chart style from available ones
  6. You have successfully changed the chart style of a Map Chart in Excel

How to create a Bar chart in Excel

How to create a Bar chart in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select the data for the chart
  3. Click the “Insert” tab
  4. Click on this icon’s dropdown button
  5. Select any “2-D Bar” or “3-D Bar” chart from available ones
  6. You have successfully created a Bar chart in Excel