by Oluwaseun | Oct 5, 2022 | Project Management Tutorials and Articles
The Excel IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to “pass” scores above 70: =IF(A1>70,”Pass”,”Fail”). More than one condition can be tested by nesting...
by Oluwaseun | Oct 4, 2022 | Project Management Tutorials and Articles
Excel Data Analysis – Subtotals with Ranges If you have a list of data that you want to group and summarize, you can use Excel Subtotal and Outline to display summary rows or columns. You can use PivotTable also for this purpose,...
by Oluwaseun | Oct 4, 2022 | Project Management Tutorials and Articles
The Excel TIMEVALUE function converts a time represented as text into a proper Excel time. For example, the formula =TIMEVALUE(“9:00 AM”) returns 0.375, the numeric representation of 9:00 AM in Excel’s time system. Numeric time values are more useful...
by Oluwaseun | Oct 4, 2022 | Project Management Tutorials and Articles
The Excel DATEVALUE function converts a date represented as a text string into a valid excel date. For example, the formula =DATEVALUE(“3/10/1975”) returns a serial number (27463) in the Excel date system that represents March 10, 1975. Proper Excel...
by Oluwaseun | Oct 3, 2022 | Project Management Tutorials and Articles
The Excel TRANSPOSE function “flips” the orientation of a given range or array: TRANSPOSE flips a vertical range to a horizontal range, and flips a horizontal range to a vertical range. Purpose Flip the orientation of a range of cells Return...
by Oluwaseun | Oct 3, 2022 | Project Management Tutorials and Articles
When you gather data from different sources, you probably can have duplicate values. You need to remove the duplicate values before going further with the analysis. Look at the following data where you have information about various products of various brands....