Excel
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
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 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
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
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