Advanced Excel Functions – DATE, VLOOKUP, and PMT Functions

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

Introduction to Spreadsheet Formulas

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

What is Absolute and Relative Cell Reference: How to Use Them

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

Excel Conditional Functions

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

What is a Spreadsheet Function

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

Introduction to Spreadsheets – Definition, Types, and Features

If you are a secondary school student or work in an office, chances are you have heard the term spreadsheet, but do you know what a spreadsheet is or what a spreadsheet is used for? In this article on introduction to spreadsheets, we will seek to answer these questions as well as the ones below, … Read more

Microsoft Excel – Learn the Features and Shortcut Keys

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