Excel

Import SQL Data into Excel File In this tutorial, we are going to import data from a external SQL database. This exercise assumes you have a working instance of SQL Server and basics of SQL Server. First we create SQL file to import in Excel. If you have already SQL exported file ready, then you…

How to Import/Convert CSV to Excel In this tutorial, We will import external data from a simple CSV file containing customer payments. You can download the CSV file for this exercise. Download the CSV File Open a new workbook Click on DATA tab on the ribbon Click on From Text button You will get the…

Data is the bloodstream of any business entity. Businesses use different programs and formats to save the data depending on the business data storage requirements. You could have a payroll program powered by a database engine, you could have data in a CSV file or even from a website that you would like to analyse…

“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 to use Excel for personal finance to properly manage our budget and finances. We will cover the following topics….

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 graph 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…

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. What…

Formulas and functions are the building blocks of working with numeric data in Excel. This article introduces you to formulas and functions. Tutorials Data For this tutorial, we will work with the following datasets. Home supplies budget S/N ITEM QTY PRICE SUBTOTAL Is it Affordable? 1 Mangoes 9 600 2 Oranges 3 1200 3 Tomatoes…

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 is 0 and the maximum is 100. You can take advantage of validation features to ensure that only values between 0 and…

How To Perform Arithmetic Operations 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…

In this Microsoft Excel tutorial, we will learn the Microsoft Exel basics. These Microsoft Excel notes will help you learn every MS Excel concepts. Let’s start with the introduction: What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform…