- Siti Suriani
Friday, July 31, 2009
Office Day @ Angkasapuri, Kuala Lumpur
- Siti Suriani
Thursday, July 30, 2009
Word Tips – Easiest Option to format a report using MS Word 2007
Normally user will spend more time to do formatting rather than focusing on the content. Here is how you can do it even faster….
Below is the sample report before formatting:-
Make sure the entire report is finalized already.
- Click anywhere within the report.
- From the Home tab, under Styles group, click on the Change Styles drop down arrow button – change the set of styles, colors and fonts (apply for the entire document).
Style Set Samples:-
- Siti Suriani
Monday, July 27, 2009
Excel Tips - Getting List from Other Spreadsheet for Display with Data Validation List
- Select the list that you want to use (it could also be from the table array you use for VLookup or HLookup. If it is, just select the list excluding the header which is the column one for VLookup table array or row one for HLookup table array). It is best if you can first sort your list in ascending order because the list taken in data validation will follow your actual list without sorting them for you.
- With the list selected, click in the name box located to the left of the formula bar and type a name (the name has to be unique and shouldn't be separated if it consists of more than one word) and then press Enter.
- Return to the other spreadsheet and select the cell(s) you want to create combo box.
- With the cell(s) selected, go to Data tab and select Data Validation from Data Tools group (for Excel 2003 or earlier, go to Data menu and select Validation...).
- On the Data Validation dialog box, go to Settings tab.
- Type the name you have given for the list in step 2, starting with the equal sign (=) in the Source field (I used FruitList for my example).
You can combine the usage of this combo box with any lookup function or use it alone.
- MRBAR
Tuesday, July 21, 2009
Excel Tips - Hide Formula from Being Displayed in the Formula Bar
- Select the cell(s) with the formula(s) you want to hide.
- From the Format Cells dialog box, go to the Protection tab.
- Click OK.
(If you want to allow entering or editing data on certain cells, select those cells and follow step 2 and 3. Then uncheck the Locked check box and click OK.)
Now you can protect your worksheet.
- From Home tab, click Format from Cells group and select Protect Sheet... or you can also find Protect Sheet button in the Changes group from Review tab (for earlier versions, go to Tools menu, point at Protection and select Protect Sheet...).
- Apply your password to protect (optional) and repeat the same password after clicking OK.
REMINDER! Password is case sensitive. To unprotect, you must type the password exactly like the one you've created. If you forgot the password then you can say good bye to your worksheet :).
- MRBAR
Excel Tips – Protect Certain Part of Spreadsheet from Changes
- Press Ctrl+1 to open up the Format Cells dialog box
- Click on the Protection tab
- Clear the Locked check box
- Open the Format Cells dialog box again
- This time around, check the Locked check box
- Next step is to protect the worksheet
- Type a password to unprotect sheet
- Try to make changes on the selected data area
Now all is being set, users are not allowed to make any changes on the selected data area.
- Siti Suriani
Monday, July 20, 2009
Word Tips - Create Table of Content
- From your document, click anywhere in the chapter's title line.
- Select the new first page.
- Select one of the built-in TOC style or select Insert Table of Contents... if you want to display more that 3 levels of TOC by increasing the value in the Show levels (same for earlier version where you can see the Show level in the Table of Contents tab of the Index and Tables dialog box).
If you do any changes on the document's title(s) or move the chapter and its title, you can just update the TOC and it will change the writing and page number automatically.
Easiest way is to press Ctrl+A to select all and then press the F9 function key. You'll then have the option to update entire content or just the page number.
- MRBAR
Excel Tips – Copying or Cutting Formula
When you copy and paste formulas containing relative references, the references are adjusted.
Microsoft Office Excel 2003
- Select cell with formula
- Click Copy on the Edit menu
- Select cell to paste
- Click Paste on the Edit menu
Microsoft Office Excel 2007
- Click Home tab
- Click Copy command button under Clipboard group
- Select cell to paste
- Click Paste command button under Clipboard group
When you cut and paste formulas containing relative references, the references are not adjusted.
Microsoft Office Excel 2003
- Select cell with formula
- Click Cut on the Edit menu
- Select cell to paste
- Click Paste on the Edit menu
Microsoft Office Excel 2007
- Click Home tab
- Click Cut command button under Clipboard group
- Select cell to paste
- Click Paste command button under Clipboard group
- Siti Suriani
Excel Tips - If Colored areas on your worksheet do not print well
- Click Page Setup on the File menu
- Click the Sheet tab
- Select the Black and White check box under Print category
Microsoft Office Excel 2007
- Click Page Layout tab
- Click Page Setup dialog box launcher button
- Click the Sheet tab
- Select the Black and White box under Print category
- Siti Suriani
Wednesday, July 15, 2009
Word Tips - Mixing Potrait and Landscape Orientation in a Document
Don't use Page Break when you want to create a new page for the diagram. Things will be alot easier if you use Section Break. By using Section Break, you will be able to change the orientation for the new page without effecting previous pages that is in potrait orientation.
- To create the new page for the diagram, go to Page Layout tab, Page Setup group (for earlier Word versions, go to Insert menu and select Breaks).
- Click in the new page.
- MRBAR
Word Tips - Getting the whole content of a paragraph in a same page
Instead of wasting time adjusting the paragraph again and again, you can set the paragraph to be in the following page automatically if it cannot fit the current page.
Here are the steps:
- Click anywhere inside the paragraph.
- From the Home Ribbon, click the dialog box launcher for Paragraph group (for earlier Word versions, go to Format menu and select Paragraph).
- On the Paragraph dialog box, go to the Line and Page Breaks tab.
- Click the check box for Keep lines together.
- Click OK.
- MRBAR
Friday, July 10, 2009
Malaysia Microsoft Office Championship 2009
Thursday, July 9, 2009
Word Tips - Take advantage on AutoCorrect Options
We can use the feature to help us to type long text such as our name, just by typing the initial.
This is how to do it...
- Go to Office Button and then click on Word Option. From Word Option dialog box, go to the Proofing page.
- Click the AutoCorrect Options button. Then you'll see the AutoCorrect Options dialog box (for earlier Word versions, go to Tools menu and select AutoCorrect Options).
- Under the Replace field, type your initial.
- Next, type your full name under the With field.
- Once done, click Add and then click OK button to close AutoCorrect Options dialog box and then click OK again to close the Word Option dialog box.
Now you can just type your initial and then when you press the space bar or enter, the initial you've just typed will automatically be replaced with your full name.
- MRBAR
About Siti Suriani
Microsoft Certified Application Specialist in Word 2007, Excel 2007 and PowerPoint 2007.
Certified Shell IT Trainer & part of Shell Handyman team under Shell Global Solution for Shell International as Consultant on Microsoft office in Shell environment.
Holds Master's Degree in Computer Science (Distributed Computing) and Bachelor's Degree in Computing.
About Ridzuan (MRBAR)
Awarded Microsoft Office 2007 Master for having certificates on Word 2007, Excel 2007, PowerPoint 2007 and Outlook 2007.
Certified Shell IT Trainer & part of Shell Handyman team under Shell Global Solution for Shell International as Consultant on Microsoft office in Shell environment.
Experienced in IT since 1986 and started to be an in-house trainer in IT since 1997 for multi-national and foreign company. Moved on deeper into IT Corporate training as a freelance trainer since 2007 and at the same time, always looks for opportunity to gain more knowledge in IT.
An Information Technology Diploma holder and in pursue on Bachelor of Technology in Computer Systems and Networks (hons).
Experienced in many sectors of employment, from labour up to management level through working experiences with various company (local, multi-national and foreign).
Experienced in photography since 1998 and doing photography workshops and photo shooting as second job
Website : www.MRBARPhotoWorks.webs.com
E-mail : mrbar.my@live.com