EXCEL -Using “Names” in a Range(Cells)

Salam,

Kita sebenarnya boleh memberikan nama kepada “cells” atau satu kumpulan cells(range of cells) didalam Excel.

Dengan memberikan nama kepada cells atau range of cells, ianya nanti boleh digunakan bila kita merujuk kepadanya dibahagian yang lain.

Sebagai contoh:
1. Masukkan nilai 2000 pada Cell A1
2. Kita boleh namakan Cell A1 sebagai “TapakMula”
3. Pilih Cell B10
4. Masukkan formula “=TapakMula” pada Cell B10
5. Excel akan memberikan nilai 2000 pada Cell B10

Bagaimana nak menamakan sesuatu Cell?
1. Pilih Cell yang dikehendaki
2. Taipkan nama pilihan di”Name Box” dan tekan enter
3. Lokasi “Name Box” adalah seperti dibawah

Kelebihan terbesar menggunakan “Name Range” ini ialah bila kita hendak merujuk kepada data-data didalam formula bila kita mempunyai satu sheet yang besar dengan jumlah data yang banyak.

Formula yang ditaip sebagai sebagai “KadarBank*PinjamanRHB” adalah lebih bermakna berbanding dengan formula yang ditaip sebagai “D3*W25”

Demo video adalah seperti berikut:

That’s it……………

Excel

Salam,

EXCEL ... This is an interesting piece of software.

Dibuat oleh Uncle Microsoft, hasil perahan idea Abang Bill Gates etc.

Why did I say its interesting ?

Its interesting bcoz:

It can show you a quick page of lines across a screen..... ha ha ... not so terror la this one.

To the beginners:

• you can quickly have sheets with many self calculated totals i.e. autosum function

• its has many built-in functions that will speed-up your work
• you can set-up a quick What-Ifs scenarios of your various calculations and projections
• its useful for almost everybody - students, accountants lawyers

To the advance users:

• it can be programmed to create self styled tools to impress ........ your boss is a great candidate
• eliminate key-in error in that huge data compiling task that you're doing
• save time ..... you save time when you let the codes do it for you
• And down here is just a sample how I manipulate those codes to do the dirty work for me and saving my shoulder from that ache...
  

In the sample above, what I've coded is:

• Excel to open my data file from designated folders
• Extract data from the opened file
• put it into my pre-prepared template
• process the data
• and give me results

This is actually part of my month end routine, to process about 300 over files, and this can be completed in just about 3 to 5 minutes.

So, if you think this is something useful and great that you want to know more.... search for Excel VBA in your search engine.

The result page should be able to give you more insights to what it is all about.

For a start you may read these article .....
http://www.math.vu.nl/obp/edu/project-obp/VBA-intro.pdf

If you want to buy a book.... consider books from Mr Walkenbach...
http://spreadsheetpage.com/

There you have it. Pick that heavy butt from that lazy chair and learn something new today....


OK then.....