116943 | Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet | Lesson 4 – Insert and edit objects

Lesson 4 – Insert and edit objects You can insert or copy pictures and clip art into an Excel worksheet or a PowerPoint presentation from many different sources, including downloading from a clip art Web site provider, copying from a Web page, or inserting from a...

116943 | Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet | Lesson 3 – Importing data from an external source

Lesson 3 – Importing data from an external source If you have data from an alternative source, you may be able to import it into Excel 2010 instead of having to re-enter all the information again.  Depending on the type of data you would like to import, you can select...

116943 | Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet | Lesson 2 – Working with Charts

Lesson 2 – Working with Charts A chart is a tool you can use in Excel to communicate your data graphically. Charts allow the audience to see the meaning behind the numbers in the spreadsheet, and they make showing comparisons and trends a lot easier. In this...

116943 | Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet | Lesson 1 – Types of graphs

Lesson 1 – Types of graphs There are a number of graphs in use, but for the purpose of this course we shall limit ourselves to the following; Pie charts Bar graphs Line Scatter graphs Area graphs   Let’s look at each graph one by one; Pie chart  The pie chart is...