1 / 35

Day 7: MICROSOFT EXCEL – CHAPTER 10 Cont. MICROSOFT EXCEL – CHAPTER 3

Day 7: MICROSOFT EXCEL – CHAPTER 10 Cont. MICROSOFT EXCEL – CHAPTER 3. Akhila Kondai akhila.kondai@mail.wvu.edu September 08, 2014. Reminder. Homework # 1 is due on September 12 th , 2014, Friday MyITLab Lesson B is due on September 15 th , 2014, Monday

darrel-riggs
Download Presentation

Day 7: MICROSOFT EXCEL – CHAPTER 10 Cont. MICROSOFT EXCEL – CHAPTER 3

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. Day 7:MICROSOFT EXCEL – CHAPTER 10 Cont.MICROSOFT EXCEL – CHAPTER 3 AkhilaKondai akhila.kondai@mail.wvu.edu September 08, 2014

  2. Reminder • Homework # 1 is due on September 12th, 2014, Friday • MyITLab Lesson B is due on September 15th, 2014, Monday • Homework # 2 is due on September 19th, 2014, Friday

  3. Convert Text to Columns • In the imported data, the data may not be structured in a way that meets your needs. • If data is displayed in one column, use the Text to Columns command to separate the data into multiple columns • Convert Text to Columns Wizard guides you through the process of separating data and choosing a delimiting character

  4. Convert Text to Columns

  5. Text Manipulation • Converting text to columns. • Select the cell or range which contains the delimited text • Go to Data ribbon->Data tools->Text to columns • Manipulating Text with functions. • Concatenate Function combines the text =CONCATENATE(text1,text2) • Proper Function capitalizes the first letter in a text string =PROPER(text) • Upper Function converts the text to upper case =UPPER(text) • Lower Function converts all upper case letters to lower case =LOWER(text)

  6. Manipulate Text with Functions

  7. Text Manipulation • Other text functions

  8. Microsoft Excel – Chapter 3.

  9. Chart • Chart gives visual representation of Excel sheet workbook • They allow us to interpret large amount of data easily and quickly.

  10. Chart components • Data Points - A data point is a numeric value that describes a single value on a chart. • Data Series - A data series is a group of related data points. • Category Labels - A category label is text that describes a collection of data points in a chart. • The chart area contains the entire chart and all of its elements. The plot area contains the graphical representation of values in the data series. The X-axis (Category axis) is a horizontal line. The Y-axis (Value axis) is a vertical line.

  11. Chart components

  12. Basic chart types • Pie – Compares parts with the whole • Column – Shows/compares values across different categories • Line charts – Shows trends over time • X-Y Scatter chart – compares pair of values, usually looking for a trend • Other types: Area chart, Stock chart, Surface chart, Doughnut chart, Bubble chart, Radar chart

  13. What they look like Pie Column chart

  14. What they look like.. Line Chart X-Y Scatter plot

  15. Choosing the correct chart type • Choose the chart type that best fits the data • For comparing values from different categories, use • Column, Bar, or Line Chart • For comparing individual values to a whole collection, use • Pie or Doughnut Chart

  16. Creating a Chart • Three main steps to create a chart • Select the Data Source that is the range of cells to chart • Select the chart type • Position and size the chart • You can change the properties of chart using several options available in the LAYOUT ribbon.

  17. Column Chart • A column chart displays data vertically, with each data series forming a column • Go to my lecture notes page, download the ‘majors’ Excel file and open it. • Select the cells A4:A11 and E4:E11 • Insert Tab -> Column chart in Charts section

  18. Clustered Column Chart • Groups or clusters similar data in columns to compare values across categories. • Select the cells A4:E11 • Insert Tab -> Column chart in Charts section (Clustered column chart) • Legendis a key that identifies color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

  19. Stacked Column Chart • Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. • Select the cells A4:E11 • Insert Tab -> Column chart in Charts section (Stacked column chart) • Right click on the chart and select “Select Data” and click “ Switch row/columns ”

  20. 100% Stacked Column Chart • Compares the percentage that each data point contributes to the total for each category. • Select the cells A4:E11 • Insert Tab -> Column chart in Charts section (100% Stacked column chart) • Right click on the chart and select “Select Data” and click “ Switch row/columns ”

  21. Bar Chart • Bar chart compares values across categories using horizontal bars. • Width of the bar indicates its value. • Create a Bar Chart for the given Majors work sheet

  22. Line Chart • Line chart uses a line to connect data points in order to show trends over a period of time. • Different color for each data series. • Create a Line Chart for the given Majors work sheet.

  23. Pie Chart • Pie chart shows each data point in proportion to the whole data series as a slice in a circular pie. • To create a pie chart for 2012, Select the cells A4:A11 and E4:E11 • Insert Tab -> Pie chart in Charts section

  24. Separating Parts of Pie (Exploding Pie) • Single Part Separation/Explosion • Make two slow clicks on one of the pieces • Left click and drag it outward • Full chart explosion/Separation • Make sure nothing is selected • Hold down the left button on one of the pieces and drag it outward

  25. Changing the Chart Type • Click the Design tab • Click Change Chart Type in the Type section • Select the desired chart type and click OK • For example you can change a stacked column chart to 100% stacked column chart

  26. Changing the Data Source

  27. Moving a Chart • To move a chart: • Click the Design tab • Click Move Chart under the Location group

  28. Printing a Chart • To print an embedded chart: • Select the chart • Click the File tab • Click Print to display the Backstage view • Use the Print Selected Chart option • To print a chart sheet: • Use the Print Active Sheet option

  29. Creating a Sparkline • A Sparkline is a miniature chart displayed in a single cell • To create a sparkline • Click the Insert Tab • Click Line, Column, or Win/Loss in the Sparklines group.

  30. Customizing Chart Labels • A chart title is the label that describes the entire chart • An axis title is a label that describes either the category or value axis • A legend is used to distinguish data points in a pie chart or data series in a multiple series chart • A data label is the value or name of a data point • A data table is a grid that contains the data source values and labels.

  31. Axes and Gridlines • Based on the data source values, Excel computes starting, ending, and incremental values for display on the value axis. • A gridline is a horizontal or vertical line through the plot area.

  32. Adding a Trendline • A trendline is a line used to depict trends and forecast future data.

  33. Trendlines • Trend Types • Linear • Exponential • Logarithmic • Polynomial • Power etc.,. • Forecast • R-Squared Value

  34. Next Class • Working with Tables and Worksheets. • Homework # 1 overview

  35. Questions ?

More Related