“Money is a tool. Used properly it makes something beautiful- used wrong, it makes a mess!” – Bradley Vinson It takes discipline to use money properly. In this tutorial, we are going to look at how we can use Excel to properly manage our personal finances. We will cover the following topics. Why manage Budget? […]

# MS Excel

## Excel Creating Charts and Conditional Formatting

A picture is worth of thousand words; a chart is worth of thousand sets of data. In this tutorial, we are going to learn how we can use charts in Excel to visualize our data. What is a chart? A chart is a visual representative of data in both columns and rows. Charts are usually […]

## IF, AND, OR, Nested IF & NOT Logical Functions in Excel

Things will not always be the way we want them to be. The unexpected can happen. For example, let’s say you have to divide numbers. Trying to divide any number by zero (0) gives an error. Logical functions come in handy such cases. In this tutorial, we are going to cover the following topics. In […]

## Best Excel Formulas & Functions: You Need to Know Now

Formulas and functions are the building blocks of working with numeric data in Excel. This article introduces you to formulas and functions. In this article, we will cover the following topics. What is a formula? Mistakes to avoid when working with formulas in Excel What is a function? (Function Wizard) The importance of functions Common […]

## Excel Data Validation, Filters, Grouping

In this tutorial, we are going to cover the following topics. Data validation Data filters Group and Ungroup Adding images to spreadsheets Data validation Data validation is very important in the sense that it helps us avoid mistakes that can be avoided. Let’s assume you are recording student exam marks and you know the minimum […]

## How to Add, Subtract, Multiply, Divide in Excel

In this tutorial, we are going to perform basic arithmetic operations i.e. addition, subtraction, division and multiplication. The following table shows the data that we will work with and the results that we should expect. S/N ARITHMETIC OPERATOR FIRST NUMBER SECOND NUMBER RESULT 1 Addition (+) 13 3 16 2 Subtraction (-) 21 9 12 […]

## Introduction to Microsoft Excel 101

What is Microsoft Excel? Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. The point where a column and a […]