Ch.3--"Powerpoint was created for.."

Microsoft Powerpoint was developed to help businessmen create presentations that are more appealing to their associates. It lays out information in a neat, yet productive way. Today Powerpoint is used by not only businessmen, but also students, teachers and trainers. When making Powerpoint the developers had to think of what a business presentation needs to get its’ point across. They had to make feature for tables, graphs, organizational charts and drawing objects. All of these things enhance a presentation. The developers also needed ways for things to be typed in easily without constantly making text boxes. That set them off with slide design all the way to animation schemes.

Ch.2--"Slide Master in Powerpoint"

The slide master feature on Microsoft Powerpoint is very useful. It is the master slide for slides that share the same layout as that master one. In the master slide you can change things like font, size, alignment or background and Powerpoint will automatically adjust all of the slides that have that same layout. Working with the master slide feature will give your Powerpoint a consistent look. This is very helpful when you are dealing with a slide show that is long. It can format all sorts of things for slides at once.

Ch.1--"View Micrsoft Powerpoint

Microsoft Powerpoint allows you to view your presentation in several different ways. One such way is the Notes Page view. It shows the each slide as separate things and underneath the slide is room for notes. These notes can be helpful because you can put possible additions to the slide. It can be helpful if you had someone else go over your powerpoint because you can type what you were thinking when you created the slideshow. Those notes will allow that other person to understand where you were coming from.

Ch.20--"Lookup and Forecast Functions along with XML workbooks"

The final chapter of advanced Excel talks about using formulas such as Lookup and Forecast. It also includes working with XML workbooks. The lookup formula finds data that already exists according to what you put as the table array and puts it where you want. The forecast feature will forecast data for you according to the other numbers in you worksheet. It works sort of like a linear regression because it will predict an outcome. To make a XML workbook all you do is when you save it you go to save as type: XML file. This will allow you to open up that workbook with something like Internet Explorer and you can make changes to it also. This can all go on while you have the workbook open in Excel.

The first project wants you to make a XML spreadsheet and make changes to it when it is open in Internet Explorer. All I did was save it on my drive and opened it with internet explorer and made the changes it wanted me to make. The second project wants you to use the forecast function to predict the number of refrigerator mechanics needed. Then it wants you to create a bar chart of the predicted data. To create a quick bar chart highlight the predicted table and hit F11. Then it wants you to add a linear trendline to the graph. To add one you go to chart and then add trendline.

The activity wants you to use the lookup feature in order to report the incentive pay for each program manager. To make the function work easier you should name the Total Project Completion in Dollars range, Project_Dollars and the Incentive table range Incentive_Table. Now when you use the lookup function put Project_Dollars for lookup value and Incentive_Table for table array.