Ada beberapa fungsi logika dalam microsoft excel. beberapa diantaranya adalah 
And | Countblank | Countif | If | Large | Max | Min | Not | Or | Small | Sumif | Vlookup----------------------------

And
What is the use of And formula?
Checks whether all conditions are passed or not

Syntax of And formula:
and(list of conditions)

Examples of Excel And formula:
and(true, false) = false
and(true, true) = true
----------------------------

Countblank
What is the use of Countblank formula?
Counts blank cells in a given list

Syntax of Countblank formula:
countblank(in this list)

Examples of Excel Countblank formula:
countblank(list) = number of blank cells in the list
----------------------------

Countif
What is the use of Countif formula?
Counts of items in a list matching a condition

Syntax of Countif formula:
countif(in this range, values meeting this criteria)

Examples of Excel Countif formula:
countif(A1:A20, 1) = counts how many cells have "1"
countif(A1:A20, "<3") = counts how many cells have less than 3
----------------------------

If
What is the use of If formula?
Fetches one of the two values based on a condition

Syntax of If formula:
if(is-this-true?, do this, or this)

Examples of Excel If formula:
if(5<10,"hello","world") = hello
if(5>10,"hello","world") = world
----------------------------

Large
What is the use of Large formula?
Finds the nth largest number in a list

Syntax of Large formula:
large(from this list, nth largest number)

Examples of Excel Large formula:
large(list, 2) = 2nd largest number in the list
----------------------------

Max
What is the use of Max formula?
Finds the maximum of a given list of numbers

Syntax of Max formula:
max(of this list of numbers)

Examples of Excel Max formula:
max(1,2,3) = 3
max(A1:A20) = maximum value in the range A1:A20
----------------------------

Min
What is the use of Min formula?
Finds the minimum of a given list of numbers

Syntax of Min formula:
min(of this list of numbers)

Examples of Excel Min formula:
min(1,2,3) = 1
min(A1:A20) = minimum value in the range A1:A20
----------------------------

Not
What is the use of Not formula?
Negates a logical value

Syntax of Not formula:
not(this logical value)

Examples of Excel Not formula:
not(false) = true
not(not(false)) = false
----------------------------

OrWhat is the use of Or formula?
Checks whether any condition is met

Syntax of Or formula:
or(list of conditions)

Examples of Excel Or formula:
or(true, false) = true
or(false, false) = false
----------------------------

Small
What is the use of Small formula?
Finds the nth smallest number in a list

Syntax of Small formula:
small(from this list, nth smallest number)

Examples of Excel Small formula:
small(list, 2) = 2nd smallest number in the list
----------------------------

Sumif
What is the use of Sumif formula?
Sums items in a list matching a condition

Syntax of Sumif formula:
sumif(in this range, values meeting this criteria, [sum-this-range])

Examples of Excel Sumif formula:
sumif(A1:A20, 3) = sums the cells with a value of "3"
sumif(A1:A20, 3, b1:b20) = same as above but adds values in B1:B20
----------------------------

Vlookup

What is the use of Vlookup formula?
Searches a list for a value you are looking for and returns a corresponding value

Syntax of Vlookup formula:
vlookup(this value, in this list, and get me value in this column, [is-my-list-sorted?])

Examples of Excel Vlookup formula:
vlookup("John", list, 2, false) = finds where Jon is in the list and returns the value in the 2nd column

Sumber : http://chandoo.org/

Fungsi Logika dalam Microsoft Excel

Ada beberapa Formula matematika diantaranya yaitu Average, Int, Mod, Rand, Round dan Sum 

-----------------------------------

Average

FormulaWhat is the use of Average formula?

Average of given numbers

Syntax of Average formula:
average(of this number, [and this number too..])

Examples of Excel Average formula:
average(2,4,6) = 4
average(A1:A5) = average of numbers in A1:A5
-----------------------------------

Int
What is the use of Int formula?
Converts a decimal number to integer lower than it

Syntax of Int formula:
int(this number)

Examples of Excel Int formula:
int(1.2365) = 1
----------------------------------

Mod
What is the use of Mod formula?
Tells you what is the reminder after dividing one number with another

Syntax of Mod formula:
mod(of this number, divided by this number)

Examples of Excel Mod formula:
mod(5,3) = 2
mod(3,5) = 3
----------------------------------

Rand
What is the use of Rand formula?
Gives you a random number to play with

Syntax of Rand formula:
rand()

Examples of Excel Rand formula:
rand() = who knows
----------------------------------

Round

What is the use of Round formula?
Rounds a number to nearest decimal you specify

Syntax of Round formula:
round(this number, to this many digits after decimal)

Examples of Excel Round formula:
round(1.2365,0) = 1
round(1.2365,2) = 1.24
----------------------------------

Sum
What is the use of Sum formula?
Adds a bunch of numbers


Syntax of Sum formula:
sum(add this, [and this ..])

Examples of Excel Sum formula:
sum(1,2,3,4) = 10
sum(5.6,2.3) = 7.9

Sumber : http://chandoo.org/

Formula Matematika dalam Excel

Secara default sebuah UserForm hanya ada tombol Close(X) saja, sehingga kita tidak bisa me-minimize ataupun me-maximize sebuah UserForm. Namun jika kita memang ingin menambahkan atau menampilkan tombol Minimize dan Maximize maka kita harus memanfaatkan fungsi API pada VBA Excel.
Untuk bisa menambahkan tombol Minimize dan Maximize di UserForm Excel, caranya adalah sebagai berikut:
Buka aplikasi Microsoft Visual Basic for Application pada Excel, bisa melalui tab developer ataupun bisa juga dengan menekan tombol Alt+F11.

Tambahkan sebuah UserForm dan kemudian masukkan script VBA berikut ini ke dalam UserForm1 (Code).

Code

Private Sub UserForm_Activate() AddMinMaxButton Me.Caption, MinButton:=True, MaxButton:=True End Sub Tambahkan sebuah Module dan masukkan script VBA berikut ke dalam Module1 (Code). Public Const WS_MINIMIZEBOX = &H20000 Public Const WS_MAXIMIZEBOX = &H10000 Public Const GWL_STYLE = (-16) Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Public Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" _ (ByVal hWnd As Long, ByVal nIndex As Long) As Long Public Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _ (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long Public Declare Function DrawMenuBar Lib "user32" (ByVal hWnd As Long) As Long Public Sub AddMinMaxButton(ByVal FormCaption As String, _ ByVal MinButton As Boolean, ByVal MaxButton As Boolean) Dim hWnd As Long Dim lngStyle As Long hWnd = FindWindow(vbNullString, FormCaption) lngStyle = GetWindowLong(hWnd, GWL_STYLE) If MaxButton Then lngStyle = lngStyle Or WS_MAXIMIZEBOX End If If MinButton Then lngStyle = lngStyle Or WS_MINIMIZEBOX End If SetWindowLong hWnd, GWL_STYLE, lngStyle DrawMenuBar hWndEnd Sub

Kembali ke UserForm1, kemudian tekan tombol F5, maka UserForm1 akan dijalankan dan lihatkan sekarang pada UserForm sudah ada tambahan berupa tombol Minimize dan Maximize.

Sumber : http://blog.belajarexcel.org/excel-macro/menambahkan-tombol-minimize-dan-maximize-di-userform/
@masbaim - your partner

Tombol Minimize dan Maksimize di User Form

Mungkin kamu memerlukan aplikasi persuratan dan Agenda, kali ini saya buatkan aplikasi Persuratan dan Agenda, masih versi 01, ada beberapa menu yang belum selesai, tapi untuk manajemen surat masuk dan surat keluar serta cetak disposisi mudah-mudahan sudah tidak ada masalah. silahkan di coba-coba.



Mungkin aplikasi ini juga bisa meembuaka wawasan baru, ternyata excel bisa dibuat aplikasi lebih dari sekedar yang kita bayangkan.

Compile aplikasi ini menggunakan software gratisan (maklum belum ada biaya untuk membeli software yang berbayar), sehingga pada beberapa anti virus yang gratisan seperti SMADAV juga dianggap sebagai virus, kalau memang diperlukan aplikasi ini, kamu bisa menonaktivkan sementara aplikasi anti virusmu, insya Allah aplikasi ini aman. Namun jika kamu menggunakan aplikasi anti virus berbayar, kamu bisa mengatur setingan agar aplikasi ini tidak dianggap musuh oleh anti virus kamu.

silahkan kalau ada masukan, insya Allah nanti kita perbaiki.
Aplikasi ini free untuk di pakai atau di share.
Untuk mengakses sheet data base saya membuat pasword yang bisa kamu minta secara gratsi via PM twitter atau facebook, sekaligus untuk mengetahui / menghitung manfaat seberapa banyak aplikasi ini di gunakan, sekaligus pemberitahuan jika terdapat update.



Kelebihan Aplikasi :- Gratis dan selalu gratis insya Allah
- Mudah di operasikan
- Data base bisa di copas karena basisnya Excel

Kekurangan :- masih terdapat modul yang belum selesai
- dianggap virus oleh SMADAV

Download di SINI , keterangan lengkap ada di sini 

Aplukasi Persuratan Excel