by Oluwaseun | Jun 28, 2019 | Articles and Short Tutorials, Microsoft Powerpoint Articles
Microsoft PowerPoint is a commercial presentation application written and distributed by Microsoft. Microsoft PowerPoint is a presentation tool that supports text, shapes, graphics, pictures and multimedia along with integration with other Microsoft Office products...
by Oluwaseun | Jun 26, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
“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 we can use Excel to properly manage our personal...
by Oluwaseun | Jun 26, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
As the name suggests, conditional formatting refers to formatting that is only applied when the specified condition is true. Let’s say we want to easily fetch the sales figures greater than 30. We can use conditional formatting to highlight all the sales figures...
by Oluwaseun | Jun 26, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
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 charts in Excel to visualize our data. What is a chart? A chart is a visual representative of data in both columns and rows. Charts...
by Oluwaseun | Jun 26, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
What is a Logical Function? It is a feature that allows us to introduce decision-making when executing formulas and functions. Functions are used to; Check if a condition is true or false Combine multiple conditions together What is a condition and why does it matter?...
by Oluwaseun | Jun 24, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
The VLOOKUP function is used to perform a vertical look up in the left most column and return a value in the same row from a column that you specify. Let’s explain this in a layman’s language. The home supplies budget has a serial number column that...
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...