Excel Tutorial Video (ETV)

Concatenate Implementation

2008-08-01T03:19:00.000-07:00

In this post, you will see guidance how to apply concatenate function.

Because animation picture are a little big (800kb), so you must click Readmore link below. It will directing you to full post.

Click button below to play the video:

Last name formula (to extract last name from full name):
=LEFT(A18,FIND(",",A18,1)-1)

First name formula (to extract first name from full name):
=MID(A18,FIND(",",A18,1)+1,LEN(A18)-FIND(",",A18,1))

Couple name formula (to join both first name with same last name):
=IF(B18=B19,CONCATENATE(C18," & ",C19, " ",B18),"")

Lock Cells with Button and Macro

2008-08-01T01:23:00.000-07:00

In this post, you will see guidance how to lock cells using button control panel and macro.

Because animation picture are a little big (600kb), so you must click Readmore link below. It will directing you to full post.

The code are: (from Jim Gordon)

Sub LockemUp()
' LockemUp Macro
' Macro recorded 7/30/2008
Cells.Select
Selection.Locked = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

Using Percent

2008-07-31T21:16:00.000-07:00

Find Inverse Matrix

2008-07-30T22:55:00.000-07:00

You know, calculate inverse matrix need hard work. Specially for matrix with wider than 3 dimension. So we do not need manually calculate it by pen. Just using Excel. Simple and Fast ;)

See Below:

Adding Quick Access Button (Excel 2007)

2008-07-28T20:35:00.000-07:00

Minimize Ribbon (Excel 2007)

2008-07-27T20:31:00.000-07:00

Sometime we dont neet to see ribbon to make us see larger view of cell.