Tags » Excel

Solusi Sistem Persamaan Linear dengan menggunakan Ms. Excel dan Matlab

  • Sistem Persamaan Linear (SPL) adalah kumpulan dari persamaan-persamaan linear yang saling berhubungan untuk mencapai tujuan tertentu. Jika variabel pada SPL kurang dari sama dengan tiga, maka kita dapat mencari solusinya dengan mudah menggunakan eliminasi, substitusi atau rumus abc.
  • 104 more words

How to Using Excel- the SpreadSheet Modeling Process

Using for Operation Management course in university.

Example:

  • Petty Components makes a variety of parts for the Auto Industry. One of these parts (CP29) does not seem to be contributing to profits.
  • 220 more words
Excel

Menampilkan Developer Ribbon di Excel 2011 Mac

Untuk menampilkan Activex Control seperti List Box, Combo Box pada worksheet seperti pada Excel for Windows, maka untuk Excel 2011 Mac kita perlu menampilkan menu Developer terlebih dahulu. 14 more words

Excel

Complex Analysis Tool (CAT): Analyzing and Recording Think or Swim RTD Data in Excel

I just updated the stock Excel CAT tool to use RTD instead of the now defunct DDE. This only works on Excel for Windows unfortunately. You can go download it now from my… 63 more words

Tools

5,000 Frequency Word List - French

Yesterday, you saw in my post, this PDF:

(copy the text between the ”   ” below, to your browser, and enter to download the PDF) “tratu.coviet.vn/download/157/Frequency+dictionary+of+French.pdf.html” 23,084 more words

Wordlists

Advanced Excel Training Sessions Help Businesses Avoid Costly Mistakes


Failures in “internal controls and supervisory systems” can lead to spectacular losses like the one described in the article above. Such errors can also ruin customer trust in the company, and might even turn away some investors from the business. 78 more words

Test Driven by Functions from excel testcomplete for Gmail

Public BroObj
public vFunction
Public vProperty
Public vValue
Public vOutput

Sub DrIveMeHard
Set objConnection = CreateObject(“ADODB.Connection”)
Set objRecordSet = CreateObject(“ADODB.Recordset”)
sFileName = “C:\Users\Reyni\Desktop\Valla\Excel_Driven.xls”

Const adOpenStatic = 3… 190 more words