INF113 Excel

Seminar Three

This week's topics

This week, we will discuss pie charts, line charts, and what-if tools. Choose one of these topics and discuss how you might use one in your job or within a school project - not including the homework for this class. Remember, any questions that you answer throughout this lecture will count towards your engagement grade.

Pie Charts

There are many reasons for viewing data in a pie chart, such as ways to display percentage or proportional data. You might remember learning fractions (parts of a whole) by viewing a pie chart.


One way that I like pie charts is when I am reviewing my my mutual funds data. When I log into my financial accounts, I like to view how much of my money is invested in small cap vs. large cap vs. real estate vs. international by seeing a colorful pie chart. It is marked with a percentage for each category. Can you think of a way you might use a pie chart?


Generally, experts say that pie charts should contain 6 or fewer categories, otherwise, it may be difficult to view.


For step-by-step directions on how to create a pie chart using your Excel data, view the following instructions: https://support.office.com/en-us/article/Add-a-pie-chart-812dccce-9e44-41c6-9091-225c7c3df3e0

Line Charts

Line charts or line graphs are used to display a series of information. This is a basic type of graph that is used in many fields to display information in different ways.


Two examples that I use this type of graph is for my financial statements. I like to view my earnings/losses over time. I also like to view my consumers power usage by looking at a line graph. I can see how much power was used during each month. This view makes a good comparison.


Can you think of other examples in which a line chart or graph might be used? What are other types of graphs or charts that we can create using Excel? What might those types of charts/graphs be used to display?

Excel's Goal Seek Analysis Tool

What is the Goal Seek tool? When or why should it be used? Can you think of an instance where you might use this feature?


For an explanation and examples of this tool, read the following article written by Susan Harkins http://www.techrepublic.com/article/how-to-use-excels-goal-seek-analysis-tool/


For a different perspective, read the article from Productivity Portfolio: http://www.timeatlas.com/excel-goal-seek/