Vbulletin: Replace default vbulletin logo in header

Q: i wanted to edited the design of my forum by putting my own design on the top of the forum but i can't find the index.html file to edit. Anyone can help me?

A: there is no "index.html" to edit, all templates and style settings are in the database.

AdminCP > Styles & Templates > Style MAnager > Click on GO >

You should see the header footer and header include templates, along with main width settings and the style var (or image path) settings

Read more...

Microsoft Office Tips & Tweaks (part 3)

When it comes to using Microsoft Office, you may be an old hand or a relative newcomer.
Either way, productivity is always at a premium, so it’s useful to know any tips and tricks that can free up more time for other, more important things. With that in mind, let’s take a look at a few insider tips and tweaks that can help you create your Office documents, presentations, and worksheets in a flash. Unless otherwise indicated, the following tips should be universally applicable to Microsoft Word, Excel, and PowerPoint.

Erase Problems

If you mess up when creating a document (and who doesn’t?) you can use the Undo feature to reverse your actions. To do this, click the Undo button or press CTRL-Z one time for every action you want to reverse. If you get carried away and reverse too many actions, you can click the Redo button (or press CTRL-Y) to reverse Undo.

Make AutoCorrect Do Your Typing

You may already be familiar with AutoCorrect as the Office feature that automatically fixes embarrassing typos in your documents, based on its default list of corrections. For example, AutoCorrect will cheerfully change “hte” to “the” without even asking you. However, you may not realize that you can also leverage the feature by creating custom entries that automatically type long, complicated, or hard-to-spell words. For example, you can create a custom entry that automatically replaces your initials with your full name or replaces a short entry with a long (but frequently used) phrase or title. This time-saver is especially helpful in a word processing program like Word, although AutoCorrect works well in PowerPoint and Excel, as well.

To create an entry in AutoCorrect, choose Tools and AutoCorrect Options and then click the AutoCorrect tab. Make sure the Replace Text As You Type option is checked. Next, in the Replace box, enter the original text that you want to type (such as your initials). In the With box, enter the text that you want to replace the original text (such as your full name), and then click Add, OK. In your document or presentation, try out the feature by typing your initials followed by a space.

Get To Commands Quickly

Microsoft Office includes multiple ways to quickly access commonly used commands. You can right-click an area of the screen, such as a placeholder in PowerPoint or a chart in Excel, and the program displays a list of associated commands on a shortcut menu. Click the command you want on the list. If you’re relatively good at using the keyboard, you can also increase efficiency by using keyboard shortcuts for many processes, such as CTRL-B to bold selected text or CTRL-R to right-align it. To help you quickly learn the keyboard shortcuts, you can display them as part of the ScreenTips that pop up whenever you rest the mouse pointer over a toolbar button. To do this, right-click any visible toolbar and then choose Customize from the shortcut menu. Click the Options tab in the Customize dialog box and then check the boxes for Show ScreenTips On Toolbars and Show Shortcut Keys In Screen Tips before clicking Close.

Draw Symmetrical Objects

You can draw a variety of objects, such as squares and circles, in Word, PowerPoint, and Excel. To do so, display the Drawing toolbar by right-clicking any visible toolbar and then choosing Drawing. On the Drawing toolbar, click the Rectangle or Oval tool and then click and drag in the application workspace. If the object is still selected, you can also enter text inside it just by typing. To create a symmetrical object (such as a perfect circle or square), press SHIFT while dragging to draw the object. To create an object from the center point (where you first begin dragging the mouse), press CTRL. Finally, to create a symmetrical object from a center point, click the tool on the toolbar, and then press CTRL-SHIFT while dragging the mouse. If you’re having trouble moving a drawn object in small increments with the mouse, try using the menu commands instead. Select the object and then choose Draw and Nudge from the Drawing toolbar. Choose a direction from the submenu that displays. As an alternative, you can move an object by using the keyboard: Press an arrow key to move a selected object six pixels at a time; pressing CTRL and an arrow key will move the object in tiny one-pixel increments.

Use WordArt

To create an attention-grabbing title, create it as WordArt Object. Click the Insert WordArt button (on the Drawing toolbar) to display the WordArt Gallery. Double-click a style, which simultaneously selects it and opens the Edit WordArt Text dialog box, and then type your text. Optionally, you can choose a typeface and font size by choosing them on the Font and Size drop-down lists. When you’re finished, click OK. You can make additional modifications to the WordArt object by selecting it and then choosing commands on the WordArt toolbar.

Jazz Up Objects With 3D Or Shadow Effects

You can add three-dimensional effects to circles, squares, and other drawn objects. Click the object to select it and then click the 3-D Style tool from the Drawing toolbar. Choose an effect from the palette. To further modify the object’s appearance, click 3-D Settings on the palette, which opens the 3-D Settings toolbar. You can then use buttons on this toolbar to change the object’s depth, surface appearance, color, or perspective. In a similar manner, you can also apply shadow effects to a drawn object. Select the object, click the Shadow Style tool on the Drawing toolbar and then choose a style from the palette. You can further revise the object’s look by clicking Shadow Settings on the palette to open the Shadow Settings toolbar and then changing the shadow’s direction or color. One important note: You can apply either a 3D or shadow effect to an object, but not both.

Copy Formatting

You can copy formatting from one object, text area, or cell to another. To do this, select the object or cell from which you want to copy the formatting (or click within the text), and then click the Format Painter button. Next, click the object, cell, or text to which you want to copy the formatting. You can also double-click the Format Painter button to keep it active. This enables you to copy formatting multiple times. When you’re finished copying formatting, click the Format Painter button again or simply press ESC.

Tear Off Toolbars

You can “tear off” many of the submenus (palettes) in your Office programs so that you can keep them open, which provides ready access to their tools. For example, it’s more convenient to keep the Font Color, AutoShapes, and Fill Color palettes displayed instead of going through the same series of mouse clicks every time you want to use their tools. To “tear off” a submenu, display it, and then drag the move bar at the top of the submenu into the document workspace area. Release the mouse. When you’re finished using a palette, click its close button to clear it from the screen.

Select Text Quickly

Word includes a number of methods that you can use to quickly select text: Double-click to select an individual word; triple-click to select a paragraph. You can also speedily select a sentence by pressing CTRL while single-clicking anywhere in the sentence. Furthermore, you can select a line (not to be confused with a sentence) by moving your mouse into left margin until it displays as a right-pointing arrow. Point at the line which you want to select and then click. Finally, you can select an entire document by choosing Edit and then Select All or by simply pressing CTRL-A.

_____________________________
by Linda Bird

Read more...

Joomla Events Calendar: A How To

The website of JEvent is available here, but no specific instruction for installation is found. This article will show you how to install Joomla Events Calendar so that it works on your joomla-based website.

They are testing version 1.5alpha now. However, we only cover version 1.4.3 here, as this version is compatible with Joomla 1.5 (legacy mode).

Here are the simple steps to install this component:

- Access sourceforge website: here

- Download the required component for JEvents: com_events_1.4.3rc2.zip

- Download Mini-calendar module: mod_events_cal_1.4.3rc2.zip. We need this module to show calendar on sidebar. If we don't install this module, calendar can only be shown on mainframe.

- You can install Latest events module, (if you like), mod_events_latest_1.4.3rc2.zip. This module shows the latest event on sidebar.

- After install these two modules, you have to activate them in Module Manager. They are displayed as "Events Calendar" and "Latest Events".

- To add an event, go to Components/Events/Manage Events.

- To add the first event, create a category first. Event category can be created in Manage Categories. After creating a category, remember to Publish it first before adding the first event.

- Check your homepage to see the calendar.

Read more...

Microsoft Excel: Basic Worksheet Formatting

Users often want to customize the look of Excel spreadsheets. There are many basic formatting options available at the cell and worksheet level. Most are available on the Format Menu located on the Standard Excel toolbar.

Format Cells

Choose Format on the toolbar and select Cells to open the Format Cells dialog box. This box has six tabs, each for a different type of formatting. (You can also access this dialog box by rightclicking in any cell and selecting Format Cells from the pop-up menu.)

The Number tab offers shortcuts so that Excel will automatically format data as you type. When you select one of the 12 categories on the left, a sample appears on the right. The Special category allows zero to be the first digit in a cell, which is useful for entering social security numbers or ZIP codes. Some other key selections include Currency, which adds a dollar sign and allows you to display decimal points, and Date, which allows you to enter dates in simple numerical form and format them in various ways.

On the Alignment tab, you can align text horizontally and vertically within a cell, change the orientation of text within a cell, and change the text direction. If you have more data than will fit in a cell, you have some neat options in the Text control section. Check the box in front of Wrap Text to continue your text onto the next line within a cell and then increase the height of the cell to view all the text. Check Shrink To Fit to decrease the size of your text until it fits into its current cell. Or select several contiguous cells and then check Merge Cells to create one larger cell that shows more text. Merge cells is also an easy way to center a header across a spreadsheet with multiple columns.

The Font tab offers options familiar from Microsoft Word, including Font, Font Style, Size, Underline, Color, and Effects. Similar to Microsoft Word, there is a Preview screen to view your choices before you click OK to apply the formatting.

The Border tab offers multiple ways to add borders to cells. (There is also a toolbar button with multiple border options.) First, select the line style and color in the line section. You can click the preset buttons at the top (None, Outline, Inside) or the more detailed buttons around the preview diagram to make borders appear on the diagram. You can also click directly on the preview diagram to make lines appear. Click on lines again to delete.

The Patterns tab allows you to choose background color and patterns for each cell. Click your color choice on the color palette and choose your pattern from the drop-down menu.

In order to lock a cell so that its data cannot be changed, check the box in front of Locked on the Protection tab. In order to hide a formula so it is not visible on a spreadsheet, check Hidden. (These features are only available on protected worksheets.)

Format Rows

Select Row on the Format menu and the formatting choices will appear. The Height option allows you to choose a numeric value for the currently selected row height. If you have entered data in a cell that is not high enough to view all the data, select that cell and choose AutoFit from the menu. The row which contains the selected cell will automatically resize to view all the data within. (Shortcut: Hold your cursor to the far left side of the screen over the bottom border of a row. When it turns to a line with arrows pointing up and down, double click the mouse, and the row will automatically resize to show all data.)

To hide a row, select any cell in the appropriate row. Then select Hide from the menu to conceal the entire row. Data will not be lost. To make a hidden row reappear, select the two cells surrounding it. Select Unhide from the Row menu, and the row will reappear.

Format Columns

Select Column on the Format menu, and the formatting choices will appear. The choices are similar to those available for formatting rows. The Width option allows you to specify a numeric width for selected cells. The AutoFit is the same for rows and columns. (The shortcut is also the same: Double-click to the right of the column you want to resize.) The Hide and Unhide features are also the same for rows and columns. Standard Width changes the default cell width. Highlight one or more sheets and choose Standard Width on the Column menu. Type a measurement in the pop-up dialog box. For estimation purposes, this number corresponds to the number of digits that will fit in a cell. (This applies if you are using the default text font for your worksheet.)

Format Sheets

Of course, if you select all cells on a worksheet before you make a formatting change, you will change the entire sheet. But there are two places in your workbook that are specifically designed to apply formatting at the worksheet level.

Select Sheet from the Format menu;there, you can select Rename to rename your sheet (names appear on the tabs at bottom left) and select Hide or Unhide (corresponding tab will be concealed).

Select Background to open the Sheet Background dialog box. From there, you can insert a graphic file as background for your sheet. Selecting Tab Color opens the Format Tab Color dialog box, so you can choose a tab color from the color palette. Worksheet tabs. Sheet formatting changes can also be made through your sheet tabs. Right click any tab, and a menu will appear. Some of the options (Rename and Tab Color) are also available on the Sheet menu and have already been described. The remaining options will help you further format and manipulate your worksheets.

Select Insert to open the Insert dialog box. From there, you can insert available templates into your worksheet. Select Delete to delete the current worksheet. Choose Select All Sheets to highlight all the sheets in a workbook. This can be useful if you’re making a sweeping formatting change, like the standard cell width.

Select Move or Copy to open the Move Or Copy dialog box. You can move your sheet within the current workbook, to any open workbook, or to a new workbook. (If you want to move a sheet within the same workbook, you can also simply click and drag that tab to change its position.) To copy the sheet, check the Create A Copy box. The Copy feature can be convenient if you are making numerous changes to a worksheet. With your copied sheet in the same workbook, you can simply look back at the o d tab or recopy it if you decide against the changes you’ve made. Copying a worksheet is also an easy way to create several tabs with the same formatting in a single workbook (for example, monthly calendars).

These basic formatting options can save you time at the keyboard and make your spreadsheets look professional.

_____________________
by Liz Stefaniak

Read more...