Ms Word 2007 : Ribbon

Episod kali ini kita akan belajar mengenai Ribbon di Ms Office 2007,
Ya pasti ada yang terpinga-pinga apabila nak menggunakan Mircosoft Office 2007. Maklumlah Ms Office 2007 telah berubah lebih banyak dari pakej sebelumnya. Di Ms Office 2007 tiada menu tetapi digantikan dengan Ribbon.

Ok sekarang mari kita tengok video berkenaan Ribbon di Microsoft Office 2007
"p/s video ini bukan saya yang buat, tapi dapat dari sumber di youtube"

Ms Word 2003 : Shortcut Key

Keys for Smart Tags

To perform this action...	Press...
To display the menu or message for a smart tag (If more than one smart tag is present, to switch to the next smart tag and display its menu or message)	ALT+SHIFT+F10
To select the next item in a smart tag menu	DOWN ARROW
To select the previous item in a smart tag menu	UP ARROW
To perform the action for the selected item in a smart tag menu	ENTER
To close the smart tag menu or message	ESC

Go Back to the Top of the Page

Keys for Task Panes

A task pane is a help window that provides ready access to commands related to a specific topic. Task Panes normally appear on the right side of the screen, tiled with the program window.

To perform this action...	Press...
To open the task pane or hide the current task pane	CTRL+F1
To move to a task pane from another pane in the program window	F6(You may need to press F6 more than once)*
To move to a task pane when a menu or toolbar is active	CTRL+TAB(You may need to press CTRL+TAB more than once)
To open the menu of task panes	CTRL+SPACEBAR (task pane must be active)
To go to the Getting Started task pane	ALT+HOME
To reverse the sequence of task panes you opened	ALT+LEFT ARROW
To repeat the sequence of task panes you opened	ALT+RIGHT ARROW
To close a menu if one is currently open, or to go back to the document	ESC
To select the next or previous option in the task pane when a task pane is active	TAB or SHIFT+TAB
To move among choices in a selected submenu; To move among certain options in a group of options	DOWN ARROW or UP ARROW
To open the selected menu, or perform the actionassigned to the selected button	SPACEBAR or ENTER
To open a shortcut menu in a document; To open a drop-down menu for the selected gallery item	SHIFT+F10
To select the first or last command on the menu orsubmenu when a menu or submenu is visible	HOME or END
To scroll up or down in the selected gallery list	PAGE UP or PAGE DOWN
To expand or collapse a collapsible item in the gallery list	CTRL+RIGHT ARROW or CTRL+LEFT ARROW
To move to the top or bottom of the selected gallery list	CTRL+HOME or CTRL+END

*If pressing F6 doesn't display the task pane you want, try pressing ALT to select the menu bar, and then CTRL+TAB to move to the task pane. In Word 2003, if you open a dialog box from the Reveal Formatting task pane, the focus may be in your document, rather than in the task pane, after you close the dialog box. If this is so, you can use F6 or CTRL+TAB to return to the taskpane.

Go Back to the Top of the Page

Keys for Menus

You can use keystrokes to select any command on the menu bar. Press ALT or F10 to activate the menu bar. Press the underlined letter in a menu name to display that menu. When the menu appears, press the underlined letter in a command name to execute the command.

To perform this action...	Press...
To display the Start menu	CTRL+ESC
To display the Control menu (the icon menu on the window title bar)	ALT+SPACEBAR
To select the menu bar, or close an open menu and submenu at the same time	F10 or ALT
To display the shortcut menu for the selected item	SHIFT+F10
To display the list of commands when a menu is selected	DOWN ARROW
To display the full set of commands when a shortened menu is open	CTRL+DOWN ARROW
To select the first or last command on the menu or submenu	HOME or END
To select the next or previous command when the menuor submenu is visible	DOWN ARROW or UP ARROW
To select the menu to the left or right; or, when a submenu is visible, to switch between the main menu and the submenu	LEFT ARROW or RIGHT ARROW
To close the visible menu; or, with a submenu visible, to close the submenu only	ESC

Go Back to the Top of the Page

Keys for Toolbars

You can use keystrokes to select any command on a visible toolbar. To select a command from a toolbar, press ALT or F10 to activate the menu bar, then CTRL+TAB as many times as necessary to activate the toolbar you want. Press TAB until you activate the button you want,then ENTER to execute the command.

To perform this action...	Press...
To select a toolbar(after pressing F10 or ALTto select the menu bar)	CTRL+TAB or CTRL+SHIFT+TAB(Pressing the keys repeatedly moves the focus among the opentoolbars, menu bars, and task panes)
To select the next or previous button or menu on thetoolbar when a toolbar is active	TAB or SHIFT+TAB
To open the menu when a menu on a toolbar is selected	ENTER
To perform the action assigned to a button when abutton is selected	ENTER

Go Back to the Top of the Page

Keys for Dialog Boxes

To perform this action...	Press...
To move from an open dialog box back to the document for dialog boxes (such as Find and Replace) that support this behavior	ALT+F6
To switch to the next tab in a dialog box	CTRL+TAB or CTRL+PAGE DOWN
To switch to the previous tab in a dialog box	CTRL+SHIFT+TAB or CTRL+PAGE UP
To move to the next option or option group	TAB
To move to the previous option or option group	SHIFT+TAB
To move between options in the selected drop-down list box, or to move between some options in a group of options	Arrow keys
To perform the action assigned to the selected button, or to select or clear the check box	SPACEBAR
To move to the option by the first letter in the option name in a drop-down list box	Letter key for the first letter in the option name you want (when a drop-down list box is selected)
To select the option, or to select or clear the check box by the letter underlined in the option name	ALT+letter key
To open the selected drop-down list box	ALT+DOWN ARROW
To close the selected drop-down list box	ESC
To perform the action for the default command button in the dialog box (the button with the bold outline, often the OK button)	ENTER
To cancel the command and close the dialog box	ESC
To close a dialog box	ALT+F4

The Open, File New Database, Save As, Insert File, and Insert Picture dialog boxes

These dialog boxes support the standard dialog box keyboard shortcuts listed in the table above. They also support the shortcuts below.

To perform this action...	Press...
To go to the previous folder	ALT+1
To open the folder one level above the open folder	ALT+2
To close the dialog box and open your Web search page	ALT+3
To delete the selected folder or file	ALT+4
To create a new folder	ALT+5
To switch among available folder views	ALT+6
To show the Tools menu	ALT+7 or ALT+L
To open the Look in list	F4 or ALT+I
To refresh the file list	F5
To display a shortcut menu for a selected item such as a folder or file	SHIFT+F10
To move between options or areas in the dialog box	TAB

Sumber dari http://www.ddmcomputing.com

Ms Powerpoint : Save As Type

Untuk Ms Powerpoint pula just simple jer... or mybe simple ini ramai kawan-kawan aku pening skit.

sebenarnya untuk 2 post sebelum ini yang ada gambar bagi contoh-contoh yang saya buat, saya menggunakan powerpoint untuk menghasilkan gambar itu. setelah slide telah disusun, saya akan menyimpankannya dengan "Save as Type" diubah kepada "JPEG file Interchange Format"

insyallah saya akan cuba letakkan gambar bagi contoh ini...he..3x saje jer x letak gambar lagi. nak tengok kawan-kawan faham tak kalau saya berikan penerangan seperti ini.

Ms Excel (Column) : Memanjangkan Column bagi sekata dengan text

Episod kali ini saya Cikgu Ralph Why IQ akan menunjukkan satu kaedah yang ramai kawan-kawan enggak tahu...betul mesti ramai yang tak tahu punya laaa...

Kalau Medan yang kita isi seperti medan B4 ini, text didalamnya sudah melebihi sempadan Column B...ramai kawan-kawan yang akan menghalakan tetikus diantara Column B dan C seperti dibawah dan akan menarik / memanjangkan sehingga ia rasa sudah sama panjang dengan medan B4.

Maka dengan ini saya ingin menunjukkan cara superb pantas untuk memanjangkan Column itu tanpa kita teragak-agak memastikan kepanjangan sama dan sesuai dengan B4...

Caranya, sama seperti diatas iaitu menghalakan tetikus diantara 2 column, bagi kes ini column B dan C, kemudian dengan menggunakan ketikan sebanyak 2 kali secara pantas (double click) anda akan melihat keajaibannya (seperti gambar dibawah). Ia dengan pantas menyesuaikan kepanjangan column mengikut B4

Episod selepas ini..mmmm.... kita belajar Powerpoint pula

Ms Word (Table) : Menambah Lajur dan Baris baru

Memula dah ada 4 lajur... tetiba kena tambah lagi 1 lajur di tengah-tengah...ayoyoyo macamana ni.

Haaaa mari sini Ralph Why IQ (Raf kenapa IQ) nak habak kat kawan-kawan semua.
1st dapatkan Toolbar Tables n Borders dengan ketik kanan pada bahagian atas seperti gambar dibawah, kemudian dapatkan Tables and Borders
selepas itu keluarlah toolbar yang diinginkan.....Haaa nampak tak butang pensel dekat tepi sekali..ketik laaa butang tersebut
Dengan kuasa bulan akan menghukummu..Opsss silap sekali keluar ayat sailormoon pula..
Ok... dengan menggunakan pensel tersebut silalah rajin-rajin membuat garisan pada bahagian yang ingin ditambah seperti gambar dibawah.
Jeng..jeng..jeng dah siap...

Sekian Terima Kasih....Next episod...kita belajar Ms Excel

Khas buat Pengguna Ms Office

Seringkali anda menghadapi masalah semasa menggunakan Ms Office???

Camner nak buat nie, camner nak buat itu, Eh mana ruler, Eh nak besarkan gambar nie boleh ke? nak masukkan gambar macam mana?

pasti ada seribu satu pertanyaan semasa anda menggunakan ms office...yup blog ini saya bukan tujukan khas kepada mereka yang mahir dalam ms office tetapi bagi mereka yang baru dan masih terpinga-pinga dalam ms office.

setelah bertahun-tahun saya mengajar secara langsung mahupun tidak langsung (semasa membuat kelas komputer mahupun semasa dipejabat) dari sekolah hingga dah kerja nie. Acapkali rakan-rakan bertanyakan masalah ms office nie... seperti pakar rujuk laa pula kepada rakan-rakan dalam kaitan pengguna ms office.

Maka kali ini terlitas dilubuk hati ini untuk meneruskan bantuan ini kedunia tanpa sempadan,
Didalam blog ini insyallah saya akan muatkan masalah yang sering dihadapi, dan saya akan tunjukkan cara untuk melakukannya. Jika anda juga mempunyai pertanyaan semasa menggunakan ms office ini boleh lah email kepada saya di mrbr2001@gmail.com . Insyallah saya akan membantu.

Sekian terima kasih
Ralph Why IQ
29 Mei 2008