How to create a Data List in Excel 2007

Creating a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings.

03-December-08 | Office | Excel |
How to hide graphic objects in Excel 2007

The Selection and Visibility task pane enables you not only to change the layering of various graphic objects in the worksheet but also to control whether they are hidden or displayed.

03-December-08 | Office | Excel |
How to Create an Ubuntu install USB stick

If you don’t fancy carrying the delicate Ubuntu installation CD around with you, you can copy its contents to a USB key stick and use that to install Ubuntu onto computers (provided those computers can boot from USB, and most modern computers will be able to).

30-November-08 | Linux | Ubuntu |
How to add WordArt to a Sheet in Excel 2007

If selecting gazillions of preset shapes available from the Shapes gallery doesn’t provide enough variety for jazzing up your worksheet, you may want to try adding some fancy text using the WordArt gallery opened by clicking the WordArt command button in the Text group of the Insert tab.

29-November-08 | Office | Excel |
How to add a Clip Art to an Excel document in Excel 2007

Clip Art is the name given to the over 150,000 ready made illustrations offered by Microsoft for use in its various Microsoft Office programs, including Excel 2007. Clip Art drawings are now so numerous that the images are classified into a bunch of different categories ranging from Abstract to Web Elements.

28-November-08 | Office | Excel |
How to add an arrow to a text box in Excel 2007

When creating a text box, you may want to add an arrow to point directly to the object or part of the chart you’re referencing.

28-November-08 | Office | Excel |
Moving an embedded chart onto its own chart sheet in Excel 2007

Although Excel automatically embeds all new charts on the same worksheet as the data they graph (unless you create using the F11 trick), you may find it easier to customize and work with it if you move the chart to its own chart sheet in the workbook.

28-November-08 | Office | Excel |
How to share files on a network in Ubuntu

If you opt to share folders across a network under Ubuntu you’ll find they’re protected with your username and password, which you might not want to share with others. The Shared Folders dialog box allows you to setup guest access but, at the time of writing, this had a serious
bug that rendered it unusable.

27-November-08 | Linux | Ubuntu |
How to ensure Ubuntu always knows the current time

Several of my computers sometimes mysteriously lose minutes when switched off, so that the time they display slowly becomes more and more behind. Luckily I have Ubuntu installed. This can periodically synchronize with the main Ubuntu time server, and thus never let the computers get out of step with the rest of the world.

27-November-08 | Linux | Ubuntu |
Improve the GNOME Terminal look and feel in Ubuntu

Both the color scheme and font of GNOME Terminal can be tweaked. This can be a good way of improving legibility and also the amount of space GNOME Terminal hogs on-screen, because a smaller font size makes the window smaller too.

27-November-08 | Linux | Ubuntu |
Moving a pivot chart to its own sheet in Excel 2007

Although Excel automatically creates all new pivot charts on the same worksheet as the pivot table, you may find it easier to customize and work with itif you move the chart to its own chart sheet in the workbook.

25-November-08 | Office | Excel |
How to Generate a Pivot Chart from a Pivot Table in Excel 2007

After creating a pivot table, you can create a pivot chart to display its summary values graphically in literally two really simple steps:

25-November-08 | Office | Excel |
How to Modify the Fields in a Pivot Table in Excel 2007

To modify the fields used in your pivot table, first you display the Field list by following these steps:

25-November-08 | Office | Excel |
How to Produce a Pivot Table in Excel 2007

Creating a pivot table has never been as easy as it is in Excel 2007: simply open the worksheet that contains the data list you want summarized by the pivot table, position the cell cursor somewhere in the cells of this list, and then click the Pivot Table command button on the Ribbon’s Insert tab or press Alt+NVT.

25-November-08 | Office | Excel |
Move or Copy Excel Sheets to other Workbooks in Excel 2007

In some situations, you need to move a particular worksheet or copy it from one workbook to another.

25-November-08 | Office | Excel |
How to Slow down a touchpad scrolling in Ubuntu

If you’ve got a notebook computer, you might be used to edge scroll on the touchpad when running Windows. This is where the right-hand edge of the notebook’s touchpad is used as a virtual scrollbar - by running a finger up and down, the currently active window scrolls up and down correspondingly.

23-November-08 | Linux | Ubuntu |
Make fonts look better in Ubuntu

Most fonts contain within them “hints” laid down by their designer about how they should look on-screen. However, Ubuntu ignores them and uses a system called autohinting, which improvises the hints based on the shape of the letters.

23-November-08 | Linux | Ubuntu |
Create links that automatically install software in Ubuntu

Sometimes if you’re trying to help somebody fix a problem you’ll have to tell them how to install software. Yet for some Ubuntu newbies even this can be confusing. The solution is to create a “software install” hyperlink within a web page (such as a forum posting), new email window or Pidgin message window.

23-November-08 | Linux | Ubuntu |
How to Rename Sheets in Excel 2007

The sheet names that Excel comes up with for the tabs in a workbook (Sheet1 through Sheet3) are, to put it mildly, not very original - and are certainly not descriptive of their function in life!

21-November-08 | Office | Excel |
How to Lock Entire Workbooks in Excel 2007

Locking workbooks in Excel is a great way to prevent yourself of breaking the whole thing when you are not suppose to touch it. Protect yourself from such actions by locking the whole thing.

20-November-08 | Office | Excel |