web analytics

Category Archives: MS Office

Essential desktop collection that makes your life much easier. Take tips about Excel, Word, Power Point, ...
Chosen tips and tutorials helps you to explore MS Office with maximum power ...

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

INSERTING AND UPDATING FORMULAS IN A MS WORD TABLE

Microsoft Word 2013

This article is about using and updating the mathematical formulas in a MS Word Table to literally calculate the values from the cells in the table. The principle of using the formulas is the same as the using the formulas in MS EXCEL. This provides you the possibility to calculate the values within the cells without using third party calculator or some other application. You can target as many cells as you want, and you can select the cell where you will insert the formula. Of course, you can have multiple formula cells.

01 - inserting table

First you need to create a table with numeric data in the cells. To create a table, click the Table icon from the Insert tab and drag the mouse cursor to select an area from the appeared menu with 4 columns and 7 rows i.e. 4×7 Table.