Microsoft Excel Tutorial

Quickly Navigate around Microsoft Excel

This tutorial shows us how to create a spreadsheet using quick navigating tips in Microsoft Excel. First, it shows how to use name box to move to different location on the spreadsheet. It also shows how to get back home to the beginning of the spreadsheet that is by clicking on the CTRL +Home on the keyboard. Finally it shows how to use the drop down box on the name box to get to different location on the spreadsheet. (http://www.youtube.com/watch?v=JsKeKBYGvr4)

Using the IF Formulas

This tutorial shows how to use the IF formulas to create a spreadsheet for children who need to have permission and those who don’t have to have, to attend a field trips. First he use the IF formula to determine the result of the children who need permission and those who don’t =if (c >17 “no,” “yes,”). This tutorial also use IF formula to determine the sex of the children =if (b2 = “m” then b).Finally it show how to determine the total cost of the field trip using IF formula =if (g2<_ 20="" 60="" http:="" o="" then="" v="RgJyIBEGwHA0)<br" watch="" www.youtube.com="">
How to use the Auto fill function in Excel

This tutorial shows how to use the Auto fill function. First the tutorial stated that the Auto fill function in Excel works by putting the cursor on the bottom right corner until it changes to a box, secondly, then drag the box all the way across the column you want to Auto fill. (http://www.youtube.com/watch?v=wR83UoSJtMg)

Using the Repeat (Rept) function

This tutorial shows how to compare data by using the Repeat function. First the tutorial stated that by typing in = rept (“,” C2) and press enter you will see the comparison between data (which is identify by asterisk) or secondly type * instead of “,”to get the comparison between data (which is identify by o’s). (http://www.youtube.com/watch?v=T-L_pXrngU0)

Payment Function in Excel

This tutorial shows how to use the payment function to find out the monthly payment and total cost for an item. Fist the tutorial show how to find the payment function that is by going to insert function, then click on the dialogue box and then search for the payment function and then typing the necessary requirement or you could type = pmt(rate, nper, pv,(fv),) on the spreadsheet to find the monthly payment and the total cost. (http://www.youtube.com/watch?v=r9cBgkhbcxI)

Microsoft Excel Tutorial over view

This tutorial show how, to create a simple spreadsheet in Microsoft excel. In this tutorial it creates a spreadsheet for three food items for the month of January- March, with the cost of each item. After which he calculate the total cost for each month. Finally it also shows how to add different type of chart and color to the spreadsheet. (http://www.youtube.com/watch?v=8L1OVkw2ZQ8)


Microsoft Excel Tutorial Beginner’s – Get Started

This tutorial shows how to enter data in a spreadsheet, how to edit this data and how to change columns width of a spreadsheet .Finally it shows how to save the spreadsheet. (http://www.youtube.com/watch?v=lJqfZw5j2R0)

Creating a Seating Chart

This tutorial shows how to create Seating Chart and diagrams and how to add colour to it. It also shows how, to add data to each of the column in the seating chart. It also shows how to create outline for this chart and how to add different pictures and object to it. Finally it shows how to print the Seating Chart. (http://www.youtube.com/watch?v=IVuhpsqW81Q)

Excel as Database

This tutorial show how to use Microsoft as a Database, it shows how to format these information. Finally it shows how to add rows and column to the data and how to filter the information in each row. (http://www.youtube.com/watch?v=5gCyIdagkyQ.)

Making a Gantt chart in Excel 2007

This tutorial shows how to make a Gantt chart. It also shows how to add series to the Gantt chart and also how to modify, format and make adjustment to the chart. (http://www.youtube.com/watch?v=HQwE0Xv1lAA)