## The new templates introduced by Microsoft Excel 2013

INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE   One other beauty that makes Microsoft Excel 2013 different is the new  templates that were introduced into it.   With the Templates which is a time saving effort, you do need need to start a particular procedure afresh. …

## How to handle Vlookup with approximate match

In my previous article , I have looked closely at What Vlookup is in Microsoft Excel. I will advise that if you have not gone through that lesson, go and do that now.   In this article, I want to talk about how to handle Vlookup with …

## How to do Vlookup with Exact Match in Excel

Have you ever wondered why you are able to withdraw from Banks when you are not in your branch, what they are making use of is Vlookup.   Vlookup can be used to search for correlation for a value in a particular column. In this article, I want to …

## How to make use of LARGE function in Excel

I once asked my student to tell me the third largest value in the snapshot above, all what they did was to scare at the screen and give me some wrong answers.   There are actually simpler ways of get the answer using the LARGE function in Microsoft Excel. …

## How to perform nested IF function in Microsoft Excel

Microsoft Excel is so nice. It allows you to join about 63 arguments together. that is why we always talk of nested arguement in Microsoft Excel. In this article, I want to solve the riddle above. We are given IQ scores for some students and we need to enter …

## Another look at AVERAGE Function in Microsoft Excel

INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE CALLING ALL EVENT VENDORS….REGISTER YOUR SERVICES AT POSTMYEVENTS In this article, I will be using the previous snapshot that I use for my discussion  on how to use SUM function in Microsoft Excel.    If you closely in the snapshot, …

## Basic calculations in Microsoft Excel

In this article , I will be teaching how to do calculations from the screenshots I am presenting below:   INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE CALLING ALL EVENT VENDORS….REGISTER YOUR SERVICES AT POSTMYEVENTS If you something like the screenshot presented above and you need to …

## How to use IF Function in Microsoft Excel

INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE   IF Function to me is one of the magic that makes Microsoft Excel powerful but not many people know how to use this function.   As you all know , IF is a conditional statement , therefore …

## How to use AVERAGEIF in Microsoft Excel 2013 with Example

INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE     Just like SUMIF, you can make use of AVERAGEIF when you need to find the average for a column that you do not need to highlight everything to get your answer. I will be making use of the Data …

## How to use SUMIF function in Microsoft Excel: An example

INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE One of the questions I have always had to answer from my students is when do I have to make use of SUMIF in Microsoft Excel. I believe by the time I am through with this exercise, I …

## How to use SUM Function in Microsoft Excel

INVEST 80 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE Have you ever been to an interview where you failed simple Microsoft excel calculation ? I have seen many who claimed to be Excel Guru but they know nothing. In this article, I want to teach you how to …

## How to increase cell or column size in Excel

INVEST 90 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE I know many of you just like me will be wondering how you can increase your cell or column in Excel. You want to make it bigger and look like a big rectangle , I will tell you the simple …

## How to use the MAXIMUM function in Excel

INVEST 90 EURO OR EQUIVALENT AND EARN DIVIDENDS FOR LIFE In my previous article, I have talked about how you can use the sum function in Microsoft Excel. In this article, I want to look how we can use the Maximum function in Excel. The Maximum function is used to …

## Introducing the Microsoft Excel Option Dialog Box

In this article , I want to look at Microsoft Excel generally and introduce you to some of the keys or commands that you can use to customise your Microsoft Excel environment. Microsoft Excel is so powerful that you cannot use all the button at once. It will be very …

## The use of the General Option Tab at the Backstage of Microsoft Excel 2013

In my previous article, we want to look at the General section of Microsoft Excel 2013. This is one of the Tabs where we can customise Microsoft Excel to fit the way we want to work. Follow me as we begin the exploration of this powerful tool together. #1: USER …

## Differences between Spreadsheet, Worksheet and Workbook in Excel

#1: SPREADSHEET A Spreadsheet is simply a paper or an electronic document , arranged in tabular form , that, is used to store, manipulate, and analyse data.   #2: WORKSHEET A Worksheet is an electronic spreadsheet that is used for entering, storing and and analysing data in Excel. One can think …

## Common terms relating to Cell and Range in Excel

In this article, I want to define some of the common terms that are likely to confuse you when you are working with Microsoft Excel 2013. Here are some of it. #1: CELL A Cell is a singular container that you can use to input and store data. When you …

## How to reference Cells in Microsoft Excel

In Microsoft Excel, Cells are given names based on columns and Rows that they are in. The Cell name is used in Microsoft Excel to differentiate one Cell from the others. A Cell will always consist of a name and a number. In Excel, the letters refers to the …

## How to do Range reference in Microsoft Excel

In my previous article, I have talked about how to reference a Cell in Microsoft Excel. In this article , I will briefly talk about how to reference a Range in Excel. First and foremost, a Range is a group of Cells that has common or similar data. When you …

## List of Default Bars in Microsoft Excel and their uses

#1. TITLE BAR The Title bar displays the workbook file name. #2. QUICK ACCESS TOOLBAR The Quick Access Toolbar provides you with an easy access to the most commonly used Excel Commands such as Save, Undo and Redo. You can customise the Quick Access Toolbar to suit your needs. More …

## A quick look at Microsoft Excel Window Commands

One thing you should know from the onset is that you can resize your Window to suit how you want to work. In this article m I want to talk about Window commands which are resizing tools that can help you alot. Follow me as we look at this together. …

## The three main section of Microsoft Excel backstage

Here and now. I want to talk about the different sections of the Microsoft Excel 2013 backstage view. Follow me as we look at some of these sections together. #1: LEFT PANE This part of the Backstage view displays the file command and the various backstage view tabs. #2: FILE …

## How to use your mouse to control Microsoft Excel

To select a cell, just click on the desired cell. To select a range of cells, just left click and drag to select the desired range of cells. If you want to select an entire column or row, just select the desired column or row header. If you want to …

## Two modes of entering data in Excel

#1: DIRECT INTO ACTIVE CELL This is one of the easiest and common way to populate your sheet when entering data in excel. You can just type the data and press the “Enter” key. You can also make use of the Tab key when you are performing this task. Pressing …

## Three cell modes you can find in Microsoft Excel

This article explains the three types of Cell modes that you will find in Microsoft Excel. It shows how these Cell modes can help you understand how data inputs work in Excel. Follow me as we look at some of these modes together. #1: READY MODE When you see the …

## The use of the Ribbon in Microsoft Excel

The Ribbon is one of the interface that is very common to all Microsoft Office applications. The Ribbon is a graphical user interface that contains all of the most commonly used commands you will need to create , modify and work with your Excel workbooks.The Ribbon was designed as a …

## Explaining Screen tips and key tips in Excel

Do you really believe life is beautiful with all Microsoft Office Applications, One of the cool features that made life so cool is Screen tip and tool tips. The two perform almost similar functions. They give users briefs description of what each of the command does. Follow me as I …

This article explains the use of the Quick Access Toolbar in Microsoft Excel. It provides you with easy access to commonly used commands in any Microsoft Office applications. The tool appears above the ribbon in the top left corner of the Excel interface. By default, Save, Undo and Redo commands …