Skip to content 
Education is a gift, stay a while and enjoy it
Advanced Excel functions will make your life easier on the job. From entering and changing information to doing calculations, graphing, and sorting data, Excel has all that you need. It is a great tool to make working with numbers easier and faster. Whether you are a business owner, office worker, or teacher, becoming a pro … Read more
In this article, we will cover how to go about analyzing data in Excel. In life, you will often need to collect, analyze and present data to draw conclusions and plan for the future. Regardless of the field of work, you are in, data collection and analysis are part of the business process. Today as … Read more
So you are studying Information Technology and have started using spreadsheet formulas. You have seen the terms formulas and functions used interchangeably, and you have begun to wonder whether they are the same thing. Well, they are not. While formulas and functions can be used to complete the same task, they are indeed different. In … Read more
Absolute and relative cell reference refers to the way you use cell names or range names in formulas and functions. Absolute and relative addressing allows you to copy a formula or function to a new cell. However, these two do not behave the same way when copied. Keep reading to learn: In the introduction to … Read more
In this article on sorting data in Excel, you will learn skills that will make visualizing and analyzing data in Excel much easier. On the job and even in our private lives, we often sort data in order to better understand or analyze it. This article will focus on how to sort data in Excel. … Read more
Excel conditional functions allow us to make calculations on part of the data by setting limits. So if you have a large volume of information on your customers, but you need to count the persons living in Trinidad, spreadsheets allow you to do this in a few seconds without having to move the data around. … Read more
If you are new to spreadsheets or Microsoft Excel, you may now be learning what a spreadsheet function or formula is. This article is an introduction to spreadsheet functions and will clarify the following: If you are interested in other spreadsheet functions, visit Excel conditional functions to learn about the IF, COUNTIF, and SUMIF functions. … Read more
The most popular spreadsheet software today is Microsoft Excel. The reason for this is due to the fact that most modern computer systems came preprogrammed with one of the Microsoft Operating systems and the Microsoft Office Suite. Recently, however, we have seen many companies fighting back to take a bite of the software market. As … Read more