Wednesday, February 8, 2012

Six Steps to a Faster Broadband Connection 3

5. Optimize Software Settings

Now that your cable or DSL line is as clean as you can make it, you're ready to tweak your system and applications for maximum performance, too.
For optimizing network performance parameters in Windows XP, Vista, or 7, we like TotalIdea Software's Tweak-XP Pro Premium, TweakVI Premium and Tweak 7, and Both programs simplify optimization without requiring you to understand Registry editing or hidden Windows settings. Both packages include dozens of tweaks in addition to network and browser adjustments. The Pro version of Network Magic, an excellent network monitoring utility, includes optimization capabilities as well.
Firetune; click for enlarged image.The free Firetune utility optimizes low-level Firefox settings to speed up browsing.System-level optimization is less important in Vista and 7 than in XP, since Vista and 7 tune your TCP stack dynamically. In fact, Vista/7 users can probably get away with just optimizing specific applications, especially their browsers. To speed up Firefox page displays, try Firetune or Fasterfox. Both are free and one-click easy. Fasterfox adds a few more customization options for expert users. Both tweak low-level Firefox settings such as cache memory capacity, maximum simultaneous connections, and "pipelining" (performing multiple data requests simultaneously).

6. Accelerate Your Downloads

Frequent downloaders can save huge amounts of time by using a download manager like our favorite, FlashGet. FlashGet creates multiple simultaneous download links, and then puts the file together afterward. All you do is click or drag download links to the FlashGet window; the program does the rest. It integrates with Internet Explorer, and works with Firefox using a companion utility called FlashGot.

BACK

Six Steps to a Faster Broadband Connection

1. Test Your Connection Speed

Speedtest.net; click for enlarged image.Speedtest.net gives you a quick snapshot of your connection speed to help you diagnose problems.Before you start tweaking, get a baseline reading of your downstream and upstream connection speeds at Speedtest.net. If possible, measure the speeds at different times of day, especially during the hours when you use the connection most frequently, and at least once after midnight or 1:00 a.m. (when competition for bandwith is likely to be at its lowest level).

2. Update Your Firmware or Get a New Modem

If your cable or DSL modem is more than a couple of years old, ask your Internet service provider for a new one. The exchange will probably be free; and if there is a fee, you can usually waive it by agreeing to a new one-year contract. The latest cable modems meet the DOCSIS 3.0 (Data Over Cable Service Interface Specification) standard. If you have a 1.1 or 2.0 modem and a high-throughput plan, you'll likely experience a large speed increase just by swapping modems.
Even with a brand-new modem, make sure that you have the latest firmware installed. I upgraded my two-year-old Efficient Networks 5100b DSL modem from firmware version 1.0.0.39 to 1.0.0.53, and immediately saw my Speedtest throughput increase from 5.3 mbps to 5.9 mbps, just a hair below the 6 mbps that I'm paying for. Cable providers such as Comcast usually push new firmware to modems, so there's no need for most cable modem users to perform upgrades themselves.
To update your DSL modem, you'll have to connect to its Web interface, which means that you'll need to know the IP address of the modem on your local network. This information should be in your user manual; alternatively, you can find default settings for most modems on the Internet. The address will probably look something like 192.168.100.1 or 192.168.0.1. Enter this character string into your browser, and the Web interface should come up. You'll likely have to sign in, using either a security code printed on the bottom of the modem or a default username and password (unless you previously changed it). Write down the log-in information for future reference.
Modem Firmware; click for enlarged image.This DSL modem status page shows several useful pieces of information, including the firmware number, the age of the modem, and actual connection speeds.Once you've logged in, check the firmware number on the status page, and see whether a newer version of the firmware is available on the manufacturer's site. If it is, download this more recent firmware to your PC, and then find and run the firmware update procedure from the modem's browser utility. Reboot, rerun Speedtest, and see whether your data is traveling faster. Besides boosting transfer speeds, using a new modem or updated firmware can solve a host of nagging connection issues, such as intermittent dropouts.

NEXT

Six Steps to a Faster Broadband Connection 2

3. Check Your Modem Parameters

Modem status screen; click for enlarged image.By rooting around in your modem's status screens, you can find such key pieces of information as signal-to-noise ratio and line attenuation, two determinants of line quality.While you're updating the firmware, check some key parameters. First, the maximum allowed speeds (both downstream and up) should match your service plan. If they don't, your ISP didn't set your service up properly. Give your ISP a call and ask it to fix the setup remotely.
Second, look for signal-to-noise ratio (or SN margin) and line attenuation, both measured in decibels (dB). The lower the signal-to-noise ratio, the more interference you have, and the greater the number of packets that will need to be re-sent because they didn't come through the first time. For this reason, a noisy line can dramatically cut throughput. Line attenuation measures the drop in voltage that comes with splitting the signal (especially for cable modems) and with long runs of cable or older wiring. Excessive signal loss will cause a drop in throughput.
For DSL modems, anything above about 50 dB for line attenuation is poor, and 20 to 30 dB is excellent. For signal-to-noise ratio, 7 to 10 dB is marginal, and 20 to 28 dB is excellent. My modem's SN margin registered at 12.5 dB, barely reaching the good range, and its line attenuation reading was 30.5 dB, which rates as very good. Note that acceptable ranges may vary depending on your service level and modem type (faster connections need to be cleaner), so check with your cable or DSL provider to see what numbers you should look for.

4. Troubleshooting Line Quality

If your off-peak Speedtest numbers didn't measure up to your plan's specifications, and if you found poor signal-to-noise or line attenuation numbers, it's time to troubleshoot your wiring. Excessive noise may cause intermittent dropouts, too.
Your first task is to determine whether the signal is already degraded when it reaches your house or whether your own wiring is at fault. To test this, move your cable modem as close as you can to where the wire first splits. If possible, take a laptop and power cord for your modem outside to the junction where it connects to the house. Retest and see if things improve. If they don't, call your cable company. If your own wiring looks to be at fault, reduce the number of splits that occur before the wiring reaches your modem, and/or replace the wire itself, which may be faulty. The ultimate solution for cable modems is to create a split directly after the junction box, and then run a clean new cable directly to your modem, using the other split for all of your TVs (which are less affected by noise).
For DSL modems, noisy inside wiring tends to be due to the other phone equipment on your line. This interference is supposed to be controlled by the filters placed between the wall jack and each device. Make sure that they are all in place. If you still have too much noise, the best solution is to install a "DSL/POTS splitter' immediately after the phone box, where the wiring comes into the house, and then run a dedicated "homerun" wire straight to the modem. This arrangement will completely isolate your modem from the regular phone wiring--and the new wire should help too.
If you don't want to do this job yourself, you can ask your cable or phone company to perform both tasks for a fee.
Finally, improper grounding can be a source of noise, especially on cable. Make sure that all of your TV equipment is plugged into properly grounded outlets, with polarized plugs oriented in the right direction, and without any three-prong-to-two-prong adapters. If you have an electric outlet tester, use it to check for excess voltage on your cable wiring. An electrician can find and fix any grounding problems, which are safety concerns as well.

BACK | NEXT 

Skype: How to Use It

I’d start by automatically assuming everyone knows what Skype is – but many people don’t. Therefore, a little background info for those of you living under a rock. (I was one of you until just last week!) Well, ok, I’d heard of Skype prior to that, but I’d never used it. And I certainly had no idea just how varied the services they offer are. After a little searching, I must confess I’m feeling a little ridiculous that I’ve only just installed the program last week.

Skype is, basically, a way to call anyone in the world – for free.

Anyone who has a computer, or Skype-capable phone, that is. So, yeah, it might not work if your family are nomads in the Mojave. Otherwise, you could probably manage it.

How do I get it?

You go to www.skype.com and download it. It took a few minutes to install on my iMac, and as soon as I registered a call-name, it was ready to go. It was that simple. Seriously.

What do I have to pay for?

Nothing! It’s FREE to create a call name, and free to call anyone else with Skype. No hidden charges, no expiration dates. Just free.

Do I need a microphone and headset?

Possibly. My iMac came with a built-in mic and built-in speakers and that’s all I use. If your computer or phone is already equipped for this, you needn’t buy anything either. If you do need a mic and headset – or if you simply just want one – you can buy one from your local electronics store for cheap.

How do I make a call?

You just log into Skype, click on the contact you want to call, and press the call button. It will then ring them – like a phone – and they can answer. Just like a real phone, really.

This is too weird, I prefer a phone.

Guess what? They sell USB phones now. You can get one for cheap from the electronics store, take it home, connect it to your USB port, and voila. Or, you could buy a Skype-enabled cordless phone handset, which will divert calls to something like a cordless phone. So don’t let the mic/headset thing put you off.

Does it sound strange, talking through a computer?

I’m sure the quality of your speakers will have something to do with it, but I can honestly tell you it sounds very phone-like on my Mac.
What else can I do for free with Skype?
You can cam-call. Yeah, all you need is the camera. Just select the option and you’re ready to go. You can also instant message. Not sure why this would be preferable, though. Unless, of course, you’re at work and don’t want the boss to know you’re not working!
By now you’ve realized Skype is pretty cool. It may not be a necessity in the US, where local calls are free, but over here in Europe, they aren’t. You pay every time you call someone, unless you’re dialing an 800 number. And you pay by the minute, which makes Skype a Godsend. It’s particularly fantastic when making naughty phone calls to another country – free calls mean you can take your time and have a proper conversation.

How to use Skype

Instructions

 Open a Skype Account. Go to www.skype.com

    • 1. (Computer->Computer) Search for your friends online. Add them by (Contacts / Add Contact). This is a free service.
    • 2. (Computer->Phone). This is called SKYPE OUT. You can dial any fixed or mobile phone where around the world if you add credit in your SKYPEOUT account (go to www.skypeout.com). Paypal and Credit card are supported. You can either add 10 EURO or 25 EURO at one time. Calls are cheap (depending on country), and are relatively comparable to IP cards. Remember to dial the country prefix!
    • 2. (Phone->Computer). This is called SKYPE IN. This is a VERY convenient service. SKYPE IN (www.skypein.com)allows you to reserve a phone number in a country of choice. The cost is 30 EURO a year, or 10 EURO for 3 months. This allows you to hand out a local number to friends / work collegues in a different country (so they are charged only a local call), and when they call you, your SKYPE on your computer will ring (no matter where you are in the world!). This is handy if you want to have a number on your business card for a country that you do not reside. The only cost to you is the yearly rental of the number, and the caller is charged a normal phone call charge.

Tips & Warnings

  • It is worth buying the voicemail service. If your computer is switched off, people can use messages.
  • There are many skype accessories. You can purchase a SKYPE PHONE, which simply plugs into your USB port, and you can use it like a normal phone (as long as your computer is switched on!)
  • If you have a mobile PDA with wireless LAN, you can download the pocket-pc version, and use SKYPE from your PDA.

How to Make a Simple Animation in Macromedia Flash

  1. Open Macromedia Flash 10
  2. Choose frame 1 on the timeline which is located above the canvas.
  3. Draw whatever you want to in your first frame (eg: a stick figure).
  4. Choose the next frame depending upon the length of your animation. The larger the difference between the frames, the longer the animation.
  5. Right click on the frame and click "Insert KEYFrame".
  6. Right click anywhere between the first and the last frame and select "Create Motion Tween". Now the same picture you drew in the first frame will appear in the last frame you made.
  7. Edit this picture in any way. You can change its size, position or other effects such as alpha, tint, etc. They appear when you right click on the object and click "Properties".
  8. Press
    Image:keys_control.png
    Image:keys_enter.png
    to view the animation
    .
  9. Play around and experiment. There is a lot more to flash animation than just this.
  • The greater number of frames, the longer the animation.
  • Try creating different layers for different objects by clicking the "+" in the layers panel besides the timeline.
  • Play with Flash; try every button and option you see to understand its effects. This way, when you actually want to create something with Flash, you will know how.
  • Try to learn from free sites such as freeflashtutorials.com. Once you get ready to learn more advanced flash try out gotoandlearn.com.
  • When working on a Flash project, save frequently, like any other project.
  • There is also what is called FBF (or Frame By Frame Animation) which is drawing one picture on one frame and then drawing that picture's next "movement" on the next frame. If you keep on doing that, you can create a very smooth animation (with skill). However, this method takes a lot of time, and therefore patience.
  • You can set the amount of FPS (Frames per second) by using the selection tool, and having nothing highlighted, then click the menu under "Actions", to bring that up, and in the upper right corner, there is the set amount of FPS that is for Flash 8.

    Tuesday, February 7, 2012

    Tutorial Microsoft excel


    SUM

    Menjumlahkan  angka atau nilai pada area yang dipilih.

    Syntax : SUM( angka, angka , ... )

    Contoh :
     
    1
    2
    3
    4
    5
    6
    A

    Data

    -5

    15

    30

    '5

    TRUE

    Formula
    Deskripsi (Hasil)
    =SUM(3, 2)
    Menjumlahkan penambahan  3 dan 2, menghasilkan nilai 5
    =SUM("5", 15, TRUE)
    Menjumlahkan penambahan 5, 15 and 1, sebab nilai tipe data text “5” (angka dalam tanda kutip) diterjemahkan menjadi angka, dan nilai logic (TRUE) diterjemahkan sebagai angka 1, menghasilkan nilai 21
    =SUM(A2:A4)
    Menjumlahkan nilai pada sel A2 s.d A4, menghasilkan nilai 40
    =SUM(A2:A4, 15)
    Menjumlahkan nilai pada sel A2 s.d A4 dan angka 15, menghasilkan nilai 55
    =SUM(A3,A5,A6, 2)
    Menjumlahkan nilai pada sel A3,A5, A6 dan angka 2, menghasilkan nilai 17. Karena nilai yang ada pada sel A5 (angka tapi diawali tanda petik) dan A6 dianggap bukan tipe numeric, sehingga tidak dijumlahkan.



    SUMIF
    Menjumlahkan  seluruh angka pada area yang dipilih dengan memberikan sebuah kriteria Hide All
    .
    Syntax : SUMIF( Area_kriteria , Kriteria , Sum_range )

    ·         Area_kriteria   adalah area yang akan dievaluasi. Sel pada setiap harus berisi angka, nama, array atau referensi yang mengandung nilai angka. Sel kosong dan teks tidak akan dijumlahkan.

    ·         Kriteria   adalah kriteria dalam format angka, ekspresi atau teks, Contoh : kriteria  dapat diekspresikan sebagai 32, "32", ">32", atau  "Negeri".

    ·         Sum_range   adalah Sel aktual yang nilainya akan dijumlahkan jika kriterianya sesuai.

    *  Anda dapat menggunakan karakter wildcard tanda tanya (?) dan asterisk (*), pada criteria. Tanda Tanya sebagai pengganti satu huruf, sedangkan karakter asterisk tidak memiliki batasan jumlah karakter.

    Contoh :
     
    1
    2
    3
    4
    5
    A
    B
    Nilai Jual
    Komisi
    100,000
    7,000
    200,000
    14,000
    300,000
    21,000
    400,000
    28,000
    Formula
    Deskripsi (Hasil)
    =SUMIF(A2:A5,">160000",B2:B5)
    Menjumlahkan Komisi (kolom B2:B5) jika Nilai Jual (kolom A2:A5) lebih besar dari 160.000, menghasilkan nilai 63.000
    =SUMIF(A2:A5,">160000")
    Menjumlahkan Nilai Jual (kolom A2:A5) yang memiliki Nilai Jual lebih besar dari 160.000, menghasilkan nilai 900.000
    =SUMIF(A2:A5,"=300000",B2:B3)
    Menjumlahkan besarnya komisi (kolom B2:B5) jika Nilai Jual (kolom A2:A5) sama dengan 300.000, menghasilkan nilai 21.000Sum


    SUMIFS
    Menjumlahkan  seluruh angka pada area yang dipilih dengan memberikan beberapa kriteria.
    PENTING :  Harap diperhatikan adanya perbedaan syntax antara SUMIFS dan SUMIF. Posisi sum_range pada SUMIF ada di akhir, sedangkan pada SUMIFS ada di awal.

    Syntax : SUMIFS( Sum_range , Area_kriteria1 , Kriteria1 , Area_kriteria2 , Kriteria2…)

    ·         Sum_range   adalah satu atau banyak sel yang akan dijumlahkan, termasuk angka atau nama, array, atau reference yang mengandung angka. Sel kosong dan teks akan diabaikan.
    ·         Area_kriteria1, Area_kriteria2, …   adalah 1 sampai 127 Area yang akan dievaluasi kesesuaian dengan kriteria.
    ·         Kriteria1, Kriteria2, …   adalah 1 sampai 127 kriteria dalam format angka, ekspresi, referensi sel, atau teks yang mendefinisikan sel yang akan ditambahkan. Contoh, kriteria dapat ditulis seperti 32, "32", ">32", "Negeri", atau B4.

    Catatan :
    *  Tiap sel pada sum_range akan dijumlahkan jika sesuai dengan kriteria.
    *  Sel yang mengandung nilai TRUE dievaluasi sebagai angka 1; Sel yang mengandung nilai FALSE dievaluasi sebagai angka 0 (zero).
    *  Tidak seperti Area dan kriteria pada funsi SUMIF, pada fungsi SUMIFS setiap Area_kriteria dan Sum_range harus memiliki ukuran yang sama.
    *  Anda dapat menggunakan karakter wildcard tanda tanya (?) dan asterisk (*), pada criteria. Tanda Tanya sebagai pengganti satu huruf, sedangkan karakter asterisk tidak memiliki batasan jumlah karakter.

    COUNT
    Menghitung banyaknya sel yang mengandung angka dan angka yang ada pada argumen.
    Syntax : COUNT(nilai1,nilai2,...)
    Nilai1, nilai2, ...   adalah 1 sampai 255 argumen yang dapat mengandung atau mereferensi berbagai tipe data, tetapi hanya angka yang dihitung.
    Catatan :
    *  Argumen berupa angka, tanggal, atau teks yang merepresentasikan angka akan dihitung.
    *  Nilai Logic dan teks yang merepresentasikan angka yang anda input langsung pada argrumen akan dihitung.
    *  Argumen berupa nilai error atau teks yang tidak bisa diterjemahkan menjadi angka akan diabaikan.
    *  Jika argumen berupa array atau reference, hanya angka pada array atau reference tersebut yang akan dihitung. Sel kosong, nilai logic, teks atau nilai error pada array atau reference akan diabaikan.
    *  Jika anda ingin menghitung nilai logic, teks, atau nilai error, anda dapat menggunakan fungsi COUNTA.

    COUNTIF
    Menghitung banyaknya sel pada area tertentu dengan batasan kriteria.
    Syntax : COUNTIF(range,criteria)
    Range  adalah sebuah atau beberapa sel yang akan diperiksa kesepadanannya, termasuk angka atau nama, array, arau reference yang mengandung angka. Blank dan nilai teks akan diabaikan.
    Criteria  adalah kriteria dalam format angka, ekspresi, cell reference, atau teks yang mendefinisikan sel yang akan dihitung. Contoh kriteria seperti : 32, "32", ">32", "apples", atau B4.

    Catatan :
    *  Anda dapat menggunakan karakter wildcard tanda tanya (?) dan asterisk (*), pada criteria. Tanda Tanya sebagai pengganti satu huruf, sedangkan karakter asterisk tidak memiliki batasan jumlah karakter racter.

     
    1
    2
    3
    4
    5
    A
    B
    Data
    Data
    apples
    32
    oranges
    54
    peaches
    75
    apples
    86
    Formula
    Deskripsi (Hasil)
    =COUNTIF(A2:A5,"apples")
    Menghitung banyaknya sel yang berisi kata “apples” pada range A2:A5, menghasilkan nilai (2)
    =COUNTIF(A2:A5,A4)
    Menghitung banyaknya sel yang berisi kata yang terkandung dalam sel A4 (“apples”) pada range A2:A5, menghasilkan nilai (1)
    =COUNTIF(A2:A5,A3)+COUNTIF(A2:A5,A2)
    Menghitung banyaknya sel yang berisi kata yang terkandung dalam sel A3 (“oranges”) pada range A2:A5 ditambah banyaknya sel  yang berisi kata yang terkandung dalam sel A2 (“apples”) pada range A2:A5, menghasilkan nilai (3)
    =COUNTIF(B2:B5,">55")
    Menghitung banyaknya sel yang memiliki nilai lebih besar dari 55 pada range B2:B5, menghasilkan nilai (2)
    =COUNTIF(B2:B5,"<>"&B4)
    Menghitung banyaknya sel yang memiliki nilai tidak sama dengan nilai pada sel B4 (75) pada range B2:B5, menghasilkan nilai (3)
    =COUNTIF(B2:B5,">=32")-COUNTIF(B2:B5,">85")
    Menghitung banyaknya sel yang bernilai lebih besar atau sama dengan dari 32 pada range B2:B5 dikurangi banyaknya sel  yang memiliki nilai lebih besar dari 85 pada range B2:B5, menghasilkan nilai (3)


    Contoh 2: Formula COUNTIF menggunakan karakter wildcard dan penanganan nilai blank

     
    1
    2
    3
    4
    5
    6
    7
    A
    B
    Data
    Data
    apples
    Yes


    oranges
    NO
    peaches
    No


    apples
    YeS
    Formula
    Deskripsi (Hasil)
    =COUNTIF(A2:A7,"*es")
    Menghitung banyaknya sel yang berisi kata berakhiran huruf “es” pada range A2:A7, menghasilkan nilai (4)
    =COUNTIF(A2:A7,"?????es")
    Menghitung banyaknya sel yang berisi kata berakhiran huruf “es” dan terdiri dari 7 huruf pada range A2:A7, menghasilkan nilai (2)
    =COUNTIF(A2:A7,"*")
    Menghitung banyaknya sel yang berisi teks, pada range A2:A7, menghasilkan nilai (4)
    =COUNTIF(A2:A7,"<>"&"*")
    Menghitung banyaknya sel yang tidak berisi berisi teks, pada range A2:A7, menghasilkan nilai (2)





    COUNTIFS
    Menghitung banyaknya sel pada area tertentu yang memenuhi beberapa kriteria.

    Syntax : COUNTIFS(range1, criteria1,range2, criteria2…)
    Range1, range2, …   adalah 1 hingga 127 range yang akan dievaluasi kesesuaiannya dengan kriteria yang diminta. Sel pada setiap range harus berupa angka, nama, array, atau reference yang mengandung angka. Blank dan nilai teks akan diabaikan.
    Criteria1, criteria2, …   adalah 1 hingga 127 kriteria dalam format angka, ekspresi, cell reference, atau teks yang mendefinisikan sel yang akan dihitung. Contoh kriteria : 32, "32", ">32", "apples", atau B4.
    Remarks
    *  Setiap sel pada range akan dihitung jika semua kriteria yang diminta terpenuhi.
    *  Jika kriteria berupa sel kosong, COUNTIFS akan menganggap berisi nilai 0.
    *  Anda dapat menggunakan karakter wildcard tanda tanya (?) dan asterisk (*), pada criteria. Tanda Tanya sebagai pengganti satu huruf, sedangkan karakter asterisk tidak memiliki batasan jumlah karakter.
    Contoh :


    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    A
    B
    C
    D
    Salesman
    Kota 1
    Kota 2
    Kota 3
    Davolio
    Ya
    Tidak
    Tidak
    Buchanan
    Ya
    Ya
    Tidak
    Suyama
    Ya
    Ya
    Ya
    Leverling
    Tidak
    Ya
    Ya
    Formula
    Description (result)
    =COUNTIFS(B2:D2,"=Ya")
    Menghitung berapa kota yang dikunjungi Davolio (range B2:D2 = Ya), menghasilkan nilai (1)
    =COUNTIFS(B2:B5,"=Ya",C2:C5,"=Ya")
    Menghitung berapa orang sales yang mengunjungi Kota1 dan Kota2 (range B2:B5 = Ya dan C2:C5 = Ya), menghasilkan nilai (2)






    PivotTable
    Untuk meng-analisa data numerik.

    Membuat PivotTable atau PivotChart report
    Untuk membuat PivotTable atau PivotChart report, anda memerlukan koneksi pada sumber data dan masuk pada lokasi report.
    1.     Pilih tabel yang akan dianalisa, pastikan bahwa kolom tabel tersebut memiliki heading.

    2.     Lakukan salah satu langkah berikut:
    §  Untuk membuat  PivotTable report, pada  tab Insert, dalam group Tables, klik PivotTable, lalu klik PivotTable.
    Selanjutnya akan tampil Kotak dialog Create PivotTable.
    §  Untuk membuat PivotTable and PivotChart report, pada tab Insert, dalam group Tables, klik PivotTable, lalu klik PivotChart.
    Selanjutnya akan tampil Kotak dialog Create PivotTable with PivotChart.

    3.     Memilih data sumber. Lakukan salah satu langkah berikut:

    Tentukan data yang akan dianalisa
    1.     Klik Select a table or range.
    2.     Inputkan (ketik) range data atau referensi nama tabel, seperti =TabelMadrasah, pada kotak Table/Range.
    Jika anda memilih sebuah sel pada suatu range atau jika insertion point berada pada tabel sebelum anda memulai wizard, maka range dari sel tersebut atau nama tabel reference akan tampil pada kotak Table/Range.
    Alternatif lain, untuk memilih range sel atau tabel, klik Collapse Dialog  untuk menyembunyikan sementara kotak dialog, pilih range pada worksheet, lalu tekan lagi Expand Dialog .
     Catatan    Jika range data berada pada worksheet lain tetapi masih pada satu workbook atau workbook lain , ketik nama workbook dan worksheet dengan syntaxsebagai berikut: ([workbookname]sheetname!range).

    Use external data
    3.     Klik Use an external data source.
    4.     Klik Choose Connection.
    Kotak dialog Existing Connections akan muncul.
    5.     Pada Show drop-down list dibagian atas kotak dialog, pilih kategori koneksi atau pilih All Existing Connections (default).
    6.     Pilih salah satu koneksi pada Select a Connection list box, lalu klik Open.
     catatan    Jika anda memilih koneksi dari kategori Connections in this Workbook, anda akan dapat menggunakan ulang atau sharing koneksi tersebut. Jika anda memilih koneksi dari Connection files on the network atau kategori Connection files on this computer, file koneksi akan dikopikan kedalam workbook sebagai sebuah koneksi baru, dan akan digunakan sebagai sebagai koneksi baru untuk PivotTable report.
             
            Memasukkan lokasi. Lakukan salah satu langkah berikut:
    §  Untuk menempatkan PivotTable report pada worksheet baru dimulai dari sel A1, klik New Worksheet.
    §  Untuk menempatkan PivotTable report pada worksheet aktif, pilih Existing Worksheet, kemudian ketik sel pertama dimana anda akan meletakkan PivotTable report.
    Alternatif lain, untuk memilih range sel atau tabel, klik Collapse Dialog  untuk menyembunyikan sementara kotak dialog, pilih range pada worksheet, lalu tekan lagi Expand Dialog .
            Click OK.
             
    Sebuah PivotTable report kosong ditambahkan pada lokasi yang anda pilih dengan menampilkan PivotTable Field List selanjutnya anda dapat mulai menambahkan field, membuat layout, dan kostumisasi PivotTable report.



    Membuat PivotChart report dari PivotTable report
    1.     Klik PivotTable report.
    2.     Pada tab Insert, dalam group Charts, klik sebuah tipe chart.
    Anda dapat menggunakan semua tipe chart kecuali xy (scatter), bubble, atau stock.



    CONTOH TABEL DATA


    CONTOH HASIL PIVOT TABEL