Friday, March 25, 2016

Excel Tips : Split the Column of Data based on what you type..



You need to seperate first and last names (or part names and numbers, or any other data) into separate columns. A new Excel 2013 feature called Flash Fill can help.

1. Enter the first name or other value in the columns next to your data and press Enter.
2. Start typing the next name. Flash fill will show the suggested names. 
3. If it looks good just press Enter to accept the list.

To continue typing without using suggested name, Press Escape..

Tuesday, March 22, 2016

Know your Internet browser shortcuts

here are dozens of different shortcut keys that can be used with Internet browsers. Below are a few of our top suggested Internet browser shortcuts.


  • Press Alt + D or Ctrl + L to move the cursor into the address bar
  • Hold down the Ctrl key and press the + or -to increase and decrease the size of text. Ctrl + 0 will reset the text.
  • Press the backspace key or press Alt key + left arrow to go back a page.
  • Press F5 or Ctrl + R to refresh or reload a web page.
  • Press F11 to make the Internet browser screen full screen. Press F11 again to return to the normal view.
  • Press Ctrl + B to open your Internet bookmarks.
  • Press Ctrl + F to open the find box to search for text within the web page you are reading.