by Oluwaseun | Nov 18, 2022 | Project Management Tutorials and Articles
The data that you obtain from different sources may not be in a form ready for analysis. You will understand how to prepare your data that is in the form of text for analysis. Initially, you need to clean the data. Data cleaning includes removing unwanted characters...
by Oluwaseun | Nov 16, 2022 | Project Management Tutorials and Articles
The Excel DATE function creates a valid date from the individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet. Purpose Create a date with year, month, and...
by Oluwaseun | Nov 14, 2022 | Project Management Tutorials and Articles
When you add text in a formula in Excel, you have to enclose the text with quotation marks (”…”). This is useful when you want to create a dynamic string that changes based on some conditions. But what happens when you want to put quotation marks as part...
by Oluwaseun | Nov 9, 2022 | Project Management Tutorials and Articles
In Microsoft Excel, you can use Conditional Formatting for data visualization. You have to specify formatting for a cell range based on the contents of the cell range. The cells that meet the specified conditions would be formatted as you have defined. You...
by Oluwaseun | Nov 7, 2022 | Project Management Tutorials and Articles
The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0, A1<10). The AND function can be used as the...
by Oluwaseun | Nov 3, 2022 | Project Management Tutorials and Articles
The VLOOKUP Function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information. In simple terms, the VLOOKUP function says the following to Excel, “Look for this piece of information (e.g.,...