Math Student Help

Check us out at http://noobtoob.com/forum

NooBTooB is a weekly independent gaming podcast for casual and serious gamers alike. This week Tobin and Yuzo talk about:

* Geometry Wars: Galaxies
* Master of Illusion
* Gears of War
* Link’s Crossbow Training
* Ghost Squad
* Pain
* Trauma Center: New Blood

And preview next week’s games:

* DDR Universe 2
* Jenga
* Yu-Gi-Oh World Championship 2008
* Julie Finds a Way

Come join the forums at http://noobtoob.com

If you crave a higher quality Noobtoob video, come check out our high res video on iTunes by clicking here:

http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=212269308

Or download high res episodes directly by going here:

http://noobtoob.com/vodcasts/mobile/

Duration : 0:59:39

(more…)

To use the consolidate feature in Excel 2007 click on the data tab and then select consolidate. You can consolidate or summarize data from multiple worksheets in the same workbook or different workbooks. You can consolidate, for example, the sales figures of all your branches whose data you have kept in different worksheets. You can use the consolidate feature to summarize the salaries of your employees over a year. You can not only add data but you can also use functions like max, min, average, etc with the consolidate function.

Duration : 0:2:38

(more…)

Userforms make data entry moe intuitive. The coding for transfer of data from the userform to the Excel worksheet is easy to learn. The code for the ‘AddData’ button is reproducd here for your ready reference. For more details you can log on to familycomputerclub.com.

Dim eRow As Long
Dim ws As Worksheet
Set ws = Worksheets(”data”)

‘find first empty row in database
eRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

‘check for a name
If Trim(Me.txtName.Value) = “” Then
Me.txtPart.SetFocus
MsgBox “Please enter a name”
Exit Sub
End If

‘copy the data to the database
ws.Cells(eRow, 1).Value = Me.txtName.Value
ws.Cells(eRow, 2).Value = Me.txtSalary.Value
ws.Cells(eRow, 3).Value = Me.txtHRA.Value
ws.Cells(eRow, 4).Value = Me.txtPF.Value
ws.Cells(eRow,5).Value=Me.txtMed.Value
ws.Cells(eRow,6).Value=Me.txtPkg.Value

‘clear the data
Me.txtName.Value = “”
Me.txtSalary.Value = “”
Me.txtHRA.Value = “”
Me.txtPF.Value = “”
Me.txtMed.Value=”"
Me.txtPkg.Value = “”
Me.txtName.SetFocus

Duration : 0:3:21

(more…)

in Vectorworks 2009 you can drag worksheet columns to re-order them. It used to be easier to re-create the worksheet rather than try to re-order the columns. with Vectorworks 2009 you can drag the worksheet columns to get the order you want.

Duration : 0:0:44

(more…)

See more Excel 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks.
Watch the demo to see how fast you can insert and delete individual or multiple rows, columns, cells, and worksheets.

Duration : 0:3:44

(more…)

Another interesting method to access cells when writing VBA macro code in the Visual Basic Editor. Accessing cells using the ‘cells’ property has major advantages when using ‘do while’ and ‘for… next’ loops.

Duration : 0:2:56

(more…)