1-866-245-5224 sales@keystonelearning.com

PowerPoint 2007: Inserting a Microsoft Excel Table

PowerPoint 2007: Inserting a Microsoft Excel Table

So far, the tables you’ve been able to create have to nice to look at, but not very functional. However, because we’re dealing with a Microsoft product (PowerPoint), we can tap into a sibling – Excel.

Microsoft Excel is a powerful spreadsheet program that comes with Microsoft Office. And, by inserting an Excel table into PowerPoint, you get access to all kinds of Excel features including number formatting, Sort & Filter and calculations.

So, if you’re looking to insert a table into your presentation that contains totals or other calculations, inserting an Excel table as opposed to a PowerPoint table is definitely the way to go.

Figure 17. Microsoft Excel Home Tab

Inserting a Microsoft Excel Table

     
  1. Choose the Table command in the Tables group on the Insert tab
     
  2.  
  3.  Choose Excel Spreadsheet
     

Resizing a Microsoft Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Position your mouse on a selection handle
     
  4.  
  5. Click and drag to the desired size
     


Editing a Microsoft Excel Table

There are several ways you can edit a table including inserting rows and columns and formatting a table.

Figure 18. Cells Group on the Excel Home Tab

Inserting a Row into an Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside your table in a cell below where your new row should appear
     
  4.  
  5. Choose the Insert command in the Cells group on the Excel Home Tab
     
  6.  
  7. Choose Insert Sheet Rows
     

Deleting a Row into an Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside your table in the row you want to delete
     
  4.  
  5. Choose the Delete command in the Cells group on the Excel Home Tab
     
  6.  
  7. Choose Delete Sheet Rows
     

Inserting a Column into an Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside your table in a cell to the right of where your new column should appear
     
  4.  
  5. Choose the Insert command in the Cells group on the Excel Home Tab
     
  6.  
  7. Choose Insert Column Rows
     

Deleting a Column into an Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside your table in the column you want to delete
     
  4.  
  5. Choose the Delete command in the Cells group on the Excel Home Tab
     
  6.  
  7. Choose Delete Sheet Columns
     

Sorting a Microsoft Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside the column you want to sort your table by
     
  4.  
  5.  Choose the Sort & Filter command in the Editing group on the Home tab
     
  6.  
  7. Click Sort A to Z or Sort Z to A
     

Creating a Calculation in a Microsoft Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside the cell that your formula will go in
     
  4.  
  5.  Choose the AutoSum command in the Editing group on the Home tab
     
  6.  
  7. Choose your formula function
     
  8.  
  9. Verify the formula is correct
     
  10.  
  11. Press [Enter]
     

Deleting a Microsoft Excel Table

     
  1. Click the outside of your Excel Table to select the table
     
  2.  
  3. Press [Delete]