Create a Pivot Table in Excel

The “Pivot Table” is one of the most powerful features in Excel.

In particular, it is very useful to use it to present information in a report format.

Assuming you have an Excel data file about the sales in different regions, with the Pivot Table created, you can click the “drop down” lists and change the data that is being displayed based on Month, Sales person, Product or geographic location.

Create a Pivot Table
In the Excel worksheet, go to toolbar and click “data”, and then “pivot table and pivot chart report” to follow the instructions given. Essentially, you just need to select the whole data set and create the pivot table in the new worksheet. All the column headers from your dataset should appear in a control box on the right of the screen. You can drag-and-drop the field buttons on your table.

For step-by-step procedures on how to create a Pivot Table, you may refer to the URL link www.homeandlearn.co.uk/ME/mes9p5.html for details.

I bet you… it is easier than you might think.

Opening of EPS file (How To)

To open an *.EPS file (Encapsulated PostScript) directly, you would need either of the following software installed onto your PC:-

Adobe Illustrator
Abobe PageMaker
Adobe Photoshop
CorelDRAW

However, there is still a work-around solution to open it using the normal Microsoft Word, Excel or PowerPoint.

The steps are:-
- Launch Microsoft Word, Excel or PowerPoint
- Click "Insert" menu then Picture, and select the From File (to point to the *.EPS file).

Find command in Linux

I suppose the “find” command is properly the most useful utility in UNIX/Linux.

The following are a few examples showing how to perform some common tasks using the “find” tool. I will add more as time goes on.

Basic syntax: find pathname... expression

#If you want to find files that are 7 days old, use the -mtime option
find . -mtime 7 -print
(Assuming today is 23-Dec, the command will show the files that are only dated 16-Dec.)

#An alternate way is to specify the range of periods
find . -mtime +6 -mtime -8 -print
find . -mtime +6 -mtime -8 -exec ls -lt {} \;

#Find files based on 7 days ago (atime means last accessed time)
find / -atime 7 -ls

#List old files and delete them (mtime means last modified/creation time of a file)
find -mtime +60 -exec rm -f {} \;

#Find core files in the directory and remove them
find . -name "core" -exec rm -f {} \;

Note:-

When using with “-exec” command, it should be used together with {} and ; (semicolon), where {} is used as a variable whose name is the file “find” found. As for ; (semicolon), it represents the end of command which must be punctuated by a quoted or escaped ; (semicolon).

*** df -h (human readable)

du -sh * | sort –nr

du -hsx * | sort -rh | head -10