by Oluwaseun | Oct 21, 2022 | Project Management Tutorials and Articles
The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the Date function. Purpose Get the...
by Oluwaseun | Oct 20, 2022 | Project Management Tutorials and Articles
Filtering allows you to extract data that meets the defined criteria from a given Range or table. This is a quick way to display only the information that is needed by you. You can Filter data in a Range, table, or PivotTable. You can filter data by − Selected...
by Oluwaseun | Oct 18, 2022 | Project Management Tutorials and Articles
The Excel PROPER function capitalizes each word in a given text string. Numbers, punctuation, and spaces are not affected Purpose Capitalize the first letter in each word Return value Text in proper case. Syntax =PROPER (text) Arguments ...
by Oluwaseun | Oct 18, 2022 | Project Management Tutorials and Articles
The Excel UPPER function converts a text string to all uppercase letters. Numbers, punctuation, and spaces are not affected. Purpose Convert text to upper case Return value Uppercase text. Syntax =UPPER (text) Arguments text – The...
by Oluwaseun | Oct 17, 2022 | Project Management Tutorials and Articles
In certain situations, you might have to Set up workbooks in which several worksheets have a similar format or structure.Get information for these worksheets from another worksheet.Summarize the results from these worksheets into a summary worksheet. For example, you...