Wednesday, September 25, 2019

Beginner Typing Lesson 1 - Part 1 (Home Keys and Basic Drills)

Beginner Typing Lesson 1 - Part 1 (Home Keys and Basic Drills)


HOME KEYS AND CORRECT FINGER POSITION

The two images below shows the Home Keys for the left and right hand. They are called the Home Keys because these are the keys your fingers must return to after typing any other key. The first image shows correct finger position for Home Keys. The second image has colour and number codes for each finger. For example, throughout this course your right index finger is used on all RED keys (also shown as number 1). Most keyboards have small bumps on the F and J keys to help you find them without looking. As you progress through your typing lessons you will learn the correct finger position for all keys.
 

      

 

OK - LETS GET STARTED!!

Move the mouse cursor (pointer) over the first yellow exercise box (below). Now click the left mouse button and you will see the cursor 'blinking' inside the box. You are ready to start typing. 

With your fingers over the HOME KEYS, copy the text from ABOVE each exercise box by tapping the same key on your keyboard. ALWAYS USE THE CORRECT FINGER POSITION. We will start with left hand. Begin by tapping the letter "F" with the index finger (also called the pointer finger) on the left hand. Tap "F" four times. Then tap the space bar once with your right thumb. Next tap "D" four times, then "S" and finally "A". Each time you have typed the letters FDSA, press the space bar with your right thumb. Do this whenever you see a space between letters. Keep copying the letters until you reach the end of the line. Now go back and repeat this exercise box (read below for a quick tip on deleting the text you have typed). 

With the mouse cursor inside a text box, hold down the Control Key and tap (type) the letter A. This will block (highlight) everything inside the text box. The very first letter you type will delete this text making it easy to start again. Always do each exercise box two times. Now press the TAB key to move to the next exercise box.

   

Left Hand

 

 ffff dddd ssss aaaa ffff dddd ssss aaaa ffff dddd ssss aaaa
  

 asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf
  

 fdsa fdsa fdsa fdsa fdsa fdsa fdsa fdsa fdsa fdsa

 

Right Hand

 

 jjjj kkkk llll ;;;; jjjj kkkk llll ;;;; jjjj kkkk llll ;;;;

 jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl;  

 

 ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj 

 

 

To move to the next box, press the TAB key or left click inside the box with your mouse.

 

Both Hands  

  fd fds fdsa jk jkl jkl; fd fds fdsa jk jkl jkl; fd fds fdsa jk jkl jkl;
 

 

WELL DONE!

You have finished Part 1 of Lesson 1. 

Repeat to get better.

 

Beginner Typing Lesson 1 - Part 2 (Introducing words and 3 more vowels)


 

Follow the colours and finger numbers in the next chart to practise lines of each pattern or word of the following. Visualise where the letter keys are and use the fingers shown.

 

Using only the four Left hand letter keys, D and F on the Home Key row with E and R on the row above we can feel out the word ‘fred’ which is one of 16 words that can be formed from only these four letters.

 

Place your fingers over the Home Keys. With the Left hand first finger lightly tap f r f r f r f r. Now with the second finger lightly tap d e d e d e d e.

On the Home Keys tap these fingers on d f d f d f d f then on the row above tap e r e r e r e r.

Within these four letters the Left hand can type the patterns de ed re er. Feel them out now by lightly touching the keys.

These patterns are used in words like demand remind asked walker.

Left Hand

 deed frrf deer reed red deed frrf deer reed red deed frrf deer reed red

 free freed fred feed fed free freed fred feed fed free freed fred feed fed

 reef reef ref ref refer refer defer defer referred deferred refereed

The Right hand fingers 1 and 2 use Home Keys J and K and U and I in the row above. 
Lightly tap these fingers on j k j k j k j k, then on the row above, u i u i u i u i
Now type the following practise line twice.

 

Right Hand

 juuj kiik juj kik juuj kiik juj kik juuj kiik juj kik juuj kiik juj kik

Please Note: we can not type any words with only these four letter keys. 
 

Both Hands 

 jude jude dud dud dude dude rude rude due due rudder rudder

 fur fur fir fir fire fire fired fired ride ride fried fried rider rider

 kid kid did did die die died died dried dried ride ride drier drier

TRY THESE FUN PHRASES

Type the semi-colon with the Right little finger or leave it out till a later lesson. 
 

 red deer; feed freddie; red fire; free feed; fried deer;

 eddie died; free ride; eddie fired fred; did eddie die;

 edifier rider dude freed red fur deer; kidder eddie rudder fed red deer;

 freed fed red deer died; fred fuji fried freed fed red deer; 

 duke jeered rude referee jed; did irked kirk fire rude jerk; 

 did freddie duke feed jeff kirk free fried red deer; rude eddie kerr jerked duke kirk;

WELL DONE!

You have finished Part 2 of Lesson 1. 

Repeat to get better. 

Sunday, April 7, 2019

Did you have a lots of data in a text document and you wish you could easily copy that to Excel?

Keyboard Shortcuts

You will save tons of time and make moves like a ninja once you master the keyboard shortcuts. Here are some of my favorites: 

  • |Ctrl + A|: will select all of the data
  • |Ctrl + C|: will copy the selected data (or object)
  • |Ctrl + V|: will paste the copied data (or object)
  • |Ctrl + End|: will take you to the last cell of your data
  • |Ctrl + Home|: will take you to the first cell of your data
  • |Ctrl + Up Arrow|: will take you to the first cell of your active column
  • |Ctrl + Down Arrow|: will take you to the last cell of your active column
  • |Shift + Space|: will select row(s) of your active cell(s)
  • |Ctrl + Space|: will select column(s) of your active cell(s)
  • |Shift + Space|: will select row(s) of your active cell(s)v
  • |Ctrl + minus sign|: will give you Delete options

    Copy Formula Down

    To quickly copy a formula down:
  • Hover to the bottom-right corner of the cell with the formula (you will notice that the cursor has turned to a thick black plus sign)
  • Double click the plus sign

    Copying Values or Formulas

    When tip #2 doesn’t work because there’s a blank cell between your starting cell and the end cell of your range or you don¢t want to drag a formula down to 1000 rows, try this:
  • Go to the first cell that you would like to copy or fill in other cells
  • In the name box, type in the address of the last cell of the range, where you want to fill data or formula and hit |Shift + Enter|
  • Press F2 to edit the formula in your first cell
  • Then hit |Ctr + Enter|


    You can see the name box highlighted in the red box. You will find this box right next to the fFormula Bar

    Total a Column or a Row

    To quickly total a column or a row, in the last cell, hit |Alt + =| (equal to sign). 

    Delete Duplicate Rows

    To delete rows with duplicated data, follow these steps:
  • Select the range of the data that you want de-duplicated (usually, |Ctrl + A| works)
  • Click on the Data menu option from the menu ribbon
  • Click on the Remove Duplicates button
  • Choose whether your range has a header row
  • Hit OK


    Add Leading Zeros

    You often find the need to add leading zeros to a number and most likely the result value is a text format. For example, you may want to show the number 7893 as 0000007893, making the number a text value with a length of 10 characters. If your number is in A1 and you want to convert that to text with leading zeros with a maximum length of 10 characters, enter this formula in B1:

    =TEXT(A1,REPT("0",10))

    Repeat Header for Printing

    While printing a multi-page sheet, it is useful to repeat the header row(s) on every page. To do so,
  • Click on Page Layout menu option on the riboon
  • Click on Print Titles button
  • Select the row(s) you want to repeat at the top in Rows to Repeat at Top box 

    Create Named Ranges

    For sheets with large number of rows, it is useful to give names to ranges so that you can refer to these names in your formulas without clicking and selecting long ranges. To quickly give names to your ranges:
  • Click on the Formulas menu option on the ribbon
  • Click on the Create from Selection button
  • Select the ranges to give names from usually Top Row works well as this row is the header row

    Copy Values

    To speed up copying only values and not the formulas, use this keyboard shortcut sequence:
  • |Ctrl + A| to select the whole range of data (or select your range with the help of the mouse)
  • |Ctrl + C| to copy the data
  • in your destination, press |Alt + E|, then |S|, then |V|, and then |Enter
    The whole sequence is:

    Ctrl + A, Ctrl + C, Alt + E, S, V, Enter

    After you practice this a couple of times, when you do this in front of your peers, without a doubt they will be in awe of your new ninja abilities.

    Import a Table from the Web

    Often you need to import data from the internet and you wish for a better way of doing so. Well, here is one way. Let¢s say you want to import the list of all time leaders of home run hitters in baseball from baseball almanac. Follow these steps to enjoy seeing this data in an Excel file:
  • Click on Data menu option from the ribbon
  • Click on From Web
  • In the browser window, enter the URL: http://www.baseball-almanac.com/hitting/hihr1.shtml
  • Hit the Go button on the browser window
  • Scroll down to the table of home runs
  • Click on Click to select this table check box
  • Click on Import
  • Click on OK



    Only a ninja can import raw tables from the web to the Excel files!

    Delete Current Row(s)

    To quickly delete current row(s), follow these two steps
  • Select the row(s) by |Shift + Space|
  • Delete the selected row(s) by |Ctrl + - (minus sign)|

    Delete Current Column(s)

    To quickly delete current column(s), follow these two steps
  • Select the column(s) by |Ctrl + Space|
  • Delete the selected column(s) by |Ctrl + - (minus sign)|

    Quick Aggregation

    Quick Tool provide aggregate statistics, such as Average, Count, Numerical Count, Max, Min, and Sum of the data from a selected range without entering any formula. To show these statistics in the bottom toolbar, right click on the toolbar and choose the desired statistic.

    Finding a Related Value

    Often you have to translate or cross-walk a value, say a state code, to it a related value, in this case the fully spelled state name. You can write multiple, nested |IF|, but a ninja way is to use a |VLOOKUP| formula. The syntax of VLOOKUP formula is: =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
  • In the above example, our lookup value is the state code and table array is a table with the state codes and their descriptions.
  • The column index is the column that we want to return after matching a code
  • The range lookup is an argument to search for exact matches (1 or TRUE) or approximate matches (0 or FALSE)

    Let’s say, your customer IDs in Column A, their mailing state code in Column B, and in Column C you want to see the state spelled out. To do so, follow these steps:

    Create a table of codes and their fully-spelled values in Column E and F
    In |C2|, enter this formula: =VLOOKUP(B2,E3:F6,2,0)
    Copy the formula down


    Converting Numbers to Ranges

    Did you ever find yourself with the need to convert a number column to discrete ranges for easier summaries or graphs? Did you wish there was a better way? Well, there is: the |VLOOKUP| formula. You saw the syntax: The syntax of VLOOKUP formula is:=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) To convert numbers to ranges, you use the |range_lookup| argument with a value of |TRUE|, which will tell Excel to make an approximate match to the lookup value. We can use this to our advantage. Let’s say, you have some measure, such as, population, revenue, sales, # of units, etc, in Column A. You want to convert these measures to certain ranges. To do so, follow these steps:
  • Create a table of measures and their discrete ranges in Column F and G
  • In |C2|, enter this formula: =VLOOKUP(A2,F3:G8,2,1)
  • Copy the formula down

    Text to Columns

    Did you have a lots of data in a text document and you wish you could easily copy that to Excel? Let’s say you have a Word document with some bullet points, like this:
  • Vendor A: 5,000
  • Vendor X: 9,900
  • Vendor D: 10,000
  • Vendor Z: 3,500

    To copy and keep the desired formatting for easier manipulation, follow these steps:
  • Copy the data from your Word document
  • Paste the data in a blank Excel spreadsheet (say starting from cell |A1|)
  • Select column A
  • Click on the Data menu on the ribbon
  • Click on Text to Columns button
  • In the Convert Text to Columns Wizard — Step 1, select “Delimited”
  • In Step 2, check the “Other” box and enter |:| (colon) as the delimiter.
  • Hit Next/Finish and complete the wizard


    The text will be separated by your delimiter and data will be in separate columns