SLNC logo
SPECIAL LEARNING NEEDS CONSULTANT
...Making learning and technology easy, accessible, affordable and available for everyone


BLOG PAGE

All articles

35 Blog Topics available

Page 6 of 7


Excel

USING 3D REFERENCES TO ANALYSE DATA OVER MULTIPLE WORKSHEETS

You can analyse data through many sheets in a workbook by using a 3D reference. In other words, if you have many worksheets in a workbook with a single cell or range of cells with data in them which you want to sum, multiply, use a function on, etc, you can do this by referring to the range of worksheets to be included followed by the range of cells to be acted on. The cells must be in the same place in the workbook on all worksheets. For example, with your cursor in the cell you want the result to appear in on the worksheet you want it on, to sum all of the figures in cell C3 in worksheets 5 to 40 you would use the formula:
=SUM(SHEET5:SHEET40!c3)
Therefore, if the figures in all of the 35 referenced sheets ...

Read More...


Mozilla

WEBSITE BASICS PART 3

Web pages are best described as rooms that makes up a building using our existing analogy for website. They are html documents which serve as online or web resources accessible through web browser and html editors. The collection of these various html documents constitute a website; better still, they are bits that forms the main structure called website.


Web pages are connected together on a website through links. This links are analogy of doors of different rooms in a building. You go in and out of a room through the door and in and out of another room the same way; and so also with links on a website. For example, there are various links on the home page of this website such as ...

Read More...


Mozilla

WEBSITE BASICS PART 2

We have houses with home addresses on the street, and we have shops in shopping mall with their various shop numbers or ID; they direct us to the specific house or shop we want to go. So also, web addresses take us straight to our desired websites holding on to the fact that they are buildings as explained in the previous post. For example, www.slnconline.com.ng/store directs you to the store’s web page on this website where you can purchase and order for different materials. But typing just www.slnconline.com.ng into the web browser will only take you to the home page.


Read More...


Mozilla

WEBSITE BASICS PART 1

A website is a collection of interconnected HTML documents or related pages. It comprises information on these linked pages and contents which are viewed through a web browsers. It is a place where information supplied on the internet by an individual or organization can be viewed, obtained or shared. Also, a website may be described as a house with many rooms as web pages. It is a virtual office, institution, shop, or house of individual and groups on the internet where you can meet and interact with them; nevertheless, some websites like Face Book, Twitter, LinkedIn and

Place marker is one unique feature that makes browsing through documents, interacting with web pages and accessing information through different word processing applications and text editors fascinating because it opens screen reader users to a new opportunity of getting things done quickly, easily and more efficiently. This place marker enables marking of particular portion of text; save or search for particular string of text in a document for the purpose of returning to it later or specific adjustment. This may be used online (on the internet) or offline; within documents such as Microsoft Office Word, HTML (web pages) PDF and other word processing applications. As a matter of fact, this is a feature that made me stick to ...

Read More...

Previous     2   3   4   5   6   7       Next