Excel

VLOOK UP
The VLOOKUP function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information.  I...
Mon, 13 Jul, 2020 at 9:30 PM
Countif function
The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples. If you need help just ma...
Mon, 13 Jul, 2020 at 9:33 PM
Protect a Worksheet/Cells from Editing
Protect a Worksheet from Editing You can protect individual worksheets from editing. When you protect a worksheet, Excel locks all of the cells from editin...
Mon, 13 Jul, 2020 at 9:35 PM
Printing what you want
1. Print Titles This is one of the most useful printing options in excel. Let’s say you a have heading row in your data and you want to print that hea...
Mon, 13 Jul, 2020 at 9:40 PM
Text to columns
To separate the contents of one Excel cell into separate columns, you can use the 'Convert Text to Columns Wizard'. For example, when you want to ...
Mon, 13 Jul, 2020 at 9:42 PM