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...