Math Student Help

J.B. needs to create a new worksheet for every customer listed on the summary worksheet. He asks if there is an Insert Worksheets command. While there isn’t, you can create one with a few lines of VBA code. Episode 730 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Duration : 0:3:27

(more…)

This lesson takes you through the basic process of subtraction in Excel. It is advisable to enlarge the screen to fullscreen size in order to see the workings of Excel properly.

Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.

Duration : 0:1:28

(more…)

Rather than create an invoice worksheet from scratch, download a free one from Office Online. Episode 742 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Duration : 0:2:8

(more…)

How to delete and rename worksheets in Microsoft Excel; learn more about spreadsheet software in this free instructional video.

Expert: Gary Zier
Bio: Gary Zier, originally from Florida, is a systems administrator with 10 years of computer networking experience and an expertise in conditional access security systems.
Filmmaker: Gary Zier

Duration : 0:1:52

(more…)

http://www.TeachExcel.com
How to protect a worksheet and workbook in excel. This will prevent unauthorized people from editing, deleting, or changing data in excel.

Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:

http://www.TeachExcel.com

Duration : 0:7:44

(more…)

James asks how he can combine data from all rows of all worksheets into a single worksheet. 11 Lines of VBA code will do the trick. Episode 636 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Duration : 0:4:29

(more…)

See how to create a hyperlink from one sheet to another sheet in the same workbook.

Duration : 0:3:0

(more…)

See how to Copy or Export only visible Excel worksheet data retaining all formulas, subtotals and worksheet formatting and deleting all hidden rows and hidden columns.

Duration : 0:6:34

(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…)