web analytics

Be more efficient with MS Office package

You can be more happy, faster, more effective if you know more MS Office secrets ... More »

Can Imagine Your Life Without Internet?

Can Imagine Your Life Without Internet? Internet is Now More Closer to You! Browsers, Communications, E-mails, Clients, Apps, Social Networks, ... More »

Security in FIRST place! Why?

Do you want to lose all your data, informations, documents, all your money, all important things in your life in 1 second? Simple, you must be protected! More »

 
If you use your computer seriously, here you wil find essential resources, advices, tricks, tutorials, videos, applications, experiances and useful resources for your daily activities ...
You wil find essential information about MS Office package, Internet activity, Your PC Sequrity, Downloads, ...

REVIEW: GADWIN PRINTSCREEN

print_screen

Gadwin PrintScreen is light-weight download (about 4 MB) application which is completely free of charge and allows the user to capture everything showing on the desktop including the mouse cursor. It is very easy to install and use. The users can select the screenshot’s source (current window, full screen), the file format (BMP, JPG, GIF, PNG, or TIFF), the destination of the captured image and other options. Gadwin PrintScreen free of charge version can be downloaded from different internet web sites like:

01 - download now icon

This tutorial guides you through http://www.snapfiles.com/get/gprintscreen.html where you should click on the Download Now icon. Then, new zip file named PrintScreen47_Setup.zip starts downloading to your computer.

02 - installation file

TAKE A SCREENSHOT IN MS WORD 2013

Microsoft Word 2013

This article explains you how to capture and paste screenshot in MS Word 2013 document without using any other application. The screenshot are taken from the opened windows in your computer. You can select a portion of the screen and move it freely around the document or make fix position.

01 - blank document

PRINTING TITLES IN MS EXCEL 2013

Microsoft Excel 2013

If you need to print a sheet which is consisted of many rows or columns filed with data, you can use the MS Excel feature that enables you to print particular rows and columns (labels) as headings of the pages. With this feature called Print Titles, you can “freeze” the selected rows or columns and you can make them visible on the other pages from the sheet. Print Title option should not be confused with the printing of the header of the report, which is also printed in the top margin of every page. Print Titles prints the headings at the top if the rows are used as print titles and on the left in the case of printing the columns as headings.

01 - selecting a sheet

Referring to Cell Range and Explaining the Most Important Functions in Мicrosoft Word 2013

Microsoft Word 2013

When you need to calculate the values in particular table, you can refer to singular cell, set of cells or range of cells. The Word referring cell system uses the A1 Convention where the letters refer to the cell’s column and the numbers refer to the cell’s row. In every particular Word table, the top left cell is referred as A1. You can use this rule for orientation when referring to other cells in the table. There are various Word functions that can use the referring system to address the cells, such as: SUM(), AVERAGE(), PRODUCT(), etc.

Every cell from the table in MS Word 2013 has its own reference by which you can call the cells in the formula.

01 - table

USING POSITIONAL ARGUMENTS IN MS WORD 2013

Microsoft Word 2013

The positional arguments in MS Word helps you to refer to the specific cell range according to the position of the current i.e. selected cell. The applied positional argument determines the direction of the cell’s ranging. The entered positional arguments always calculate the range beginning with the cells that are adjacent to the current cell. You can combine two positional arguments to calculate the cells that are in the same row and column with the current cell.

01 - formula dialogue box

When typing the formula in Formula textbox, you may enter different positional arguments depending on the cells that you want to be calculated. There are four positional arguments:

  • ABOVE
  • BELOW
  • LEFT
  • RIGHT