How to delete empty rows in Excel

How to delete empty rows in Excel

Ever worked with Excel documents only to find out later you have a lot of blank rows or even rows that contain blank cells? You can easily delete these rows using the Find and Replace feature in excel. Although having blank rows or cells within your excel worksheet is not considered bad, sometimes people find … Read more

How to Install Excel on Android and iOS

How to Install Excel on Android and iOS

For the past years, many changes have taken place at Microsoft. One of the greatest changes took place when Microsoft introduced Microsoft Office for Android and iOS devices. In the latter days, one can easily view, edit and create documents using Microsoft apps installed on their devices. However, to newly Excel users, you have to … Read more

How to update Excel in Windows 10

How to update Excel in Windows 10

Software updates are critical for keeping your software up to date with the most recent features, performance enhancements, and security fixes. Microsoft upgrades its Office suite regularly. Below are simple guides on how to update excel in windows 10. How to Update Excel on Windows 1. On your windows, double click on your excel app … Read more

How to create an excel questionnaire

How to create an excel questionnaire

Creating a questionnaire in Excel requires one to understand what he wants to know, ask the question and give the allowance for the respondent to answer. After coming up with the questionnaire, you can choose to print it out to receive handwritten answers or allow on-screen typed answers. This is done as follows; Steps to … Read more

How to join two Excel Graphs together

How to join two Excel Graphs together

Did you know you can join two excel graphs together? If you didn't know, now you know. However, many Excel users find this task to be challenging, which is not the case. Joining two graphs together not only saves the user time but also minimizes the space covered. Also, it may involve several workarounds which … Read more

How to change Excel Table border-color

How to change Excel Table border-color

Excel respects the fact that different people have different tastes in colors, and therefore it allows them to change border color from one color to another. The feature of changing border color makes your Excel look more presentable. Let's discuss some of the ways that can be used to change the border color of an … Read more

How to put a picture behind the text in Excel

How to put a picture behind the text in Excel

Did you know you can add a background image to your excel data? Excel has unique features that allow its users to insert a background image on their data. The background image helps in making the data have an interesting. Two methods can be used to insert a background image on your Excel document. These … Read more

How to use Excel for Z score

How to use Excel for Z score

Z score also known as the standard score, is a statistical measurement. It is used to determine the number of standard deviations a number is above or below a mean. Initially, manual methods were used to calculate Z scores and this proved to be tiresome. With the introduction of Excel, everything changed drastically. The process … Read more