Author: xldoc
-
The right way to add a landscape page in a Word Document
You need a landscape page in your Word document to either fit in a large table or image, or for any other reason. How to insert a landscape page in Word First add a Section Break First insert a Section Break by going to the ribbon and finding the “Breaks” option. Then Click on Section…
-
How to Add Table of Contents in Word
The Table of Contents option in Word is located in the ribbon under the references tab. Clicking on the Table of Contents button gives you a a few options on what type of table you want to insert. Most people just go with Option 2 which creates a table of contents with the label “Table…
-
Shortcut for Highlighting Text in Word
Pressing Ctrl + Alt + H highlights any selected text in a Word file. Pressing Ctrl + Alt + H highlighted text un-highlights it. The color of the highlight will be either the default yellow or the last used color. If you unhighlighted text by clicking on the highlighter and selecting “No Color”, then pressing…
-
How to use VLOOKUP in Excel
To use VLOOKUP, you have to first understand what it does and how it works. Then we will get to actually using it. What does VLOOKUP do in Excel The VLOOKUP function retrieves the value of a target cell located a specified number of columns to the right of a reference cell. The format of…
-
The SUM Function in Excel
If you need to add bunch of numbers, type in =SUM( in a cell, and select the numbers you want to add. How to use the SUM Formula in Excel After typing =SUM(, you can either click on individual numbers or drag across and array of numbers you want to add. When clicking on individual…
-
How to use COUNT and COUNTA in Excel
The Count function in Excel is used to count the number of values in a selection of cells. How to use COUNT in Excel Type =Count( in a cell and select the cells you want to count for numerical entries. After selection, close the bracket with ) and hit enter. The cell you entered the…