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...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
S/N ARITHMETIC OPERATOR FIRST NUMBER SECOND NUMBER RESULT 1 Addition (+) 13 3 16 2 Subtraction (-) 21 9 12 3 Division (/) 33 12 2.75 4 Multiplication (*) 7 3 21 Let’s now use Microsoft excel to achieve the above results Create a folder on your computer in my...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Ctrl + P used to open the print dialogue window Ctrl + N creates a new workbook Ctrl + S saves the current workbook Ctrl + C copy contents of current select Ctrl + V paste data from the clipboard SHIFT + F3 displays the function insert dialog window SHIFT + F11...
by Oluwaseun | Jun 21, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
What is Microsoft Excel? Microsoft Excel is a spreadsheet program that is used to record and analyze 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...
by Oluwaseun | Jun 17, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles
The quick access toolbar is a customizable toolbar that contains commands that you may want to use. You can place the quick access toolbar above or below the ribbon. To change the location of the quick access toolbar Click on the arrow at the end of the toolbar...
by Oluwaseun | Jun 17, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles
MENUS Microsoft Word 2013 maintains the same menu system with Word 2007 and 2010. Recall that the office Button in word 2007 was replaced with FILE in word 2010. You should remember this features as you work within Word 2013 The Microsoft Office Button The...
by Oluwaseun | Jun 17, 2019 | Articles and Short Tutorials, Microsoft Word Tutorials and Articles
There are two ways to start a Microsoft Word; Double click on the Microsoft word icon on the desktop ( if available) Click on the start button→ ALL programs → Microsoft office 2013 → Word 2013 OR Click on Start Button → From the search box → Type Word 2013 →...