by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
What is a function? (Function Wizard) A function is a predefined formula. Functions allow you to use descriptive names to automatically apply formulas for you. Examples of functions include; SUM for summation of a range of numbers AVERAGE for calculating the average...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
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...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
At times, you would like to brand the documents printed in excel with letterhead information and print with the company logo, etc. Excel has features that allow you to import images into Excel. The command for adding images is found under the INSERT tab on the ribbon....
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Data filters allow us to get data that matches our desired criteria. Let’s say we want to show the results of all the students whose names start with “JA” or get scores that are less than, greater than or equal to a certain value, we can use filters...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
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...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
The print area is the part of the worksheet that you would like to print out on paper. The quick and easy way of doing it is by using the following shortcut commands Ctrl + P You will get the following print preview. Press Esc button to exit print preview...