Tuesday, September 3, 2013

Q&Q sport watch review

A short review of the following sports watches form Q&Q (M102J001Y | M010001 |M010J001Y)

Until now to time my laps I used the phone, but since Sunday, I have a running watch. I chose a Q&Q 150 lap memory watch from Q&Q.

q&q sports running watch 150 laps digital
Q&Q M102J001Y 150 memory lap

Sunday, August 18, 2013

Slide rule, the computer before computers

Some people forget that not computers put a man on the moon. Before the era of lightning fast calculations made with the aid of computers engineers used slide rulers.

slide rule

Thursday, August 8, 2013

Calculating the time difference between 2 dates

As a loan shark you give money to people in need, and you need to keep track of the dates when you should go and get your money back.

Saturday, July 27, 2013

Excel Consolidate

Let's assume you are a toy manufacturer, new on the market. This is your second year producing toys and need a report of total sales for every toy you produce. The data comes to you in a table format and you would like to sum the number of toys you sold in the last 2 years per category.

Wednesday, June 12, 2013

Calculate time with excel

As a sweatshop owner, you need to keep track of the time the Smurfs, Snow White and the 7 Dwarfs and Little Red Riding Hood are working for you.
You keep a table of data containing the name of the worker, date, the start of shift time, end of shift time.
In the first column you put in the name of your worker, in the second you fill in the date (manually or my favorite way Ctrl + ; ) in the third time you fill in the time at which the worker started his shift Ctrl + Shift + ; and in the fourth column the time at which the worker finished the shift again with the same shortcut.

Wednesday, May 15, 2013

13 useful shortcuts for Excel

Here are my favorite shortcuts for speeding my work in Excel.

     1.  Ctrl + * selects the entire table that contains data

     2.  Ctrl + Arrow Up / Down / Right / Left the selected cell jumps to last set of data in a table (Ctrl + Shift + Arrow/... to select the cells)

     3.  Ctrl + D copy the vale of the cell just above (Ctrl + R copy the value of the cell from left)

     4.  Alt, E, A, A delete the value and formatting of the selected cell or cells *)

     5.  Alt, D, F, F create a filter list *)

     6.  Ctrl + H replace values

     7.  Ctrl + : insert the current date (Ctrl + Shift + : insert the current time)

     8.  Ctrl + T transform a set of data into a table

     9.  Ctrl + 1 gets you to the format cells dialog box

    10. Ctrl + Shift + F3 create names from selection (Ctrl + F3 to display the Name Manager)

    11. Ctrl + Page Down / Page Up scrolls through sheets

    12. Alt + Arrow Down display a drop down list of all the entries above

    13. Alt + F2 insert a comment (double press Esc to exit comment box)

*) do not enter the comma just press the characters in the right order

What shortcuts can’t you live without?

Saturday, May 4, 2013

Excel automatic hyperlink - How to remove it or change the way it’s displayed

When writing in excel something like an email address or web page address excel automatically converts it to a hyperlink. When this happens the font color is changed to blue and an underline appears under the hyperlink. Once you click it the blue changes to a pale purple red.

You can address the problem in two ways