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.,...
by Oluwaseun | Nov 1, 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...