The new templates introduced by Microsoft Excel 2013

Image result for excel 2013 templates  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. …
Read More »

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 …
Read More »

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 …
Read More »

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. …
Read More »

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 …
Read More »

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, …
Read More »

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 …
Read More »

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 …
Read More »

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 …
Read More »

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 …
Read More »

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 …
Read More »

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 …
Read More »

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 …
Read More »

Introducing the Microsoft Excel Option Dialog Box

microsoft office excelIn 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 …
Read More »

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

general option tabIn 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 …
Read More »

Differences between Spreadsheet, Worksheet and Workbook in Excel

excel spreadsheet#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 …
Read More »

Common terms relating to Cell and Range in Excel

rangeIn 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 …
Read More »

How to reference Cells in Microsoft Excel

cell reference  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 …
Read More »

How to do Range reference in Microsoft Excel

range-in-excelIn 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 …
Read More »

List of Default Bars in Microsoft Excel and their uses

excel-title-bar#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 …
Read More »

A quick look at Microsoft Excel Window Commands

Image result for image of windows minimise sectionOne 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. …
Read More »

The three main section of Microsoft Excel backstage

microsoft excel backstageHere 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 …
Read More »

How to use your mouse to control Microsoft Excel

Image result for image of a mouseTo 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 …
Read More »

Two modes of entering data in Excel

entering data#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 …
Read More »

Three cell modes you can find in Microsoft Excel

cell modesThis 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 …
Read More »

The use of the Ribbon in Microsoft Excel

ribbonThe 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 …
Read More »

Explaining Screen tips and key tips in Excel

screen tipsDo 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 …
Read More »

The use of the Quick Access Toolbar in Excel

 quick access toolbarThis 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 …
Read More »

The use of mini toolbar and contextual menus in excel

mini toolbarThe mini Tool bar in Excel 2013 provides you with two other options for easily ascertaining the mini toolbar and context menus. The mini toolbar is displayed when you right click the active cell on a worksheet. It is a small , rectangular , pop up window that contains a …
Read More »

Use of the Save and Save as command in Excel

saveMicrosoft Excel provides users with two options for saving your new workbook files: The Save and Save as commands. The Save command is used when you need to save an existing work. May be a work is already saved and you need to save new additions to the work. You …
Read More »

Older Entries »