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....
by Oluwaseun | Oct 2, 2022 | Project Management Tutorials and Articles
Table Name Excel assigns a name to every table that is created. Step 1 − To look at the name of the table you just created, click table, click on table tools – design tab on the Ribbon. Step 2 − In the Properties group, in the Table...
by Oluwaseun | Oct 2, 2022 | Project Management Tutorials and Articles
TABLE IN EXCEL A Table is a rectangular range of structured data. The key features are − Each row in the table corresponds to a single record of the data. Example – Employee information.Each column contains a specific piece of information. Example...