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...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
We all love beautiful things don’t we? Formatting in Excel helps us achieve exactly that. We can make our spreadsheets more presentable. We will use the data in the arithmetic operations table. We will make the column names; Bold Align serial numbers to the left...