MS Excel

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 […]

MS Excel

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 […]

MS Excel

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 […]