1 / 7

Introduction to Microsoft Excel 2007 - Insert Tab

Introduction to Microsoft Excel 2007 - Insert Tab. Learningcomputer.com. Insert Tab. The Insert Tab will let you add external objects in your workbook  You can insert things pictures, clip art images, smart art graphics, charts, Pivot tables, hyperlinks, header and footer sections, etc.

Audrey
Télécharger la présentation

Introduction to Microsoft Excel 2007 - Insert Tab

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Microsoft Excel 2007 - Insert Tab Learningcomputer.com

  2. Insert Tab • The Insert Tab will let you add external objects in your workbook  • You can insert things pictures, clip art images, smart art graphics, charts, Pivot tables, hyperlinks, header and footer sections, etc. • For our lesson today we will be using my personal budget workbook • I have split my workbook into three sections, income, expenditures and balance

  3. A Chart is worth 1000 data values • When working with any numerical data, you can use charts to give important visual clues. Lets cover different types of Charts • Column and Bar chart are typically used to plot data against categories for example product types, Sales quarters etc. • Line and area charts are useful to show trends or time for example a stock price Chart displayed or time • The pie chart is beneficial in understanding breakdown and allocation of quantity.  This is the one be used for our personal budget • Scatter also known as XY chart are useful in mathematical and scientific settings. They help you understand relation between X and Why values

  4. Personal Budget • We will start of with a 2-D Clustered Column Chart • Next we will switch it to a 3-D Pie Chart • Using Quick Syltes under Design Tab, we will try another one • We will add a title and legend using quick layout • Move chart to a new Excel Sheet • Review Layout options

  5. Insert a Table • Utilizing the table feature, you can: • Sort and filter your data easily • Format portion of your workbook using quick styles command under the table styles group • For the Pivot table we will use • Another Excel sheet Product Sales by Category • Have Category at Vertical Axis • Have Product as the Horizontal Axis • Amount right in the middle

  6. Illustrations Group • Using illustrations group we can insert graphics into Excel workbook • Clip Art is similar in concept so we will not cover that one • Let’s say that we need to insert a picture that portrays budget relevance into our Excel sheet.  • Demo

  7. How about some calculations? • We are going to switch gears do the following: • Sum up all the student scores in column L • Calculate the percentages achieved in column M • Computer the average • After this we will go back to the Number group and change format for: • Percentage column • Averages to two decimal places

More Related